publicbooleanloginValidate(StringaccountNum,Stringpassword){StringtempPass="";ResultSetrs;loginValidSql="selectpasswordfromclient_accountwhereaccount_num=?";try{loginVali...
public boolean loginValidate(String accountNum, String password) {
String tempPass = "";
ResultSet rs;
loginValidSql = "select password from client_account where account_num = ?";
try {
loginValidPrestmt = conn.prepareStatement(loginValidSql);
loginValidPrestmt.setString(1, accountNum);
rs = loginValidPrestmt.executeQuery();
while (rs.next()) {
tempPass = rs.getString(1);
}
if (rs != null) {
if (tempPass.equals(password)) {
return true;
}
}
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
System.out.println("exception");
return false;
}
return false;
}
异常:java.lang.NullPointerException
位置:loginValidPrestmt = conn.prepareStatement(loginValidSql);
public DatabaseModel() {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(dbURL, dbUsername, dbPassword);
} catch (Exception e) {
System.out.println(e.getMessage());
}
}
展开