mybatis.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="db.properties"></properties>
<typeAliases>
<!-- 用来给查询返回值的数据类型取别名的-->
<typeAlias type="com.mybatis.pojo.User" alias="user"></typeAlias>
</typeAliases>
<environments default="development">
<environment id="development">
<!-- 默认使用觉得不错的事务管理方式-->
<transactionManager type="JDBC"/>
<!-- pooLED当前使用连接池,如果不适应连接池,填写UNPOOLED-->
<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>
<mappers>
<!-- 用来扫描sql所在的映射文件的路径-->
<!-- <mapper resource="com/mybatis/mapper/UserMapper.xml"/>-->
<!-- 用来扫描映射文件及被绑定的接口类所在的包-->
<package name="com.mybatis.mapper"/>
</mappers>
</configuration>
数据库的连接配置 :db.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatisdata?useSSL=false&characterEncoding=utf8
username = root
password= root
映射文件:Mapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mybatis.mapper.Mapper">
</mapper>