mybatis开发Mapper代理方式

工程

1UserMapper接口

package cn.itcast.mapper;

import java.util.List;

import cn.itcast.po.User;

public interface UserMapper {
	//根据用户ID查询用户信息 
	public User findUserById(int id)  throws Exception;
	//根据用户名称模糊查询用户列表 
	public List<User> findUserByName(String name);
	//添加用户 
	public void insertUser(User user);

}

2Usermapper.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="cn.itcast.mapper.UserMapper">

<!-- 根据用户ID查询用户信息 -->
<select id="findUserById" parameterType="int" resultType="cn.itcast.po.User">
	select * from user where id = #{id}
</select>
<!-- 根据用户名称模糊查询用户列表 -->
<select id="findUserByName" parameterType="String" resultType="cn.itcast.po.User">
	select * from user where username like '%${value}%'
</select>
<!-- 添加用户 -->
<insert id="insertUser" parameterType="cn.itcast.po.User">
	insert into User(username, birthday, sex, address) values(#{username}, #{birthday},#{sex},#{address})
</insert>
</mapper>

3在全局配置文件SqlMapConfig.xml下加载映射文件Usermapper.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>
<!-- 配置mybatis的环境信息 -->
<environments default="development">
	<environment id="development">
		<!-- 配置JDBC事务控制，由mybatis进行管理 -->
		<transactionManager type="JDBC"></transactionManager>
		<!-- 配置数据源，采用连接池 -->
		<dataSource type="POOLED">
			<property name="driver" value="com.mysql.jdbc.Driver"/>
			<property name="url" value="jdbc:mysql://localhost:3306/zn"/>
			<property name="username" value="root"/>
			<property name="password" value="123456"/>
		</dataSource>
	</environment>
</environments>

<!-- 加载映射文件 -->
<mappers>
	<mapper resource="User.xml"/>
	<mapper resource="mapper/UserMapper.xml"/>
</mappers>
</configuration>

4测试

package cn.itcast.mapper;

import static org.junit.Assert.*;

import java.io.InputStream;

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.Before;
import org.junit.Test;

import cn.itcast.po.User;

public class UserMapperTest {

	
	private SqlSessionFactory sqlSessionFactory;
	@Before
	public void setUp() throws Exception {
		//读取配置文件
		String resource ="SqlMapConfig.xml";
		InputStream inputStream =  Resources.getResourceAsStream(resource);
		//创建SqlSessionFactory
		 sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);	

	}

	@Test
	public void testFindUserById() throws Exception {
		//创建UserMapper对象
		SqlSession sqlSession =  sqlSessionFactory.openSession();
		//由mybatis通过Sqlsession创建代理对象
		UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
		User user = userMapper.findUserById(1) ;
		System.out.println(user);
		sqlSession.close();
		
	}

	@Test
	public void testFindUserByName() {
		fail("Not yet implemented");
	}

	@Test
	public void testInsertUser() {
		//创建UserMapper对象
		SqlSession sqlSession = sqlSessionFactory.openSession(true) ;
		UserMapper userMapper = sqlSession.getMapper(UserMapper.class) ;
		User user = new User() ;
		user.setUsername("znzn");
		user.setAddress("hubei");
		userMapper.insertUser(user);
		sqlSession.close();
		
		
	}

}