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