【mybatis专题】二：mybatis-spring快速开始

本文基于Java+spring+mybatis+mysql创建一个简易的mybatis-spring的快速开始的demo

参考官网：http://mybatis.org/spring/getting-started.html

1、创建maven项目，项目结构如下图所示，然后引入依赖

项目依赖如下，maven有个优点，依赖传递，只需要引入spring-webmvc的依赖就基本引用了常用的spring依赖了

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>4.3.22.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.2</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>4.3.22.RELEASE</version>
    </dependency>

2、在mysql选择一个数据库创建一个简单的blog表，建表语句如下（阅读过上一章的可以跳过此步骤，使用的还是blog表）：

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
 
-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog`  (
  `blog_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `author` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`blog_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
 
-- ----------------------------
-- Records of blog
-- ----------------------------
INSERT INTO `blog` VALUES (1, 'mybatis快速开始', '参考：https://mybatis.org/mybatis-3/getting-started.html', 'csdn_white', '2020-12-17 10:25:54', NULL);
INSERT INTO `blog` VALUES (2, 'mybatis集成spring', '参考：http://mybatis.org/spring/index.html', 'csdn_white', '2020-12-17 10:26:46', NULL);
 
SET FOREIGN_KEY_CHECKS = 1;

3、创建基本的Java实体类Blog和BlogMapper接口（阅读过上一章的可以跳过此步骤）

package com.example.mybatis.entity;
 
import java.util.Date;
 
public class Blog {
    private int blogId;
    private String title;
    private String content;
    private String author;
    private Date createTime;
    private Date updateTime;
 
    public int getBlogId() {
        return blogId;
    }
 
    public void setBlogId(int blogId) {
        this.blogId = blogId;
    }
 
    public String getTitle() {
        return title;
    }
 
    public void setTitle(String title) {
        this.title = title;
    }
 
    public String getContent() {
        return content;
    }
 
    public void setContent(String content) {
        this.content = content;
    }
 
    public String getAuthor() {
        return author;
    }
 
    public void setAuthor(String author) {
        this.author = author;
    }
 
    public Date getCreateTime() {
        return createTime;
    }
 
    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }
 
    public Date getUpdateTime() {
        return updateTime;
    }
 
    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }
 
    @Override
    public String toString() {
        return "Blog{" +
                "blogId=" + blogId +
                ", title='" + title + '\'' +
                ", content='" + content + '\'' +
                ", author='" + author + '\'' +
                ", createTime=" + createTime +
                ", updateTime=" + updateTime +
                '}';
    }
}

package com.example.mybatis.mapper;
 
import com.example.mybatis.entity.Blog;
import org.apache.ibatis.annotations.*;
 
import java.util.Date;
import java.util.List;
 
public interface BlogMapper {
 
    @Select("select * from blog")
    List<Blog> queryAllBlog();
 
    @Insert("insert into blog(title,content,author,create_time) values(#{title},#{content},#{author},#{createTime,jdbcType=TIMESTAMP})")
    int addBlog(Blog blog);
 
    @Update("update blog set content=#{blog.content},update_time=#{blog.updateTime} where blog_id=#{blogId}")
    int updateBlogByBlogId(@Param("blog") Blog blog, @Param("blogId") int blogId);
 
    @Delete("delete from blog where blog_id=#{blogId}")
    int deleteBlogByBlogId(@Param("blogId")int blogId);
}

4、创建BlogService和BlogServiceImpl

package org.example.service;

import org.example.entity.Blog;

import java.util.List;

public interface BlogService {

    List<Blog> queryAllBlog();
    int addBlog(Blog blog);
    int updateBlogByBlogId(Blog blog, int blogId);
    int deleteBlogByBlogId(int blogId);
}

package org.example.service.impl;

import org.example.entity.Blog;
import org.example.mapper.BlogMapper;
import org.example.service.BlogService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class BlogServiceImpl implements BlogService {

    @Autowired
    private BlogMapper blogMapper;

    @Override
    public List<Blog> queryAllBlog() {
        return blogMapper.queryAllBlog();
    }

    @Override
    public int addBlog(Blog blog) {
        return blogMapper.addBlog(blog);
    }

    @Override
    public int updateBlogByBlogId(Blog blog, int blogId) {
        return blogMapper.updateBlogByBlogId(blog,blogId);
    }

    @Override
    public int deleteBlogByBlogId(int blogId) {
        return blogMapper.deleteBlogByBlogId(blogId);
    }
}

5、准备好mysql连接数据库的基本信息db.properties

datasource.driverClass = com.mysql.jdbc.Driver
datasource.url = jdbc:mysql://localhost:3306/my_test?useSSL=false
datasource.username = root
datasource.password = root

6、根据官网所说spring使用mybatis必须有SqlSessionFactory和一个mapper接口，mapper上面已经创建了，下面通过Java config引入SqlSessionFactory

package org.example.config;

import org.apache.ibatis.datasource.pooled.PooledDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.*;

import javax.sql.DataSource;

@Configuration
@PropertySources({@PropertySource("db.properties")})
public class MybatisConfig {

    @Value("${datasource.driverClass}")
    private String driverClass;
    @Value("${datasource.url}")
    private String url;
    @Value("${datasource.username}")
    private String username;
    @Value("${datasource.password}")
    private String password;

    @Bean
    public SqlSessionFactory sqlSessionFactory() throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource());
        //此处类似mybatis-config.xml的configuration标签
        org.apache.ibatis.session.Configuration configuration =new org.apache.ibatis.session.Configuration();
        //开启mybatis下划线自动转换驼峰命名
        configuration.setMapUnderscoreToCamelCase(true);
        sqlSessionFactoryBean.setConfiguration(configuration);
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBean.getObject();
        return sqlSessionFactory;
    }

    @Bean
    public DataSource dataSource(){
        PooledDataSource pooledDataSource = new PooledDataSource();
        pooledDataSource.setDriver(driverClass);
        pooledDataSource.setUrl(url);
        pooledDataSource.setUsername(username);
        pooledDataSource.setPassword(password);
        return pooledDataSource;
    }

}

7、app使用main方法启动spring容器，测试是否能够正常使用mybatis

package org.example;

import org.example.entity.Blog;
import org.example.service.BlogService;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.*;

import java.util.List;

@ComponentScan(basePackages = {"org.example"})
@MapperScan(basePackages = {"org.example.mapper"})
public class App{

    public static void main( String[] args )
    {
        AnnotationConfigApplicationContext applicationContext = new AnnotationConfigApplicationContext(App.class);
        BlogService blogService = applicationContext.getBean(BlogService.class);
        List<Blog> blogs = blogService.queryAllBlog();
        if(blogs!=null){
            for (Blog blog : blogs) {
                System.out.println(blog);
            }
        }else{
            System.out.println("blogs is null");
        }
    }
}

8、测试结果：

结果表明：BlogMapper成功注入BlogService的实例中

下章讲述mybatis是怎样将BlogMapper接口实例化并且根据@Select、@Insert、@Update、@Delete的注解和value（sql） 实现执行sql的效果，并且将生成的类交给spring容器来管理的