sql - Can no longer login in Java application after entering wrong login -
i having issue code wherein when try enter wrong login, cannot login more after entering correct login. method login authentication connects database. what's wrong here? jdbc mistake made or in actual java code?
public void loginauthentication(string getusername, string getpassword) throws classnotfoundexception { try { class.forname("org.apache.derby.jdbc.embeddeddriver"); final string dburl = "jdbc:derby:mydb;", dbusername = "adminusername", dbpassword = "mypassword"; connection dbconnection = drivermanager.getconnection(dburl, dbusername, dbpassword); statement querystatement = dbconnection.createstatement(resultset.type_scroll_insensitive, resultset.concur_read_only); string sql = "select * login_details username='" + getusername + "'"; resultset rs = querystatement.executequery(sql); while (rs.next()) { username = rs.getstring("username"); password = rs.getstring("password"); } if ((username == getusername) && (password == getpassword)) { loginsuccess = true; } else { system.out.println("invalid login"); } } catch (sqlexception e) { string errormessage = e.getmessage(); joptionpane.showmessagedialog(null, errormessage); } }
it works fine when enter valid login credentials on first try.
update: using .equals method , can login entering wrong credentials. however, still continue error
"exception in thread "awt-eventqueue-0" java.lang.nullpointerexception".
hope helps guys figure out wrong code.
update: here full stack trace of error
exception in thread "awt-eventqueue-0" java.lang.nullpointerexception @ appdata.login.loginauthentication(login.java:69) @ appgui.startuicomponents$1.actionperformed(startuicomponents.java:105) @ javax.swing.abstractbutton.fireactionperformed(abstractbutton.java:2022) @ javax.swing.abstractbutton$handler.actionperformed(abstractbutton.java:2346) @ javax.swing.defaultbuttonmodel.fireactionperformed(defaultbuttonmodel.java:402) @ javax.swing.defaultbuttonmodel.setpressed(defaultbuttonmodel.java:259) @ javax.swing.plaf.basic.basicbuttonlistener.mousereleased(basicbuttonlistener.java:252) @ java.awt.component.processmouseevent(component.java:6525) @ javax.swing.jcomponent.processmouseevent(jcomponent.java:3324) @ java.awt.component.processevent(component.java:6290) @ java.awt.container.processevent(container.java:2234) @ java.awt.component.dispatcheventimpl(component.java:4881) @ java.awt.container.dispatcheventimpl(container.java:2292) @ java.awt.component.dispatchevent(component.java:4703) @ java.awt.lightweightdispatcher.retargetmouseevent(container.java:4898) @ java.awt.lightweightdispatcher.processmouseevent(container.java:4533) @ java.awt.lightweightdispatcher.dispatchevent(container.java:4462) @ java.awt.container.dispatcheventimpl(container.java:2278) @ java.awt.window.dispatcheventimpl(window.java:2750) @ java.awt.component.dispatchevent(component.java:4703) @ java.awt.eventqueue.dispatcheventimpl(eventqueue.java:758) @ java.awt.eventqueue.access$500(eventqueue.java:97) @ java.awt.eventqueue$3.run(eventqueue.java:709) @ java.awt.eventqueue$3.run(eventqueue.java:703) @ java.security.accesscontroller.doprivileged(native method) @ java.security.protectiondomain$1.dointersectionprivilege(protectiondomain.java:75) @ java.security.protectiondomain$1.dointersectionprivilege(protectiondomain.java:86) @ java.awt.eventqueue$4.run(eventqueue.java:731) @ java.awt.eventqueue$4.run(eventqueue.java:729) @ java.security.accesscontroller.doprivileged(native method) @ java.security.protectiondomain$1.dointersectionprivilege(protectiondomain.java:75) @ java.awt.eventqueue.dispatchevent(eventqueue.java:728) @ java.awt.eventdispatchthread.pumponeeventforfilters(eventdispatchthread.java:201) @ java.awt.eventdispatchthread.pumpeventsforfilter(eventdispatchthread.java:116) @ java.awt.eventdispatchthread.pumpeventsforhierarchy(eventdispatchthread.java:105) @ java.awt.eventdispatchthread.pumpevents(eventdispatchthread.java:101) @ java.awt.eventdispatchthread.pumpevents(eventdispatchthread.java:93) @ java.awt.eventdispatchthread.run(eventdispatchthread.java:82)
Comments
Post a Comment