Springboot整合Mybatis和SQLite

Springboot整合Mybatis和SQLite

• • 项目目录
  • SQLite中的数据
  • maven的pom.xml导入所需要的依赖
  • 创建SQLite需要的文件
  • 配置yml文件
  • Msg类
  • User类
  • controller类
  • service类
  • dao类
  • maper.xml文件
  • 在springboot主运行程序加上MapperScan注解
  • 配置完成在postman上测试

项目目录

SQLite中的数据

maven的pom.xml导入所需要的依赖

 
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.3.1
        

        
            org.projectlombok
            lombok
            true
        

        
        
            org.xerial
            sqlite-jdbc
            3.8.11.2
        

        
        
            com.alibaba
            druid-spring-boot-starter
            1.1.10
        

创建SQLite需要的文件

在resources目录下创建databases.db，如下图

配置yml文件

server:
  port: 8888
spring:
  mvc:
    static-path-pattern: classpath:/**
  # 配置 Oracle
  datasource:
    driver-class-name: org.sqlite.JDBC  #数据库链接驱动
    url: jdbc:sqlite::resource:databases/data.db #数据库链接地址
    username:
    password:
    type: com.alibaba.druid.pool.DruidDataSource

# mybatis配置
mybatis:
  mapper-locations: classpath:mapper/*.xml    # mapper映射文件位置
  type-aliases-package: cn.xdedm.entity    # 实体类所在的位置
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl   #用于控制台打印sql语句
    map-underscore-to-camel-case: true

Msg类

package cn.xdedm.entity;

import java.util.HashMap;
import java.util.Map;

public class Msg {
    //状态码 10001 成功 10002失败
    private int code;
    private String msg;
    private Map extend=new HashMap();

    /**
     * 返回成功
     * @return
     */
    public static  Msg Success (){
        Msg result = new Msg();
        result.setCode(10001);
        result.setMsg("成功");
        return result;
    }

    /***
     * 返回失败
     * @return
     */
    public static  Msg fail (){
        Msg result = new Msg();
        result.setCode(10002);
        result.setMsg("失败");
        return result;
    }

    public Msg Add(String key,Object value){
        this.getExtend().put(key,value);
        return this;
    }

    public int getCode() {
        return code;
    }

    public void setCode(int code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public Map getExtend() {
        return extend;
    }

    public void setExtend(Map extend) {
        this.extend = extend;
    }

    @Override
    public String toString() {
        return "Msg{" +
                "code=" + code +
                ", msg='" + msg + '\'' +
                ", extend=" + extend +
                '}';
    }

}

User类

package cn.xdedm.entity;

import lombok.Data;

@Data
public class User {
    private Integer id ;
    private String  nickName ;
    private String  account ;
    private String  password ;
    private String  createTime;
    private Integer vaildFlag ;
}

controller类

   package cn.xdedm.controller;

import cn.xdedm.entity.Msg;

import cn.xdedm.entity.User;
import cn.xdedm.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("user")
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping("/query")
    public Msg QueryUser(@RequestBody User user){

        Msg msg=userService.QueryUser(user);

        return msg;

    }

}

service类

package cn.xdedm.service;

import cn.xdedm.dao.UserMapper;
import cn.xdedm.entity.Msg;
import cn.xdedm.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService {

    @Autowired
    private UserMapper userMapper;

    public Msg QueryUser(User user) {
        User user_db=userMapper.QueryUser(user);
        return Msg.Success().Add("user",user_db);
    }
}

dao类

package cn.xdedm.dao;

import cn.xdedm.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

@Component
@Mapper
public interface UserMapper {
    User QueryUser(User user);
}

maper.xml文件

    
        select * from passwordsystem_user where 1=1
        
            and id=#{id}
        
        
            and nick_name=#{nickName}
        
        
            and vaild_flag=#{vaildFlag}
        
        
            and account=#{account}
        

    

在springboot主运行程序加上MapperScan注解

package cn.xdedm;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("cn.xdedm.dao")
public class PasswordsystemApplication {

    public static void main(String[] args) {
        SpringApplication.run(PasswordsystemApplication.class, args);
    }

}

配置完成在postman上测试