3_MyBatis配置详解-5_关于外部属性配置文件存储数据库连接信息

旧城等待， 2023-09-27 13:17 68阅读 0赞

在resources下准备jdbc.properties属性配置文件

![34a453cce059006ab8ca95ad7b76dd98.png][]

配置文件中的内容

*  jdbc\_driver=com.mysql.cj.jdbc.Driver
 *  jdbc\_url=jdbc:mysql://127.0.0.1:3306/mydb?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
 *  jdbc\_username=root
 *  jdbc\_password=root

在核心配置文件中引入db.properties属性文件

*  <?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.properties"></properties>
 *  
 *  <settings>
 *  
 *  <setting name="logImpl" value="LOG4J"/>
 *  </settings>
 *  
 *  
 *  <typeAliases>
 *  
 *  <package name="com.msb.pojo"/>
 *  </typeAliases>
 *  
 *  
 *  <environments default="mysql">
 *  
 *  <environment id="mysql">
 *  <transactionManager type="JDBC"/>
 *  
 *  <dataSource type="POOLED">
 *  <property name="driver" value="$\{jdbc\_driver\}"/>
 *  <property name="url" value="$\{jdbc\_url\}"/>
 *  <property name="username" value="$\{jdbc\_username\}"/>
 *  <property name="password" value="$\{jdbc\_password\}"/>
 *  </dataSource>
 *  </environment>
 *  </environments>
 *  
 *  <mappers>
 *  <mapper resource="com/msb/mapper/DeptMapper.xml"/>
 *  </mappers>
 *  </configuration>
 *

[34a453cce059006ab8ca95ad7b76dd98.png]: https://img-blog.csdnimg.cn/img_convert/34a453cce059006ab8ca95ad7b76dd98.png