在bdb中使用SQLite

首发地址：http://inmethetiger.iteye.com/blog/1680669

在bdb中的原生态包中并不包含对SQLite的支持。但是提供了一个jdbc.jar包，这个包能像访问SQLite数据库一样使用bdb的数据库

SQLite连接数据库的方法

需要sqlite-jdbc.jar包

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class SQLiteT {public static void main(String[] args) throws SQLException,ClassNotFoundException {Class.forName("org.sqlite.JDBC");Connection conn = DriverManager.getConnection("jdbc:sqlite:geoportal.db","root","root");Statement stat = conn.createStatement();stat.executeUpdate("create table tbl1(name varchar(20), salary int);");// 创建一个表，两列stat.executeUpdate("insert into tbl1 values('ZhangSan',8000);");// 插入数据stat.executeUpdate("insert into tbl1 values('LiSi',7800);");stat.executeUpdate("insert into tbl1 values('WangWu',5800);");stat.executeUpdate("insert into tbl1 values('ZhaoLiu',9100);");ResultSet rs = stat.executeQuery("select * from tbl1;");// 查询数据while (rs.next()) {// 将查询到的数据打印出来System.out.print("name = " + rs.getString("name") + " ");// 列属性一System.out.println("salary = " + rs.getString("salary"));// 列属性二}}}

?

?使用bdb原生态api创建数据库的方法：

需要db.jar

?

 DatabaseConfig dbConfig = new DatabaseConfig();        dbConfig.setTransactional(true);        if (create) {            dbConfig.setAllowCreate(true);            dbConfig.setType(DatabaseType.BTREE);        }        // catalog is needed for serial bindings (java serialization)        Database catalogDb = env.openDatabase(null, "catalog", null, dbConfig);        catalog = new StoredClassCatalog(catalogDb);        // use Integer tuple binding for key entries        TupleBinding keyBinding =            TupleBinding.getPrimitiveBinding(Integer.class);        // use String serial binding for data entries        SerialBinding dataBinding = new SerialBinding(catalog, String.class);        this.db = env.openDatabase(null, "helloworld", null, dbConfig);        // create a map view of the database        this.map = new StoredSortedMap(db, keyBinding, dataBinding, true);

?

?

在bdb中使用SQLite的方法

需要bdb中下载的jar包中的jdbc.jar

?

package db.sqllitedb;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class BDB_SQLlite {public static void main(String[] args) {Connection conn = null;SQLite.Database db = null;try {Class.forName("SQLite.JDBCDriver").newInstance();conn = DriverManager.getConnection("jdbc:sqlite:/blabla.db");java.lang.reflect.Method m = conn.getClass().getMethod("getSQLiteDatabase", null);db = (SQLite.Database) m.invoke(conn, null);System.out.println(db.version());Statement stat = conn.createStatement();stat.executeUpdate("create table tbl1(name varchar(20), salary int);");// 创建一个表，两列stat.executeUpdate("insert into tbl1 values('ZhangSan',8000);");// 插入数据stat.executeUpdate("insert into tbl1 values('LiSi',7800);");stat.executeUpdate("insert into tbl1 values('WangWu',5800);");stat.executeUpdate("insert into tbl1 values('ZhaoLiu',9100);");ResultSet rs = stat.executeQuery("select * from tbl1;");// 查询数据while (rs.next()) {// 将查询到的数据打印出来System.out.print("name = " + rs.getString("name") + " ");// 列属性一System.out.println("salary = " + rs.getString("salary"));// 列属性二}} catch (Exception e) {e.printStackTrace();}}}

?

其中访问SQLite的方法类似。最重要的是驱动包的加载方式。