db 호출용 class

1. public class DBInfo_DataHelper {
2. public long insert(Context context, String tableName, String[] columns, String[] values){
3. SQLiteDatabase db = dbWriteOpen(context, "Write");
5. ContentValues insertValues = new ContentValues();
7. for(int i = 0; i < columns.length; i++){
8. insertValues.put(columns[i], values[i]);
9. }
11. return db.insert(tableName, null, insertValues);
12. }
14. public int delete(Context context, String tableName, String whereClause, String[] whereArgs){
15. SQLiteDatabase db = dbWriteOpen(context, "Write");
17. return db.delete(tableName, whereClause, whereArgs);
18. }
20. public Cursor select(Context context, String tableName, String[] columns, String selection, String[] selectionArgs, String orderBy){
21. SQLiteDatabase db = dbWriteOpen(context, "Read");
23. return db.query(tableName, columns, selection, selectionArgs, null, null, orderBy);
24. }
26. public long update(Context context, String tableName, ContentValues values, String whereClause, String[] whereArgs){
27. SQLiteDatabase db = dbWriteOpen(context, "Write");
29. return db.update(tableName, values, whereClause, whereArgs);
30. }
32. private SQLiteDatabase dbWriteOpen(Context context, String dbGubun){
33. DBInfo_Table_DataHelper tableHelper = new DBInfo_Table_DataHelper(context);
35. if(dbGubun == "Write"){
36. return tableHelper.getWritableDatabase();
37. }else if(dbGubun == "Read"){
38. return tableHelper.getReadableDatabase();
39. }
41. return null;
42. }
43. }