mybatis-config+database.properties模板

mybatis-config模板

<?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="database.properties" />
    <!--实体类位置-->
    <typeAliases>
       <package name=""/>
    </typeAliases>
    <!--配置运行的数据库环境-->
    <environments default="myEnv">
       <environment id="myEnv">
          <transactionManager type="jdbc" />
          <dataSource type="pooled">
             <property name="driver" value="\${driver}" />
             <property name="url" value="\${url}" />
             <property name="username" value="\${username}" />
             <property name="password" value="\${password}" />
          </dataSource>
       </environment>
    </environments>
    
    <!-- 实体类SQL映射文件 接口位置-->
    <mappers>
       <package name=""/>
    </mappers>
</configuration>

databse.propertie

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/${databaseName}?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull
username=root
password=root