SpringBoot3集成sqlite
1.引入pom.xml
<dependencies><dependency><groupId>org.xerial</groupId><artifactId>sqlite-jdbc</artifactId><version>3.34.0</version></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>1.2.23</version></dependency><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-spring-boot3-starter</artifactId><version>3.5.10.1</version></dependency></dependencies>
2.新建sqlite數據庫(推薦選工程根目錄建一個sqlite.db,可以使用dbever建)
3.配置配置文件yml
spring:datasource:url: jdbc:sqlite:C:\Users\Administrator\Desktop\project\自研框架\spring-ai-study\spring-ai-sqlite\src\main\resources\sqlite.dbdriver-class-name: org.sqlite.JDBC
mybatis-plus:configuration:log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
4.創建user表和user實體類
@TableName("user")
@Data
public class User {private Integer id;private String username;private Integer age;
}
5.創建mapper
import com.ai.fast.pojo.entity.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;public interface UserMapper extends BaseMapper<User> {
}
6.創建userController
@RestController
@RequiredArgsConstructor
@RequestMapping("/user")
public class UserController {private final UserMapper userMapper;@GetMapping("/insert")public User insert() {User user = new User();user.setUsername("張三");user.setAge(18);userMapper.insert(user);return user;}@GetMapping("/list")public List<User> list() {return userMapper.selectList(Wrappers.emptyWrapper());}
}
7.啟動類上添加mapperscan注解
@MapperScan("com.ai.fast.mapper")
@SpringBootApplication
public class Application {public static void main(String[] args) {SpringApplication.run(Application.class,args);}
}
