jdbc 对sqlite的基本操作

1.向数据库中创建表

public void addTable( String dbpath)
  {

//创建表单的sql语句
  
  String createtablesql= " CREATE TABLE T_AFAF_AREA(PID TEXT,STDNAME TEXT) ";
  //这里的TEXT 类型根据需要改变
    try{
        Class.forName("org.sqlite.JDBC");
        Connection conn = DriverManager.getConnection("jdbc:sqlite:"+dbpath);   
        Statement stmt = conn.createStatement();
        //巡检表
  stmt.executeUpdate(createtablesql);
  }catch(Exception e)
    {
      e.printStackTrace();
    }
  }

2.从 .db 文件中删除表

这里只贴出来语句其他都一样

//判断巡检表是否存在 存在 则删除
      String deletetablesql = " drop table  if exists T_EXAMINEDATA  ";

3 . 从 .db 文件中读取信息

public List <TStreetsExamine> queryTStreetsExamine(String dbpath)
  {
    List <TStreetsExamine> list = new ArrayList<TStreetsExamine>();
    try{
        Class.forName("org.sqlite.JDBC");
        Connection conn = DriverManager.getConnection("jdbc:sqlite:"+dbpath);   
      Statement stmt = conn.createStatement();
      ResultSet res = stmt.executeQuery(" select * from T_STREETS_SURVEY    ");
      while(res.next())
      {
        //公共部分
        String pid =	res.getString("PID");
  //......................................这里省略n行					 list.add(te);
      }
      res.close();
      stmt.close();
      res.close();
    }
    catch(Exception e)
    { 
      e.printStackTrace();
    }
    
    return list;
    
  }

4.向.db文件中写入数据

public void addStreets(TStreets te ,String dbpath)
  {
    try{

        Class.forName("org.sqlite.JDBC");
        Connection conn = DriverManager.getConnection("jdbc:sqlite:"+"E://toponymsurvey11122.db");   
       Statement stmt = conn.createStatement();
       PreparedStatement pstmt = null ;	// 数据库操作
              String sql = " INSERT INTO T_STREETS(PID ,STDENAME) VALUES (?,?)  " ;
  pstmt = conn.prepareStatement(sql) ;
                   pstmt.setString(1,te.getPid()) ;
       pstmt.setString(2,te.getStdname()) ;
             pstmt.executeUpdate() ;	// 执行更新
       pstmt.close() ;
       stmt.close();
       conn.close();
    }catch(Exception e)
    {
      e.printStackTrace();
      
    }
  }

5 需要导入的驱动包

• 本文来自：Linux学习网