SpringBooot连接本地sqlite数据库

1. pom.xml添加依赖

    <!-- sqlite -->
    <dependency>
        <groupId>org.xerial</groupId>
        <artifactId>sqlite-jdbc</artifactId>
        <version>3.21.0.1</version>
    </dependency>
   

2. .properties添加配置

    spring.datasource.driver-class-name=org.sqlite.JDBC
    ​spring.datasource.url=jdbc:sqlite:C:/Users/catface/Desktop/user.db
   

3. 编写代码

   // pojo
   public class User {
       private String username;
       private String password;
   	// setter&getter...
   }
   

   ---

   // Dao
   @Repository
   @Mapper
   public interface LoginDao {
       List<User> getUsers();
   }
   

   ---

   // mapper
   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
   <mapper namespace="cc.catface.sbt_test.multi_sql_source.login.dao.LoginDao">
       <select id="getUsers" resultType="cc.catface.sbt_test.multi_sql_source.pojo.User">
           select username,password from user;
       </select>
   </mapper>
   

   ---

   // service
   @Service
   public class LoginService {
   
       @Autowired
       LoginDao loginDao;
   
       public List<User> getUsers() {
           return loginDao.getUsers();
       }
   }
   

   ---

   // controller
   @Controller
   public class LoginController {
       
       @Autowired
       LoginService loginService;
       
       @ResponseBody
       @RequestMapping("/getUsers")
       public String getUsers() {
           return loginService.getUsers().toString();
       }
   }
   

4. 访问链接http://localhost:8080/getUsers查看数据结果