mainactivity.java:
package com.example.myapplication;
import androidx.appcompat.app.AppCompatActivity;
import android.os.Bundle;
import android.os.Handler;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
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);
// Hide the buttons and word views initially
findViewById(R.id.button_known).setVisibility(View.GONE);
findViewById(R.id.button_unknown).setVisibility(View.GONE);
findViewById(R.id.textView_word).setVisibility(View.GONE);
findViewById(R.id.textView_pronunciation).setVisibility(View.GONE);
findViewById(R.id.textView_meaning).setVisibility(View.GONE);
// Set button listeners
Button knownButton = findViewById(R.id.button_known);
knownButton.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
knownCount++;
showMeaning();
}
});
Button unknownButton = findViewById(R.id.button_unknown);
unknownButton.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
unknownCount++;
showMeaning();
}
});
}
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();
findViewById(R.id.button_known).setVisibility(View.VISIBLE);
findViewById(R.id.button_unknown).setVisibility(View.VISIBLE);
findViewById(R.id.textView_word).setVisibility(View.VISIBLE);
findViewById(R.id.textView_pronunciation).setVisibility(View.VISIBLE);
findViewById(R.id.textView_meaning).setVisibility(View.VISIBLE);
} 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:
loadWords();
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:
<?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">
<TextView
android:id="@+id/textView_word"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Word"
android:textSize="24sp"
android:layout_centerHorizontal="true"
android:layout_marginTop="50dp"
android:visibility="gone"/>
<TextView
android:id="@+id/textView_pronunciation"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Pronunciation"
android:textSize="18sp"
android:layout_below="@id/textView_word"
android:layout_centerHorizontal="true"
android:layout_marginTop="20dp"
android:visibility="gone"/>
<TextView
android:id="@+id/textView_meaning"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Meaning"
android:textSize="18sp"
android:layout_below="@id/textView_pronunciation"
android:layout_centerHorizontal="true"
android:layout_marginTop="20dp"
android:visibility="gone"/>
<Button
android:id="@+id/button_known"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="认识"
android:layout_below="@id/textView_meaning"
android:layout_marginTop="50dp"
android:layout_alignParentStart="true"
android:layout_marginStart="50dp"
android:visibility="gone"/>
<Button
android:id="@+id/button_unknown"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="不认识"
android:layout_below="@id/textView_meaning"
android:layout_marginTop="50dp"
android:layout_alignParentEnd="true"
android:layout_marginEnd="50dp"
android:visibility="gone"/>
</RelativeLayout>