Android 数据库一次创建多个表

Android 数据库一次创建多个表

时间:2012-11-21 11:25来源:未知 作者:Eric*Market 点击:335次

　　Android 数据库一次创建多个表
我们今天来说的就是android培训中的数据库（sqlite）一次性多建立几个表，这样我们就可以不会在用的时候在建立一张表，一次性我们建立多表以后，我们就省去很多的事情，那么我们还等什么，就来看看代码吧：
 

01		packageeoe.database;
02
03		importandroid.content.Context;
04		importandroid.database.sqlite.SQLiteDatabase;
05		importandroid.database.sqlite.SQLiteOpenHelper;
06		importandroid.util.Log;
07
08		/**
09		* 默认就在数据库里创建4张表
10		*/
11
12		publicclassDBOpenHelperextendsSQLiteOpenHelper {
13		privatestaticfinalString name ="database.db";//数据库名称
14		privatestaticfinalintversion =1;//数据库版本
15		publicDBOpenHelper(Context context) {
16		super(context, name,null, version);
17		}
18
19
20		@Override
21		publicvoidonCreate(SQLiteDatabase db) {
22		Log.e("DBOpenHelper","DBOpenHelperDBOpenHelperDBOpenHelperDBOpenHelper");
23
24	db.execSQL("CREATE TABLE IF NOT EXISTS config (id integer primary key autoincrement, s varchar(60), rt varchar(60),st varchar(60), ru varchar(60), v varchar(60),i varchar(60))");
25
26	db.execSQL("CREATE TABLE IF NOT EXISTS application (id integer primary key autoincrement, s varchar(60), tt varchar(60),st varchar(60),tc1 varchar(60), tc2 varchar(60), ru varchar(60),tn varchar(60),m varchar(60))");
27
28	db.execSQL("CREATE TABLE IF NOT EXISTS install (id integer primary key autoincrement, na varchar(60), it varchar(60),d varchar(60))");
29
30	db.execSQL("CREATE TABLE IF NOT EXISTS smslist (id integer primary key autoincrement, t varchar(60), st varchar(60),n1 varchar(60),n2 varchar(60),n varchar(60),m varchar(60),a varchar(60))");
31		}
32
33		@Override
34		publicvoidonUpgrade(SQLiteDatabase db,intoldVersion,intnewVersion) {
35		Log.e("DBOpenHelper","onUpgradeonUpgradeonUpgradeonUpgrade");
36		db.execSQL("DROP TABLE IF EXISTS config");
37		db.execSQL("DROP TABLE IF EXISTS application");
38		db.execSQL("DROP TABLE IF EXISTS install");
39		db.execSQL("DROP TABLE IF EXISTS smslist");
40		onCreate(db);
41		}
42		}

　　            数据库服务 

