新建IDEA springboot 项目

最新推荐文章于 2025-07-04 10:31:00 发布

kakaaaa!

最新推荐文章于 2025-07-04 10:31:00 发布

阅读量340

点赞数

CC 4.0 BY-SA版权

分类专栏： web

本文链接：https://blog.youkuaiyun.com/vily_luky/article/details/82493900

web 专栏收录该内容

50 篇文章

订阅专栏

本文详细介绍如何在Spring Boot项目中集成SQLite数据库，包括pom.xml依赖配置、application.properties配置、自定义配置类SQliteConfig及简单RESTful API示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1：

2：

3：

4：结构图

5：pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.vily</groupId>
    <artifactId>demo6</artifactId>
    <version>1.0-SNAPSHOT</version>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.4.RELEASE</version>
        <relativePath/>

    </parent>
    <dependencies>

        <!-- MYSQL -->
        <!--<dependency>-->
            <!--<groupId>com.mchange</groupId>-->
            <!--<artifactId>c3p0</artifactId>-->
            <!--<version>0.9.5.2</version>-->
        <!--</dependency>-->
        <!--<dependency>-->
            <!--<groupId>mysql</groupId>-->
            <!--<artifactId>mysql-connector-java</artifactId>-->
        <!--</dependency>-->
        <!-- Spring Boot JDBC -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <dependency>
            <groupId>com.google.code.gson</groupId>
            <artifactId>gson</artifactId>
            <version>2.8.5</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- 连接sqlite数据库 -->
        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
            <version>3.23.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.5.0</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

6: application.properties

server.port=8085
spring.datasource.url=jdbc:sqlite:D:\\database\\vily0704.db3
spring.datasource.username=vily
spring.datasource.password=jhakujhaku
spring.datasource.driver-class-name=org.sqlite.JDBC

mybatis.typeAliasesPackage=org.spring.springboot.domain
mybatis.mapperLocations=classpath:mapper/*.xml

7: 设置数据库连接池 config---SQliteConfig

package com.vily.config;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

/**
 * description :
 * Author : Vily
 * Date : 2018/09/07
 * Time : 10:05
 */
@Configuration
public class SQliteConfig {
    @Bean(name = "sqliteDataSource")
    @Qualifier(value = "sqliteDataSource")  //spring装配bean的唯一标识
    @ConfigurationProperties(prefix = "sqlite.spring.datasource")   //application.properties配置文件中该数据源的配置前缀
    public DataSource sqliteDataSource(){
        return DataSourceBuilder.create().build();
    }

}

8: test ----TestController

@RestController
public class TestController {


    @GetMapping("/hehe")
    public String Test() {

        return "今天 你喝酒了吗？";
    }


}

9：postman测试：

10：新建webapp 目录