import javax.swing.*;
import javax.swing.JOptionPane;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class formLogin extends JFrame {


    private JButton button1;
    private JTextField textField1;
    private JPasswordField passwordField1;
    private JPanel Login;

    public formLogin() {
        setContentPane(Login);
        pack();
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);


        button1.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String sql="Select * from main";
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    Connection con= (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/testbd","root","qqq111");
                    Statement stmt=con.createStatement();
                    ResultSet rs = stmt.executeQuery(sql);
                    String user=textField1.getText();
                    String pwd= new String (passwordField1.getPassword());
                    while(rs.next()) {
                        String uname=rs.getString("name");
                        String password=rs.getString("passw");
                        if ((user.equals(uname)) && (pwd.equals(password)))
                           JOptionPane.showMessageDialog(null, "Nice");
                    }
                }
                catch (Exception es){
                    JOptionPane.showMessageDialog(null, es.getMessage());
                }
            }
        });
        setVisible(true);
    }
}

public class Start {
    public static void main(String[] args){
        Home Start = new Home();
    }
}