· 8 years ago · Aug 09, 2018, 10:52 AM
1How to create a two table in single Database in Android Application?
2package com.android.cdtech;
3
4 import java.sql.SQLException;
5
6 import android.content.ContentValues;
7 import android.content.Context;
8import android.database.Cursor;
9 import android.database.sqlite.SQLiteDatabase;
10 import android.database.sqlite.SQLiteOpenHelper;
11 import android.util.Log;
12
13 public class saveData {
14 public static final String KEY_ROWID = "rowid"; public static final String KEY_DATE = "Date";public static final String KEY_NAME = "CustomerName";public static final String KEY_AMOUNT = "Amount";public static final String KEY_BANK = "Banks";
15 private static final String TAG = "DBAdapter";
16 public static final String KEY_BUSNAME="BusinessName";public static final String KEY_ADD="Address";public static final String KEY_CPERSON="ContactPerson";;
17 private static final String DATABASE_NAME = "EXPORTDETAILS";
18 private static final String DATABASE_TABLE = "Payment";
19 private static final String DATABASE_TABLE2 = "Customer";
20 private static final int DATABASE_VERSION = 1;
21 private static String DATABASE_CREATE =
22"create table Payment (_id integer primary key autoincrement, "
23+ "Date text not null,"+"CustomerName text not null,"+"Amount text not null,"+"Banks text not null);";
24
25 private static final String DATABASE_CREATECUS =
26 "create table Customer (_id integer primary key autoincrement, "
27 + "BusinessName text not null,"+"Address text not null,"+"ContactPerson text not null,"+"PhoneNumber text not null,);";
28 private final Context context;
29 private DatabaseHelper DBHelper;
30 private SQLiteDatabase db;
31
32
33
34 public saveData(Context ctx)
35 {
36 this.context = ctx;
37 DBHelper = new DatabaseHelper(context);
38 }
39 private static class DatabaseHelper extends SQLiteOpenHelper
40 {
41 DatabaseHelper(Context context)
42 {
43 super(context, DATABASE_NAME, null, DATABASE_VERSION);
44 }
45
46 @Override
47 public void onCreate(SQLiteDatabase db)
48 {
49 db.execSQL(DATABASE_CREATE);
50 db.execSQL(DATABASE_CREATECUS);
51 }
52
53 @Override
54 public void onUpgrade(SQLiteDatabase db, int oldVersion,
55 int newVersion)
56 {
57 Log.w(TAG, "Upgrading database from version " + oldVersion
58 + " to "
59 + newVersion + ", which will destroy all old data");
60 db.execSQL("DROP TABLE IF EXISTS titles");
61 onCreate(db);
62 }
63 }
64public saveData open()throws SQLException
65{
66 db=DBHelper.getWritableDatabase();
67 return this;
68}
69public void close()
70{
71 DBHelper.close();
72}
73
74 public long insert(String Date,String CustomerName,String Amount,String Banks) {
75 // TODO Auto-generated method stub
76 ContentValues cv=new ContentValues();
77 cv.put(KEY_DATE,Date);
78 cv.put(KEY_NAME,CustomerName);
79 cv.put(KEY_AMOUNT,Amount);
80 cv.put(KEY_BANK,Banks);
81 return db.insert(DATABASE_TABLE, null,cv);
82}
83 public long insertForm(String BusinessName ,String Address ,String ContactPerson) {
84 // TODO Auto-generated method stub
85 ContentValues cv=new ContentValues();
86 cv.put(KEY_BUSNAME,BusinessName);
87 cv.put(KEY_ADD,Address);
88 cv.put(KEY_CPERSON,ContactPerson);
89 }
90 public Cursor getlatlng()
91 {
92 Cursor latlngCursor = db.rawQuery("select * from " + DATABASE_TABLE,null);
93 if (latlngCursor != null)
94 {
95 latlngCursor.moveToFirst();
96 }
97 db.close();
98 return latlngCursor;
99 }
100 public Cursor order()
101 {
102 Cursor latlngCursor = db.rawQuery("select * from " + DATABASE_TABLE2,null);
103 if (latlngCursor != null)
104 {
105 latlngCursor.moveToFirst();
106 }
107 db.close();
108 return latlngCursor;
109 }
110
111use below two class
112
113package Your 'packagename';
114
115
116import android.content.Context;
117import android.database.sqlite.SQLiteDatabase;
118import android.database.sqlite.SQLiteOpenHelper;
119import android.util.Log;
120
121
122public class DBHelper extends SQLiteOpenHelper {
123 private static final String DATABASE_NAME = "BistroDB";
124
125 private static final int DATABASE_VERSION =1;
126
127 // Database creation sql statement
128 public static final String Table1= "create table table1name ("Your cloumns");";
129
130
131 public static final String Table2 = "create table table2name ("Your cloumns");";
132
133
134
135
136 public DBHelper(Context context) {
137 super(context, DATABASE_NAME, null, DATABASE_VERSION);
138 }
139
140 // Method is called during creation of the database
141 @Override
142 public void onCreate(SQLiteDatabase database) {
143 database.execSQL(table1);
144 database.execSQL(table2);
145
146 }
147
148 // Method is called during an upgrade of the database, e.g. if you increase
149 // the database version
150 @Override
151 public void onUpgrade(SQLiteDatabase database, int oldVersion,
152 int newVersion) {
153 Log.w(DBHelper.class.getName(),
154 "Upgrading database from version " + oldVersion + " to "
155 + newVersion + ", which will destroy all old data");
156 database.execSQL("DROP TABLE IF EXISTS table1");
157 database.execSQL("DROP TABLE IF EXISTS table2");
158
159 onCreate(database);
160 }
161
162
163 public boolean deleteDatabase(Context context) {
164 return context.deleteDatabase(DATABASE_NAME);
165 }
166
167}
168
169package 'Your package name';
170
171
172
173 import android.content.ContentValues;
174 import android.content.Context;
175 import android.database.Cursor;
176 import android.database.SQLException;
177 import android.database.sqlite.SQLiteDatabase;
178
179 public class DataBaseAdapter {
180
181 // Database fields
182
183 private Context context;
184 private SQLiteDatabase database;
185 private DBHelper dbHelper;
186
187 public DataBaseAdapter(Context context) {
188 this.context = context;
189 }
190
191 public DataBaseAdapter open() throws SQLException {
192 dbHelper = new DBHelper(context);
193 database = dbHelper.getWritableDatabase();
194 return this;
195 }
196
197 public void close() {
198 dbHelper.close();
199 }
200
201
202 public Cursor fetchAllTAble1data() {
203 return database.query("MenuData", new String[] { "id", "Title",
204 "Image", "Description" }, null, null, null, null, null);
205 }
206
207 public Cursor fetchAllTable2data() {
208 return database.query("RestaurantsData", new String[] {
209 "restaurant_id", "name", "phone", "email", "open_days",
210 "timing", "website", "loc_name", "street", "city", "longitude",
211 "latitude", "zip" }, null, null, null, null, null);
212 }
213
214 public void deleteTable(String tablename){
215 database.execSQL("drop table if exists "+tablename+';');
216 }
217 public void createIndividualTable(String query){
218 database.execSQL(query);
219 }
220
221
222 public void InsertTable1Data(TAble1 review) {
223 ContentValues values = new ContentValues();
224 values.put("Name", review.Name);
225 values.put("Email", review.Email);
226 values.put("Comment", review.Comment);
227 values.put("Rating", review.Rating);
228
229 database.insert("ReviewsData", null, values);
230
231 }
232
233 public void InsertTable2Data(TAble2 photos) {
234 ContentValues values = new ContentValues();
235 values.put("photo", photos.Photos);
236
237 database.insert("PhotosData", null, values);
238
239 }
240
241
242
243 public ContentValues createContentValues(String category, String summary,
244 String description) {
245 ContentValues values = new ContentValues();
246
247 return values;
248 }
249 }