本文共 3468 字，大约阅读时间需要 11 分钟。

Springboot整合mybatis笔记

1，工程的创建

2，数据库中创建表

创建表

CREATE TABLE `user` (--   `id` int(32) NOT NULL AUTO_INCREMENT,--   `UserName` varchar(30) NOT NULL,--   `PassWord` varchar(35) NOT NULL,--   PRIMARY KEY (`id`)-- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

创建成功我在user表中添加了几条数据

3，整合mybatis并访问数据

项目配置application.yml文件内容为

server:  port: 8080#mysql的新版本需要指定数据时区spring:  datasource:    username: root    password: 1234567    url: jdbc:mysql://localhost:3306/study?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8    driver-class-name: com.mysql.cj.jdbc.Driver#mybatis#指定映射文件的路径,指定bean所在的包mybatis:  mapper-locations: classpath:mapper/*.xml  type-aliases-package: com.echart.entity

mapper.xml文件内容及其位置

   
   
   
      
        
         
         
       
      
      
      select * from user
   

entity类位置及其内容

package com.echart.entity;/** * @author ganxiang * IDE      IntelliJ IDEA * @project_name and filename echart User * @date 2020/06/16 0016 19:34 */public class User {
       private Integer id;    private String userName;    private String passWord;    public Integer getId() {
           return id;    }    public void setId(Integer id) {
           this.id = id;    }    public String getUserName() {
           return userName;    }    public void setUserName(String userName) {
           this.userName = userName;    }    public String getPassWord() {
           return passWord;    }    public void setPassWord(String passWord) {
           this.passWord = passWord;    }    @Override    public String toString() {
           return "User{" +                "id=" + id +                ", userName='" + userName + '\'' +                ", passWord='" + passWord + '\'' +                '}';    }}

dao数据访问层为

package com.echart.dao;import com.echart.entity.User;import org.springframework.stereotype.Repository;import java.util.List;/** * @author ganxiang * IDE      IntelliJ IDEA * @project_name and filename echart UserMapper * @date 2020/06/16 0016 19:38 */@Repositorypublic interface UserMapper {
       List
   
     findall();}
   

service层

package com.echart.service;import com.echart.dao.UserMapper;import com.echart.entity.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;/** * @author ganxiang * IDE      IntelliJ IDEA * @project_name and filename echart UserService * @date 2020/06/16 0016 19:37 */@Servicepublic class UserService {
       @Autowired    UserMapper userMapper;    public List
   
     findall(){
   return userMapper.findall();}}
   

最后我们的测试类TestController

package com.echart.controller;import com.echart.entity.User;import com.echart.service.UserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import java.util.List;/** * @author ganxiang * IDE      IntelliJ IDEA * @project_name and filename echart TestController * @date 2020/06/16 0016 19:36 */@RestControllerpublic class TestController {
       @Autowired    private UserService userService;        @RequestMapping("/all")    public List
   
     findall(){
           return userService.findall();    }}
   

4，测试展示

转载地址：http://eeqzi.baihongyu.com/