<?XML version= "1.0" encoding= "UTF-8"?><!DOCTYPE mapperpublic "-//mybatis.org//dtd Mapper 3.0//en" "Http://mybatis.org/dtd/mybatis-3-mapper.dtd "><!--namespace: namespaces, which are used to isolate SQL, have a very important role to play, and will later speak -<Mappernamespace= "Com.it.mapper.UserMapper"> <SQLID= "Selectuser">SELECT * from ' user '</SQL> <!--Check user information based on multiple IDs - <SelectID= "Selectusersbyids"ParameterType= "Com.it.entity.QueryVo"Resulttype= "Com.it.entity.User"> <includerefID= "Selectuser"/> <where> <foreachCollection= "Idslist"Item= "id"Separator=","Open= "id in ("Close=")">#{id}</foreach> </where> </Select></Mapper>
mapping files for Usermapper
PackageCom.it.mapper;Importjava.util.List;ImportCom.it.entity.QueryVo;ImportCom.it.entity.User; Public InterfaceUsermapper { PublicUser Queryuserbyid (Integer ID); PublicList<user>Finduserbyqueryvo (Queryvo vo); //querying user information based on multiple IDs PublicList<user>selectusersbyids (Queryvo vo);}
Usermapper interface
Packagecom.it.test;Importjava.io.IOException;ImportJava.io.InputStream;Importjava.util.ArrayList;Importjava.util.List;Importorg.apache.ibatis.io.Resources;Importorg.apache.ibatis.session.SqlSession;Importorg.apache.ibatis.session.SqlSessionFactory;ImportOrg.apache.ibatis.session.SqlSessionFactoryBuilder;Importorg.junit.Test;ImportCom.it.entity.QueryVo;ImportCom.it.entity.User;ImportCom.it.mapper.UserMapper; Public classmappertest {@Test Public voidTestfindusersbyids ()throwsexception{//Load configuration fileString resource = "Sqlmapconfig.xml"; InputStream in=Resources.getresourceasstream (Resource); //Create SessionfactorySqlsessionfactory sessionfactory =NewSqlsessionfactorybuilder (). build (in); //Create sqlsessionSqlsession sqlsession =sessionfactory.opensession (); Usermapper Usermapper= Sqlsession.getmapper (usermapper.class); List<Integer> ids =NewArraylist<integer>(); Ids.add (10); Ids.add (16); Ids.add (22); Queryvo Vo=NewQueryvo (); Vo.setidslist (IDS); List<User> users =Usermapper.selectusersbyids (VO); for(user user:users) {System.out.println (user); } }}
Test method Testfindusersbyids
Use of Where,if,foreach in MyBatis Mapper mapping file