mybatis之分页查询

1）StudentDao.java

/**

 * 持久层*/

public class StudentDao {

    /**

     * 增加学生

     */

    public void add(Student student) throws Exception{

        SqlSession sqlSession = MyBatisUtil.getSqlSession();

        try{

            sqlSession.insert("mynamespace.add",student);

        }catch(Exception e){

            e.printStackTrace();

            sqlSession.rollback();

            throw e;

        }finally{

            sqlSession.commit();

            MyBatisUtil.closeSqlSession();

        }

    }

    /**

     * 无条件分页查询学生

     */

    public List<Student> findAllWithFy(int start,int size) throws Exception{

        SqlSession sqlSession = MyBatisUtil.getSqlSession();

        try{

            Map<String,Integer> map = new LinkedHashMap<String,Integer>();

            map.put("pstart",start);

            map.put("psize",size);

            return sqlSession.selectList("mynamespace.findAllWithFy",map);

        }catch(Exception e){

            e.printStackTrace();

            sqlSession.rollback();

            throw e;

        }finally{

            sqlSession.commit();

            MyBatisUtil.closeSqlSession();

        }

    }

    /**

     * 有条件分页查询学生

     */

    public List<Student> findAllByNameWithFy(String name,int start,int size) throws Exception{

        SqlSession sqlSession = MyBatisUtil.getSqlSession();

        try{

            Map<String,Object> map = new LinkedHashMap<String,Object>();

            map.put("pname","%"+name+"%");

            map.put("pstart",start);

            map.put("psize",size);

            return sqlSession.selectList("mynamespace.findAllByNameWithFy",map);

        }catch(Exception e){

            e.printStackTrace();

            sqlSession.rollback();

            throw e;

        }finally{

            sqlSession.commit();

            MyBatisUtil.closeSqlSession();

        }

    }

    public static void main(String[] args) throws Exception{

        StudentDao dao = new StudentDao();

        System.out.println("-----------Page1");

        for(Student s:dao.findAllByNameWithFy("哈",0,3)){

            System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

        }

        System.out.println("-----------Page2");

        for(Student s:dao.findAllByNameWithFy("哈",3,3)){

            System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

        }

        System.out.println("-----------Page3");

        for(Student s:dao.findAllByNameWithFy("哈",6,3)){

            System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

        }

        System.out.println("-----------Page4");

        for(Student s:dao.findAllByNameWithFy("哈",9,3)){

            System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

        }

    }

}

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

2）StudentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="mynamespace">

    <insert id="add" parameterType="loaderman.Student">

        insert into students(id,name,sal) values(#{id},#{name},#{sal})

    </insert>

    <select id="findAllWithFy" parameterType="map" resultType="loaderman.Student">

        select id,name,sal from students limit #{pstart},#{psize}

    </select>

    <select id="findAllByNameWithFy" parameterType="map" resultType="loaderman.Student">

        select id,name,sal from students where name like #{pname} limit #{pstart},#{psize}

    </select>

</mapper>

/**

*持久层

*@authorAdminTC

publicclass StudentDao {

/**

*增加学生

publicvoid add(Student student) throws Exception{

SqlSession sqlSession = MyBatisUtil.getSqlSession();

try{

sqlSession.insert("mynamespace.add",student);

}catch(Exception e){

e.printStackTrace();

sqlSession.rollback();

throw e;

}finally{

sqlSession.commit();

MyBatisUtil.closeSqlSession();

}

/**

*无条件分页查询学生

public List<Student> findAllWithFy(int start,int size) throws Exception{

SqlSession sqlSession = MyBatisUtil.getSqlSession();

try{

Map<String,Integer> map = new
LinkedHashMap<String,Integer>();

map.put("pstart",start);

map.put("psize",size);

return sqlSession.selectList("mynamespace.findAllWithFy",map);

}catch(Exception e){

e.printStackTrace();

sqlSession.rollback();

throw e;

}finally{

sqlSession.commit();

MyBatisUtil.closeSqlSession();

}

/**

*有条件分页查询学生

public List<Student> findAllByNameWithFy(String name,int start,int size) throws Exception{

SqlSession sqlSession = MyBatisUtil.getSqlSession();

try{

Map<String,Object> map = new LinkedHashMap<String,Object>();

map.put("pname","%"+name+"%");

map.put("pstart",start);

map.put("psize",size);

return sqlSession.selectList("mynamespace.findAllByNameWithFy",map);

}catch(Exception e){

e.printStackTrace();

sqlSession.rollback();

throw e;

}finally{

sqlSession.commit();

MyBatisUtil.closeSqlSession();

}

publicstaticvoid main(String[] args) throws Exception{

StudentDao dao = new StudentDao();

System.out.println("-----------Page1");

for(Student s:dao.findAllByNameWithFy("哈",0,3)){

System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

}

System.out.println("-----------Page2");

for(Student s:dao.findAllByNameWithFy("哈",3,3)){

System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

}

System.out.println("-----------Page3");

for(Student s:dao.findAllByNameWithFy("哈",6,3)){

System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

}

System.out.println("-----------Page4");

for(Student s:dao.findAllByNameWithFy("哈",9,3)){

System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());

}

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

巴特西

mybatis之分页查询

最新文章

热门文章