jsf 2 - getting null value in username and password from database -



jsf 2 - getting null value in username and password from database -

database=db_jsf table=tbl_users fields=id,uname, pword when ever seek run doesn't values form database cannot match database name input text.

public void dbdata(string uname){ try{ class.forname("com.mysql.jdbc.driver"); con = drivermanager.getconnection("jdbc:mysql://localhost:3306/db_jsf","root","root"); ps = con.createstatement(); sql_str="select * tbl_users uname ('" + uname + "')";// rs=ps.executequery(sql_str); rs.next(); dbusername=rs.getstring(2).tostring(); dbpassword=rs.getstring(3).tostring(); }catch(classnotfoundexception ex){ system.err.print("class not found in getconnection"+ex.getmessage()); }catch(exception e) { //e.printstacktrace(); system.out.println("exception error"+e); } } public string checkvaliduser(){ dbdata(username); system.out.println("username ::"+dbusername); system.out.println("password ::"+dbpassword); if(username.equals(dbusername) && password.equals(dbpassword)) { system.out.println("valid data"); homecoming "valid"; } else { system.out.println("invalid data"); homecoming "invalid"; } }

these codes when ever seek come in username , password prints out username:null password:null

jsf-2

Comments

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

Accessing MATLAB's unicode strings from C -

javascript - mongodb won't find my schema method in nested container -