SQLite JDBC Driver
来源:互联网 发布:大数据架构师 技术题 编辑:程序博客网 时间:2024/06/10 06:01
// 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 Driver
SQLite JDBC, developed by Taro L. Saito, is a library for accessing and creating SQLite database 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; download our sqlite-jdbc library, then append the library (JAR file) to your class path.
See the sample code.
Usage
SQLite JDBC is a library for accessing SQLite databases through the JDBC API. For the general usage of JDBC, see JDBC Tutorial or Oracle JDBC Documentation.
- Download sqlite-jdbc-(VERSION).jar from the download page (or by using Maven) then append this jar file into your classpath.
Load the JDBC driver
org.sqlite.JDBC
from your code. (see the example below)
- More usage examples are available at Usage
- Usage Example (Assuming
sqlite-jdbc-(VERSION).jar
is placed in the current directory)
> javac Sample.java> java -classpath ".;sqlite-jdbc-(VERSION).jar" Sample # in Windowsor > java -classpath ".:sqlite-jdbc-(VERSION).jar" Sample # in Mac or Linuxname = leoid = 1name = yuiid = 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 { public 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.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()) { // read the result set System.out.println("name = " + rs.getString("name")); System.out.println("id = " + rs.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.err.println(e); } } } }
How to Specify Database Files
Here is an example to select a file C:\work\mydatabase.db
(in Windows)
Connection connection = DriverManager.getConnection("jdbc:sqlite:C:/work/mydatabase.db");
A UNIX (Linux, Mac OS X, etc) file /home/leo/work/mydatabase.db
Connection connection = DriverManager.getConnection("jdbc:sqlite:/home/leo/work/mydatabase.db");
How to Use Memory Databases
SQLite 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:");
- SQLite JDBC Driver
- jdbc of sqlite getClob()-- java.sql.SQLException: not implemented by SQLite JDBC driver
- JDBC Driver
- JDBC DRIVER
- jdbc&sqlite
- JDBC - Driver Types(JDBC - Driver图解)
- SQLite Xerial Driver
- java jdbc driver
- JDBC Driver写法!
- jdbc driver 的作用
- InterBase JDBC Driver
- MySQL JDBC Driver
- JDBC Driver Connection URL
- JDBC driver connection url
- JDBC-ODBC Driver应用
- SQL Server JDBC driver
- Excel Jdbc Driver 文档
- sqlserver 2005 jdbc driver
- Qt 自定义 滚动条 样式
- ubuntu server 安装 oracle java8
- andriod—Application
- 100Same Tree
- linux下c语言编程-helloworld
- SQLite JDBC Driver
- 中国电信欢go建立话费话费异常预警(国际)
- Android Volley完全解析(三),定制自己的Request
- MySQL____将查询结果插入到表中
- JS实现复制到剪贴板
- SQL2008定时备份数据库
- Linux下的五种I/O模型
- 【effective c++读书笔记】【第7章】模板和泛型编程(3)
- 命名管道(FIFO)