01		packageeoe.database;
02
03		importandroid.content.Context;
04		importandroid.database.Cursor;
05		importcom.yangguangfu.bean.ApplicationInfo;
06		importcom.yangguangfu.bean.ConfigInfo;
07		importcom.yangguangfu.bean.InstallInfo;
08		importcom.yangguangfu.bean.SMSInfo;
09
10		/**
11		* 数据库方法封装，创建表，删除表，数据(增删该查)...
12		*/
13		publicclassDatabaseService {
14		privateDBOpenHelper dbOpenHelper;
15		publicDatabaseService(Context context) {
16		dbOpenHelper =newDBOpenHelper(context);
17		}
18
19		publicvoiddropTable(String taleName) {
20		dbOpenHelper.getWritableDatabase().execSQL("DROP TABLE IF EXISTS "+ taleName);
21		}
22
23		publicvoidcloseDatabase(String DatabaseName) {
24		dbOpenHelper.getWritableDatabase().close();
25		}
26
27		publicvoidcreateConfigTable() {
28	String sql ="CREATE TABLE IF NOT EXISTS config (id integer primary key autoincrement, s varchar(60), rt varchar(60),st varchar(60), ru varchar(60), v varchar(60),i varchar(60))";
29
30		dbOpenHelper.getWritableDatabase().execSQL(sql);
31		}
32
33		publicvoidcreateTableApplication() {
34	String sql ="CREATE TABLE IF NOT EXISTS application (id integer primary key autoincrement, s varchar(60), tt varchar(60),st varchar(60),tc1 varchar(60), tc2 varchar(60), ru varchar(60),tn varchar(60),m varchar(60))";
35
36
37		dbOpenHelper.getWritableDatabase().execSQL(sql);
38		}
39
40		publicvoidcreateTableInstall() {
41	String sql ="CREATE TABLE IF NOT EXISTS install (id integer primary key autoincrement, na varchar(60), it varchar(60),d varchar(60))";
42
43
44		dbOpenHelper.getWritableDatabase().execSQL(sql);
45		}
46
47		publicvoidcreateTableSmslist() {
48	String sql ="CREATE TABLE IF NOT EXISTS smslist (id integer primary key autoincrement, t varchar(60), st varchar(60),n1 varchar(60),n2 varchar(60),n varchar(60),m varchar(60),a varchar(60))";
49
50		dbOpenHelper.getWritableDatabase().execSQL(sql);
51		}
52
53		publicvoidsaveConfigInfo(ConfigInfo configInfo) {
54
55	dbOpenHelper.getWritableDatabase().execSQL("insert into config (s, rt, st, ru, v,i) values(?,?,?,?,?,?)",newObject[] { configInfo.getS(), configInfo.getRt(),configInfo.getSt(), configInfo.getRu(),configInfo.getV(), configInfo.getI() });
56		}
57
58		publicvoidsaveApplicationInfo(ApplicationInfo configInfo) {
59	dbOpenHelper.getWritableDatabase().execSQL("insert into application (s,tt,tc1,tc2,ru,tn,m) values(?,?,?,?,?,?,?)",newObject[] { configInfo.getS(), configInfo.getTt(),configInfo.getTc1(), configInfo.getTc2(),configInfo.getRu(), configInfo.getTn(),configInfo.getM() });
60		}
61
62		publicvoidsaveMsmInfo(SMSInfo configInfo) {
63
64	dbOpenHelper.getWritableDatabase().execSQL("insert into smslist (t,st,n1,n2,n,m,a) values(?,?,?,?,?,?,?)",newObject[] { configInfo.getT(), configInfo.getSt(),configInfo.getN1(), configInfo.getN2(),configInfo.getN(), configInfo.getM(),configInfo.getA() });
65		}
66
67		publicvoidsaveInstallInfo(InstallInfo configInfo) {
68
69	dbOpenHelper.getWritableDatabase().execSQL("insert into install (na,it,d) values(?,?,?)",newObject[] { configInfo.getNa(), configInfo.getIt(),configInfo.getD() });}
70
71		publicvoidupdateConfigInfo(ConfigInfo configInfo) {
72
73	dbOpenHelper.getWritableDatabase().execSQL("update config set s=?, rt=?, st=?, ru=?, v=?,i=? where id=?",newObject[] { configInfo.getS(), configInfo.getRt(),configInfo.getSt(), configInfo.getRu(),configInfo.getV(), configInfo.getI(),configInfo.getId() });
74		}
75
76		publicvoidupdateApplicationInfo(ApplicationInfo configInfo) {
77
78	dbOpenHelper.getWritableDatabase().execSQL("update application set s=?, tt=?, st=?, tc1=?, tc2=?,ru=?,tn=?,m=? where id=?",newObject[] { configInfo.getS(), configInfo.getTt(),configInfo.getSt(), configInfo.getTc1(),configInfo.getTc2(), configInfo.getRu(),
79		configInfo.getTn(),configInfo.getM(), configInfo.getId() });
80
81		}
82
83		publicvoidupdateInstallInfo(InstallInfo configInfo) {
84
85		dbOpenHelper.getWritableDatabase().execSQL("update install set na=?, it=?, d=? where id=?",
86		newObject[] { configInfo.getNa(), configInfo.getIt(),configInfo.getD(), configInfo.getId() });
87		}
88
89		publicvoidupdateSMSInfo(SMSInfo configInfo) {
90
91		dbOpenHelper.getWritableDatabase()
92	.execSQL("update smslist set t=?, st=?, n1=?, n2=?, n=?, m=?, a=? where id=?",newObject[] { configInfo.getT(), configInfo.getSt(),configInfo.getN1(), configInfo.getN2(),configInfo.getN(), configInfo.getM(),configInfo.getA(), configInfo.getId() });
93		}

public void deleteItemData(String tableName, Integer id) {
 
    dbOpenHelper.getWritableDatabase().execSQL("delete from " + tableName + " where id=?",new Object[] { id });
 
    }
 
    public InstallInfo findInstallInfo(Integer id) {
 
    Cursor cursor = dbOpenHelper.getWritableDatabase().rawQuery("select id,na,it,d from install where id=?",new String[] { String.valueOf(id) });
 
    if (cursor.moveToNext()) {
    InstallInfo configInfo = new InstallInfo();
    configInfo.setId((cursor.getInt(0)));
    configInfo.setNa(cursor.getString(1));
    configInfo.setIt(cursor.getString(2));
    configInfo.setD(cursor.getString(3));
    return configInfo;
 
    }
    return null;
    }
 
    public ConfigInfo findConfigInfo(Integer id) {
 
    Cursor cursor = dbOpenHelper.getWritableDatabase().rawQuery("select id,s,rt,st,ru,v,i from config where id=?",new String[] { String.valueOf(id) });
 
    if (cursor.moveToNext()) {
    ConfigInfo configInfo = new ConfigInfo();
    configInfo.setId((cursor.getInt(0)));
    configInfo.setS(cursor.getString(1));
    configInfo.setRt(cursor.getString(2));
    configInfo.setSt(cursor.getString(3));
    configInfo.setRu(cursor.getString(4));
    configInfo.setV(cursor.getString(5));
    configInfo.setI(cursor.getString(6));
    return configInfo;
    }
    return null;
    }
 
    public SMSInfo findSMSInfo(Integer id) {
    Cursor cursor = dbOpenHelper.getWritableDatabase().rawQuery("select id,t,st,n1,n2,n,m,a from smslist where id=?",new String[] { String.valueOf(id) });
 
    if (cursor.moveToNext()) {
    SMSInfo configInfo = new SMSInfo();
    configInfo.setId((cursor.getInt(0)));
    configInfo.setT(cursor.getString(1));
    configInfo.setSt(cursor.getString(2));
    configInfo.setN1(cursor.getString(3));
    configInfo.setN2(cursor.getString(4));
    configInfo.setN(cursor.getString(5));
    configInfo.setM(cursor.getString(6));
    configInfo.setA(cursor.getString(7));
    return configInfo;
    }
    return null;
    }
 
   
    public ApplicationInfo findApplication(Integer id) {
    Cursor cursor = dbOpenHelper.getWritableDatabase().rawQuery("select id,s,tt,st,tc1,tc2,ru,tn,m from application where id=?",new String[] { String.valueOf(id) });
 
   
    if (cursor.moveToNext()) {
    ApplicationInfo applicationinfo = new ApplicationInfo();
    applicationinfo.setId((cursor.getInt(0)));
    applicationinfo.setS(cursor.getString(1));
    applicationinfo.setTt(cursor.getString(2));
    applicationinfo.setSt(cursor.getString(3));
    applicationinfo.setTc1(cursor.getString(4));
    applicationinfo.setTc2(cursor.getString(5));
    applicationinfo.setRu(cursor.getString(6));
    applicationinfo.setTn(cursor.getString(7));
    applicationinfo.setM(cursor.getString(8));
    return applicationinfo;
    }
    return null;
    }
 
    public long getDataCount(String tableName) {
    Cursor cursor = dbOpenHelper.getReadableDatabase().rawQuery("select count(*) from " + tableName, null);
    cursor.moveToFirst();
    return cursor.getLong(0);
    }
 
   
    public void close() {
    dbOpenHelper.close();
    }
 
    }