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();
}
}