Java使用MyBatis操作SQLite

Maven依赖，mybatis版本是3.0.0的时候报错，之后改成2.2.2不报错了

<!--        sqlite 数据库-->
        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
            <version>3.34.0</version>
        </dependency>
<!--        mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

application.properties，D:/workspace/mem4j/db/sqlite-test.db要改成自己的路径

spring.datasource.url=jdbc:sqlite:D:/workspace/mem4j/db/sqlite-test.db
spring.datasource.driver-class-name=org.sqlite.JDBC
mybatis.mapper-locations=classpath:/mapper/*.xml

其余的使用和操作mysql一样

domain

package com.mem4j.domain;

import lombok.Data;

@Data
public class User {

    private Integer id;

    private String name;

}

mapper

package com.mem4j.mapper;

import com.mem4j.domain.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper {

    List<User> selectAll();

}

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.mem4j.mapper.UserMapper">
    <resultMap id="BaseResultMap" type="com.mem4j.domain.User">
        <id column="id" jdbcType="INTEGER" property="id" />
        <result column="name" jdbcType="VARCHAR" property="name" />
    </resultMap>
    <select id="selectAll" resultMap="BaseResultMap">
        select *
        from test;
    </select>
</mapper>