mybatis-foreach-refid
1.pom
< ? xml version= "1.0" encoding= "UTF-8" ? >
< project xmlns= "http://maven.apache.org/POM/4.0.0"
xmlns: xsi= "http://www.w3.org/2001/XMLSchema-instance"
xsi: schemaLocation= "http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" >
< modelVersion> 4.0 .0 < / modelVersion>
< groupId> com. lq< / groupId>
< artifactId> mybatis- dynamic- sql< / artifactId>
< version> 1.0 - SNAPSHOT< / version>
< packaging> jar< / packaging>
< dependencies>
< dependency>
< groupId> org. mybatis< / groupId>
< artifactId> mybatis< / artifactId>
< version> 3.4 .5 < / version>
< / dependency>
< dependency>
< groupId> mysql< / groupId>
< artifactId> mysql- connector- java< / artifactId>
< version> 5.1 .6 < / version>
< / dependency>
< dependency>
< groupId> log4j< / groupId>
< artifactId> log4j< / artifactId>
< version> 1.2 .12 < / version>
< / dependency>
< dependency>
< groupId> junit< / groupId>
< artifactId> junit< / artifactId>
< version> 4.12 < / version>
< / dependency>
< / dependencies>
< / project>
2.UserDao
package com. lq. dao;
import com. lq. domain. QueryVo;
import com. lq. domain. User;
import java. util. List;
public interface UserDao {
List< User> findByIds ( QueryVo queryVo) ;
List< User> findAll ( ) ;
}
3.QueryVo
package com. lq. domain;
import java. util. List;
public class QueryVo {
private User user;
private List< Integer> ids;
public User getUser ( ) {
return user;
}
public void setUser ( User user) {
this . user = user;
}
public List< Integer> getIds ( ) {
return ids;
}
public void setIds ( List< Integer> ids) {
this . ids = ids;
}
@Override
public String toString ( ) {
return "QueryVo{" +
"user=" + user +
", ids=" + ids +
'}' ;
}
}
4.User
package com. lq. domain;
import java. io. Serializable;
import java. util. Date;
public class User implements Serializable {
private Integer id;
private String username;
private Date birthday;
private String sex;
private String address;
public Integer getId ( ) {
return id;
}
public void setId ( Integer id) {
this . id = id;
}
public String getUsername ( ) {
return username;
}
public void setUsername ( String username) {
this . username = username;
}
public Date getBirthday ( ) {
return birthday;
}
public void setBirthday ( Date birthday) {
this . birthday = birthday;
}
public String getSex ( ) {
return sex;
}
public void setSex ( String sex) {
this . sex = sex;
}
public String getAddress ( ) {
return address;
}
public void setAddress ( String address) {
this . address = address;
}
@Override
public String toString ( ) {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", birthday=" + birthday +
", sex='" + sex + '\'' +
", address='" + address + '\'' +
'}' ;
}
}
5.UserDao.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= "com.lq.dao.UserDao" >
< sql id= "defaultUser" >
select * from user
< / sql>
< select id= "findAll" resultType= "user" >
< include refid= "defaultUser" > < / include>
< / select>
< select id= "findByIds" parameterType= "queryvo" resultType= "user" >
select * from user
< where>
< if test= "ids != null and ids.size()>0" >
< foreach collection= "ids" open= "and id in (" close= ")" item= "uid" separator= "," >
#{ uid}
< / foreach>
< / if >
< / where>
< / select>
< / mapper>
6.jdbcConfig.properties
jdbc. driver= com. mysql. jdbc. Driver
jdbc. url= jdbc: mysql: / / localhost: 3306 / eesy
jdbc. username= root
jdbc. password= root
7.log4j.properties
# Set root category priority to INFO and its only appender to CONSOLE.
#log4j. rootCategory= INFO, CONSOLE debug info warn error fatal
log4j. rootCategory= debug, CONSOLE, LOGFILE
# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j. logger. org. apache. axis. enterprise= FATAL, CONSOLE
# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j. appender. CONSOLE= org. apache. log4j. ConsoleAppender
log4j. appender. CONSOLE. layout= org. apache. log4j. PatternLayout
log4j. appender. CONSOLE. layout. ConversionPattern= % d{ ISO8601} % - 6 r [ % 15.15 t] % - 5 p % 30.30 c % x - % m\n
# LOGFILE is set to be a File appender using a PatternLayout.
log4j. appender. LOGFILE= org. apache. log4j. FileAppender
log4j. appender. LOGFILE. File= d: \axis. log
log4j. appender. LOGFILE. Append= true
log4j. appender. LOGFILE. layout= org. apache. log4j. PatternLayout
log4j. appender. LOGFILE. layout. ConversionPattern= % d{ ISO8601} % - 6 r [ % 15.15 t] % - 5 p % 30.30 c % x - % m\n
8.SqlMapConfig.xml
< ? 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-- >
< properties resource= "jdbcConfig.properties" > < / properties>
< ! -- 使用typeAliases配置别名,它只能配置domain中类的别名 -- >
< typeAliases>
< package name= "com.lq.domain" > < / package >
< / typeAliases>
< ! -- 配置环境-- >
< environments default = "mysql" >
< ! -- 配置mysql的环境-- >
< environment id= "mysql" >
< ! -- 配置事务 -- >
< transactionManager type= "JDBC" > < / transactionManager>
< ! -- 配置连接池-- >
< dataSource type= "POOLED" >
< property name= "driver" value= "${jdbc.driver}" > < / property>
< property name= "url" value= "${jdbc.url}" > < / property>
< property name= "username" value= "${jdbc.username}" > < / property>
< property name= "password" value= "${jdbc.password}" > < / property>
< / dataSource>
< / environment>
< / environments>
< ! -- 配置映射文件的位置 -- >
< mappers>
< package name= "com.lq.dao" > < / package >
< / mappers>
< / configuration>
9.MybatisTest
package com. lq. test;
import com. lq. dao. UserDao;
import com. lq. domain. QueryVo;
import com. lq. domain. User;
import org. apache. ibatis. io. Resources;
import org. apache. ibatis. session. SqlSession;
import org. apache. ibatis. session. SqlSessionFactory;
import org. apache. ibatis. session. SqlSessionFactoryBuilder;
import org. junit. After;
import org. junit. Before;
import org. junit. Test;
import java. io. InputStream;
import java. util. ArrayList;
import java. util. List;
public class MybatisTest {
private InputStream in;
private SqlSession sqlSession;
private UserDao userDao;
@Before
public void init ( ) throws Exception{
in = Resources. getResourceAsStream ( "SqlMapConfig.xml" ) ;
SqlSessionFactory factory = new SqlSessionFactoryBuilder ( ) . build ( in) ;
sqlSession = factory. openSession ( true ) ;
userDao = sqlSession. getMapper ( UserDao. class ) ;
}
@After
public void destroy ( ) throws Exception{
sqlSession. close ( ) ;
in. close ( ) ;
}
@Test
public void testFindByIds ( ) {
List< Integer> ids= new ArrayList < Integer> ( ) ;
ids. add ( 41 ) ;
ids. add ( 42 ) ;
ids. add ( 45 ) ;
QueryVo queryVo = new QueryVo ( ) ;
queryVo. setIds ( ids) ;
List< User> byCondition = userDao. findByIds ( queryVo) ;
for ( User user1 : byCondition) {
System. out. println ( user1) ;
}
}
@Test
public void testFindAll ( ) {
List< User> byCondition = userDao. findAll ( ) ;
for ( User user1 : byCondition) {
System. out. println ( user1) ;
}
}
}