Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String url = "jdbc:ucanaccess://C:/Users/hp/Documents/student.accdb";
- String user = ""; String pass = "";
- try {
- connect = DriverManager.getConnection(url, user, pass);
- System.out.println("Database tersambung");
- PreparedStatement st = connect.prepareStatement("select * from akun");
- ResultSet rs = st.executeQuery();
- while(rs.next()){
- if(jTextField1.getText().equals(rs.getString(1).replaceAll("<div>","").replaceAll("</div>",""))&&
- jTextField2.getText().equals(rs.getString(2).replaceAll("<div>","").replaceAll("</div>",""))){
- rs.close(); break;
- }
- }
- if(rs.isClosed()){
- dispose();
- new penduduk().setVisible(true);
- } else{
- JOptionPane.showMessageDialog(rootPane, "Username atau password salah","GAGAL",JOptionPane.ERROR_MESSAGE);
- jTextField1.setText(null); jTextField2.setText(null);
- }
- } catch(Exception e){
- System.out.println(e.getMessage());
- }
- } `
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement