javaweb:增加jdbc.properties,增加MyBatis配置文件

增加jdbc.properties,增加MyBatis配置文件

jdbc.properties内容

driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/community?useSSL=false&serverTimezone=UTC
username=root
password=123456

driverClassName是驱动

url是数据库链接

username是数据库用户名

password是数据库密码

sqlMapConfig.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>
 	<properties resource="jdbc.properties"/>
	<environments default="development">  
	    <environment id="development">  
		    <!-- 使用jdbc事务管理-->  
		    <transactionManager type="JDBC" />  
		    <!-- 数据库连接池-->  
		    <dataSource type="POOLED">  
			    <property name="driver" value="${driverClassName}" />  
			    <property name="url" value="${url}" />  
			    <property name="username" value="${username}" />  
			    <property name="password" value="${password}" />  
		    </dataSource>  
	    </environment>  
	</environments> 
	<!-- 加载映射文件 -->  	
	<mappers> 
		<!-- <mapper resource="mappers/Db45Mapper.xml"/> -->
	</mappers> 
</configuration>