Mybatis_全局配置文件

1、全局配置文件

<?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>
<properties resource="jdbc_property"></properties>
<environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/> 
      <dataSource type="POOLED">
        <property name="driver" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.user}"/>
        <property name="password" value="${jdbc.password}"/>
      </dataSource>
    </environment>
      <environment id="test">
      <transactionManager type="JDBC"/> 
      <dataSource type="POOLED">
        <property name="driver" value="${sqlserver.driver}"/>
        <property name="url" value="${sqlserver.url}"/>
        <property name="username" value="${sqlserver.user}"/>
        <property name="password" value="${sqlserver.password}"/>
      </dataSource>
    </environment>
     </environments>
     <databaseIdProvider type="DB_VENDOR">
    <property name="MySQL" value="mysql"/>
    <property name="Microsoft SQL Server" value="sqlserver"/>
</databaseIdProvider>
     <mappers>
     <mapper class="com.taozi.mybatis.test.Mybatis_01_Mapper"/>
       </mappers>
       </configuration>

2、jdbc_property

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/mydata_1
jdbc.user=root
jdbc.password=root

sqlserver.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
sqlserver.url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=mybatis_01
sqlserver.user=admin
sqlserver.password=admin

3、sql映射接口（接口编程）

public interface Mybatis_01_Mapper {
    public  Student getStuById(int id);
}

4、sql映射文件（使用接口编程）

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  <mapper namespace="com.taozi.mybatis.test.Mybatis_01_Mapper">
  <select id="getStuById" resultType="com.taozi.mybatis.bean.Student" databaseId="mysql">
    select * from stu where id = #{id}
  </select>
  <select id="getStuById" resultType="com.taozi.mybatis.bean.Student" databaseId="sqlserver">
    select * from stu where id = #{id}
  </select>

5、测试类

@Test
    public void test_01() throws IOException{
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory =
                  new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession();

        Mybatis_01_Mapper mapper = session.getMapper(Mybatis_01_Mapper.class);
        Student stu = mapper.getStuById(1);
         System.out.println(stu);
         session.close();
    }

6、结果
全局配置文件中的environments标签的default属性，在mysql与sqlserver中切换，可以得到对应库中的数据

小结：
1、 配置文件中的标签先后顺序不可变
2、sqlserver连接和mysql连接稍有不同，驱动书写方式不一样
3、不知道数据库版本时，获取到数据库连接后，可使用下列函数获取

 DatabaseMetaData metaData=conn.getMetaData();
        String sqlname=metaData.getDatabaseProductName();