Java基础 — JDBC
首先得下载个驱动:
https://bitbucket.org/xerial/sqlite-jdbc/downloads/sqlite-jdbc-3.8.11.2.jar
保存到本地:比如/Users/robert/software/sqlite-jdbc-3.8.11.2.jar
具体API翻文档。直接上例子。
public class TestDb {
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
try {
Class.forName("org.sqlite.JDBC"); // 注册driver
connection = DriverManager.getConnection("jdbc:sqlite:test.db");
// System.out.println("maxConn: " + connection.getMetaData().getMaxConnections());
doInsert(connection);
doQuery(connection);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public static void doInsert(Connection connection) throws SQLException {
Statement statement = connection.createStatement();
try {
String sqlString = "CREATE TABLE db2 (age INT PRIMARY KEY)";
statement.executeUpdate(sqlString);
statement.executeUpdate("INSERT INTO db2 VALUES (3), (4), (10)");
connection.setAutoCommit(true);
statement.close();
} finally {
statement.close();
}
}
public static void doQuery(Connection connection) throws SQLException {
Statement statement = connection.createStatement();
try {
String queryString = "SELECT * FROM db2";
ResultSet resultSet = statement.executeQuery(queryString);
while (resultSet.next()) {
int age = resultSet.getInt(1);
System.out.println("" + age);
}
} finally {
statement.close();
}
}
}
编译:javac TestDb.java
运行:java -cp ".:/Users/robert/software/sqlite-jdbc-3.8.11.2.jar" TestDb