Mybatis的搭建与使用

Hibernate是非常完美的一个持久性框架，但是由于其考虑到各种功能和通用性，导致这个框架太大了，另外就是封装的太好了导致自主性比较小。所以Mybatis受到很多公司的欢迎。Mybatis以前叫做ibatis，用法稍微有点区别，在这里我用的是Mybatis 3

1.去官网下载Mybatis的Jar包 http://mybatis.github.io/

2.配置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>
	<!-- 给bean取别名用在mapping文件中 -->
	<typeAliases>
		<typeAlias type="com.lubby.bean.Worker" alias="Worker" />
	</typeAliases>
	<environments default="development">
		<environment id="development">
			<!-- 使用JDBC的事务管理 -->
			<transactionManager type="JDBC" />
			<!-- 数据源 -->
			<dataSource type="POOLED">
				<property name="driver" value="org.postgresql.Driver" />
				<property name="url" value="jdbc:postgresql://127.0.0.1:5432/lubby" />
				<property name="username" value="admin" />
				<property name="password" value="admin" />
			</dataSource>
		</environment>
	</environments>
	<!-- 这里可以写多个实体的映射文件 -->
	<mappers>
		<mapper resource="com/lubby/bean/WorkerSqlMap.xml" />
	</mappers>
</configuration>

package com.lubby.bean;
public class Worker {
	private String id;
	private String name;
	int age;
	public Worker() {
		super();
	}
	public Worker(String id, String name, int age) {
		super();
		this.id = id;
		this.name = name;
		this.age = age;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	@Override
	public String toString() {
		return "Worker [id=" + id + ", name=" + name + ", age=" + age + "]";
	}
}

<?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">

<!-- namespace用于java代码调用时识别指定xml的mapper文件 -->
<mapper namespace="com.lubby.bean">
	<sql id="field">
		id,name,age
	</sql>
	<select id="getAllWorker" resultType="Worker">
		select
		<include refid="field" />
		from worker
	</select>
	<select id="getWorkerById" resultType="Worker">
		select
		<include refid="field" />
		from worker where
		id= #{id}
	</select>
	<select id="getWorkerByName" resultType="Worker">
		select
		<include refid="field" />
		from worker where name like '%'||#{name}||'%'
	</select>

	<insert id="addWorker">
		insert into worker (
		<include refid="field" />
		) values(#{id},#{name},#{age})
	</insert>

	<update id="updateWorker">
		update worker set name=#{name} ,age=#{age} where
		id=#{id}
	</update>

	<delete id="deleteWorkerById">
	delete from worker where id=#{id};
	</delete>
</mapper>

package com.lubby.test;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

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.lubby.bean.Worker;

public class Test {
	public static void main(String[] args) {
		SqlSessionFactory factory = null;
		try {
			Reader reader = Resources.getResourceAsReader("com/lubby/config/SqlMapConfig.xml");
			factory = new SqlSessionFactoryBuilder().build(reader);

		} catch (IOException e) {
			e.printStackTrace();
		}

		SqlSession session = factory.openSession();

		Worker worker = new Worker("003", "Join", 100);
		//session.insert("com.lubby.bean.addWorker", worker);
		//session.delete("com.lubby.bean.deleteWorkerById", "005");
		//session.commit();
		List<Worker> list = session.selectList("com.lubby.bean.getAllWorker");
		System.out.println(session.selectOne("com.lubby.bean.getWorkerById", "001"));
		System.out.println(session.update("com.lubby.bean.updateWorker", worker));
		System.out.println(session.delete("com.lubby.bean.deleteWorkerById", "004"));
		session.commit();
		System.out.println(session.selectList("com.lubby.bean.getWorkerByName", "J"));
		System.out.println(list);
	}

}