How to fill select list from database table

Greenhorn

Posts: 25

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

How to fill select list from database table using servlet and jsp.

my code is given below please tell me where it goes wrong and proper solution also.
1.UsersDetail.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import = "java.util.*;" %>

<html>
<head>
    <title>
        Select User
    </title>
   
    
</head>
<body bgcolor="LIGHTGREY" onload="UserDetailServlet">
    <form method="post" action="UserDetailServlet">
            <table border="1">

<tr><td colspan="8" align="center">  <center><font size="4"><b> Verify User Details !</b></font></center></td></tr>
                    
                <tr> <td> <font size="2"> Select User Name </font></td>      
                    <td> <font size="2"> Name </font></td>      
                    <td align="center"><font size="2"> Password </font></td>
                    <td align="center"> <font size="2"> Address </font></td>
                    <td align="center"><font size="2"> Contact No </font></td>
                    <td align="center"><font size="2"> Gender </font></td>
                    <td align="center"><font size="2"> E-mail id </font></td></tr>
                <tr>           
                    <td align="center" >

<%   
String username, password, address, male, email, cont, nm,str,slt1,sh,up;
   Vector uname = new Vector();
uname = (Vector)request.getAttribute("uname");     
  if(uname == null) {       
out.println("No Users Found");    
     
 }  
  
%>
                  <select id="my" name="my">
                  <Option value ="select">Select User Name</option> 
                      
                        <%
                            try
                            {
                         for(int i=0; i < uname.size(); i++)  
                          {
                            %>
                             <option value="<%=uname.elementAt(i) %>"> <%=(String)uname.elementAt(i) %>  </option> 
                                                         
                        <%
                        }
                            }
               catch(Exception e) 
		  		{
				}
%>
               </select>

</body>
            </html>

2. UserDetailServlet.java

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class UserDetailServlet
 */
@WebServlet("/UserDetailServlet")
public class UserDetailServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public UserDetailServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		try {
						
			doCommon(request, response);
		} catch (ClassNotFoundException e) {		
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	
	protected void doCommon(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException {
		
		ConnectionFactory fact = new ConnectionFactory();
		Connection c = fact.getConnectionType4();
		Statement stmt = c.createStatement();
		ResultSet rs = stmt.executeQuery("SELECT * FROM ALOGIN");
		//PrintWriter out = response.getWriter();
		String name;
		String n,p;
		String password, address, male, email, cont, nm,str = null,slt1 = null,sh,up;
	    String upnam, uppassword, upaddress, upmale, upemail, upcont, upnm;
	    String slt = "";
	    int flag = 0, a = 0, temp = 0;
	    long contact, upcontact;
	    boolean b = false;
		
	    Vector listOfUsers = new Vector();    
        
        if(rs != null)
        {    
           while(rs.next())
           {     
           	listOfUsers.addElement(rs.getString(2));    
           }     
        }    
		
		
        request.setAttribute("uname", listOfUsers);     
		
		 
        
         slt = request.getParameter("my");
         up = request.getParameter("update");      
         sh = request.getParameter("show");
         
         
      if( sh.equals("show"))
            {
                rs = stmt.executeQuery("select * from login");

while (rs.next())
                {
                    nm = rs.getString(2);

if (nm.equals(slt))
                    {
                        str = nm;
                        request.setAttribute("nm", str);
                        slt1 = slt;
                        name = rs.getString(1);
                        request.setAttribute("name", name);
                        password = rs.getString(3);
                        request.setAttribute("password", password);
                        address = rs.getString(4);
                        request.setAttribute("address", address);
                        male = rs.getString(6);
                        request.setAttribute("male", male);
                        email = rs.getString(7);
                        request.setAttribute("email", email);
                        cont = rs.getString(5);
                        contact = Long.parseLong(cont);
                        request.setAttribute("contact", contact);
                        temp = 1;
                    }
                }
            }
         
      
      
         if( sh.equals("update"))
              {
                                  
             if (temp == 1)
                 
               {
                             
                   upnam= request.getParameter("udn");
                   uppassword=request.getParameter("udp");
                   upaddress=request.getParameter("uda");
                   upmale=request.getParameter("udg");
                   upemail=request.getParameter("ude");
                   upcont=request.getParameter("udc");
                   upcontact = Long.parseLong(upcont);
                   upnm=request.getParameter("udg");

b=stmt.execute("update login SET NAME = '" + upnam + "' , USERNAME = '"+ slt1 + "', PASSWORD = '" + uppassword + "', ADDRESS = '" + upaddress + "', CONTACT= '"+upcontact+ "', GENDER = '"+upmale+ "', EMAIL= '"+upemail+ "'  where username='"+ str +"' "); 
               }
             }
				
		
	}
	
	
	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		try {
						
				doCommon(request, response);
			
		}
		catch (ClassNotFoundException e)
		{		
				e.printStackTrace();
			}
		catch (SQLException e) 
		{
				e.printStackTrace();
			}
		
			
	}

}

Bear Bibeault

Sheriff

Posts: 67634

173

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Wow, you are really using some outdated stuff there. Firstly, a List implementation should be used in place of Vector. And any JSP page written since 2002 (that's 10 year ago!) should not have Java scriptlets in them. You should be using the JSTL and EL. Please read this JspFaq entry.

You also have not told us what the problem is. Just saying that it doesn't work, doesn't help us to help you. Please read ItDoesntWorkIsUseless, and provide more details as to what your problem is.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Then YOU must do the pig's work! Read this tiny ad. READ IT!

Free, earth friendly heat - from the CodeRanch trailboss

https://www.kickstarter.com/projects/paulwheaton/free-heat