Java连接SQLite

目录结构

SQLiteConfig.properties

driver=org.sqlite.JDBC
url=jdbc:sqlite:src/main/resources/test.db
username=""
password=""

mybatis-config

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<!--mybatis配置文件的标签顺序必须是以下顺序：
The content of element type “configuration”
must match “(properties?,settings?,typeAliases?,
typeHandlers?,objectFactory?,objectWrapperFactory?,
reflectorFactory?,plugins?,environments?,databaseIdProvider?,mappers?)”.
-->

<!-- <properties resource="H2Config.properties" /> -->
 <!-- <properties resource="MySQL8.properties" /> -->
 <properties resource="SQLiteConfig.properties" />

<settings>
<setting name="logImpl" value="LOG4J"/>
<setting name="cacheEnabled" value="true"/>
</settings>

<typeAliases>
  <package name="cn.edu" />
</typeAliases>

  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>

  <mappers>
    <!--  <mapper resource="cn/edu/CountryMapper.xml"/>  -->

    <!-- 包下的所有映射器 -->
    <package name="cn.edu" />
  </mappers>

</configuration>

pom

<dependency>
    <groupId>org.xerial</groupId>
    <artifactId>sqlite-jdbc</artifactId>
    <version>3.36.0.3</version>
    <scope>runtime</scope>
</dependency>