80,351
社区成员
发帖
与我相关
我的任务
分享
// 语音场景方言表tbl_menu_dialect
private void initDB_tbl_menu_dialect(SQLiteDatabase paramSQLiteDatabase) {
paramSQLiteDatabase
.execSQL("CREATE TABLE IF NOT EXISTS tbl_menu_dialect (_id integer primary key autoincrement, menuid integer not null ,dialectname TEXT,audiofile TEXT,version integer not null DEFAULT 0 );");
}
public Cursor fecth_menud(String dialectname) {
Cursor mCursor = mDb.query(tbl_dialect.DB_NAME, new String[] {
tbl_dialect.KEY_ROWID, tbl_dialect.KEY_DIALECTNAME,
tbl_dialect.KEY_AUDIOFILE, tbl_dialect.KEY_MENUID },
tbl_dialect.KEY_DIALECTNAME + "='" + dialectname + "'", null,
null, null, null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
public int getAllDialect(String dialectname) {
Cursor cursor = mDbHelper.fecth_menud(dialectname);
return cursor.getColumnIndex("_id");
}
DialectDao didao = new DialectDao(context);
int dialectid = didao.getAllDialect(ti);