1.MyBatis 例子
首先，单独使用MyBatis时：
[java]
import java.io.IOException;
import java.io.Reader;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class MyBatisUtil {
// 每一个MyBatis的应用程序都以一个SqlSessionFactory对象的实例为核心
// 使用SqlSessionFactory的最佳实践是在应用运行期间不要重复创建多次,最佳范围是应用范围
private final static SqlSessionFactory sqlSessionFactory;
static {
String resource = "configuration.xml";
Reader reader = null;
try {
reader = Resources.getResourceAsReader(resource);
} catch (IOException e) {
System.out.println(e.getMessage());
}
// SqlSessionFactory对象的实例可以通过SqlSessionFactoryBuilder对象来获得
// SqlSessionFactoryBuilder实例的最佳范围是方法范围（也就是本地方法变量）。
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
}
public static SqlSessionFactory getSqlSessionFactory() {
return sqlSessionFactory;
}
}
配置文件：
[html]
< xml version="1.0" encoding="UTF-8" >
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
insert into vincent_user(name,age) values(#{name},#{age})
select * from vincent_user where name=#{name}
使用的测试类为：
[java]
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;
public class TestMapper {
static SqlSessionFactory sqlSessionFactory = null;
static {
sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
}
@Test
public void testAdd() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = new User("tom",new Integer(5));
userMapper.insertUser(user);
sqlSession.commit();//这里一定要提交，不然数据进不去
数据库中
} finally {
sqlSession.close();
}
}
@Test
public void getUser() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = userMapper.getUser("jun");
System.out.println("name: "+user.getName()+"|age: "+user.getAge());
} finally {
sqlSession.close();
}
}
}
2.整合Spring3后，单独使用Mybatis
首先，Spring3配置文件中（applicationContext.xml）有：
[
html]
[html]
工具类：
[java]
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
public class MyBatisUtil {
private final static SqlSessionFactory sqlSessionFactory;
static { www.2cto.com
Applicatio