1.修改pom.xml加入依赖
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!-- 引入日志依赖 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!--mysql驱动包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
2.新建log4j.properties日志属性文件
创建了resources文件夹,右击选择Mark Directory as --> resources root
日志中写入
# Global logging configuration
# 在开发环境下日志级别要设置成DEBUG,生产环境设置成info或error
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
3.新建db.properties属性文件
#mysql
db.user=root
db.password=root
db.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
db.driverClass=com.mysql.cj.jdbc.Driver
db.maxPoolSize=30
db.minPoolSize=3
db.initialPoolSize=5
db.acquireIncrement=5
4.SqlMapConfig.xml核心配置文件
SqlMapConfig.xml是mybatis核心配置文件,配置mybatis的运行环境,数据源、事务等。
首先,先创建mybatis核心配置文件模版
<?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>
</configuration>
5.SqlMapConfig.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>
<!-- 加载属性文件 db.properties -->
<properties resource="db.properties"></properties>
<!-- 配置全局参数 -->
<!--<settings></settings>-->
<!-- 自定义别名:扫描指定包下的实体类,给这些类取别名,默认是它的类名或者类名首字母小写 -->
<typeAliases>
<package name="com.cm.entity"/>
</typeAliases>
<!-- 和spring整合后 environments配置将废除-->
<environments default="development">
<environment id="development">
<!-- 使用jdbc事务管理,事务控制由mybatis-->
<transactionManager type="JDBC" />
<!-- 数据库连接池,由mybatis管理,通过${}直接加载属性文件上的值-->
<!-- -->
<dataSource type="POOLED">
<property name="driver" value="${db.driverClass}" />
<property name="url" value="${db.jdbcUrl}" />
<property name="username" value="${db.username}" />
<property name="password" value="${db.password}" />
</dataSource>
</environment>
</environments>
<!-- 批量加载mapper映射文件:指定mapper接口所在的包名,mybatis为其生成代理对象 -->
<mappers>
<package name=" " />
</mappers>
</configuration>
6.Mapper映射文件
再次修改pom.xml
加入
<build>
<!-- 识别在src/main/java路径下的xml文件 -->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
</build>
再创建mapper映射文件模版
<?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=" ">
</mapper>
最后再新建Mapper映射文件
7.最后创建相应的实体类包entity