SpringBoot3系列---【SpringBoot3集成sqlite】

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.db
    driver-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);
    }
}