Code for Java Login Form with database connection
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:StudentDetails");
Statement stm=con.createStatement();
ResultSet rs=stm.executeQuery("Select * from Users");
rs.next();
//This gets the username and password from the database
//and assings it to the two variables
String name=(rs.getString("UserName"));
String pass=(rs.getString("Password"));
String AdminUser="StudentAdministrator";
String NurHead="NurseryHead";
String PriHead="PrimaryHead";
String SecHead="SecondaryHead";
//converting the name and password variable from the databse into char [] array
char[] DBUserArray;
DBUserArray=name.toCharArray();
char [] DBPassArray;
DBPassArray=pass.toCharArray();
char AdminArray []=AdminUser.toCharArray();
char NurArray []=NurHead.toCharArray();
char[] PriArray =PriHead.toCharArray();
char[] SecArray=SecHead.toCharArray();
//this line gets the user typed username and password
//and converts inyo char array format
char[] input = txtpassword.getPassword();
String user=txtusername.getText();
char [] userString;
userString=user.toCharArray();
int Admin=0;
if (AdminArray.length==DBUserArray.length||input.length==DBPassArray.length){
Admin=1;
} else if (NurArray.length==DBUserArray.length||input.length==DBPassArray.length){
Admin=2;
} else if (PriArray.length==DBUserArray.length||input.length==DBPassArray.length){
Admin=3;
} else if (SecArray.length==DBUserArray.length||input.length==DBPassArray.length){
Admin=4;
}
switch(Admin) {
case 1: new MainWindow().setVisible(true);
setVisible(false);
break;
case 2: new Customer().SectionA().setVisible(true);
setVisible(false);
break;
case 3: new Customer().SectionB(true);
setVisible(false);
break;
case 4: new Customer().SectionC(true);
setVisible(false);
break;
default: JOptionPane.showMessageDialog(null, "Username and Password Wrong","User Login",JOptionPane.ERROR_MESSAGE);
catch(Exception ex) {
JOptionPane.showMessageDialog(null, "Problem found!"+ex, "Error!", WIDTH);
}