/**
* 取得数据库的表信息
*
* @return
*/
public ArrayList<DBMasterEntity> getTables() {
ArrayList<DBMasterEntity> tadbMasterArrayList = new ArrayList<DBMasterEntity>();
String sql = "select * from sqlite_master where type='table' order by name";
CHLogger.i(SQLiteDB.this, sql);
if (testSQLiteDatabase()) {
if (sql != null && !sql.equalsIgnoreCase("")) {
this.queryStr = sql;
free();
queryCursor =
mSQLiteDatabase.rawQuery(
"select * from sqlite_master where type='table' order by name", null);
if (queryCursor != null) {
while (queryCursor.moveToNext()) {
if (queryCursor != null && queryCursor.getColumnCount() > 0) {
DBMasterEntity tadbMasterEntity = new DBMasterEntity();
tadbMasterEntity.setType(queryCursor.getString(0));
tadbMasterEntity.setName(queryCursor.getString(1));
tadbMasterEntity.setTbl_name(queryCursor.getString(2));
tadbMasterEntity.setRootpage(queryCursor.getInt(3));
tadbMasterEntity.setSql(queryCursor.getString(4));
tadbMasterArrayList.add(tadbMasterEntity);
}
}
} else {
CHLogger.e(SQLiteDB.this, "数据库未打开！");
}
}
} else {
CHLogger.e(SQLiteDB.this, "数据库未打开！");
}
return tadbMasterArrayList;
}
/**
* INSERT, UPDATE 以及DELETE
*
* @param sql 语句
* @param bindArgs
* @throws CHDBNotOpenException
*/
public void execute(String sql, String[] bindArgs) throws CHDBNotOpenException {
CHLogger.i(SQLiteDB.this, "准备执行SQL[" + sql + "]语句");
if (testSQLiteDatabase()) {
if (sql != null && !sql.equalsIgnoreCase("")) {
this.queryStr = sql;
if (bindArgs != null) {
mSQLiteDatabase.execSQL(sql, bindArgs);
} else {
mSQLiteDatabase.execSQL(sql);
}
}
} else {
throw new CHDBNotOpenException("数据库未打开！");
}
}
/**
* 执行查询，主要是SELECT, SHOW 等指令 返回数据集
*
* @param sql sql语句
* @param selectionArgs
* @return
*/
public ArrayList<CHHashMap<String>> query(String sql, String[] selectionArgs) {
CHLogger.i(SQLiteDB.this, sql);
if (testSQLiteDatabase()) {
if (sql != null && !sql.equalsIgnoreCase("")) {
this.queryStr = sql;
}
free();
this.queryCursor = mSQLiteDatabase.rawQuery(sql, selectionArgs);
if (queryCursor != null) {
return getQueryCursorData();
} else {
CHLogger.e(SQLiteDB.this, "执行" + sql + "错误");
}
} else {
CHLogger.e(SQLiteDB.this, "数据库未打开！");
}
return null;
}
/**
* 执行查询，主要是SELECT, SHOW 等指令 返回数据集
*
* @param clazz
* @param distinct 限制重复，如过为true则限制,false则不用管
* @param where where语句
* @param groupBy groupBy语句
* @param having having语句
* @param orderBy orderBy语句
* @param limit limit语句
* @return
*/
@SuppressWarnings("unchecked")
public <T> List<T> query(
Class<?> clazz,
boolean distinct,
String where,
String groupBy,
String having,
String orderBy,
String limit) {
if (testSQLiteDatabase()) {
List<T> list = null;
SqlBuilder getSqlBuilder =
SqlBuilderFactory.getInstance().getSqlBuilder(SqlBuilderFactory.SELECT);
getSqlBuilder.setClazz(clazz);
getSqlBuilder.setCondition(distinct, where, groupBy, having, orderBy, limit);
try {
String sqlString = getSqlBuilder.getSqlStatement();
CHLogger.i(SQLiteDB.this, "执行" + sqlString);
free();
this.queryCursor = mSQLiteDatabase.rawQuery(sqlString, null);
list = (List<T>) DBUtils.getListEntity(clazz, this.queryCursor);
} catch (IllegalArgumentException e) {
// TODO Auto-generated catch block
CHLogger.e(SQLiteDB.this, e.getMessage());
e.printStackTrace();
} catch (CHDBException e) {
// TODO Auto-generated catch block
CHLogger.e(SQLiteDB.this, e.getMessage());
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
CHLogger.e(SQLiteDB.this, e.getMessage());
e.printStackTrace();
}
return list;
} else {
return null;
}
}