sum of all drop down values

Hi,
I have a dropdown in my jsp with all users from database. When I select a user I'm able to get the details of the corresponding result, but when I click on all it should give the total individually. Below is the code that I use to get individually.

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="DBCon.jsp" %>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <meta charset="utf-8" />

</head> 
    <body><form name="Reports" method="post" action="DropDown.jsp"><table><tr>

<tr><td>To</td><td><input type="text" id="to" name="to"></td></tr>
                     <tr><td>Select user:</td><td><select name="user" id="user">

<option value="">Select User</option>
            <%
            try{
                ps=con.prepareStatement("select substr(sys_connect_by_path(userid,','),2) userid from (select rownum rowno,'''' || userid || '''' userid from users where rownum < 4)where connect_by_isleaf = 1 connect by prior rowno = rowno - 1 start with rowno = 1");
                rs=ps.executeQuery();
                while(rs.next()){
              %>
                <option value="<%String user2=rs.getString(1);out.println(user2);%>">All</option>
                <%
            }
            }
            catch(Exception e)
                                       {
                out.println(e);
            }
            %>
            <%
            try{
                ps=con.prepareStatement("Select Distinct Specialist from Scope1");
                rs=ps.executeQuery();
                while(rs.next()){
              %>
                <option value="'<%String user1=rs.getString(1);out.print(user1);%>'"><%out.print(user1);%></option>
                <%
            }
            out.println("<select>");
            }
            catch(Exception e)
                                       {
                out.println(e);
            }
            %>

</select></td></tr>
                     <tr><td>
        Select Type:</td><td><select name="type" id="type">
            <option value="">Select Type</option>
            <option value="'Updates','Multibases','DAIS','Acds','Legis','LegAll'">All</option>
            <%
            try{
                ps=con.prepareStatement("Select Distinct type from Scope1");
                rs=ps.executeQuery();
                while(rs.next()){
        %>
                <option value="'<%String type1=rs.getString(1).trim();out.print(type1);%>'"><%out.println(type1.trim());%></option>
                <%
            }
            out.println("<Select>");
            }
            catch(Exception e)
                                       {
                out.println(e);
            }
            %>
                            </select></td></tr>
                     <tr><td><input type="submit" value="Generate" id="sub1" name="sub1"></td></tr>
        </table> </form>   </body>
</html>

and the get result is as below.

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="DBCon.jsp" %>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body><table>
        <%
        String a=request.getParameter("type").trim();
        String b=request.getParameter("user").trim();
        String c=request.getParameter("from").trim();
        String d=request.getParameter("to").trim();
        try{%>
        <tr><b><%=b%></b></tr><%
            //String sql=("SELECT type, SUM(Update_Count) FROM Scope1 where type in ("+a+") and Specialist in ("+b+") and (RECVD_DATE >='"+c+"' and RECVD_DATE <='"+d+"') group by type");
            //out.print(sql);
            ps1=con.prepareStatement("SELECT type, SUM(Update_Count) FROM Scope1 where type in ("+a+") and Specialist in ("+b+") and (RECVD_DATE >='"+c+"' and RECVD_DATE <='"+d+"') group by type");
            rs1=ps1.executeQuery();
            while(rs1.next())
            {
            %>

Thanks

Lets see

- Scriptlets in a JSP page
- Database queries in a JSP page
- Queries open to SQL Injection
- Scriptlet tags used instead of expression tags
<%String user2=rs.getString(1);out.println(user2);%>
should be
<%= rs.getString(1) %>
- Form submission invokes a JSP
- That sql query for retrieving users looks overly complicated - do you really need a hierarchical query to retrieve users? Using rownum in the query hints at troubles to me.

All in all, it looks like a horrible mess.
I'm not even 100% certain what your asking because it presumes knowledge of your application, your database structure, and whats in your head.

My suggestions:
- start smaller
- get a good book on JSP Web application design
- java code belongs in a java class - not in a JSP page. JSP should be using JSTL and EL