1.创建查询条件实体类
package mybatis.entity;
public class UserSm {
private int minid;
private int maxid;
private String likename;
public int getMinid() {
return minid;
}
public void setMinid(int minid) {
this.minid = minid;
}
public int getMaxid() {
return maxid;
}
public UserSm(int minid, int maxid, String likename) {
super();
this.minid = minid;
this.maxid = maxid;
this.likename = likename;
}
public UserSm() {
super();
}
public void setMaxid(int maxid) {
this.maxid = maxid;
}
public String getLikename() {
return likename;
}
public void setLikename(String likename) {
this.likename = likename;
}
}
2XML文件
<?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="test">
<select id="getUser" parameterType="mybatis.entity.User" resultType="mybatis.entity.User" >//参数直接传递的实体类
select * from user where id BETWEEN #{minid} and #{maxid}
<if test='likename !="%null%"'>
and username like #{likename}
</if>
<if test="">//if语法
达成的条件
</if>
</select>
</mapper>
测试类
package mybatis.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import mybatis.entity.User;
import mybatis.entity.UserSm;
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 TestMain {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
// TODO Auto-generated method stub
String resource ="SqlMapConfig.xml";
InputStream inputStream= Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession= sqlSessionFactory.openSession();
UserSm userSm =new UserSm(1, 3, "%a%");
List<User> listuserList= sqlSession.selectList("test.getUser",userSm);
System.out.println(listuserList);
}
}
