如何从MySQL获取数据到Android Studio并在TextView、ImageView展示

Hey there! Let's walk through exactly how to get your dictionary data from MySQL into your Android app's UI elements. Since Android apps shouldn't connect directly to MySQL (it's insecure and violates best practices), we'll use a backend API as a middleman—this is the standard approach for most mobile apps that interact with databases.

1. First: Build a Backend API to Expose MySQL Data #

You'll need a simple server-side API that connects to your MySQL database, runs queries, and returns data in JSON format (easy for Android to parse). I'll use Java Spring Boot as an example, but you could also use PHP, Node.js, etc.—the core idea is the same.

Example Spring Boot Setup: #

• Entity Class (matches your MySQL dictionary table):

@Entity
@Table(name = "dictionary")
public class WordEntry {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String word;
    private String definition;
    private String imageUrl; // Or store image as BLOB, but URL is easier for Android

    // Getters and Setters
}

• Repository Interface (handles database queries):

public interface WordEntryRepository extends JpaRepository<WordEntry, Long> {
    Optional<WordEntry> findByWord(String word); // Query for a specific word
}

• Controller (exposes API endpoint):

@RestController
@RequestMapping("/api/dictionary")
public class DictionaryController {
    @Autowired
    private WordEntryRepository repository;

    @GetMapping("/{word}")
    public ResponseEntity<WordEntry> getWord(@PathVariable String word) {
        Optional<WordEntry> entry = repository.findByWord(word);
        return entry.map(ResponseEntity::ok)
                .orElseGet(() -> ResponseEntity.notFound().build());
    }
}

Deploy this API to a server (like a VPS, Heroku, or AWS) so your Android app can reach it over the internet.

2. Android App Setup: Add Dependencies #

Add these to your app-level build.gradle (Module level) to handle network requests and image loading:

// Retrofit for network calls
implementation 'com.squareup.retrofit2:retrofit:2.9.0'
implementation 'com.squareup.retrofit2:converter-gson:2.9.0'

// Glide for image loading
implementation 'com.github.bumptech.glide:glide:4.15.1'
annotationProcessor 'com.github.bumptech.glide:compiler:4.15.1'

Don't forget to add the INTERNET permission to your AndroidManifest.xml:

<uses-permission android:name="android.permission.INTERNET" />

3. Create Data Model & API Interface in Android #

First, make a model class that matches the JSON response from your API:

public class WordEntry {
    private Long id;
    private String word;
    private String definition;
    private String imageUrl;

    // Getters and Setters
}

Then create a Retrofit API interface:

public interface DictionaryApi {
    @GET("/api/dictionary/{word}")
    Call<WordEntry> getWord(@Path("word") String word);
}

4. Fetch Data & Display It #

In your Activity or Fragment, set up Retrofit, make the network call, and update the UI. Important: Never run network calls on the main thread—use Retrofit's callbacks or Kotlin Coroutines.

Example with Callbacks (Java): #

public class DictionaryActivity extends AppCompatActivity {
    private TextView wordTextView;
    private TextView definitionTextView;
    private ImageView wordImageView;

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

        wordTextView = findViewById(R.id.word_text);
        definitionTextView = findViewById(R.id.definition_text);
        wordImageView = findViewById(R.id.word_image);

        // Initialize Retrofit
        Retrofit retrofit = new Retrofit.Builder()
                .baseUrl("https://your-api-domain.com/") // Replace with your API URL
                .addConverterFactory(GsonConverterFactory.create())
                .build();

        DictionaryApi api = retrofit.create(DictionaryApi.class);
        Call<WordEntry> call = api.getWord("apple"); // Example word to fetch

        call.enqueue(new Callback<WordEntry>() {
            @Override
            public void onResponse(Call<WordEntry> call, Response<WordEntry> response) {
                if (response.isSuccessful() && response.body() != null) {
                    WordEntry entry = response.body();
                    // Update TextView
                    wordTextView.setText(entry.getWord());
                    definitionTextView.setText(entry.getDefinition());
                    // Load ImageView with Glide
                    Glide.with(DictionaryActivity.this)
                            .load(entry.getImageUrl())
                            .placeholder(R.drawable.placeholder) // Optional placeholder
                            .into(wordImageView);
                } else {
                    // Handle error (e.g., word not found)
                    wordTextView.setText("Word not found");
                }
            }

            @Override
            public void onFailure(Call<WordEntry> call, Throwable t) {
                // Handle network error
                wordTextView.setText("Network error: " + t.getMessage());
            }
        });
    }
}

If You're Storing Images as BLOB in MySQL: #

If your MySQL table stores images as binary BLOB data instead of URLs, modify your API to return the image as a Base64 string. Then in Android, convert the Base64 string to a Bitmap and set it to the ImageView:

// Example: Convert Base64 string to Bitmap
String base64Image = entry.getImageBase64();
byte[] decodedString = Base64.decode(base64Image, Base64.DEFAULT);
Bitmap decodedByte = BitmapFactory.decodeByteArray(decodedString, 0, decodedString.length);
wordImageView.setImageBitmap(decodedByte);

Pro Tips to Avoid Headaches #

• Use ViewModel & LiveData: For better lifecycle management (prevents crashes when rotating the screen).
• Add Error Handling: Show toast messages or retry buttons for network failures.
• Use HTTPS: Always serve your API over HTTPS to keep data secure.
• Cache Data: Use Room database to cache frequent searches so users don't need internet every time.

内容的提问来源于stack exchange，提问作者Raymund Balatayo