Advertisement
Guest User

Untitled

a guest
Jun 12th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.07 KB | None | 0 0
  1.  try{
  2.        Class.forName("com.mysql.jdbc.Driver").newInstance();
  3.        Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/database?zeroDateTimeBehavior=convertToNull","root","");
  4.        Statement state= conn.createStatement();
  5.        
  6.        String sql="SELECT * FROM login where username="+"'"+nama.getText()+"'"+"AND katasandi="+"'"+pw.getText()+"'";
  7.        ResultSet rs = state.executeQuery(sql);
  8.        String user = null;
  9.        String pass = null;
  10.        while(rs.next()){
  11.        user = rs.getString(1);
  12.        pass = rs.getString(2);
  13.        }
  14.         if(!user.equals(null)&& !pass.equals(null))
  15.         {
  16.             this.setVisible(false);
  17.             new MENU().setVisible(true);    
  18.         }
  19.         else {
  20.          JOptionPane.showMessageDialog(null,"Username Password Salah");    
  21.             nama.setText("");
  22.             pw.setText("");
  23.             nama.requestFocus();
  24.                 }
  25.        }
  26.        catch (Exception e)
  27.        {
  28.            JOptionPane.showMessageDialog(null,"Username Password Salah"+e.getMessage());
  29.        }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement