springboot mybatis sqlite3

创建数据库

sqlite3 test1.db

创建表并添加数据

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
 
INSERT INTO `user` VALUES ('1', 'zhangsan', '123', '张三');
INSERT INTO `user` VALUES ('2', 'lisi', '123', '李四');

配置

spring:
  datasource: # 配置数据路连接驱动
    driver-class-name: org.sqlite.JDBC
    jdbc-url: jdbc:sqlite:F:/test1.db
#    jdbc-url: jdbc:sqlite::resource:static/test1.db