<?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"><mappernamespace="com.lp.dao.UserDao"><selectid="findById"parameterType="int"resultType="user">
select * from user where id =#{id};
</select><selectid="findByKeyWord"parameterType="string"resultType="user">
select * from user where username like #{keyword}
</select><deleteid="deleteById"parameterType="int">
delete from user where id = #{id};
</delete><insertid="saveUser"parameterType="user">
insert into user value(null,#{username},#{birthday},#{sex},#{address})
</insert></mapper>
src\test\java\com\lp\pack03\Test01Proxy.java
package com.lp.pack03;import com.lp.bean.User;import com.lp.dao.UserDao;import com.lp.util.MySessionUtils;import org.apache.ibatis.session.SqlSession;import org.junit.Test;import java.util.Date;import java.util.List;publicclassTest01Proxy{@Testpublicvoidtest01(){
SqlSession sqlSession = MySessionUtils.getSession();//select * from user where id=4;
UserDao dao =sqlSession.getMapper(UserDao.class);//内部使用你编写的接口生成代理对象
User user = dao.findById(4);
System.out.println(user);
sqlSession.close();}@Testpublicvoidtest02(){
SqlSession sqlSession = MySessionUtils.getSession();//返回的是实现接口的实现类对象
UserDao dao = sqlSession.getMapper(UserDao.class);//搜索名字
List<User> list = dao.findByKeyWord("张%");
System.out.println(list);//定义接口
sqlSession.close();}@Testpublicvoidtest03(){
SqlSession sqlSession = MySessionUtils.getSession();//返回的是实现接口的实现类对象
UserDao dao = sqlSession.getMapper(UserDao.class);//删除
dao.deleteById(23);//
sqlSession.commit();
sqlSession.close();}@Testpublicvoidtest04(){
SqlSession sqlSession = MySessionUtils.getSession();//返回的是实现接口的实现类对象
UserDao dao = sqlSession.getMapper(UserDao.class);
User user =newUser();
user.setUsername("jackjhone");
user.setAddress("北京");
user.setBirthday(newDate());
user.setSex(3);
dao.saveUser(user);
sqlSession.commit();
sqlSession.close();}}