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
Post a Comment