在TEXTVIEW中添加分数

Question

我的应用程序中有一个autocompletetextview、一个textview和一个按钮。单击该按钮时，它将在数据库中搜索与TextView中的单词相等的单词。

flow：•Word from autocompletetextview（通过单击imagebuttons输入）>Search Word（使用按钮）条件：•如果Word在数据库中，textview将显示相应的分数（也在dbase中），则autocompletetextview应清除该文本（生成另一个Word）。

问题：1。我如何添加第一个分数，它已经在textview和下一个单词的分数？2.如何禁用AutoCompleteTextView中的“EditText”效果？我需要这样做来“优先”只通过imagebuttons进行输入（我的意思是，无论何时您有一个autocompletetextview，它就像您有一个编辑文本一样）。

如有任何建议，将不胜感激。我不知道怎么做所以我问这个问题。我是android编程的新手。我希望你能理解我的问题和我的语法：）

下面是我使用的代码：mainactivity.java

DBAdapter dbHelper;
TextView score;
protected static final String TAG = null;
String generatedString = " ";
AutoCompleteTextView text;
TextView timer;
ImageButton searchWord;
ImageButton image1, image2, image3, image4, image5, image6, image7, image8,
image9, image10, image11, image12, image13, image14, image15, image16;
private CountDownTimer countDownTimer;
private boolean timeHasStarted = false;


@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

dbHelper =new DBAdapter(this);
searchWord = (ImageButton) findViewById(R.id.searchWord);
image1 = (ImageButton) findViewById(R.id.Button1);

timer = (TextView) this.findViewById(R.id.timer);
timer.setText("00:00:30");
countDownTimer = new MyCountDownTimer(30000,1000);

final AutoCompleteTextView text = (AutoCompleteTextView) findViewById(R.id.textHere);

final ImageButton image1 = (ImageButton) findViewById(R.id.Button1);

final int[] myPics = { images here };


int rando = (int)(Math.random()* 5);
image1.setImageResource(myPics[rando]);
image1.setId(myPics[rando]);


OnClickListener myCommoClickListner = new OnClickListener(){

@Override
public void onClick(View arg0) {
// start timer  when 1 of 16 imagebutton is click ( display letters = image in imagebutton
};



image1.setOnClickListener(myCommoClickListner);
}

@TargetApi(Build.VERSION_CODES.GINGERBREAD) @SuppressLint("NewApi") public class MyCountDownTimer extends CountDownTimer{
public MyCountDownTimer(long millisInFuture, long countDownInterval){
super(millisInFuture, countDownInterval);
}

@TargetApi(Build.VERSION_CODES.GINGERBREAD) @SuppressLint("NewApi") @Override
public void onTick(long millisUntilFinished) {
long millis = millisUntilFinished;  
String hms = String.format("%02d:%02d:%02d", TimeUnit.MILLISECONDS.toHours(millis),  
TimeUnit.MILLISECONDS.toMinutes(millis) - TimeUnit.HOURS.toMinutes(TimeUnit.MILLISECONDS.toHours(millis)),  
TimeUnit.MILLISECONDS.toSeconds(millis) - TimeUnit.MINUTES.toSeconds(TimeUnit.MILLISECONDS.toMinutes(millis)));  
System.out.println(hms);  
timer.setText(hms);  

}

@Override
public void onFinish() {
timer.setText("Time's Up!");
}
}

//Search
public void viewWord(View view)
{
score = (TextView)findViewById(R.id.yourScore);
String s1= search.getText().toString();
String s2= dbHelper.getData(s1);
score.setText(s2);
}
}

这是我的dbadapter中搜索代码时的代码：公共字符串getData（String word）{SQLiteDatabase db=helper.getWritableDatabase（）；String[]columns={dbhelper.word,dbhelper.score}；Cursor Cursor=db.query(dbhelper.table_name,columns,dbhelper.word+“=‘”+word+“’”,null,null,null,null,null,null）；StringBuffer buffer=new StringBuffer（）；while（Cursor.MoveTonext（））{int index1=Cursor.getColumnIndex（dbhelper.word）；int index2==Cursor.GetString(index2)；buffer.Append（score+“\n”）；}返回buffer.ToString（）；}

Answer 1

你的问题有点不清楚，但我会试着根据我的解释来回答：

1. 如何添加第一个分数，该分数已经在textview中，以及下一个单词的分数？

我假设你想把第一个分数和下一个分数相加？

public String getData(String word)
    {
    SQLiteDatabase db = helper.getWritableDatabase();
    String[] columns={DBHelper.WORD, DBHelper.SCORE};
    Cursor cursor=db.query(DBHelper.TABLE_NAME, columns, DBHelper.WORD+ "= '"+word+"'", null, null, null, null);
    StringBuffer buffer = new StringBuffer();
    cursor.moveToFirst(); 
    // Given that you are only finding one instance, while is not necessary and in fact may not do what you want. It will return the LAST instance of your query value
        int index1 =cursor.getColumnIndex(DBHelper.WORD);
        int index2 =cursor.getColumnIndex(DBHelper.SCORE);
        String words =cursor.getString(index1);
        String score =cursor.getString(index2);

    cursor=db.query(DBHelper.TABLE_NAME, columns, "*", null, null, null, null); // "*" should be the wildcard for SQL

        cursor.moveToNext();
        int indexSecond1 =cursor.getColumnIndex(DBHelper.WORD);
        int indexSecond2 =cursor.getColumnIndex(DBHelper.SCORE);
        // Do something with the data


        buffer.append(score +"\n");

    return buffer.toString();
}