7Qn01qiq

1public void createDynamicDatabase(Context context,String tableName,ArrayList<String> title) {
2
3                Log.i("INSIDE createLoginDatabase() Method","*************creatLoginDatabase*********");
4                try {
5
6                    int i;
7                    String querryString;
8                    myDataBase = context.openOrCreateDatabase("Db",Context.MODE_WORLD_WRITEABLE, null);         //Opens database in writable mode.
9                    //System.out.println("Table Name : "+tableName.get(0));
10
11                    querryString = title.get(0)+" VARCHAR(30),";
12                    Log.d("**createDynamicDatabase", "in oncreate");
13                    for(i=1;i<title.size()-1;i++)
14                    {               
15                        querryString += title.get(i);
16                        querryString +=" VARCHAR(30)";
17                        querryString +=",";
18                    }
19                    querryString+= title.get(i) +" VARCHAR(30)";
20
21                    querryString = "CREATE TABLE IF NOT EXISTS " + tableName + "("+querryString+");";
22
23                    System.out.println("Create Table Stmt : "+ querryString);
24
25                    myDataBase.execSQL(querryString);
26
27                } catch (SQLException ex) {
28                    Log.i("CreateDB Exception ",ex.getMessage());
29                }
30            }
31            public void insert(Context context,ArrayList<String> array_vals,ArrayList<String> title,String TABLE_NAME) {
32                Log.d("Inside Insert","Insertion starts for table name: "+TABLE_NAME);
33                myDataBase = context.openOrCreateDatabase("Db",Context.MODE_WORLD_WRITEABLE, null);         //Opens database in writable mode.
34                String titleString=null;
35                String markString= null;
36                int i;
37                titleString = title.get(0)+",";
38                markString = "?,";
39                Log.d("**createDynamicDatabase", "in oncreate");
40                for(i=1;i<title.size()-1;i++)
41                {               
42                    titleString += title.get(i);
43                    titleString +=",";
44                    markString += "?,";
45                }
46                titleString+= title.get(i);
47                markString += "?";
48
49                //System.out.println("Title String: "+titleString);
50                //System.out.println("Mark String: "+markString);
51
52
53                INSERT="insert into "+ TABLE_NAME + "("+titleString+")"+ "values" +"("+markString+")";
54                System.out.println("Insert statement: "+INSERT);
55                //System.out.println("Array size iiiiii::: "+array_vals.size());
56                //this.insertStmt = this.myDataBase.compileStatement(INSERT);
57                int s=0;
58
59                while(s<array_vals.size()){
60
61                System.out.println("Size of array1"+array_vals.size());
62                        //System.out.println("Size of array"+title.size());
63                int j=1;
64                this.insertStmt = this.myDataBase.compileStatement(INSERT);
65                for(int k =0;k< title.size();k++)
66                {
67
68                    //System.out.println("Value of column "+title+" is "+array_vals.get(k+s));
69                    //System.out.println("PRINT S:"+array_vals.get(k+s));
70                    System.out.println("BindString: insertStmt.bindString("+j+","+ array_vals.get(k+s)+")");
71                    insertStmt.bindString(j, array_vals.get(k+s));
72
73
74
75                    j++;
76                }
77
78                s+=title.size();
79
80                }
81                insertStmt.executeInsert();
82            }