java操作sqlite

来源：互联网发布：红色警戒3起义时刻mac 编辑：程序博客网时间：2024/06/06 08:33

1、下载sqlite的驱动

<!-- sqlite -->    <dependency><groupId>org.xerial</groupId><artifactId>sqlite-jdbc</artifactId><version>3.8.11.2</version></dependency>

2、sqlite的工具类

/** *  */package core.sqlite;import java.sql.Connection;import java.sql.DriverManager;/** * Sqllite数据源 */public class SqlliteDataSource {private Connection conn;private String dbFile;/** *  */public SqlliteDataSource() {}/** * 打开数据源连接 * @throws Exception */protected synchronized void open() throws Exception{if (this.dbFile == null){throw new IllegalArgumentException("dbFile cannot be null, please set it.");}Class.forName("org.sqlite.JDBC");    this.conn =    DriverManager.getConnection("jdbc:sqlite:" + dbFile);}/** * 关闭数据源连接 * @throws Exception */protected synchronized void close() throws Exception{if (this.conn != null){this.conn.close();this.conn = null;}}/** * 判断是否已连接数据库 * @return  */public synchronized boolean isConnected(){return this.conn != null;}/** * 数据库文件 * @return */public String getDbFile() {return dbFile;}/** * 设置数据库文件 * @param dbFile */public void setDbFile(String dbFile) {this.dbFile = dbFile;}/** * 获取数据库连接 * @return */protected Connection getConnection(){return this.conn;}}

3、例子

package core.sqlite;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import java.util.Date;public class SqliteTest {public static void main(String[] args) {// TODO Auto-generated method stubString dbFile = "E:\\其他\\mysqlite.db";SqlliteDataSource sqllite = new SqlliteDataSource();sqllite.setDbFile(dbFile);try {Date date1= new Date();sqllite.open();Connection conn = sqllite.getConnection();String sql = "insert into TABLE_TEST (NAME) values('张三');";StringBuilder sb = new StringBuilder();for(int i=0;i<100;i++){//sqllite_state.execute("insert into TABLE_TEST (NAME) values('张三');");sb.append(sql);System.out.println(i+":"+sql);}Statement sqllite_state = conn.createStatement();//sqllite_state.execute();//只用于查询语句，返回集合的，用于insert、update、delete是错误的sqllite_state.executeUpdate(sb.toString());//只用于insert、update、delete，不能用于selectsqllite.close();Date date2= new Date();System.out.println("执行完毕,用时:"+(date2.getTime()-date1.getTime())/1000);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

阅读全文

0 0