/Mybatis02/src/cn/hu/file/Mybatis02.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> <!-- 引入外部jdbc配置文件 --> <properties resource="cn/hu/file/Oracle.propertise"></properties> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <!-- 注册实体类的映射文件 --> <mappers> <!-- <mapper resource="hu/entity/Product.xml"/> <mapper resource="hu/entity/User.xml"/> <mapper resource="hu/entity/ClassInfoMapper.xml"/> --> <!-- <package name="hu.entity"/> --> <package name="hu.dao"/> <!-- <mapper class="hu.dao.ClassInfoMapper"/> --> </mappers></configuration>
Oracle.propertise
driver=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@localhost:1521:orcl?characterEncoding=UTF-8 username=scott password=123456
///链接工厂
package cn.hu.database; import java.io.IOException; 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; public class OracleDB { private static SqlSessionFactory sqlSessionFactory=null; static { //加载数据库配置文件 InputStream ins; try { ins = Resources.getResourceAsStream("cn/hu/file/Mybatis02.xml"); // 获取连接对象工工厂 sqlSessionFactory=new SqlSessionFactoryBuilder().build(ins); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * * @return */ public static SqlSession getSession() { return sqlSessionFactory.openSession(); } public static void closeSession(SqlSession session) { if (session!=null) { session.close(); } } }
