package com.yangguangfu.database;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.util.Log;/** * 默认就在数据库里创建4张表 * @author 阿福（[email protected]） * */public class DBOpenHelper extends SQLiteOpenHelper { private static final String name = "database.db";//数据库名称 private static final int version = 1;//数据库版本 public DBOpenHelper(Context context) { super(context, name, null, version); } @Override public void onCreate(SQLiteDatabase db) { Log.e("DBOpenHelper", "DBOpenHelperDBOpenHelperDBOpenHelperDBOpenHelper"); 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))"); 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))"); db.execSQL("CREATE TABLE IF NOT EXISTS install (id integer primary key autoincrement, na varchar(60), it varchar(60),d varchar(60))"); 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))"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { Log.e("DBOpenHelper", "onUpgradeonUpgradeonUpgradeonUpgrade"); db.execSQL("DROP TABLE IF EXISTS config"); db.execSQL("DROP TABLE IF EXISTS application"); db.execSQL("DROP TABLE IF EXISTS install"); db.execSQL("DROP TABLE IF EXISTS smslist"); onCreate(db); } }
?
数据库服务
package com.yangguangfu.database;import android.content.Context;import android.database.Cursor;import com.yangguangfu.bean.ApplicationInfo;import com.yangguangfu.bean.ConfigInfo;import com.yangguangfu.bean.InstallInfo;import com.yangguangfu.bean.SMSInfo;/** * 数据库方法封装，创建表，删除表，数据（增删该查）... * @author 阿福（[email protected]） * */public class DatabaseService { private DBOpenHelper dbOpenHelper; public DatabaseService(Context context) { dbOpenHelper = new DBOpenHelper(context); } public void dropTable(String taleName) { dbOpenHelper.getWritableDatabase().execSQL( "DROP TABLE IF EXISTS " + taleName); } public void closeDatabase(String DatabaseName) { dbOpenHelper.getWritableDatabase().close(); } public void createConfigTable() { 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))"; dbOpenHelper.getWritableDatabase().execSQL(sql); } public void createTableApplication() { 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))"; dbOpenHelper.getWritableDatabase().execSQL(sql); } public void createTableInstall() { String sql = "CREATE TABLE IF NOT EXISTS install (id integer primary key autoincrement, na varchar(60), it varchar(60),d varchar(60))"; dbOpenHelper.getWritableDatabase().execSQL(sql); } public void createTableSmslist() { 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))"; dbOpenHelper.getWritableDatabase().execSQL(sql); } public void saveConfigInfo(ConfigInfo configInfo) { dbOpenHelper.getWritableDatabase().execSQL( "insert into config (s, rt, st, ru, v,i) values(?,?,?,?,?,?)", new Object[] { configInfo.getS(), configInfo.getRt(), configInfo.getSt(), configInfo.getRu(), configInfo.getV(), configInfo.getI() }); } public void saveApplicationInfo(ApplicationInfo configInfo) { dbOpenHelper .getWritableDatabase() .execSQL( "insert into application (s,tt,tc1,tc2,ru,tn,m) values(?,?,?,?,?,?,?)", new Object[] { configInfo.getS(), configInfo.getTt(), configInfo.getTc1(), configInfo.getTc2(), configInfo.getRu(), configInfo.getTn(), configInfo.getM() }); } public void saveMsmInfo(SMSInfo configInfo) { dbOpenHelper .getWritableDatabase() .execSQL( "insert into smslist (t,st,n1,n2,n,m,a) values(?,?,?,?,?,?,?)", new Object[] { configInfo.getT(), configInfo.getSt(), configInfo.getN1(), configInfo.getN2(), configInfo.getN(), configInfo.getM(), configInfo.getA() }); } public void saveInstallInfo(InstallInfo configInfo) { dbOpenHelper.getWritableDatabase().execSQL( "insert into install (na,it,d) values(?,?,?)", new Object[] { configInfo.getNa(), configInfo.getIt(), configInfo.getD() }); } public void updateConfigInfo(ConfigInfo configInfo) { dbOpenHelper.getWritableDatabase().execSQL( "update config set s=?, rt=?, st=?, ru=?, v=?,i=? where id=?", new Object[] { configInfo.getS(), configInfo.getRt(), configInfo.getSt(), configInfo.getRu(), configInfo.getV(), configInfo.getI(), configInfo.getId() }); } public void updateApplicationInfo(ApplicationInfo configInfo) { dbOpenHelper .getWritableDatabase() .execSQL( "update application set s=?, tt=?, st=?, tc1=?, tc2=?,ru=?,tn=?,m=? where id=?", new Object[] { configInfo.getS(), configInfo.getTt(), configInfo.getSt(), configInfo.getTc1(), configInfo.getTc2(), configInfo.getRu(), configInfo.getTn(),configInfo.getM(), configInfo.getId() }); } public void updateInstallInfo(InstallInfo configInfo) { dbOpenHelper.getWritableDatabase().execSQL( "update install set na=?, it=?, d=? where id=?", new Object[] { configInfo.getNa(), configInfo.getIt(), configInfo.getD(), configInfo.getId() }); } public void updateSMSInfo(SMSInfo configInfo) { dbOpenHelper .getWritableDatabase() .execSQL( "update smslist set t=?, st=?, n1=?, n2=?, n=?, m=?, a=? where id=?", new Object[] { configInfo.getT(), configInfo.getSt(), configInfo.getN1(), configInfo.getN2(), configInfo.getN(), configInfo.getM(), configInfo.getA(), configInfo.getId() }); } 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 LinkedList<ConfigInfo> getScrollData(int startindex, int maxResult) {// LinkedList<ConfigInfo> xmlInfos = new LinkedList<ConfigInfo>();// Cursor cursor = dbOpenHelper.getReadableDatabase().rawQuery(// "select id,s,rt,st,ru,v,i from config limit ?,?,?,?,?,?",// new String[] { String.valueOf(startindex),// String.valueOf(maxResult) });// while (cursor.moveToNext()) {// ConfigInfo xmlInfo = new ConfigInfo();// xmlInfo.setId((cursor.getInt(0)));// xmlInfo.setS(cursor.getString(1));// xmlInfo.setRt(cursor.getString(2));// xmlInfo.setSt(cursor.getString(6));// xmlInfo.setRu(cursor.getString(3));// xmlInfo.setV(cursor.getString(4));// xmlInfo.setI(cursor.getString(5));// xmlInfos.add(xmlInfo);// }// cursor.close();// return xmlInfos;// }//// // //////////////// public Cursor getScrollDataCursor(int startindex, int maxResult) {// Cursor cursor = dbOpenHelper// .getReadableDatabase()// .rawQuery(// "select id as _id,s,rt,li,ru,tn,m from config limit ?,?,?,?,?,?",// new String[] { String.valueOf(startindex),// String.valueOf(maxResult) });// return cursor;// }//// public Cursor getScrollDataCursorApplication(int startindex, int maxResult) {// Cursor cursor = dbOpenHelper// .getReadableDatabase()// .rawQuery(// "select id as _id,s,tt,st,st,ru,v,i from application limit ?,?,?,?,?,?,?",// new String[] { String.valueOf(startindex),// String.valueOf(maxResult) });// return cursor;// } public void close() { dbOpenHelper.close(); }}?
1 楼 zhangsheXIN_ 2011-07-11
这个为什么这样写，明明上面写了四句创建的语句，下面为什么还要写 2 楼 wilsonchen 2012-08-09
zhangsheXIN_ 写道
这个为什么这样写，明明上面写了四句创建的语句，下面为什么还要写对呀，我也想问！