sqlite3真的很方便，随手写个小应用太方便了。本着极简（懒）的态度，做一个最简集成。

window环境
首先sqlite3 去官网下一个预编译的版本的，再下一个工具包（exe执行文件），然后

sqlite3 test.db

创建一个数据库。
建表

create table user
(
  id   INTEGER not null
    primary key
  autoincrement,
  name varchar(20)
);

这里表名取成了user，因为懒。

maven pom.xml:

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>cn.jesseyang</groupId>
    <artifactId>sqlite-demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>

    <name>sqlite-demo</name>
    <description>Demo project for Spring Boot</description>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.1.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc -->
        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
            <version>3.23.1</version>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.6</version>
        </dependency>

    </dependencies>




</project>

application.yml

这里的::resource 的意思是相对路径。绝对路径可以不要这个resource.这里的db文件夹我建在了resources目录下。

spring:
  datasource:
    url: jdbc:sqlite::resource:db/test.db
    driver-class-name: org.sqlite.JDBC
    username:
    password:

dommain

用了lombok 省了getter setter

@Data
public class User {
    private String name;
}

usermapper

感谢mybatisplus就是这么简单

@Mapper
public interface UserMapper extends BaseMapper<User> {
}

试一把

直接写在了Application类里面测试，妥妥的

@SpringBootApplication
@RestController
public class SqliteDemoApplication {

    @Autowired
    UserMapper userMapper;

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



    @RequestMapping("/insert")
    public Object insert(String name){
        User user = new User();
        user.setName(name);
        userMapper.insert(user);
        return user;
    }

    @RequestMapping("/show")
    public Object show(){

        return userMapper.selectList(null);
    }
}

地址：
https://gitee.com/jesseyang/springboot-sqlite3-mybatisplus-demo