详解Java使用sqlite 数据库如何生成db文件

java 使用sqllite 数据库如何生成db文件

           本文主要介绍java 使用sqllite 数据库如何生成db文件的实现实例，网上资料不是很多，自己上网搜资料看到的一个实例，希望可以帮助到读者

实现代码：

import java.sql.connection; 
import java.sql.preparedstatement; 
import java.sql.resultset; 
 
import javax.sql.datasource; 
 
import org.apache.commons.dbcp2.basicdatasource; 
import org.springframework.jdbc.datasource.datasourceutils; 
 
public class main { 
 
  public static void update(string sql) { 
    datasource data = getdatasource(); 
    connection conn = null; 
    try { 
      conn = data.getconnection(); 
      preparedstatement ps = conn.preparestatement(sql); 
      ps.executeupdate(); 
    } catch (exception e) { 
      throw new runtimeexception(e.getmessage()); 
    } finally { 
      try { 
        datasourceutils.docloseconnection(conn, datasource); 
      } catch (exception e) { 
      } 
    } 
  } 
 
  protected static basicdatasource datasource = null; 
 
  public static datasource getdatasource() { 
    synchronized (thread.class) { 
      if (null == datasource) { 
        datasource = new basicdatasource(); 
        datasource.seturl("jdbc:sqlite:hp.db"); 
        datasource.setdriverclassname("org.sqlite.jdbc"); 
      } 
    } 
    return datasource; 
  } 
 
  public static void main(string[] args) throws exception { 
    update("drop table if exists company"); 
    update("create table company (id int,cname varchar(40))"); 
 
    for (int x = 0; x < 300; x++) { 
      update("insert into company(id , cname) values(" + x + " ,'xx" + x + "')"); 
    } 
 
    preparedstatement ps = getdatasource().getconnection().preparestatement("select * from company"); 
    resultset rs = ps.executequery(); 
    while (rs.next()) { 
      system.out.println(rs.getstring("id") + "--" + rs.getstring("cname")); 
    } 
  } 
} 

感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！