1.mybatis引入的jdbc.properties配置
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql:///liuyu?characterEncoding=utf8&useUnicode=true&useSSL=false&serverTimezone=Hongkong
jdbc.username=root
jdbc.password=123
2.mybatis.xml文件配置
<?xml version="1.0" encoding="UTF-8"?>
<!--mybatis.xml文件头-->
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 引入外部jdbc.properties文件(放置在resource文件夹下)-->
<properties resource="jdbc.properties"></properties>
<environments default="mysql">
<environment id="mysql">
<transactionManager type="JDBC"></transactionManager>
<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="mybatis.dao.StudentDao.xml"></mapper>
<!-- <package name="mybatis.dao"/>-->
</mappers>
</configuration>
3.mapper.xml(Dao.xml)文件配置
(若运行时出现找不到Dao.xml文件,可手动将xml放入编译后的对应文件夹中)
<?xml version="1.0" encoding="UTF-8" ?>
<!--mapper.xml文件头-->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace设定对应Dao的路径(从源根开始的全路径)-->
<mapper namespace="mybatis.dao.StudentDao">
<select id="selectAll" resultType="mybatis.entity.Student">
select * from student order by id
</select>
</mapper>
4.