mybatis+oracle配置文件

来源:互联网 发布:javascript onclick 编辑:程序博客网 时间:2024/06/07 08:10

/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();
        }
    }
 
}


0 0
原创粉丝点击