连接远程数据库与查询

一、连接远程数据库

修改配置：

测试连接：

二、分页查询

创建查询方法编写sql语句

<select id="selectAll" parameterType="int" resultMap="BaseResultMap">
    SELECT * FROM auth_user ORDER BY id DESC LIMIT #{pageIndex}, #{pageSize}
  </select>

主程序：

 /**
     * 分页查询用户
     * @param pageIndex
     * @param pageSize
     * @return
     */
    public HttpResult getAll(int pageIndex,int pageSize){

        List<AuthUser> users = userMapper.selectAll((pageIndex - 1)* pageSize, pageSize);
        return new HttpResult(200,null,users);
    }

 效果图

三、登录

   /**
     * 登录
     * @param phone
     * @param password
     * @return
     */
    public HttpResult login(String phone,String password){
        HttpResult result = null;
        AuthUser authUser = new AuthUser();
        authUser.setPhone(phone);
        authUser.setPasswd(password);
        List<AuthUser> users = userMapper.select(authUser);
        if (users.size() > 0){
            result = new HttpResult(200,null,"登陆成功");
        }else {
            result = new HttpResult(500,"账号或密码错误",null);
        }
        return result;
    }

 效果图

四、关联表使用

将其先全部删除再全部添加

  /**
     * 角色分配资源
     * @param roleId
     * @param resIds
     * @return
     */
    public HttpResult assignRole(int roleId,String[] resIds){
        HttpResult result = null;
        try {
            AuthRoleRes roleRes1 = new AuthRoleRes();
            roleRes1.setRoleid(roleId);
            roleResMapper.delete(roleRes1);

            for (String resId:resIds) {
                AuthRoleRes roleRes = new AuthRoleRes();
                roleRes.setRoleid(roleId);
                roleRes.setResid(Integer.parseInt(resId));
                roleResMapper.insert(roleRes);
            }
            result = new HttpResult(200,null,"授权成功");
        } catch (Exception e) {
            e.printStackTrace();
            result = new HttpResult(500,"授权失败",null);
        }
        return result;
    }