Esempio n. 1
0
  public static void main(String[] args) {
    try {
      CreateTable createTable = new CreateTable();
      boolean criou = createTable.createPessoa();

      if (criou) {
        System.out.println("Tabela pessoa criada com sucesso");
      }

      System.out.println("Sistema iniciado");
    } catch (ClassNotFoundException e) {
      e.printStackTrace();
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
Esempio n. 2
0
  /**
   * 删除表数据和删除但条数据
   *
   * @param context
   * @param db
   * @param Table_Name
   * @param whereclause
   * @param whereargs
   */
  protected int delete(
      Context context, String db, String Table_Name, String whereclause, String[] whereargs) {
    databaseHelper = CreateTable.getInstance(context, db);
    sqLiteDatabase = databaseHelper.getWritableDatabase();

    return sqLiteDatabase.delete(Table_Name, whereclause, whereargs);
  }
Esempio n. 3
0
 /**
  * 查询去重数据库
  *
  * @param context
  * @param db
  * @param Table_Name
  * @param colums 获取数据的列名称
  * @param selection where后面的内容
  * @param selectionArgs where后面内容的参数
  * @param groupBy GROUP BY后面的字符串
  * @param having HAVING后面的字符串
  * @param orderBy ORDER BY后面的字符串
  * @param limit 返回的数量
  * @param distinct 是否去重
  * @return
  */
 protected Cursor distinctQuery(
     Context context,
     String db,
     String Table_Name,
     String[] colums,
     String selection,
     String[] selectionArgs,
     String groupBy,
     String having,
     String orderBy,
     String limit,
     boolean distinct,
     String distinctType) {
   databaseHelper = CreateTable.getInstance(context, db);
   sqLiteDatabase = databaseHelper.getReadableDatabase();
   try {
     if (distinct) {
       String content = "";
       if (colums != null) {
         for (int i = 0; i < colums.length; i++) {
           content += "," + colums[i];
         }
       }
       String sql = "select distinct(" + distinctType + ")" + content + " from " + Table_Name;
       return sqLiteDatabase.rawQuery(sql, new String[] {});
     } else {
       return sqLiteDatabase.query(
           Table_Name, colums, selection, selectionArgs, groupBy, having, orderBy, limit);
     }
   } catch (Exception e) {
     return null;
   }
 }
Esempio n. 4
0
  /**
   * 更新数据库数据
   *
   * @param context
   * @param db
   * @param table
   * @param contentValues
   * @param whereclause
   * @param whereargs
   */
  protected int update(
      Context context,
      String db,
      String table,
      ContentValues contentValues,
      String whereclause,
      String[] whereargs) {
    databaseHelper = CreateTable.getInstance(context, db);
    sqLiteDatabase = databaseHelper.getWritableDatabase();

    return sqLiteDatabase.update(table, contentValues, whereclause, whereargs);
  }
Esempio n. 5
0
  /**
   * 查询数据库
   *
   * @param context
   * @param db
   * @param Table_Name
   * @param colums 获取数据的列名称
   * @param selection where后面的内容
   * @param selectionArgs where后面内容的参数
   * @param groupBy GROUP BY后面的字符串
   * @param having HAVING后面的字符串
   * @param orderBy ORDER BY后面的字符串
   * @param limit 返回的数量
   * @return
   */
  protected Cursor query(
      Context context,
      String db,
      String Table_Name,
      String[] colums,
      String selection,
      String[] selectionArgs,
      String groupBy,
      String having,
      String orderBy,
      String limit) {
    databaseHelper = CreateTable.getInstance(context, db);
    sqLiteDatabase = databaseHelper.getReadableDatabase();

    try {
      return sqLiteDatabase.query(
          Table_Name, colums, selection, selectionArgs, groupBy, having, orderBy, limit);
    } catch (Exception e) {
      return null;
    }
  }
Esempio n. 6
0
  /**
   * 添加数据库数据
   *
   * @param context
   * @param db
   * @param table
   * @param contentValues
   */
  protected long insert(Context context, String db, String table, ContentValues contentValues) {
    databaseHelper = CreateTable.getInstance(context, db);
    sqLiteDatabase = databaseHelper.getWritableDatabase();

    return sqLiteDatabase.insert(table, null, contentValues);
  }