java数据库中的数据如何在不同的活动中分配给数组?
我的项目的目的是,我想建立一个词汇卡。应用程序将给你一个英语单词,下面将有4个土耳其语单词(1个单词是真单词。Ex : hello= merhaba
)。你会猜到真实的。我将使用array
来实现这一点。是我错了还是你想给我一个建议
我一直在开发一个小项目。我想在不同的活动中使用数据库中的数据。我的数据与数据库中的数据类似:
ID word word_tr
1 hello merhaba
2 hi selam
我希望assin数据以不同的活动(WordsActivity)排列
阵列1
你好
嗨
阵列2
梅哈巴
塞勒姆 ...
这是我的代码:
package de.murattekinlive.pwords;
import 安卓.content.ContentValues;
import 安卓.content.Context;
import 安卓.database.Cursor;
import 安卓.database.sqlite.SQLiteDatabase;
import 安卓.database.sqlite.SQLiteOpenHelper;
import java.util.ArrayList;
import java.util.List;
public class DataBase extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "DBWORDS";
private static final String TABLE_NAME = "WTABLE";
private static final String ID ="ID";
private static final String WORD = "WORD";
private static final String WORD_TR1 = "TURKCE_1";
public DataBase(Context context){
super(context,DATABASE_NAME,null,DATABASE_VERSION);
}
public DataBase(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_DBTABLE = "CREATE TABLE " + TABLE_NAME + "(" + ID +" INTEGER PRIMARY KEY AUTOINCREMENT," +WORD+
" TEXT," +WORD_TR1+" TEXT" + " )";
db.execSQL(CREATE_DBTABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
String TABLE_DELETE = "DROP TABLE IF EXISTS" + TABLE_NAME ;
db.execSQL(TABLE_DELETE);
onCreate(db);
}
public long addRecord(Words words){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(WORD,words.getWORD());
contentValues.put(WORD_TR1,words.getTR1());
long status = sqLiteDatabase.insert(TABLE_NAME,null,contentValues);
sqLiteDatabase.close();
return status;
}
public List<Words> allRecords(){
List<Words> wordsList = new ArrayList<>();
String sql_query = "SELECT *FROM " + TABLE_NAME;
SQLiteDatabase sqLiteDatabase =this.getWritableDatabase();
Cursor cursor =sqLiteDatabase.rawQuery(sql_query,null);
if(cursor.moveToFirst()){
Words words =null;
do{
words = new Words();
words.setID(cursor.getInt(0));
words.setWORD(cursor.getString(1));
words.setTR1(cursor.getString(2));
wordsList.add(words);
}while (cursor.moveToNext());
}
return wordsList;
}
public String getRandomQuote(){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
Cursor cursor = sqLiteDatabase.query(TABLE_NAME + " ORDER BY RANDOM() LIMIT 1",new String[]
{WORD,WORD_TR1},null,null,null,null,null);
if(cursor.moveToFirst()){
return
cursor.getString(cursor.getColumnIndex(WORD))+
cursor.getString(cursor.getColumnIndex(WORD_TR1));
}
else
return "nothing";
}
}
我的wordActivity(我想用数据完成所有任务)
package de.murattekinlive.pwords;
import 安卓.content.Intent;
import 安卓.support.v7.app.AppCompatActivity;
import 安卓.os.Bundle;
import 安卓.widget.TextView;
import java.util.List;
public class WordsActivity extends AppCompatActivity {
TextView textView;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_words);
textView = (TextView) findViewById(R.id.textView);
Intent intent = getIntent();
String random = intent.getStringExtra("random"); // this is just test...
textView.setText("Number : " + random);
}
}
# 1 楼答案
我不知道我是否理解了这个问题,但是如果您希望数据库中的每个单词都有两个数组,只需在活动中调用
allRecords()
方法,然后扫描列表,将两个单独的数组eng
和turk
装箱然后随机选取4个整数(比如
0,1,2,3
),并访问这些位置来设置文本视图中的文本(使用其中一个来检索英语单词)如果我不明白你的要求,请告诉我