· 8 years ago · Aug 12, 2018, 12:58 PM
1//******************for creating below code*****************
2 public void createDynamicDatabase(Context context,String tableName,ArrayList<String> title) {
3
4 Log.i("INSIDE createLoginDatabase() Method","*************creatLoginDatabase*********");
5 try {
6
7 int i;
8 String querryString;
9 myDataBase = context.openOrCreateDatabase("Db",Context.MODE_WORLD_WRITEABLE, null); //Opens database in writable mode.
10 //System.out.println("Table Name : "+tableName.get(0));
11
12 querryString = title.get(0)+" VARCHAR(30),";
13 Log.d("**createDynamicDatabase", "in oncreate");
14 for(i=1;i<title.size()-1;i++)
15 {
16 querryString += title.get(i);
17 querryString +=" VARCHAR(30)";
18 querryString +=",";
19 }
20 querryString+= title.get(i) +" VARCHAR(30)";
21
22 querryString = "CREATE TABLE IF NOT EXISTS " + tableName + "("+querryString+");";
23
24 System.out.println("Create Table Stmt : "+ querryString);
25
26 myDataBase.execSQL(querryString);
27
28 } catch (SQLException ex) {
29 Log.i("CreateDB Exception ",ex.getMessage());
30 }
31 }
32
33 //******************for inserting below code*****************
34
35
36 public void insert(Context context,ArrayList<String> array_vals,ArrayList<String> title,String TABLE_NAME) {
37 Log.d("Inside Insert","Insertion starts for table name: "+TABLE_NAME);
38 myDataBase = context.openOrCreateDatabase("Db",Context.MODE_WORLD_WRITEABLE, null); //Opens database in writable mode.
39 String titleString=null;
40 String markString= null;
41 int i;
42 titleString = title.get(0)+",";
43 markString = "?,";
44 Log.d("**createDynamicDatabase", "in oncreate");
45 for(i=1;i<title.size()-1;i++)
46 {
47 titleString += title.get(i);
48 titleString +=",";
49 markString += "?,";
50 }
51 titleString+= title.get(i);
52 markString += "?";
53
54 //System.out.println("Title String: "+titleString);
55 //System.out.println("Mark String: "+markString);
56
57
58 INSERT="insert into "+ TABLE_NAME + "("+titleString+")"+ "values" +"("+markString+")";
59 System.out.println("Insert statement: "+INSERT);
60 //System.out.println("Array size iiiiii::: "+array_vals.size());
61 //this.insertStmt = this.myDataBase.compileStatement(INSERT);
62 int s=0;
63
64 while(s<array_vals.size()){
65
66 System.out.println("Size of array1"+array_vals.size());
67 //System.out.println("Size of array"+title.size());
68 int j=1;
69 this.insertStmt = this.myDataBase.compileStatement(INSERT);
70 for(int k =0;k< title.size();k++)
71 {
72
73 //System.out.println("Value of column "+title+" is "+array_vals.get(k+s));
74 //System.out.println("PRINT S:"+array_vals.get(k+s));
75 System.out.println("BindString: insertStmt.bindString("+j+","+ array_vals.get(k+s)+")");
76 insertStmt.bindString(j, array_vals.get(k+s));
77
78
79
80 j++;
81 }
82
83 s+=title.size();
84
85 }
86 insertStmt.executeInsert();
87 }
88
89public ArrayList<Product> getListProduct() {
90 Product product = null;
91 ArrayList<Product> productList = new ArrayList<>();
92 openDatabase();
93 Cursor cursor = mDatabase.rawQuery("SELECT * FROM PRODUCT", null);
94 cursor.moveToFirst();
95 int countit=cursor.getColumnCount();
96 System.out.println("countit"+countit);
97 while (!cursor.isAfterLast()) {
98 System.out.println("cursor=="+cursor.isAfterLast());
99 // for(int i = 0; i < cursor.getColumnCount(); i ++){
100 product = new Product(cursor.getInt(0), cursor.getString(1), cursor.getInt(2));
101 productList.add(product);
102 cursor.moveToNext();
103 // }
104
105
106
107 }
108 cursor.close();
109 closeDatabase();
110 return productList;
111 }