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

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

c# - Access objects in UserControl from MainWindow in WPF -

javascript - How to name a jQuery function to make a browser's back button work? -