mybatis使用mysql分页_使用mysql实现mybatis的分页效果

1、mybatis.xml

/p>

"./mybatis-3-config.dtd">

2、DeptMapper.java

package com.wh.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.wh.pojo.Dept;

import com.wh.vo.VO;

public interface DeptMapper {

public List selectByName(String name);

public List selectByMore(@Param("dpt_name")String dpt_name,@Param("dpt_ioc")String dpt_ioc);

public List selectByList(@Param("ids") List ids);

public List selectPage(VO vo);

}

3、DeptMapper.xml

/p>

"./mybatis-3-mapper.dtd">

select * from dept where dpt_name like '%${value}%'

select * from dept where 1=1

and dpt_name like concat('%',#{dpt_name,jdbcType=VARCHAR},'%')

and dpt_ioc like concat(concat('%',#{dpt_ioc,jdbcType=VARCHAR}),'%')

select * from dept where dpt_id in

#{id}

select * from dept limit #{pager.start},#{pager.pageSize}

4、DeptDaoImpl.java

package com.wh.mapperImpl;

import java.util.List;

import com.wh.mapper.DeptMapper;

import com.wh.pojo.Dept;

import com.wh.vo.VO;

public class DeptDaoImpl extends BaseDao implements DeptMapper {

@Override

public List selectByName(String name) {

this.openSession();

DeptMapper mapper=(DeptMapper) ss.getMapper(DeptMapper.class);

return mapper.selectByName(name);

}

@Override

public List selectByMore(String dpt_name, String dpt_ioc) {

this.openSession();

DeptMapper mapper=(Dep