SQLite JDBC Driver
// load the sqlite-JDBC driver using the current class loader Class.forName("org.sqlite.JDBC"); NOTICE: sqlite-jdbc has moved to GitHub:https://github.com/xerial/sqlite-jdbc SQLite JDBC DriverSQLite JDBC,developed byTaro L. Saito,is a library for accessing and creatingSQLitedatabase files in Java. Our SQLiteJDBC library requires no configuration since native libraries for major OSs,including Windows,Mac OS X,Linux etc.,are assembled into a single JAR (Java Archive) file. The usage is quite simple;downloadour sqlite-jdbc library,then append the library (JAR file) to your class path. Seethe sample code.
UsageSQLite JDBC is a library for accessing SQLite databases through the JDBC API. For the general usage of JDBC,seeJDBC TutorialorOracle JDBC Documentation.
> javac Sample.java > java -classpath ".;sqlite-jdbc-(VERSION).jar" Sample # in Windows or > java -classpath ".:sqlite-jdbc-(VERSION).jar" Sample # in Mac or Linux name = leo id = 1 name = yui id = 2 Sample.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Sample { static void main(String[] args) { Connection connection = null; try { // create a database connection connection = DriverManager.getConnection("jdbc:sqlite:sample.db"); Statement statement = connection.createStatement(); statement.setQueryTimeout(30); // set timeout to 30 sec. statement.executeUpdate("drop table if exists person"); statement"create table person (id integer,name string)"); statement"insert into person values(1,'leo')"); statement"insert into person values(2,'yui')"); ResultSet rs = statement.executeQuery("select * from person"); while(rs.next()) { // read the result set System.out.println("name = " + rs.getString("name")); System"id = " .getInt("id")); } } catch(SQLException e) { // if the error message is "out of memory", // it probably means no database file is found System.err.println(e.getMessage()); } finally { try { if(connection != null) connection.close(); } catch(SQLException e) { // connection close failed. System.println(e); } } } } How to Specify Database Files Here is an example to select a file Connection connection = DriverManager.getConnection("jdbc:sqlite:C:/work/mydatabase.db"); A UNIX (Linux,etc) file Connection connection = DriverManager.getConnection("jdbc:sqlite:/home/leo/work/mydatabase.db"); How to Use Memory DatabasesSQLite supports on-memory database management,which does not create any database files. To use a memory database in your Java code,get the database connection as follows: Connection connection = DriverManager.getConnection("jdbc:sqlite::memory:"); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |