mybatis与oracle配置

oracle.properties.xml  配置

driver=oracle.jdbc.driver.OracleDriver

url=jdbc:oracle:thin:@localhost:1521:orcl

username=scott

password=tiger

configuration.xml 配置

<configuration>

 <!-- 引用db.properties配置文件 -->

      <properties resource="com/config/mapper/oracle.properties"/>

      

<!-- 给实体类取一个别名 -->

<typeAliases>

<typeAlias type="com.xxx.model.Notice" alias="Notice"/>

</typeAliases>

<!-- 

          development : 开发模式

          work : 工作模式

      -->

<environments default="development">

<environment id="development">

<transactionManager type="JDBC" />

<!-- 配置数据库连接信息 -->

<dataSource type="POOLED">

<!-- value属性值引用db.properties配置文件中配置的值 -->

<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="com/xxx/mybatis/SearchMapper.xml" />

</mappers>

</configuration>

      

oracle.properties.xml  配置

driver=oracle.jdbc.driver.OracleDriver

url=jdbc:oracle:thin:@localhost:1521:orcl

username=scott

password=tiger

configuration.xml 配置

<configuration>

 <!-- 引用db.properties配置文件 -->

      <properties resource="com/config/mapper/oracle.properties"/>

      

<!-- 给实体类取一个别名 -->

<typeAliases>

<typeAlias type="com.xxx.model.Notice" alias="Notice"/>

</typeAliases>

<!-- 

          development : 开发模式

          work : 工作模式

      -->

<environments default="development">

<environment id="development">

<transactionManager type="JDBC" />

<!-- 配置数据库连接信息 -->

<dataSource type="POOLED">

<!-- value属性值引用db.properties配置文件中配置的值 -->

<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="com/xxx/mybatis/SearchMapper.xml" />

</mappers>

</configuration>