转自: http://blog.csdn.net/fover717/article/details/8334209
http://www.cnblogs.com/zemliu/archive/2013/08/07/3242966.html
http://fhd001.iteye.com/blog/1121189
参考:http://blog.csdn.net/isea533/article/details/23831273
http://blog.csdn.net/hupanfeng/article/details/9238127
1.MyBatis 例子
首先,单独使用MyBatis时:
- 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;
- }
- }
配置文件:
- <?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="Mapper.UserMapper">
- <!-- 这里namespace必须是UserMapper接口的路径,不然要运行的时候要报错 “is not known to the MapperRegistry”-->
- <insert id="insertUser" parameterType="User">
- insert into vincent_user(name,age) values(#{name},#{age})
- <!-- 这里sql结尾不能加分号,否则报“ORA-00911”的错误 -->
- </insert>
- <!-- 这里的id必须和UserMapper接口中的接口方法名相同,不然运行的时候也要报错 -->
- <select id="getUser" resultType="User" parameterType="java.lang.String">
- select * from vincent_user where name=#{name}
- </select>
- </mapper>
使用的测试类为: