pro 新建 数据 配置信息 onf ron XML oca
原来直接把数据库连接配置信息写在 conf.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://localhost:3306/test" />
- <property name="username" value="root" />
- <property name="password" value="123456" />
- </dataSource>
- </environment>
- </environments>
- </configuration>
优化如下:
(1)新建 db,properties 文件,将数据库的连接配置信息写在一个 properties 文件中,路径:src/db.properties
- driver=com.mysql.jdbc.Driver
- url=jdbc:mysql://localhost:3306/test
- name=root
- password=123456
(2)在 conf.xml 文件中引用 properties 文件,修改 conf.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>
- <!-- 引用db.properties配置文件 -->
- <properties resource="db.properties"/>
- <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="${name}" />
- <property name="password" value="${password}" />
- </dataSource>
- </environment>
- </environments>
- </configuration>
(@_@)... 完...
mybatis 学习笔记 (三)-- 优化数据库连接配置
来源: http://www.bubuko.com/infodetail-2147607.html