Mybatis

mybatis-config.xml

mybatis配置文件

<?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>
    
    <!-- 1.可以定义键值对 2. 可以引用文件 -->
    <properties>
        <!-- 定义键值对 ${mysql_url} 使用 -->
        <property name="mysql_url" value="jdbc:mysql://127.0.0.1:3306/db_test" />
    </properties>
    
    <!-- 引用文件 ${mysql_user} 使用 -->
    <properties resource="jdbc.properties"></properties>
    
    <!-- 使用驼峰命名法转换字段 -->
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
	
    <!-- 在environments配置数据库连接信息 -->
    <!-- 每个environment标签可以定义一套连接配置 -->
    <!-- default属性，用来指定使用哪个environment标签 -->
    <environments default="mysql">
        <!-- mysql 连接示例 -->
        <environment id="mysql">
            <!-- transactionManage标签用于配置数据库管理方式 --> 
            <transactionManager type="JDBC"/>
            <!-- dataSource标签用来配置数据库连接信息 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/db_test"/>
                <property name="username" value="username"/>
                <property name="password" value="password"/>
            </dataSource>
        </environment>
        
        <!-- oracle 连接示例-->
        <environment id="oracle">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:gpm"/>
                <property name="username" value="username"/>
                <property name="password" value="password"/>
            </dataSource>
        </environment>
        
    </environments>

    <mappers>
        <mapper resource="com/xw/sd/mapper/BookMapper.xml"/>
    </mappers>

</configuration>

jdbc.properties

mysql_driver = com.mysql.jdbc.Driver
mysql_url = jdbc:mysql://127.0.0.1:3306/db_test
mysql_username = username
mysql_password = password