BDSQLiteHelper.java

package com.bigdo.common;

import java.io.File;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Environment;
import android.util.Log;

public class BDSQLiteHelper extends SQLiteOpenHelper {

	private final static String database_name = "bigdo_db";
	private final static int database_version = 126;

	// private Context context;

	public BDSQLiteHelper(Context context) {
		super(context, database_name, null, database_version);
		// this.context = context;
	}

	@Override
	public void onCreate(SQLiteDatabase arg0) {
		RACreateDB(arg0);
	}

	private void RACreateDB(SQLiteDatabase arg0) {
		try {
			String hometop = "Create table hometop (idbatch integer,idvideo integer,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(hometop);

			String hometoplist = "Create table hometoplist (idbatch integer,idvideo integer,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(hometoplist);

			String latest = "Create table latest (idbatch integer,idvideo integer ,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(latest);

			String free = "Create table free (idbatch integer,idvideo integer,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(free);

			String hot = "Create table hot (idbatch integer,idvideo integer ,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(hot);

			String relate = "Create table relate (idbatch integer,idrelate integer ,idvideo integer,idptype integer,idtype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idrelate\",\"idvideo\",\"idtype\"));";
			arg0.execSQL(relate);

			String box = "Create table box (idbatch integer,idvideo integer,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(box);

			String videotype = "Create table videotype (idbatch integer,idtype integer,idptype integer,typename text,isdefault integer ,PRIMARY KEY(\"idtype\"));";
			arg0.execSQL(videotype);

			String download = "Create table download (idown integer, idvideo integer,idtype integer,title text,downurl text,isfinish integer,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(download);

			String sms = "Create table sms (vcode text COLLATE NOCASE,PRIMARY KEY(\"vcode\"));";
			arg0.execSQL(sms);

			String teacher = "Create table teacher (idteacher integer,teacher text,taptitudes text,img text,PRIMARY KEY(\"idteacher\"));";
			arg0.execSQL(teacher);

			String teachervideo = "Create table teachervideo (idbatch integer,idvideo integer,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idteacher\",\"idvideo\",\"idtype\"));";
			arg0.execSQL(teachervideo);

			String grow = "Create table grow (idgrow integer,title text,content text,createtime text,PRIMARY KEY(\"idgrow\"));";
			arg0.execSQL(grow);

			String myorder = "Create table myorder (orderno integer,user text,userdesc text,amount integer,status integer,createtime text,paytype text,notes text,PRIMARY KEY(\"orderno\"));";
			arg0.execSQL(myorder);

			String search = "Create table search (idbatch integer,idvideo integer ,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(search);

			String searchgood = "Create table searchgood (idmodel text, idbatch integer,idvideo integer ,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idmodel\",\"idvideo\",\"idtype\"));";
			arg0.execSQL(searchgood);

			String collect = "Create table collect (user text COLLATE NOCASE,idcollect integer,idbatch integer,idvideo integer ,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(collect);

			String point = "Create table point (user text COLLATE NOCASE,idpoint integer,point integer,pointdesc text ,createtime test ,PRIMARY KEY(\"idpoint\"));";
			arg0.execSQL(point); 
			
			String payhistory = "Create table payhistory (idbatch integer,idvideo integer,idtype integer,idptype integer,score integer,title text,"
					+ "idteacher integer,teacher text,taptitudes text,timg text,desc text,paycount integer,paytime text,img text,video text ,"
					+ "createtime text ,updatetime text ,PRIMARY KEY(\"idvideo\",\"idtype\"));";
			arg0.execSQL(payhistory);

		} catch (Exception e) {
			Log.e("CreateDB", e.getMessage());
		}
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		try {
			String hometop = "DROP TABLE IF EXISTS hometop";
			db.execSQL(hometop);

			String hometoplist = "DROP TABLE IF EXISTS hometoplist";
			db.execSQL(hometoplist);

			String latest = "DROP TABLE IF EXISTS latest";
			db.execSQL(latest);

			String free = "DROP TABLE IF EXISTS free";
			db.execSQL(free);

			String hot = "DROP TABLE IF EXISTS hot";
			db.execSQL(hot);

			String relate = "DROP TABLE IF EXISTS relate";
			db.execSQL(relate);

			String box = "DROP TABLE IF EXISTS box";
			db.execSQL(box);

			String videotype = "DROP TABLE IF EXISTS videotype";
			db.execSQL(videotype);

			String download = "DROP TABLE IF EXISTS download";
			db.execSQL(download);

			String sms = "DROP TABLE IF EXISTS sms";
			db.execSQL(sms);

			String teacher = "DROP TABLE IF EXISTS teacher";
			db.execSQL(teacher);

			String teachervideo = "DROP TABLE IF EXISTS teachervideo";
			db.execSQL(teachervideo);

			String grow = "DROP TABLE IF EXISTS grow";
			db.execSQL(grow);

			String myorder = "DROP TABLE IF EXISTS myorder";
			db.execSQL(myorder);

			String search = "DROP TABLE IF EXISTS search";
			db.execSQL(search);

			String searchgood = "DROP TABLE IF EXISTS searchgood";
			db.execSQL(searchgood);

			String collect = "DROP TABLE IF EXISTS collect";
			db.execSQL(collect);

			String point = "DROP TABLE IF EXISTS point";
			db.execSQL(point);
			
			String payhistory = "DROP TABLE IF EXISTS payhistory";
			db.execSQL(payhistory);
			
			

			RACreateDB(db);

		} catch (Exception e) {
		}

	}

