public class DataBaseHelper extends
sqliteOpenHelper{ private static final int VERSION = 1; // 在
sqliteOpenHelper的子类当中,必须有该构造
函数 // content为activity对象 // name 为表
名称 // version 为
数据库的版本,必须为正数 public DataBaseHelper(Context context,String name,CursorFactory factory,int version) { super(context,name,factory,version); // TODO Auto-generated constructor stub } public DataBaseHelper(Context context,String name) { this(context,VERSION); } public DataBaseHelper(Context context,int version) { this(context,null,version); } @Override public void onCreate(
sqliteDatabase arg0) { // TODO Auto-generated method stub } @Override public void onUpgrade(
sqliteDatabase arg0,int arg1,int arg2) { // TODO Auto-generated method stub } /** * 判断某张表是否存在 * * @param tabName * 表名 * @return */ public boolean IsExistTable(String TableName) { boolean result = false; if (TableName == null) { return false; }
sqliteDatabase db = null; Cursor cursor = null; try { db = this.getReadableDatabase(); String
sql = "select count(*) as c from
sqlite_master where type ='table' and name ='" + TableName.trim() + "' "; cursor = db.rawQuery(
sql,null); if (cursor.moveToNext()) { int count = cursor.getInt(0); if (count > 0) { result = true; } } } catch (Exception e) { }finally{ closeCursor(cursor); db.close(); } //System.out.println("表是否存在---"+result); return result; } /** * 判断视图是否已存在 * @param viewName 视图的名字 * @return * @author JL * @create 2011-5-20 */ public boolean IsExistView(String viewName) { boolean result = false; if (viewName == null) { return false; }
sqliteDatabase db = null; Cursor cursor = null; try { db = this.getReadableDatabase(); String
sql = "select count(*) as c from
sqlite_master where type ='view' and name ='" + viewName.trim() + "' "; cursor = db.rawQuery(
sql,null); if (cursor.moveToNext()) { int count = cursor.getInt(0); if (count > 0) { result = true; } } } catch (Exception e) { e.printStackTrace(); }finally{ closeCursor(cursor); db.close(); } return result; } protected void closeCursor(Cursor cursor) { if (cursor != null) { cursor.close(); } } }
原文链接：https://www.f2er.com/sqlite/200067.html
