Notes

package shalgalt;


import java.awt.Color;
import java.awt.EventQueue;
import java.awt.Font;
import java.awt.Taskbar.State;
import java.awt.Window.Type;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.border.EmptyBorder;
import java.sql.*;

public class Login extends JFrame {
private JPanel contentPanel;
private JTextField user;
private JPasswordField pass;
private JButton addButton;
private JButton updateButton;
private JButton deleteButton;
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
Login login = new Login();
}
});

}
public Login() {
JFrame frame = new JFrame();
frame.setVisible(true);
frame.setDefaultCloseOperation(EXIT_ON_CLOSE);
frame.setBounds(100,100,250,250);

contentPanel= new JPanel();
contentPanel.setBorder(new EmptyBorder(5,5,5,5));
frame.setContentPane(contentPanel);
contentPanel.setLayout(null);

JLabel labelWelcome = new JLabel("Welcome");
labelWelcome.setBounds(10,10,200,45);
contentPanel.add(labelWelcome);

JLabel lblUsername = new JLabel("Username");
lblUsername.setBounds(20,64,62,14);
contentPanel.add(lblUsername);

user = new JTextField();
user.setBounds(10,78,198,28);
contentPanel.add(user);
user.setColumns(10);

JLabel lblPassword = new JLabel("Password");
lblPassword.setBounds(20,117,62,14);
contentPanel.add(lblPassword);

pass = new JPasswordField();
pass.setBounds(10,132,198,28);
contentPanel.add(pass);

JButton loginBtn = new JButton("Nevtreh");
loginBtn.addActionListener(new ActionListener() {
private JFrame frmLogin;

public void actionPerformed(ActionEvent e) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con = DriverManager.getConnection
("jdbc:mysql://localhost:3306/pawn shop","root","");

Statement stmt = con.createStatement();
String sql = "SELECT * FROM users WHERE "
+ "username='"+user.getText()+"' AND password='"+pass.getText()+"'";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()) {
MainPage mp = new MainPage();
frame.dispose();
JOptionPane.showMessageDialog(null, "Login Successfully...");
}else {
JOptionPane.showMessageDialog(null, "Login failed...");
}
}catch (Exception ex){
System.out.print(ex);
}
}
});
loginBtn.setBounds(10,170,90,25);
contentPanel.add(loginBtn);

JButton regBtn = new JButton("Burtgel");
regBtn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
Register rg = new Register();
}catch (Exception ex){
System.out.print(ex);
}
}
});
regBtn.setBounds(110,170,90,25);
contentPanel.add(regBtn);
}
}