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;
    }
}

也就是将数据库的数据拿了出来，等等要进行比较。