sqlite java login based on username password and position
I am a new java programmer working in netbeans and I am trying to make a login based on a sqlite database. Inside the database, I have a username column, a password column, and a position column. The purpose of the login is for when a user inputs his username and password and pressed the login button, the program would connect to the sqlite database, access a specific table on the database, check to see if the the username and password field matches, and then depending on their position (Administrator, Manager, or Teacher), they will go to a different jframe. At the moment, I created a code that will take the jtextfield from the login jframe and run it through the sqlite database for any matches, save the the result to a jdialog with jtextfields that is hidden, and then depending if the username and password jtextfield in the jdialog empty or not as well as well depending on which position that username has (Administrator, Manager, or Teacher), the login jframe will close with the respective jframe opening.
This is my code for connecting to the sqlite database
private void loginDatabase(){
//Checks to see if Login is Administrator and then sends him to his respective location
String userName1 = Usr1.getText();
String passWord1 = Pass1.getText();
try{
String query1 = "select * from LoginManager where Username='"+userName1+"' and Password='"+passWord1+"' and Position=?";
PreparedStatement pst1 = conn.prepareStatement(query1);
ResultSet rs1 = pst1.executeQuery();
if (rs1.next()){
String add1 = rs1.getString("Username");
usernameCon1.setText(add1);
String add2 = rs1.getString("Password");
passwordCon1.setText(add2);
String add3 = rs1.getString("Position");
positionCon1.setText(add3);
}
pst1.close();
rs1.close();
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
This is my code for the actual work (currently, both methods are not attach to a button on enter key press because I'm trying to make them into classes first and then putting them in there)
private void login(){
loginDatabase();
if (usernameCon1.getText().matches(regex) &&passwordCon1.getText().matches(Pass1.getText()) && positionCon1.getText().equals("Administrator")){
Admin();
usernameCon1.setText("");
passwordCon1.setText("");
positionCon1.setText("");
Usr1.setText("");
Pass1.setText("");
}
else if (!usernameCon1.getText().isEmpty() && !passwordCon1.getText().isEmpty() && positionCon1.getText().equals("Manager")){
}
else if (!usernameCon1.getText().isEmpty() && !passwordCon1.getText().isEmpty() && positionCon1.getText().equals("Teacher")){
}
else {
JOptionPane.showMessageDialog(null, "Invalid Login", "Invalid Login", JOptionPane.ERROR_MESSAGE);
}
}
Ultimately, I'm having trouble with that if else statement.
I apologize for the crazy syntax. When I started this project, I was really new to coding etiquette. I have been trying to change my habit throughout my program and all my other programs will be in proper format.
Thanks again for the help.
EDIT: So I figured it out, I simply removed the extra stuff from the sql statement to only get the information based on the username and password.
String query1 = "select * from LoginManager where Username='"+userName1+"' and Password='"+passWord1+"'";
For a better code structure, use a User class.
public class User{
public String userName;
public String passWord;
public String position;
public User(String userName,String passWord,String position){
this.userName = userName;
this.passWord = passWord;
this.position = position;
}
}
To properly use PreparedStatment, prepare the parameters. like this:
String query = "select * from LoginManager where Username=? and Password=?";
PreparedStatement stmt = con.prepareStatement(query);
//Parameters
stmt.setString(1, userName);
stmt.setString(2, passWord);
//Execute
stmt.executeQuery();
loginDatabase method return the user object or null case login failed
public User loginDatabase(String userName,String passWord){
User user = null;
String query = "select * from LoginManager where Username=? and Password=?";
PreparedStatement stmt = con.prepareStatement(query);
//Parameters
stmt.setString(1, userName);
stmt.setString(2, passWord);
//Execute
ResultSet res = stmt.executeQuery();
if(res.next()){
//You dont need to find userName & passWord, are already exists
String position = res.getString("position");
user = new User(userName, passWord, position);
}
return user;
}
And finally, to check user position.
public void login(){
String userName = userNameTF.getText();
String passWord = passWordTF.getText();
User user = loginDatabase(userName, passWord);
if(user != null){
switch(user.position){
case "Administrator":
// ...
break;
case "Manager":
// ...
break;
case "Teacher":
// ...
break;
}
}else{
// login failed 'Invalid login'
}
}
-
05:30
-
04:00
-
00:00
-
10:30
-
9:10
-
07:40
Firebase Cloud Functions: PubSub, "res.on is not a function"
-
04:00
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
-
9:20
-
7:40
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 111570 visits
- search for elements in a list 111065 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98827 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 96332 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92528 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 62042 visits
- Adding methods to es6 child class 22376 visits
