Advertisement
Guest User

Untitled

a guest
Jan 17th, 2017
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. String url = "jdbc:ucanaccess://C:/Users/hp/Documents/student.accdb";
  2. String user = ""; String pass = "";
  3. try {
  4. connect = DriverManager.getConnection(url, user, pass);
  5. System.out.println("Database tersambung");
  6. PreparedStatement st = connect.prepareStatement("select * from akun");
  7. ResultSet rs = st.executeQuery();
  8. while(rs.next()){
  9. if(jTextField1.getText().equals(rs.getString(1).replaceAll("<div>","").replaceAll("</div>",""))&&
  10. jTextField2.getText().equals(rs.getString(2).replaceAll("<div>","").replaceAll("</div>",""))){
  11. rs.close(); break;
  12. }
  13. }
  14. if(rs.isClosed()){
  15. dispose();
  16. new penduduk().setVisible(true);
  17. } else{
  18. JOptionPane.showMessageDialog(rootPane, "Username atau password salah","GAGAL",JOptionPane.ERROR_MESSAGE);
  19. jTextField1.setText(null); jTextField2.setText(null);
  20. }
  21.  
  22.  
  23. } catch(Exception e){
  24. System.out.println(e.getMessage());
  25. }
  26. } `
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement