Mybatis框架，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', '李四');

Mybatis框架？配置

spring:datasource: # 配置數據路連接驅動driver-class-name: org.sqlite.JDBCjdbc-url: jdbc:sqlite:F:/test1.db
#    jdbc-url: jdbc:sqlite::resource:static/test1.db