对比阅读:#Spring:<context:property-placeholder> #Spring中配置数据源的两种方式 @FDDLC
MyBatis中配置数据库的三种方式:
方式一:
<environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC"></transactionManager> <dataSource type="POOLED"> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/Test?characterEncoding=UTF8&serverTimezone=Asia/Shanghai"/> <property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> </environments>特点:直接!
注意:此处url的值里用 & 来表示&
方式二:
<properties> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/Test?characterEncoding=UTF8&serverTimezone=Asia/Shanghai"/> <property name="username" value="root"/> <property name="password" value="root"/> </properties> <environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC"></transactionManager> <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>特点:不那么直接了,但是:你觉得怎么样?
注意:此处url的值里用 & 来表示&
方式三:
先编写mysql.properties文件:
driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/Test?characterEncoding=UTF8&serverTimezone=Asia/Shanghai username=root password=root注意:此处url的值里用 & 来表示&
然后再配置:
<properties resource="mysql.properties"></properties> <environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC"></transactionManager> <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>这里用到了<properties>标签的resource属性,用来指定properties的位置(一般在类路径下)。
注意:${driver}用的是$,不是#!