예제 #1
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);
  }
예제 #2
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;
   }
 }
예제 #3
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);
  }
예제 #4
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;
    }
  }
예제 #5
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);
  }