第二次修改作业-CSDN博客

本文链接：https://blog.csdn.net/JokeJaegerKing/article/details/139556276

mainactivity.java:

package com.example.myapplication;

import androidx.appcompat.app.AppCompatActivity;
import android.os.Bundle;
import android.os.Handler;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Random;

public class MainActivity extends AppCompatActivity {

private List<String> words = new ArrayList<>();
private List<String> pronunciations = new ArrayList<>();
private List<String> meanings = new ArrayList<>();
private int currentIndex = -1;
private int knownCount = 0;
private int unknownCount = 0;
private Handler handler = new Handler();

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

Button buttonKnown = findViewById(R.id.button_known);
Button buttonUnknown = findViewById(R.id.button_unknown);

buttonKnown.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
if (currentIndex != -1) {
knownCount++;
showMeaning();
}
}
});

buttonUnknown.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
if (currentIndex != -1) {
unknownCount++;
showMeaning();
}
}
});

loadWords();
}

private void loadWords() {
new Thread(new Runnable() {
@Override
public void run() {
try {
String driverName = "net.sourceforge.jtds.jdbc.Driver";
String dbURL = "jdbc:jtds:sqlserver://xx.xxx.x.xx:xxxx;DatabaseName=单词表";
String userName = "tempsql";
String userPwd = "tempsql";

Class.forName(driverName);
Connection con = DriverManager.getConnection(dbURL, userName, userPwd);
String sql = "SELECT * FROM [四级]";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);

while (rs.next()) {
words.add(rs.getString("english"));
pronunciations.add(rs.getString("symbol"));
meanings.add(rs.getString("chinese"));
}

rs.close();
st.close();
con.close();

handler.post(new Runnable() {
@Override
public void run() {
if (words.size() > 0) {
showNextWord();
} else {
Toast.makeText(MainActivity.this, "No words available", Toast.LENGTH_SHORT).show();
}
}
});

} catch (Exception e) {
e.printStackTrace();
handler.post(new Runnable() {
@Override
public void run() {
Toast.makeText(MainActivity.this, "Failed to load words", Toast.LENGTH_SHORT).show();
}
});
}
}
}).start();
}

private void showNextWord() {
Random random = new Random();
currentIndex = random.nextInt(words.size());
TextView wordView = findViewById(R.id.textView_word);
TextView pronunciationView = findViewById(R.id.textView_pronunciation);
TextView meaningView = findViewById(R.id.textView_meaning);

wordView.setText(words.get(currentIndex));
pronunciationView.setText(pronunciations.get(currentIndex));
meaningView.setText("");
}

private void showMeaning() {
TextView meaningView = findViewById(R.id.textView_meaning);
meaningView.setText(meanings.get(currentIndex));
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.main_menu, menu);
return true;
}

@Override
public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) {
case R.id.menu_start:
if (!words.isEmpty()) {
showNextWord();
}
return true;
case R.id.menu_end:
showResult();
return true;
default:
return super.onOptionsItemSelected(item);
}
}

private void showResult() {
Toast.makeText(this, "认识的单词数量: " + knownCount + "\n不认识的单词数量: " + unknownCount, Toast.LENGTH_LONG).show();
}
}

activity_main:

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity">

main_menu: