public static final String SORT_ORDER_BY_CITY_CODE = "city_code ASC";
public static final String SORT_ORDER_SORT_NUMBER = "sort ASC";
public static final String SORT_ORDER_WEATHER_DATE = "date ASC";
public static final String DATA = Environment.getDataDirectory().getPath();
public static final String PACKAGE ="com.freeme.asrservice";
public static final String DATABASE ="databases";
public static final String DATABASE_NAME = "machine_brand.db";
public static final String SEPARATOR ="/";
public static final String DATABASE_PATH = DATA + DATA+SEPARATOR+PACKAGE+SEPARATOR+DATABASE+SEPARATOR;
public ContentResolver mContentResolver;
public Context mContext;
public DataHelper(Context paramContext) {
this.mContext = paramContext;
this.mContentResolver = paramContext.getContentResolver();
}
public void closeCursor(Cursor paramCursor) {
if (paramCursor != null)
paramCursor.close();
}
public Cursor getCursorWidthCondition(Uri paramUri) {
return getCursorWidthCondition(paramUri, null, null, null);
}
public Cursor getCursorWidthCondition(Uri paramUri,String[] paramArrayOfString) {
return getCursorWidthCondition(paramUri, paramArrayOfString, null, null);
}
public Cursor getCursorWidthCondition(Uri paramUri,String[] paramArrayOfString, String paramString) {
return getCursorWidthCondition(paramUri, paramArrayOfString,paramString, null);
}
public Cursor getCursorWidthCondition(Uri paramUri,String[] paramArrayOfString, String paramString1,
String paramString2) {
Cursor localCursor1 = null;
try {
Cursor localCursor2 = this.mContentResolver.query(paramUri,
paramArrayOfString, paramString1, null, paramString2);
localCursor1 = localCursor2;
return localCursor1;
} catch (Exception localException) {
while (true) {
localException.printStackTrace();
}
}
}
public boolean isCursorEmpty(Cursor paramCursor) {
if ((paramCursor == null) || (paramCursor.getCount() <= 0))
return true;
return false;
}
/**
* use the city.db of raw ,create the city database
*/
synchronized public static int init(Context context) {
String outFileName = DATABASE_PATH + DATABASE_NAME;
File dir = new File(outFileName);
if (dir.exists())
return 1;
dir = new File(DATABASE_PATH);
if (!dir.exists())
dir.mkdir();
InputStream input = null;
OutputStream output = null;
try {
input =context.getAssets().open(DATABASE_NAME);
output = new FileOutputStream(outFileName);
byte[] buffer = new byte[2048];
int length;
while ((length = input.read(buffer)) > 0) {
output.write(buffer, 0, length);
}
} catch (FileNotFoundException e) {
e.printStackTrace();
return 0;
} catch (IOException e) {
e.printStackTrace();
return -1;
} finally {
try {
output.flush();
output.close();
} catch (IOException e) {
}
try {
input.close();
} catch (IOException e) {
}
}
return 1;
}
}
String mCode = null;
Cursor mCursor = null;
SQLiteDatabase db = SQLiteDatabase.openDatabase(
DataHelper.DATABASE_PATH + DataHelper.DATABASE_NAME, null,
SQLiteDatabase.OPEN_READONLY);
try {
mCursor = db.rawQuery("select brand from tb_machine_brand ", null);
} catch (Exception e) {
}
if (mCursor != null) {
while (mCursor.moveToNext()) {
mCode = mCursor.getString(mCursor.getColumnIndex("brand"));
Log.i("zhang", "mCode=="+mCode);
mScene.add(mCode);
}
}
db.close();
mCursor.close();