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 需要导入的驱动包