论坛 › SQLite › java: SQLite使用实例

mahonglin123456 发表于 2016-11-29 09:44:38

java: SQLite使用实例

　　开发环境：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
　　//创建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

查看完整版本: java: SQLite使用实例