java 调用 sqlite 数据库

package com.uso6.www; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; /** * Sqlite 例子 * @author aaa539687357@vip.qq.com * */ public class SqliteTest { public static void main(String[] args) throws ClassNotFoundException { // 使用这个类加载 sqlite-JDBC Class.forName("org.sqlite.JDBC"); Connection connection = null; try { // 创建一个数据库连接 connection = DriverManager.getConnection("jdbc:sqlite:simple.db"); Statement statement = connection.createStatement(); // 设置 30 秒超时 statement.setQueryTimeout(30); statement.executeUpdate("drop table if exists person"); statement.executeUpdate("create table person (id integer, name string)"); statement.executeUpdate("insert into person values(1, 'leo')"); statement.executeUpdate("insert into person values(2, 'yui')"); ResultSet rs = statement.executeQuery("select * from person"); while(rs.next()) { // 读取结果集 System.out.println("name = " + rs.getString("name")); System.out.println("id = " + rs.getInt("id")); } } catch (SQLException e) { // 如果错误信息是 "out of memory", // 大概是找不到数据库文件 System.err.println(e.getMessage()); } finally { try { if(connection != null) connection.close(); } catch(SQLException e) { // 连接关闭失败 System.err.println(e); } } } }