sqllite java 密码,SQLite登录检查用户名和密码

我正在创建一个应用程序(使用Java和SQLite)(JFrame，使用Netbeans)我有我想要登录的用户 . (我有所有正确的包JDBC，SQLite等)

我遇到的问题似乎是获取用户名/密码来检查我的users.db文件..我正在使用Java和SQLite . 我也在使用JDBC .

我的一些代码作为一个例子(这发送我的用户信息来创建帐户，工作正常)，我的数据库是users.db，我想比较USERNAME＆PASSWORD的用户名/密码

Connection dbconn = null;

Statement stmt = null;

String query = "insert into USERS(ID, FIRSTNAME, SECONDNAME, USERNAME, PASSWORD, JAVALESSON, CLESSON, PYTHONLESSON) values(?, ?, ?, ?, ?, ?, ?, ?)";

try {

Class.forName("org.sqlite.JDBC");

dbconn = DriverManager.getConnection("jdbc:sqlite:users.db");

Statement statement = dbconn.createStatement();

PreparedStatement pstmt = dbconn.prepareStatement(query);

我有一个UsernameLoginBox和PasswordLoginBox，如何根据文本框中的字符串检查USERNAME＆PASSWORD(来自SQLite数据库)以进行登录？

经过审查的代码：

Connection conn = null;

ResultSet rs =null;

PreparedStatement pst =null;

String sql1 = "Select * from USERS where USERNAME=? and PASSWORD=?";

try{

pst = conn.prepareStatement(sql1);

pst.setString(1, UsernameLogIn.toString());

pst.setString(2, PasswordLogInField.getText());

rs=pst.executeQuery();

if(rs.next()){

JOptionPane.showMessageDialog(null, "Username & Password are correct");

} else {

JOptionPane.showMessageDialog(null, "Username & Password are incorrect");

System.out.println("Logged in");

}

}

catch(Exception e){

JOptionPane.showMessageDialog(null, e);

System.out.println("Not Logged in");

}

还有这个：

Connection cbconn = null;

Statement stmt2 = null;

String upcheck = "SELECT USERNAME, PASSWORD FROM USERS";

ResultSet rs = Statement.executeQuery(upcheck);

while (results.next()) {

String staffname = results.getString("snameeee");

String password = results.getString("SPwd");

if ((f.equals(staffname)) && (s.equals(password))) {

JOptionPane.showMessageDialog(null, "Username and Password exist");

}else {

//JOptionPane.showMessageDialog(null, "Please Check Username and Password ");

}

results.close();

} catch (SQLException sql) {

out.println(sql);