在Java中使用jdbc访问sqlite数据库还是方便的。
1. 在build.gradle中指定sqlite的jdbc的依赖
dependencies {
// Use JUnit Jupiter for testing.
testImplementation libs.junit.jupiter
testRuntimeOnly 'org.junit.platform:junit-platform-launcher'
// This dependency is used by the application.
implementation libs.guava
implementation 'org.xerial:sqlite-jdbc:3.46.1.0'
}
sqlite的jdbc的version可以在https://github.com/xerial/sqlite-jdbc/releases找到最新的version.
2.编写一个jdbc的demo 程序
package com.example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class App {
public static void main(String[] args) {
String url = "jdbc:sqlite:sample.db";
try (Connection conn = DriverManager.getConnection(url)) {
if (conn != null) {
Statement stmt = conn.createStatement();
String sql = "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT NOT NULL)";
stmt.execute(sql);
sql = "INSERT INTO users(name) VALUES('Alice')";
stmt.execute(sql);
ResultSet rs = stmt.executeQuery("SELECT * FROM users");
while (rs.next()) {
System.out.println("ID: " + rs.getInt("id") + ", Name: " + rs.getString("name"));
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
3.用Gradle的debug运行程序,会在app目录下创建一个sample.db.并建立好新的表users.
4.在vscode 查看sqlite数据库内容,安装sqlite插件,试了几个sqlite插件,这个还是比较好用一些,它不仅仅可以view sqlite,也可以执行sql语言
5.Ctrl+Shit+P 中sqlite:open db选择刚刚生成的sample.db就可以查看对应的数据库的内容了。