setString(1,username)是意思

最新推荐文章于 2022-09-17 11:44:04 发布

老道长的漫长修炼

最新推荐文章于 2022-09-17 11:44:04 发布

阅读量1.5k

点赞数

文章标签： mysql jdbc

本文链接：https://blog.csdn.net/weixin_47239885/article/details/116994931

版权

SQL语句：private static final String SelectUserByName=“SELECT sys_user.id,sys_user.user_name,sys_user.user_password,sys_user.salt,sys_user.department_id,sys_user.position_id,sys_user.role_id,sys_user.real_name,sys_user.gender,sys_user.birthday,sys_user.portrait,sys_user.email,sys_user.mobile,sys_user.qq,sys_user.wechat,sys_user.user_status,sys_user.remark ,sys_department.department_name,sys_position.position_name,sys_role.role_name FROM sys_user INNER JOIN sys_department ON sys_user.department_id = sys_department.id INNER JOIN sys_position ON sys_user.position_id = sys_position.id INNER JOIN sys_role ON sys_user.role_id = sys_role.id WHERE sys_user.is_deleted=0 AND sys_user.user_name=?”;

@Override
public UserVo selectUserByName(String userName) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;

    UserVo userVo=null;
    try {
        conn= JdbcUtils.getConnection();//连接数据库
        ps=conn.prepareStatement(SelectUserByName);//创建数据库对象
        **ps.setString(1,userName);给第一个问号赋值**

        rs=ps.executeQuery();
        while (rs.next()){
            userVo=new UserVo();
            userVo.setId(rs.getInt("id"));
            userVo.setUserName(rs.getString("user_name"));
            userVo.setUserPassword(rs.getString("user_password"));
            userVo.setSalt(rs.getString("salt"));
            userVo.setDepartmentId(rs.getInt("department_id"));
            userVo.setPositionId(rs.getInt("position_id"));
            userVo.setRoleId(rs.getInt("role_id"));
            userVo.setRealName(rs.getString("real_name"));
            userVo.setGender(rs.getByte("gender"));
            userVo.setPortrait(rs.getString("portrait"));
            userVo.setBirthday(new Date(rs.getDate("birthday").getTime()));
            userVo.setEmail(rs.getString("email"));
            userVo.setMobile(rs.getString("mobile"));
            userVo.setQq(rs.getString("qq"));
            userVo.setWechat(rs.getString("wechat"));
            userVo.setUserStatus(rs.getByte("user_status"));
            userVo.setRemark(rs.getString("remark"));
            userVo.setDepartmentName(rs.getString("department_name"));
            userVo.setPositionName(rs.getString("position_name"));
            userVo.setRoleName(rs.getString("role_name"));
        }
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }finally {
        JdbcUtils.close(conn,ps,rs);
    }
    return userVo;
}