java: SQLite使用实例，javasqlite使用实例
开发环境：JDK1.6.15+Eclipse4.2
jar包下载：sqlitejdbc.jar + sqlitejdbc.dll
将sqlitejdbc.jar添加到build path, 将sqlitejdbc.dll放到JDk bin目录下。
示例代码：
//连接SqlLiteDB
Class.forName("org.sqlite.JDBC");
Connection connection = DriverManager.getConnection("jdbc:sqlite:"+System.getProperty("user.dir")+"\\db\\server.db");
connection.setAutoCommit(false);
//删除table
drop table if exists [tablename]
//创建table
String command = "create table task (taskid integer primary key autoincrement," + //主键自增长
"parentid integer default 0," +
"batfile varchar(200)," +
"battxt varchar(2000)," +
"iswrite integer default 0," +
"timegap integer default 0," +
"status varchar(30)," +
"taskname varchar(50));";
Statement stament = connection.createStatement();
stament.executeUpdate(command);
connection.commit();
//管理SqlLite的工具，附件(sql Lite管理工具)：sqliteadmin 和 SQLiteSpy
- Sqlite管理工具.rar (2.4 MB)
- 下载次数: 8
- sqlitejdbc.jar (15.7 KB)
- 下载次数: 7
- sqlitejdbcdll.zip (133 KB)
- 下载次数: 5