Mybatis Mapper动态代理开发（基础版）

1 创建项目，lib下引入Mybatis的jar包

 2 引入数据库连接的jar包

3 选中所有lib下的包右键Build Path

 4 编写Mybatis核心配置文件（sqlMapConfig.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>
	<!-- 和spring整合后 environments配置将废除 -->
	<environments default="development">
		<environment id="development">
			<!-- 使用jdbc事务管理 -->
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url"
					value="jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8" />
				<property name="username" value="root" />
				<property name="password" value="123456" />
			</dataSource>
		</environment>
	</environments>
	<!-- mapper的位置 -->
	<mappers>
	<mapper resource="sqlmap/User.xml"/>
	</mappers>
</configuration>

 5 创建POJO类

public class User{
	private Integer id;
	private String username;
	private String sex;
	private Date birthday;
	private String address;
    .......get/set方法........

}

6 创建sql映射User.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">
<!-- sql语句 -->
<!-- namespace:命名空间 -->
<mapper namespace="com.mapper.UserMapper">


	<!-- 通过id查询一个用户 -->

	<select id="findUserById" parameterType="Integer" resultType="com.entity.User">
		select * from user where id = #{v}
	</select>


	<!--              根据用户名称模糊查询用户列表
	 #{} 占位符(带引号) 		  select * from user where id = ? ？ ==  '欧文' 
	 ${} 字符拼接('%赵薇%')    select * from user where username like '%${}%' -->


	<select id="findUserByUsername" parameterType="String"
		resultType="com.entity.User">
		<!-- 防sql注入 -->
		<!-- select * from user where username like "%"#{username}"%" -->
		select * from user where username like '%${value}%'
	</select>

	<!-- 添加用户 -->

	<insert id="insertUser" parameterType="com.entity.User">
		<!-- 添加用户后用户下单，需要返回用户的id 使用selectKey -->
		<selectKey keyProperty="id" resultType="Integer" order="AFTER">
			select LAST_INSERT_ID()
		</selectKey>
		insert into user(username,sex,birthday,address)
		values(#{username},#{sex},#{birthday},#{address})
	</insert>

	
	<!-- 修改 -->

	<update id="updateUserByID" parameterType="com.entity.User">
	update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id}
	</update>


	<!-- 删除 -->

	<delete id="deleteUserById" parameterType="Integer">
	 delete from user where id = #{value}
	</delete>
</mapper>

7 加载映射文件

 

8 编写Mapper接口类（只写接口不需要实现类（由程序生成））

package com.mapper;

import com.entity.User;

/**
 *
 * mapper动态代理开发
 * 只写接口不需要实现类（由程序生成）
 * 用来取代Dao
 */
public interface UserMapper {
	//遵循4个原则
	//1 接口方法名 == User.xml中的id
	//2 返回值类型 与 User.xml中的返回值一致
	//3 方法的入参 与  User.xml中一致
	//4 命名空间绑定此接口（User.xml中namespace写此类）
	public User findUserById(Integer id);
}

 9 编写测试类

package com.junit;



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.Test;

import com.entity.User;
import com.mapper.UserMapper;

public class MybatisMappterTest {
	@Test
	public void testMapper() throws Exception {
		String resource = "sqlMapConfig.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		SqlSession sqlSession = sqlSessionFactory.openSession();
		
		UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
		User user = userMapper.findUserById(10);
		System.out.println(user);
	}

}