android sqlite 一次创建多个表_移动开发_编程开发_程序员俱乐部

中国优秀的程序员网站程序员频道CXYCLUB技术地图
热搜:
更多>>
 
您所在的位置: 程序员俱乐部 > 编程开发 > 移动开发 > android sqlite 一次创建多个表

android sqlite 一次创建多个表

 2010/12/27 9:45:27  yangguangfu  http://yangguangfu.javaeye.com  我要评论(0)
  • 摘要:packagecom.yangguangfu.database;importandroid.content.Context;importandroid.database.sqlite.SQLiteDatabase;importandroid.database.sqlite.SQLiteOpenHelper;importandroid.util.Log;/***默认就在数据库里创建4张表*@author阿福(trygf521@126.com
  • 标签:android 创建 SQL
package com.yangguangfu.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
/**
 * 默认就在数据库里创建4张表
 * @author 阿福(trygf521@126.com)
 *
 */
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 阿福(trygf521@126.com)
 *
 */
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();
	}

}
?
发表评论
用户名: 匿名