SQLite - Java
Java 通过 sqlite-jdbc 驱动访问：Class.forName 注册、DriverManager.getConnection 建连、PreparedStatement 绑定参数。
Key PointsSQLite,Java,sqlite-jdbc,JDBC,PreparedStatement
讲解
Java 通过 sqlite-jdbc 驱动访问：Class.forName 注册、DriverManager.getConnection 建连、PreparedStatement 绑定参数。
示例
Java
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
PreparedStatement ps = conn.prepareStatement(
"SELECT name FROM company WHERE id = ?");
ps.setInt(1, 1);
ResultSet rs = ps.executeQuery();Output
-- Maven 依赖 org.xerial:sqlite-jdbc
-- 查询结果从 ResultSet 逐行读取讲解
Java 通过 sqlite-jdbc 驱动访问：Class.forName 注册、DriverManager.getConnection 建连、PreparedStatement 绑定参数。
示例
Java
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
PreparedStatement ps = conn.prepareStatement(
"SELECT name FROM company WHERE id = ?");
ps.setInt(1, 1);
ResultSet rs = ps.executeQuery();Output
-- Maven 依赖 org.xerial:sqlite-jdbc
-- 查询结果从 ResultSet 逐行读取