使用MyBatis(12)动态SQL 完成分页查询

来源：互联网发布：淘宝模特怎么入行编辑：程序博客网时间：2024/06/06 01:31

修改动态SQL加上limit

1.和上一篇一样Student类不变

2.建立多条件查询的类

package com.yw.test12;public class Condition{    private int id;    private String name;    private int start;    private int count;        public int getStart()    {        return start;    }    public void setStart(int start)    {        this.start = start;    }    public int getCount()    {        return count;    }    public void setCount(int count)    {        this.count = count;    }    public int getId()    {        return id;    }    public void setId(int id)    {        this.id = id;    }    public String getName()    {        return name;    }    public void setName(String name)    {        this.name = name;    }    }

3.配置文件

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    <properties resource="config.properties">    </properties>    <environments default="development">        <environment id="development">            <transactionManager type="JDBC" />            <dataSource type="POOLED">                <property name="driver" value="${driver}" />                <property name="url" value="${url}" />                <property name="username" value="${username}" />                <property name="password" value="${password}" />            </dataSource>        </environment>    </environments>    <mappers>        <!-- <mapper resource="org/mybatis/example/BlogMapper.xml"/> -->        <mapper resource="com/yw/test12/StudentMapper.xml" />    </mappers></configuration>

4.映射文件

<?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="com.yw.test12.StudentMapper">    <select id="findStudent" resultType="com.yw.test12.Student" parameterType="com.yw.test12.Condition" >        SELECT * FROM student                                    <if test="name !=null || name !='' " >        where    name like #{name}        </if>        limit #{start},#{count}            </select></mapper>

5.测试类

package com.yw.test12;import java.io.IOException;import java.io.InputStream;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class Test01{    public static void main(String[] args) throws IOException    {        String resource = "com/yw/test12/mybatis-config.xml";        InputStream inputStream = Resources.getResourceAsStream(resource);        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        SqlSession session = sqlSessionFactory.openSession(false);        try        {            System.out.println("=====动态SQL======");            Condition s1=new Condition();            s1.setName("%a%");            s1.setStart(1);            s1.setCount(2);                                    List user = session.selectList("com.yw.test12.StudentMapper.findStudent", s1);            System.out.println(user);        }        finally        {            session.close();        }    }}

6.效果如下

0 0