第一种:一般链接方式
<environments
default
="mysql"
>
<!--
配置
mysql
的环境
-->
<environment
id
="mysql"
>
<!--
配置事务类型
-->
<transactionManager
type
="JDBC"
></transactionManager>
<!--
配置数据源(链接池)
-->
<!--
数据源:
driver
、
url
、
username
、
password-->
<dataSource
type
="POOLED"
>
<!--
配置链接数据库的基本信息
-->
<property
name
="driver"
value
="com.mysql.cj.jdbc.Driver"
></property>
<!--<property name="driver" value="com.mysql.jdbc.Driver"/>-->
<property
name
="url"
value
="jdbc:mysql://localhost:3306/eesy_mybatis?useUnicode=true
&
useUnicode=true
&
useJDBCCompliantTimezoneShift=true
&
useLegacyDatetimeCode=false
&
serverTimezone=UTC
&
characterEncoding=utf-8
&
useSSL=false
&
allowPublicKeyRetrieval=true"
/>
<property
name
="username"
value
="root"
></property>
<property
name
="password"
value
="123456"
></property>
</dataSource>
</environment>
</environments>
第二种:起别名
<properties>
<property
name
="driver"
value
="com.mysql.jdbc.Driver"
></property>
<property
name
="url"
value
="jdbc:
mysql://localhost:3306/eesy_mybatis
"
></property>
<property
name
="username"
value
="root"
></property>
<property
name
="password"
value
="1234"
></property>
</properties>
<properties>
<property
name
="driver"
value
="${driver}"
></property>
<property
name
="url"
value
="${url}"
></property>
<property
name
="username"
value
="${username}"
></property>
<property
name
="password"
value
="${password}"
></property>
</properties>
第三种:引用 外部文件
<!--
配置
properties
可以在标签内部配置数据库连接信息,也可以通过属性引用外部配置文件信息
resource
属性:
用于指定配置文件位置,是按照类路径的写法来写,并保存于类路径下
-->
<!--
配置数据库链接环境
-->
<properties
resource
="jdbcConfig.properties" 或者使用
url
="D:\Program Files\ideaxiangmu\day01_eesy_01mybatis\src\main\resources\jdbcConfig.properties"
>
<property
name
="driver"
value
="${jdbc.driver}"
></property>
<property
name
="url"
value
="${jdbc.url}"
></property>
<property
name
="username"
value
="${jdbc.username}"
></property>
<property
name
="password"
value
="${jdbc.password}"
></property>
</properties>
外部文件这里用的文件名字问
jdbcConfig.properties
jdbc.driver
=
com.mysql.cj.jdbc.Driver
jdbc.url
=
jdbc:mysql://localhost:3306/eesy_mybatis
jdbc.username
=
root
jdbc.password
=
123456