LOGIN FORM
1} FIRST MAKE YOUR LOGIN FORM LAYOUT
2} THEN IMPORT THESE TO YOUR PACKAGE
import java.sql.*;
import javax.swing.JOptionPane;
3} THEN WORK ON CODING
private void loginActionPerformed(java.awt.event.ActionEvent evt)
{
String sql="Select * from login";
try {
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdtabase_name","yourmysql_id","yourmysql_password");
Statement stmt=con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String user=jTextField1.getText();
String pwd= new String (jPasswordField1.getPassword());
if (rs.next()) {
String uname=rs.getString("EMPLOYEE_ID");
String password=rs.getString("PASSWORD");
if ((user.equals(uname))&&(pwd.equals(password)))
{
new menu().setVisible(true);
JOptionPane.showMessageDialog(null,"Successfull Login");}
else
{
JOptionPane.showMessageDialog(null,"Incorrect Username or Password!");
new menu().setVisible(false);
}
}
}
catch (Exception e){
System.out.print("error in connectivity");
}
NOW READY TO RUN !
THANKYOU
