Android实现创建或升级数据库时执行语句

本文实例讲述了Android创建或升级数据库时执行的语句，如果是创建或升级数据库，请使用带List参数的构造方法，带SQL语句的构造方法将在数据库创建或升级时执行。

具体程序代码如下：

import java.util.List;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class SimpleSQLiteOpenHelper extends SQLiteOpenHelper {
 private static final int INIT_VERSION = 1;
 
 private List sqlStatementExed;
 
 public SimpleSQLiteOpenHelper(Context context, String name,
  CursorFactory factory, int version) {
 super(context, name, factory, version);
 sqlStatementExed = null;
 }
 
 public SimpleSQLiteOpenHelper(Context context, String name,
  CursorFactory factory, int version, List sqlStatementExed) {
 super(context, name, factory, version);
 this.sqlStatementExed = sqlStatementExed;
 }
 
 public SimpleSQLiteOpenHelper(Context context, String name, int version) {
 super(context, name, null, version);
 sqlStatementExed = null;
 }
 
 public SimpleSQLiteOpenHelper(Context context, String name) {
 super(context, name, null, INIT_VERSION);
 sqlStatementExed = null;
 }
 
 public SimpleSQLiteOpenHelper(Context context, String name, int version,
  List sqlCreateStatement) {
 super(context, name, null, version);
 this.sqlStatementExed = sqlCreateStatement;
 }
 
 public SimpleSQLiteOpenHelper(Context context, String name,
  List sqlCreateStatement) {
 super(context, name, null, INIT_VERSION);
 this.sqlStatementExed = sqlCreateStatement;
 }
 
 @Override
 @Deprecated
 public void onCreate(SQLiteDatabase db) {
 exeSqlStatementExed(db);
 }
 
 @Override
 @Deprecated
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 if (newVersion > oldVersion) {
  exeSqlStatementExed(db);
 }
 }
 
 private void exeSqlStatementExed(SQLiteDatabase db) {
 if (sqlStatementExed != null) {
  for (String statement : sqlStatementExed) {
  db.execSQL(statement);
  }
 }
 }
}

希望本文所述方法对于大家进行Android程序开发能够起到一定的帮助作用。