simple login form using java and db2 . everything ok but still resultset empty -


i trying make simple login form. every thing working fine, connection established, query executed resultset still empty getting redirected fail.jsp. no error no warning @ all.

servlet code:

protected void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception {     string name = request.getparameter("name");     string password = request.getparameter("password");     modelclass md = new modelclass();     daoclass dao = new daoclass();     md.setname(name);     md.setpassword(password);     system.out.println("this before sql query on main servlet page");     string sql = "select * useradd name = ? , password= ?";     string result = dao.guser(md, sql);     if (result.equals("success")) {         response.sendredirect("welcome.jsp");     } else {         response.sendredirect("fail.jsp");     }  } 

this dao class makes connection.

data access code(dao.java):

public class daoclass {      public static string username = "nickneo";     public static string password = "123123";     public static string driver = "com.ibm.db2.jcc.db2driver";     public static string url = "jdbc:db2://localhost:50000/citylife";     public static connection con = null;     public static preparedstatement ps = null;      static {          try {             class.forname(driver);             system.out.println("before connection");             con = drivermanager.getconnection(url, username, password);             system.out.println("connection successfullll......!!!!!!");         } catch(exception e) {             e.printstacktrace();         }     }     public string guser(modelclass obj, string sql) {          try {             system.out.println("entry try block");             ps=con.preparestatement(sql);             ps.setstring(1, obj.getname());             ps.setstring(2, obj.getpassword());             system.out.println("before query");             resultset rs = ps.executequery();             system.out.println("query executed");             int = 0;             while(rs.next()) {                 system.out.println("entered while loop");                 ++i;             }             if (i >= 1) {                 return "success";             } else {                 system.out.println("this inside else of while block");                 return "fail";             }          } catch(exception e) {             e.printstacktrace();         }         system.out.println("this outer fail statement");         return "fail";     } } 

the rs empty. tried many things still getting rs empty. please help


Comments