JavaEE之mybatis代理开发模式

MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Old Java Objects,普通的 Java对象)映射成数据库中的记录。下面我简单说说怎么创建mybatis的代理开发模式：

第一步：创建一个空的Javaweb项目，这个我就不详细说了；

第二步：导包，这个我也就不详细说了；

第三步：创建Javabean：

package com.fengqi.vo;
import java.util.Date;
public class Users {
	private Integer id;
	private String user_name;
	private Date user_birthday;
	private String user_sex;
	private Integer user_age;
	private String user_addr;
	private String user_iphone;
	public Users() {
		
	}
	public Users(Integer id, String user_name, Date user_birthday,
			String user_sex, Integer user_age, String user_addr,
			String user_iphone) {
		super();
		this.id = id;
		this.user_name = user_name;
		this.user_birthday = user_birthday;
		this.user_sex = user_sex;
		this.user_age = user_age;
		this.user_addr = user_addr;
		this.user_iphone = user_iphone;
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUser_name() {
		return user_name;
	}
	public void setUser_name(String user_name) {
		this.user_name = user_name;
	}
	public Date getUser_birthday() {
		return user_birthday;
	}
	public void setUser_birthday(Date user_birthday) {
		this.user_birthday = user_birthday;
	}
	public String getUser_sex() {
		return user_sex;
	}
	public void setUser_sex(String user_sex) {
		this.user_sex = user_sex;
	}
	public Integer getUser_age() {
		return user_age;
	}
	public void setUser_age(Integer user_age) {
		this.user_age = user_age;
	}
	public String getUser_addr() {
		return user_addr;
	}
	public void setUser_addr(String user_addr) {
		this.user_addr = user_addr;
	}
	public String getUser_iphone() {
		return user_iphone;
	}
	public void setUser_iphone(String user_iphone) {
		this.user_iphone = user_iphone;
	}
	@Override
	public String toString() {
		return "Users [id=" + id + ", user_name=" + user_name
				+ ", user_birthday=" + user_birthday + ", user_sex=" + user_sex
				+ ", user_age=" + user_age + ", user_addr=" + user_addr
				+ ", user_iphone=" + user_iphone + "]";
	}
}

第四步：创建接口：

package com.fengqi.dao;
import com.fengqi.vo.Users;
public interface UsersMapper {
	//查找用户接口
	public Users selectUser(String id);
	//删除用户接口
	public Users delectUser(int id);
	//插入用户接口
	public Users insertUser(Users user);
	//修改用户接口
	public Users updateUser(Users user);
}

第五步：创建mapper：

<?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.fengqi.dao.UsersMapper">
	<!-- 查找用户 -->
  <select id="selectUser" parameterType="String" resultType="Users">
      select user_name from userss where id=#{id}
  </select>
  	<!-- 删除用户 -->
  <delete id="delectUser" parameterType="java.lang.Integer" >
  	delete from userss where id=#{id}
  </delete>
  	<!-- 增加用户 -->
  <insert id="insertUser" parameterType="com.fengqi.vo.Users">
  		insert into userss(id,user_name,user_birthday,user_sex,user_age,user_addr,user_iphone) values(#{id},#{user_name},#{user_birthday},#{user_sex},#{user_age},#{user_addr},#{user_iphone});
  </insert>
  	<!-- 修改用户 -->
  <update id="updateUser" parameterType="com.fengqi.vo.Users">
  		update userss set user_name=#{user_name},user_birthday=#{user_birthday},user_sex=#{user_sex},user_age=#{user_age},user_addr=#{user_addr},user_iphone=#{user_iphone}  where id=#{id}
  </update>
</mapper>

第六步：创建全局配置文件：

<?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别名定义 -->
	<typeAliases>
		<typeAlias alias="Users" type="com.fengqi.vo.Users"/>
	</typeAliases>
	<!-- development 工厂模式 -->
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"/>
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8"/>
				<property name="username" value="root"/>
				<property name="password" value="123456"/>
			</dataSource>
		</environment>
	</environments>
	<!-- mybatis的mapper文件，每个xml配置文件对应一个接口 -->
	<mappers>
		<mapper resource="com/fengqi/dao/UsersMapper.xml"/>   
	</mappers>
</configuration>

第七步：创建测试类：

package com.fengqi.test;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
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 com.fengqi.vo.Users;
public class UserTest {
	public static void main(String[] args) throws SQLException, IOException{
		String resource = "configuration.xml";
		//加载配置文件
		Reader reader = Resources.getResourceAsReader(resource);
		//根据read获取SqlSessionFactory 对象
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		//根据SqlSessionFactory获取SqlSession对象
		SqlSession session = sessionFactory.openSession();
		try{
			//根据ID查找用户
			Users user = (Users)session.selectOne("com.fengqi.dao.UsersMapper.selectUser","3");
			System.out.println("username:"+user.getUser_name());
			//根据ID删除用户
			/*session.delete("com.fengqi.dao.UsersMapper.delectUser",3);
			session.commit();*/
			//插入用户
			/*Users ui = new Users(null,"archybold8",new Date(),"0",11,"陕西省西安市","18392357490");
			session.insert("com.fengqi.dao.UsersMapper.insertUser",ui);
			session.commit();*/
			//更新用户
			/*Users ui = new Users(14,"archy78",new Date(),"1",29,"陕西省西安市","18392357490");
			session.update("com.fengqi.dao.UsersMapper.updateUser", ui);
			session.commit();	*/	
		}finally{
			//关闭session
			session.close();
		}
	}
}

第八步：测试结果：

第八步：项目总览：