实用 | Mybatis环境搭建

最新推荐文章于 2021-12-17 16:13:37 发布

孙行者Monkey

最新推荐文章于 2021-12-17 16:13:37 发布

阅读量292

点赞数 1

分类专栏： MyBatis 文章标签： MyBatis

本文链接：https://blog.csdn.net/qq_41359684/article/details/101297299

版权

MyBatis 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

1.创建Maven项目

2.引入依赖

<packaging>jar</packaging>
<properties>
  <!-- 自动生成G/S方法 -->
  <lombok.version>1.18.6</lombok.version>
  <!-- Mybatis框架包 -->
  <mybatis.version>3.5.0</mybatis.version>
  <!-- Mysql驱动包 -->
  <mysql.version>8.0.15</mysql.version>
  <!-- Log4j依赖包 -->
  <slf4j.version>1.7.26</slf4j.version>
  <log4j.version>1.2.17</log4j.version>
  <!-- 单元测试依赖包 -->
  <junit.version>4.12</junit.version>
</properties>
<dependencies>
  <dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>${lombok.version}</version>
  </dependency>
 <dependency>
<version>${mybatis.version}</version>
  </dependency>
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql.version}</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api -->
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-api</artifactId>
    <version>${slf4j.version}</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/log4j/log4j -->
  <dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>${log4j.version}</version>
  </dependency>
 
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>${slf4j.version}</version>
  </dependency>
  <dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>${junit.version}</version>
  </dependency>
</dependencies>

3.配置文件

主配置文件

<?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>
  <!-- 指定默认环境 -->
  <environments default="dev">
    <!-- 环境配置 -->
    <environment id="dev">
      <!-- 事务管理类型 -->
      <transactionManager type="JDBC"/>
      <!-- 连接池配置 -->
      <dataSource type="POOLED">
        <!-- 驱动 -->
<property name="url"
value="jdbc:mysql://127.0.0.1:3306/mybatisdb"/>
        <!-- 用户名 -->
        <property name="username" value="root"/>
        <!-- 密码 -->
        <property name="password" value="root"/>
      </dataSource>
    </environment>
  </environments>
  <!-- 映射集配置 -->
  <mappers>
    <!-- 多映射配置 -->
    <mapper resource="mapper/userMapper.xml" />
  </mappers>
</configuration>

映射配置文件

<?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.itheima.mybatis.day02.crud.mapper.UserMapper">
  <!-- 查询标识; 返回值; 执行语句 -->
  <select id="findById"
resultType="com.itheima.mybatis.day02.crud.model.User">
   select * from user where id = #{id}
  </select>
</mapper>

日志配置文件

# 日志级别, 输出类型
log4j.rootLogger=DEBUG, stdout
# 控制台输出工具
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
# 控制台输出样式布局工具
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
# 控制台输出样式定义
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n