· 8 years ago · Aug 05, 2018, 04:30 PM
1private void createTable(String tableName, Map<String, String> fields, SQLiteDatabase db) {
2 Iterator iter = fields.entrySet().iterator();
3 String columns = "(";
4 Log.d("column", columns);
5 int counter = 1;
6
7 while (iter.hasNext()) {
8
9 Map.Entry mEntry = (Map.Entry) iter.next();
10 columns += mEntry.getKey() + " " + mEntry.getValue();
11 if (counter == fields.size()) {
12 columns += ")";
13 } else {
14 columns += " , ";
15 counter++;
16 }
17 }
18 if (counter > 1) {
19
20 Log.d("column", columns);
21 String createNewTable = "CREATE TABLE IF NOT EXISTS " + tableName + " " + columns;
22 db.execSQL(createNewTable);
23
24 }
25 }