首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

java: SQLite应用实例

2013-01-17 
java: SQLite使用实例开发环境:JDK1.6.15+Eclipse4.2jar包下载:sqlitejdbc.jar + sqlitejdbc.dll将sqlitej

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 [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

热点排行