	public static void delAllData(Context context) {
		BDSQLiteHelper sqlObj = null;
		SQLiteDatabase sql_w = null;
		try {
			sqlObj = new BDSQLiteHelper(context);
			sql_w = sqlObj.getWritableDatabase();

			sql_w.delete("hometop", null, null);

			sql_w.delete("hometoplist", null, null);

			sql_w.delete("latest", null, null);

			sql_w.delete("free", null, null);

			sql_w.delete("hot", null, null);

			sql_w.delete("relate", null, null);

			sql_w.delete("box", null, null);

			sql_w.delete("videotype", null, null);

			sql_w.delete("download", null, null);

			sql_w.delete("sms", null, null);

			sql_w.delete("teacher", null, null);

			sql_w.delete("teachervideo", null, null);

			sql_w.delete("grow", null, null);

			sql_w.delete("myorder", null, null);

			sql_w.delete("search", null, null);

			sql_w.delete("searchgood", null, null);

			sql_w.delete("collect", null, null);

			sql_w.delete("point", null, null);
			
			sql_w.delete("payhistory", null, null);
			

		} catch (Exception e) {
		}
		try {
			if (sql_w != null) {
				sql_w.close();
				sql_w = null;
			}
		} catch (Exception ex) {
		}
		try {
			if (sqlObj != null) {
				sqlObj.close();
				sqlObj = null;
			}
		} catch (Exception ex) {
		}
		try {
			DelAll(RConfig.Base_Dir);
		} catch (Exception e) {
			// TODO: handle exception
		}
	}

	public static final void DelAll(String fileDirPath) {
		try {
			try {
				String status = Environment.getExternalStorageState();
				if (status.equals(Environment.MEDIA_MOUNTED)) {
					fileDirPath = Environment.getExternalStorageDirectory()
							+ fileDirPath;
					File file = new File(fileDirPath);
					if (file.exists()) {
						deleteAllFiles(file);
					}
				}
			} catch (Exception e) {
			}
		} catch (Exception e) {
		}
	}

	private static void deleteAllFiles(File root) {
		File files[] = root.listFiles();
		if (files != null) {
			for (File f : files) {
				if (f.isDirectory()) { // 判断是否为文件夹
					deleteAllFiles(f);
					try {
						f.delete();
					} catch (Exception e) {
					}
				} else {
					if (f.exists()) { // 判断是否存在
						deleteAllFiles(f);
						try {
							f.delete();
						} catch (Exception e) {
						}
					}
				}
			}
		}
	}
}