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();
}
}
/**
* 删除表数据和删除但条数据
*
* @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);
}
/**
* 查询去重数据库
*
* @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;
}
}
/**
* 更新数据库数据
*
* @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);
}
/**
* 查询数据库
*
* @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;
}
}
/**
* 添加数据库数据
*
* @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);
}