1、下载SQLLite,官网地址:https://sqlite.org/download.html
2、选择下载的文件

3、下载完在解压在电脑的目录下,然后cmd执行如下命令创建数据库
cd D:\WK\2025\StudentManagerSystem\sqlite
D:
entManagerSystem\sqlite>sqlite3.exe 所建库的名字.db
至此建立数据库的部分已经完成
4、在spring boot中 建立maven依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-spring-boot4-starter</artifactId>
<version>3.5.17</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-jsqlparser</artifactId>
<version>3.5.17</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot4-starter</artifactId>
<version>4.5.0</version>
</dependency>
<!-- Source: https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc -->
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.54.1.0</version>
<scope>compile</scope>
</dependency>
在插件pom中build标签下面写入如下
<resources>
<resource>
<directory>src/main/resources</directory>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
5、在application.yml及其application-dev.yml文件中写入如下
application.yml文件
server:
port: 9223
spring:
profiles:
active: dev
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
mapper-locations: classpath:com/example/detail_data_tool/**/mapper/xml/*.xml
application-dev.yml文件如下:
spring:
datasource:
dynamic:
#默认数据源
primary: master
datasource:
master:
driver-class-name: org.sqlite.JDBC
url: jdbc:sqlite:file:D:\SQLLite\test.db
hikari:
# max-lifetime: 70000
maximum-pool-size: 200 # 必改
minimum-idle: 50 # 必改
connection-timeout: 30000
idle-timeout: 600000
max-lifetime: 1800000
leak-detection-threshold: 10000
connection-test-query: SELECT 1
6、在启动类添加如下注解:
@MapperScan("com.example.detail_data_tool.**.mapper")
7、进行mybatis-plus的一些配置
7.1)定义批量插入接口BasePlusMapper,使得后续mapper都集成BasePlusMapper<实体类>
package com.example.detail_data_tool.tj.sqllite.config;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import java.util.Collection;
public interface BasePlusMapper <T> extends BaseMapper<T> {
//真正的批量插入
Integer insertBatchSomeColumn(Collection<T> entityList);
}
7.2)定义EasySqlInjector 把批量插入引入进去
package com.example.detail_data_tool.tj.sqllite.config;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.injector.DefaultSqlInjector;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.extension.injector.methods.InsertBatchSomeColumn;
import java.util.List;
public class EasySqlInjector extends DefaultSqlInjector {
@Override
public List<AbstractMethod> getMethodList(Class<?> mapperClass, TableInfo tableInfo) {
// 注意:此SQL注入器继承了DefaultSqlInjector(默认注入器),调用了DefaultSqlInjector的getMethodList方法,保留了mybatis-plus的自带方法
List<AbstractMethod> methodList = super.getMethodList(mapperClass, tableInfo);
methodList.add(new InsertBatchSomeColumn(i -> i.getFieldFill() != FieldFill.UPDATE));
return methodList;
}
}
7.3)定义MyBatisPlusConfig类,用于注册分页插件及其批量插入方法
package com.example.detail_data_tool.tj.sqllite.config;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
@MapperScan("com.example.detail_data_tool.**.mapper")
public class MyBatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.SQLITE));
return interceptor;
}
//插件,用于批量插入真正的
@Bean
public EasySqlInjector easySqlInjector() {
return new EasySqlInjector();
}
}
至此完成 剩余的就是写业务代码了,和mp原生一致,记得在Mapper中 原始是集成BaseMapper换成BasePlusMapper就可以实现真的批量插入了 对应的方法如下:
baseMapper.insertBatchSomeColumn(list);
8、关于SQLLite的语法
基本和mysql类似 有几处不一样
8.1)关于字符串拼接,用||
SELECT 'Hello' || ' ' || 'World';
-- 结果:Hello World
8.2)获取时间的函数
用 datetime(‘now’), date(‘now’) 即可
372



被折叠的 条评论
为什么被折叠?



