50,550
社区成员
发帖
与我相关
我的任务
分享
package dao;
import beans.JDBConnection;
import beans.ManagerForm;
//import java.util.*;
import java.sql.*;
public class ManagerDAO {
private JDBConnection conn = new JDBConnection();
public int checkManager(ManagerForm managerForm)
throws Exception{
int flag = 0;
//查询是否有管理员帐号
String sql = "select * from tb_manager where account='" + managerForm.getAccount()+ "'";
ResultSet rs = conn.executeQuery(sql);
System.out.print("验证ret的值:" + rs);//rs值为1,证明取到值了,对吧
try {
//存在该帐号
if (rs.next()) {
//获得管理员密码
System.out.print(rs.getString("password"));
String password = managerForm.getPassword();//获取输入的密码
//密码正确,置flag为1,管理员帐号密码都正确
if (password.equals(rs.getString("password"))) {
flag = 1;
System.out.print("验证ret的值:" + flag);
}
else {
flag = 0;
}
}
else{
flag = 0;
}
}
catch (SQLException ex) {
flag = 0;
}
finally {
conn.closeConnection();
}
return flag;
}
}
catch(Exception e)
{
e.printStackTrace();
}