mybatis使用mapper代理访问数据库

mybatis实现mapper代理，需要遵循以下规范

1、dao接口名称必须与mapper.xml名称相同

2、mapper.xml的命名空间为接口的全类名

<!-- 命名空间配置为接口的全类名 -->
<mapper namespace="com.gec.mapper.UserDao">
	<!-- 省略 -->
</mapper>

3、接口的方法名与mapper.xml中的sql语句需相同，参数及返回值类型需相同

UserDao .java

package com.gec.mapper;

import java.util.List;

import com.gec.bean.User;

public interface UserDao {
	public int insert(User user);
	
	public int delete(Integer id);
	
	public int update(User user);
	
	public List<User> findAll();
	
	public User findById(Integer id);
	
	public List<User> find(String address);
	
}

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.gec.mapper.UserDao">
	<!-- id为接口的方法名 -->
	<!-- parameterType：参数类型
		#{}  通过该符号，获取到传入对象中的具体属性值，默认加上单引号
		$    该符号获取的属性值，不会默认加上单引号 -->
	<insert id="insert" parameterType="com.gec.bean.User">
		<!-- insert into t_user values(#{id},#{address},#{username},#{birthday}) -->
		insert into t_user(id,address,username,birthday) values(#{id},#{address},#{username},#{birthday})
		<!-- keyProperty="表示主键在com.gec.bean.User中的名称" keyColumn="主键在数据库中表的字段名" 
		resultType="主键的类型" order="在执行sql前还是执行后（Oracle：BEFORE  MySql:AFTER）" -->
		<selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
			select last_insert_id()
		</selectKey>
	</insert>
	
	<delete id="delete" parameterType="java.lang.Integer">
		delete from t_user where id=#{id}
	</delete>
	
	<update id="update" parameterType="com.gec.bean.User">
		update t_user set username=#{username},birthday=#{birthday},address=#{address} where id=#{id}
	</update>
	
	<select id="findAll" parameterType="com.gec.bean.User" resultType="com.gec.bean.User">
		select * from t_user
	</select>
	
	<select id="findById" parameterType="int" resultType="com.gec.bean.User">
		select * from t_user where id=#{id}
	</select>
	
	<select id="find" parameterType="String" resultType="user">
		select * from t_user where address=#{add}
	</select>
	
</mapper>

获得接口代理对象的测试

@Test
	public void testInsert(){
		try {
			SqlSession session = MybatisUtils.getSession();
			User user = new User(null, "张三丰", new Date(), "广东广州");
			//通过Session的getMapper对象得到UserDao接口的代理对象
			UserDao userDao = session.getMapper(UserDao.class);
			userDao.insert(user);
			//提交事务
			session.commit();
			System.out.println("用户Id:"+user.getId());
			//关闭session
			session.close();
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}