java 使用jdbc連線sqlite

1、因為SQLite官方並沒有JDBC的Driver,所以先到 https://bitbucket.org/xerial/sqlite-jdbc下載

2、將下載的sqlite-jdbc-3.7.2.jar,放到Java的classpath內,並在classpath內加入jar
      如:set classpath=d:\java_test ; d:\java_test\sqlite-jdbc-3.7.2.jar

3、範例的程式碼如下:
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

//執行程式前,要先設定正確的CLASSPATH,
//如在Windows: set CLASSPATH=d:\java_test ; d:\java_test\sqlite-jdbc-3.7.2.jar

public class test020 {
  public static void main(String[] args) throws ClassNotFoundException {
    Class.forName("org.sqlite.JDBC"); // 建立database的連線
    Connection connection = null;
  
try{
      connection = DriverManager.getConnection("jdbc:sqlite:d:\\java_test\\sample.db"); //要加上跳脫字元「\」
      Statement statement = connection.createStatement();
      statement.setQueryTimeout(30);  //set timeout to 30 sec.
 statement.executeUpdate("drop table test01");
      statement.executeUpdate("create table test01 (id integer, name string)");
 statement.executeUpdate("insert into test01 values (1,'張三')");
 statement.executeUpdate("insert into test01 values (2,'李四')");
 
 ResultSet rs = statement.executeQuery("select * from test01");
      while(rs.next()) //逐筆讀取ResultSet的資料
      {
        System.out.println("姓名 = " + rs.getString("name"));
        System.out.println("編號 = " + rs.getInt("id"));
      }
 
    }
    catch (SQLException e) {
      System.err.println(e.getMessage());
    }
finally
    {
      try
      {
        if(connection != null)
          connection.close();
      }
      catch(SQLException e)
      {
        System.err.println(e); //connection close failed.
      }
    }
  }
  
}