sqlite 判断某张表是否存在

1. /** 
2.      * 判断某张表是否存在 
3.      * @param tabName 表名 
4.      * @return 
5.      */  
6.     public boolean tabbleIsExist(String tableName){  
7.             boolean result = false;  
8.             if(tableName == null){  
9.                     return false;  
10.             }  
11.             SQLiteDatabase db = null;  
12.             Cursor cursor = null;  
13.             try {  
14.                     db = this.getReadableDatabase();  
15.                     String sql = "select count(*) as c from Sqlite_master  where type ='table' and name ='"+tableName.trim()+"' ";  
16.                     cursor = db.rawQuery(sql, null);  
17.                     if(cursor.moveToNext()){  
18.                             int count = cursor.getInt(0);  
19.                             if(count>0){  
20.                                     result = true;  
21.                             }  
22.                     }  
23.                       
24.             } catch (Exception e) {  
25.                     // TODO: handle exception  
26.             }                  
27.             return result;  
28.     }