mybatis+oracle配置文件

    xiaoxiao2021-03-25  112

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

    转载请注明原文地址: https://ju.6miu.com/read-25942.html

    最新回复(0)