This Example will teach you how to do the Role based Login Application in Java MySQL. This application is very impotent when you do the industrial projects like hospital management system, inventory system, school management etc.
There are various actors if you take the example of hospital management system. have to give the different permission to each actors like Doctor,Patient,IT Enginner,Admin.
Login Form
Login form consist of three different roles those are Admin,Enginner,Receptionist. assign each actor role as different colors.color would be change based on the role.
Create there objects
Connection con; PreparedStatement pst; ResultSet rs;
Login button Code
String username = txtUname.getText();
String password = txtPass.getText();
String utype = txtUtype.getSelectedItem().toString();
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/employeeinfo","root","");
pst = con.prepareStatement("select * from user where uname =? and password =? and utype = ?");
pst.setString(1, username);
pst.setString(2, password);
pst.setString(3, utype);
rs= pst.executeQuery();
if(rs.next())
{
int userid = rs.getInt("id");
this.hide();
new Main(username,utype).setVisible(true);
}
else
{
JOptionPane.showMessageDialog(this,"UserName and Password do not Match");
}
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch (SQLException ex) {
ex.printStackTrace();
}
Login Form Code
Main Form
if the user login successfully role will be shown to the Main form along with the color and username and user type.
Main Form Code
String uname;
String utype;
public Main(String username, String utype) {
initComponents();
this.uname = username;
this.utype = utype;
lblUtype.setText(this.utype);
String usertype = lblUtype.getText().trim();
if(utype.equals("admin"))
{
lblUser.setText(this.uname);
lblUser.setForeground(Color.RED);
lblUtype.setText(this.utype);
lblUtype.setForeground(Color.RED);
}
else if(utype.equals("receptionist"))
{
lblUser.setText(this.uname);
lblUser.setForeground(Color.BLUE);
lblUtype.setText(this.utype);
lblUtype.setForeground(Color.BLUE);
}
else
{
lblUser.setText(this.uname);
lblUser.setForeground(Color.GREEN);
lblUtype.setText(this.utype);
lblUtype.setForeground(Color.GREEN);
}
}i have attached the video link below. which will do this tutorials step by step.
