JavaWeb用户信息管理系统-创建登录业的务持久层
1 创建用户查询数据库的接口
public interface UserLoginDao {
public Users selectUsersByUserPwd(String username,String userpwd);
}
2 创建实现类
public class UserLoginDaoImpl implements UserLoginDao {
/**
* 用户登录的数据库查询
*/
Users user = null;
@Override
public Users selectUsersByUserPwd(String username, String userpwd) {
Connection conn = null;
try {
conn = JdbcUtils.getConnection();
PreparedStatement ps = conn.prepareStatement("select *from where username=? and userpwd =?");
ps.setString(1, username);
ps.setString(2, userpwd);
ResultSet resultSet = ps.executeQuery();
while (resultSet.next()) {
user = new Users();
user.setUsersex(resultSet.getString("usersex"));
user.setUserpwd(resultSet.getString("userpwd"));
user.setUsername(resultSet.getString("username"));
user.setUserid(resultSet.getInt("userid"));
user.setPhonenumber(resultSet.getString("phonenumber"));
user.setQqnumber(resultSet.getString("qqnumber"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
}
return user;
}
}
也就是将数据库的数据拿了出来,等等要进行比较。