mysql - Log-In page - Java Swing -
i'm having bother jdbc , creation of log in page. have button called btnlogin , 2 text fields, 1 called usernamefield, , other called passwordfield(which actual password field).
what i'm trying achieve is, when user enters information fields, database searches the database have set up, 'logs in' displaying appropriate welcome message or error message.
what doing wrong? very lost. code below.
btnlogin.addactionlistener(new actionlistener() { @suppresswarnings({ "deprecation" }) public void actionperformed(actionevent arg0) { // creating connection , query variables connection conn = null; resultset rs = null; preparedstatement pst = null; string url = "jdbc:mysql://my.db.url/*******"; //load driver try { class.forname("com.mysql.jdbc.driver"); // making connection conn = drivermanager.getconnection(url, "*******", "*******"); // query string sql = "select * log_in username = ? , pssword = ?"; pst = conn.preparestatement(sql); pst.setstring(1, usernamefield.gettext()); pst.setstring(2, passwordfield.gettext()); rs = pst.executequery(sql); if(rs.next()){ //retrieve column name string username = rs.getstring("username"); system.out.println("username : " + username); string password = rs.getstring("pssword"); system.out.println("password : " + password); lbllog_in.settext("welcome."); } else { lbllog_in.settext("error: invalid log in information."); } } catch (sqlexception e) { system.out.println("sql exception."); } catch (classnotfoundexception e) { system.out.println("class not found exception."); } } });
Comments
Post a Comment