<!-- 配置數(shù)據(jù)源（連接池）信息 -->?
<dataSource type="POOLED">?
?? ?<property name="driver" value="${jdbc.driver}"/>
?? ?<property name="url" value="${jdbc.url}"/>
?? ?<property name="username" value="${jdbc.username}"/>
?? ?<property name="password" value="${jdbc.password}"/>
</dataSource>

@Test
public void testSaveUser() throws Exception {
User user = new User();
user.setUsername("mybatis user09");
//6.執(zhí)行操作
int res = userDao.saveUser(user);
System.out.println(res);
System.out.println(user.getId());
}
@Before//在測(cè)試方法執(zhí)行之前執(zhí)行
public void init()throws Exception {
//1.讀取配置文件
in = Resources.getResourceAsStream("SqlMapConfig.xml");
//2.創(chuàng)建構(gòu)建者對(duì)象
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
//3.創(chuàng)建 SqlSession 工廠對(duì)象
factory = builder.build(in);
//4.創(chuàng)建 SqlSession 對(duì)象
session = factory.openSession();
//5.創(chuàng)建 Dao 的代理對(duì)象
userDao = session.getMapper(IUserDao.class);
}
@After//在測(cè)試方法執(zhí)行完成之后執(zhí)行
public void destroy() throws Exception{
//7.提交事務(wù)
session.commit();
//8.釋放資源
session.close();
in.close();
}

@Before//在測(cè)試方法執(zhí)行之前執(zhí)行
public void init()throws Exception {
//1.讀取配置文件
in = Resources.getResourceAsStream("SqlMapConfig.xml");
//2.創(chuàng)建構(gòu)建者對(duì)象
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
//3.創(chuàng)建 SqlSession 工廠對(duì)象
factory = builder.build(in);
//4.創(chuàng)建 SqlSession 對(duì)象
**session = factory.openSession(true);**
//5.創(chuàng)建 Dao 的代理對(duì)象
userDao = session.getMapper(IUserDao.class);
}
@After//在測(cè)試方法執(zhí)行完成之后執(zhí)行
public void destroy() throws Exception{
//7.釋放資源
session.close();
in.close();
}

/**
* 根據(jù)用戶信息，查詢用戶列表
* @param user
* @return
*/
List<User> findByUser(User user);

<select id="findByUser" resultType="user" parameterType="user">
select * from user where 1=1
<if test="username!=null and username != '' ">
and username like #{username}
</if> <if test="address != null">
and address like #{address}
</if>
</select>

@Test
public void testFindByUser() {
User u = new User();
u.setUsername("%王%");
u.setAddress("%順義%");
//6.執(zhí)行操作
List<User> users = userDao.findByUser(u);
for(User user : users) {
System.out.println(user);
} }

<!-- 根據(jù)用戶信息查詢 --> 
<select id="findByUser" resultType="user" parameterType="user"> <include refid="defaultSql">
</include> <where> <if test="username!=null and username != '' ">
and username like #{username}
</if> <if test="address != null">
and address like #{address}
</if>
</where>
</select>

SELECT * FROM USERS WHERE username LIKE ‘%張%' AND (id =10 OR id =89 OR id=16)
SELECT * FROM USERS WHERE username LIKE ‘%張%' AND id IN (10,89,16)

/**
* 
* <p>Title: QueryVo</p>
* <p>Description: 查詢的條件</p>
* <p>Company: http://www.itheima.com/ </p>
*/
public class QueryVo implements Serializable {
private List<Integer> ids;
public List<Integer> getIds() {
return ids; }
public void setIds(List<Integer> ids) {
this.ids = ids; } }

/**
* 根據(jù) id 集合查詢用戶
* @param vo
* @return
*/
List<User> findInIds(QueryVo vo);

<!-- 查詢所有用戶在 id 的集合之中 -->
?<select id="findInIds" resultType="user" parameterType="queryvo">
<!-- select * from user where id in (1,2,3,4,5); -->
?<include refid="defaultSql"></include>?
?<where>
? ? ? ? ? ? <if test="list != null and list.size() > 0">
? ? ? ? ? ? ? ? <foreach collection="list" open="id in ( " close=")" item="uid"
? ? ? ? ? ? ? ? ? ? ? ? ?separator=",">
? ? ? ? ? ? ? ? ? ? #{uid}
? ? ? ? ? ? ? ? </foreach>
? ? ? ? ? ? </if>
? ? ? ? </where>
</select>

select 字段 from user where id in (?)

@Test
public void testFindInIds() {
QueryVo vo = new QueryVo();
List<Integer> ids = new ArrayList<Integer>();
ids.add(41);
ids.add(42);
ids.add(43);
ids.add(46);
ids.add(57);
vo.setIds(ids);
//6.執(zhí)行操作
List<User> users = userDao.findInIds(vo);
for(User user : users) {
System.out.println(user);
} }

<!-- 抽取重復(fù)的語(yǔ)句代碼片段 -->
 <sql id="defaultSql">
	select * from user
</sql>

<!-- 配置查詢所有操作 --> 
<select id="findAll" resultType="user">
<include refid="defaultSql"></include>
</select>
<!-- 根據(jù) id 查詢 --> <select id="findById" resultType="UsEr" parameterType="int">
<include refid="defaultSql"></include>
where id = #{uid}
</select>