10.MyBatis配置文件

可变参数

• Configuration XML 的参数可以是变化的，本例将数据库IP、用户名、密码设为可变项。

1.修改mybatis-config.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>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://${server}/af_example?useUnicode=true&amp;characterEncoding=UTF-8"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="mybatis-mapper.xml"/>
  </mappers>
</configuration>

2.修改mybatis-mapper.xml

<?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="af.test">
  <select id="getStudent" resultType="my.Student">
    select * from student where id = #{id}
  </select>
  
</mapper>

3.测试  Properties 用法有点像HashMap

package my;

import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;
import java.util.Properties;

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 Test
{
	public static void main(String[] args) throws Exception
	{
		// 设定参数
		Properties props = new Properties();
		props.put("server", "127.0.0.1");
		props.put("username", "root");
		props.put("password", "a1b2c3");
		
		// 创建 SqlSessionFactory
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream,props);//传入可变参数

		// 使用简化的try-with-resources语法，等效于try..finally语句
		try (SqlSession session = sqlSessionFactory.openSession()) {
			Map<String,Object> para=new HashMap<>();
			para.put("id", 20190001);
			Student row = session.selectOne("af.test.getStudent",para);
			if(row != null)
				System.out.println("找到一条记录");
		}
		System.out.println("Exit");
	}

}

4.结果