mybatis分页返回数据

最新推荐文章于 2024-07-18 18:15:00 发布

m0_37825155

最新推荐文章于 2024-07-18 18:15:00 发布

阅读量621

点赞数

文章标签： mybatis

本文链接：https://blog.csdn.net/m0_37825155/article/details/121350828

版权

修改mapper.xml,添加

<sql id="Base_Column_List">
    id, serverIp, dbOperateType, dbType, serverPass, serverPort, dbIp, dbport, dbUsename,
    dbPass, dbDatabaseName, backupPath, oracleBase, oracleHome, oracleSid, oraclePath,
    oracleNlsLang, pgLocation, resultmessage, resultFlag, shellcode, operateTime, operateId,
    serverUserName
</sql>

<select id="selectList" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from SecurityBackupMgr where dboperatetype='bf' order by operatetime desc
</select>

    <resultMap id="BaseResultMap" type="com.XXX.XXXX.XXX.entity.SecurityBackupMgr">
    <id column="id" jdbcType="DECIMAL" property="id" />
    <result column="serverIp" jdbcType="VARCHAR" property="serverip" />
    <result column="dbOperateType" jdbcType="VARCHAR" property="dboperatetype" />
    <result column="dbType" jdbcType="VARCHAR" property="dbtype" />
    <result column="serverPass" jdbcType="VARCHAR" property="serverpass" />
    <result column="serverPort" jdbcType="VARCHAR" property="serverport" />
    <result column="dbIp" jdbcType="VARCHAR" property="dbip" />
    <result column="dbport" jdbcType="VARCHAR" property="dbport" />
    <result column="dbUsename" jdbcType="VARCHAR" property="dbusename" />
    <result column="dbPass" jdbcType="VARCHAR" property="dbpass" />
    <result column="dbDatabaseName" jdbcType="VARCHAR" property="dbdatabasename" />
    <result column="backupPath" jdbcType="VARCHAR" property="backuppath" />
    <result column="oracleBase" jdbcType="VARCHAR" property="oraclebase" />
    <result column="oracleHome" jdbcType="VARCHAR" property="oraclehome" />
    <result column="oracleSid" jdbcType="VARCHAR" property="oraclesid" />
    <result column="oraclePath" jdbcType="VARCHAR" property="oraclepath" />
    <result column="oracleNlsLang" jdbcType="VARCHAR" property="oraclenlslang" />
    <result column="pgLocation" jdbcType="VARCHAR" property="pglocation" />
    <result column="resultmessage" jdbcType="VARCHAR" property="resultmessage" />
    <result column="resultFlag" jdbcType="VARCHAR" property="resultflag" />
    <result column="shellcode" jdbcType="VARCHAR" property="shellcode" />
    <result column="operateTime" jdbcType="TIMESTAMP" property="operatetime" />
    <result column="operateId" jdbcType="VARCHAR" property="operateid" />
    <result column="serverUserName" jdbcType="VARCHAR" property="serverusername" />
</resultMap>

修改dao,添加
   Page<SecurityBackupMgr> selectList();

   修改service
    ResponseResult<PageInfo<SecurityBackupMgr>> getList(int pageNum, int pageSize);
   修改service实现
       @Override
    public ResponseResult<PageInfo<SecurityBackupMgr>> getList(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        Page<SecurityBackupMgr> page = securityBackupMgrDao.selectList();
        PageInfo<SecurityBackupMgr> pageInfo = new PageInfo<>(page);
        return ResponseResult.Builder.buildOk("查询成功", pageInfo);
    }
   修改controller

    @ApiOperation(value = "dbbackrecordList", notes = "备份记录列表")
    @ApiImplicitParams({
    })
    @RequestMapping(value = "/database/dadabase/recordList", method = RequestMethod.GET)
    public ResponseResult<PageInfo<SecurityBackupMgr>> recordList(
            @RequestParam(value = "pageNum",required = false) Integer pageNum,
            @RequestParam(value = "pageSize",required = false) Integer pageSize) {
        try {
            if(pageNum == null || pageNum == 0)
            {
                pageNum = 1;
            }
            if(pageSize == null || pageSize == 0)
            {
                pageSize = 10;
            }
            ResponseResult<PageInfo<SecurityBackupMgr>> responseResult = dBBackService.getList(pageNum,pageSize);
            return responseResult;
        } catch (Exception e) {
            logger.error("备份记录列表查询失败，", e);
            return ResponseResult.Builder.buildError("查询失败！");
        }
    }