· 8 years ago · Aug 19, 2018, 05:16 AM
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 while (iter.hasNext()) {
7 Map.Entry mEntry = (Map.Entry) iter.next();
8 columns += mEntry.getKey() + " " + mEntry.getValue();
9 if (counter == fields.size()) {
10 columns += ")";
11 } else {
12 columns += " , ";
13 counter++;
14 }
15 }
16 if (counter > 1) {
17 Log.d("column", columns);
18 String createNewTable = "CREATE TABLE IF NOT EXISTS " + tableName + " " + columns;
19 db.execSQL(createNewTable);
20 }
21}