springboot整合mybatis连接数据库

• 1.引入maven依赖

  <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>2.2.0</version>
  </dependency>
  
  <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-jdbc</artifactId>
  </dependency>
  
  <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
  </dependency>
  
  <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
  </dependency>
  

• 2.编写mapper接口

  //Mapper注解表示这是一个mybatis的mapper类
  @Mapper
  @Repository
  public interface UserMapper {
  
      List<User> queryUserList();
  
      User queryUserById(int id);
  
      int addUser(User user);
  
      int updateUser(User user);
  
      int deleteUser(int id);
  
  }
  

• 3.编写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.lv.mapper.UserMapper">  <!--注意命名空间-->
  
      <select id="queryUserList" resultType="User">
          select * from user;
      </select>
  
      <select id="queryUserById" resultType="User" parameterType="int">
          select * from user where id=#{id};
      </select>
  
      <insert id="addUser" parameterType="User">
          insert into user (id,name,pwd) values (#{id},#{name},#{pwd});
      </insert>
  
      <update id="updateUser" parameterType="User">
          update user set name=#{name},pwd=#{pwd} where id=#{id};
      </update>
  
      <delete id="deleteUser" parameterType="int">
          delete from user where id=#{id};
      </delete>
  
  </mapper>
  

• 4.配置application.properties或者application.yaml，连接数据库

  spring.datasource.username=root
  spring.datasource.password=123456
  spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
  spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
  
  # mybatis配置
  mybatis.type-aliases-package=com.lv.pojo
  mybatis.mapper-locations=classpath:mybatis/mapper/*.xml  # mapper.xml位置
  
  

• 5.测试结果，在测试类中测试

      @Autowired
      UserMapper userMapper;
  
      @Test
      void contextLoads() throws SQLException {
  
          List<User> users = userMapper.queryUserList();
          for (User user : users) {
              System.out.println(user);
          }
  
      }