import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class fLogin extends JFrame{
JLabel luser, lpass;
JTextField tuser, tpass;
JButton blogin;
JPanel panelform, paneltombol;
String url = "jdbc:mysql://localhost/praktikum";
String username = "root";
String password = "";
Connection conn;
Statement st;
public fLogin(){
setTitle("LOGIN PLEASE");
setSize(250,150);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setVisible(true);
luser = new JLabel("USERNAME");
lpass = new JLabel("PASSWORD");
tuser = new JTextField(9);
tpass = new JTextField(50);
blogin = new JButton("LOGIN");
panelform = new JPanel(new GridLayout(2, 2));
paneltombol = new JPanel(new FlowLayout());
setLayout(new BorderLayout());
add(panelform, BorderLayout.NORTH);
panelform.add(luser);
panelform.add(tuser);
panelform.add(lpass);
panelform.add(tpass);
add(paneltombol, BorderLayout.SOUTH);
paneltombol.add(blogin);
blogin.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
masukkanData();
}
});
}
public void masukkanData(){
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,username,password);
st = conn.createStatement();
String sql = "select * from mhs where username = '" +tuser.getText()+ "' and password = '" +tpass.getText()+ "'";
ResultSet rs =st.executeQuery(sql);
if (rs.next() != false){
String nama = rs.getString("username");
JOptionPane.showMessageDialog(null, "selamat datang "+nama, "Hasil", JOptionPane.INFORMATION_MESSAGE);
}else{
JOptionPane.showMessageDialog(null, "Username atau password salah", "Hasil", JOptionPane.INFORMATION_MESSAGE);
}
st.close();
conn.close();
}catch (SQLException ex){
System.out.print(ex);
JOptionPane.showMessageDialog(null, "SQL salah!", "Hasil", JOptionPane.INFORMATION_MESSAGE);
}catch (ClassNotFoundException ex){
JOptionPane.showMessageDialog(null, "driver tidak ditemukan", "Hasil", JOptionPane.ERROR_MESSAGE);
}
}
public static void main(String[] args) {
fLogin a = new fLogin();
}
}
Tidak ada komentar:
Posting Komentar