Android开发：点击提交按钮存储多组件数据至SQLite数据库

Hey there! Glad you got this sorted out by adding a multi-parameter insertLabel method—let me walk through how this solution works in detail so others (and future you!) can follow along easily.

Step 1: Extend Your DatabaseHandler with a Multi-Parameter Insert Method #

The key fix here is creating an insert method that accepts all the values you need to store, instead of a single label. This lets you bundle up all your UI data and save it in one database operation. Here's what that might look like:

public class DatabaseHandler extends SQLiteOpenHelper {
    // Replace these with your actual database/table/column names
    private static final String DATABASE_NAME = "UserFormDB";
    private static final String TABLE_FORM_DATA = "form_data";
    private static final String COLUMN_ID = "id";
    private static final String COLUMN_SPINNER1 = "spinner1_val";
    private static final String COLUMN_SPINNER2 = "spinner2_val";
    private static final String COLUMN_SPINNER3 = "spinner3_val";
    private static final String COLUMN_CHECKBOXES = "checkboxes_val";
    private static final String COLUMN_EDITTEXT = "edittext_val";

    // ... Your existing constructor and onUpgrade() code ...

    // New method to insert all form data at once
    public void insertFormData(String spinner1, String spinner2, String spinner3, String checkboxes, String editText) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues values = new ContentValues();

        // Map each input value to its corresponding database column
        values.put(COLUMN_SPINNER1, spinner1);
        values.put(COLUMN_SPINNER2, spinner2);
        values.put(COLUMN_SPINNER3, spinner3);
        values.put(COLUMN_CHECKBOXES, checkboxes);
        values.put(COLUMN_EDITTEXT, editText);

        // Insert the row into the table
        db.insert(TABLE_FORM_DATA, null, values);
        db.close(); // Always close the database connection when done
    }
}

Step 2: Collect All UI Values in Your Save Button Click Listener #

Next, you need to grab the current values from each spinner, checkbox, and edit text when the save button is tapped. For multiple checkboxes, a common approach is to concatenate the text of all selected ones into a single string (you can use a different format if needed, like a JSON array).

// Assuming you've initialized your UI elements in onCreate()
Button saveButton = findViewById(R.id.save_btn);
Spinner spinner1 = findViewById(R.id.spinner1);
Spinner spinner2 = findViewById(R.id.spinner2);
Spinner spinner3 = findViewById(R.id.spinner3);
EditText editText = findViewById(R.id.input_edittext);
CheckBox cb1 = findViewById(R.id.checkbox1);
CheckBox cb2 = findViewById(R.id.checkbox2);
CheckBox cb3 = findViewById(R.id.checkbox3); // Add more as needed

saveButton.setOnClickListener(v -> {
    // Get spinner selections
    String s1Val = spinner1.getSelectedItem().toString();
    String s2Val = spinner2.getSelectedItem().toString();
    String s3Val = spinner3.getSelectedItem().toString();

    // Get edit text content
    String etVal = editText.getText().toString().trim();

    // Collect selected checkboxes
    StringBuilder cbBuilder = new StringBuilder();
    if (cb1.isChecked()) cbBuilder.append(cb1.getText()).append(", ");
    if (cb2.isChecked()) cbBuilder.append(cb2.getText()).append(", ");
    if (cb3.isChecked()) cbBuilder.append(cb3.getText()).append(", ");

    // Remove trailing comma if needed
    String cbVal = cbBuilder.length() > 0 ? cbBuilder.substring(0, cbBuilder.length() - 2) : "";

    // Save to database
    DatabaseHandler dbHandler = new DatabaseHandler(MainActivity.this);
    dbHandler.insertFormData(s1Val, s2Val, s3Val, cbVal, etVal);

    // Optional: Confirm success to the user
    Toast.makeText(MainActivity.this, "Data saved!", Toast.LENGTH_SHORT).show();
});

Step 3: Double-Check Your Database Table Structure #

Make sure your table creation SQL includes all the columns you're trying to save. If you already created the table earlier, you’ll need to either upgrade the database or uninstall/reinstall your app to apply the changes:

@Override
public void onCreate(SQLiteDatabase db) {
    String CREATE_TABLE = "CREATE TABLE " + TABLE_FORM_DATA + "("
            + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
            + COLUMN_SPINNER1 + " TEXT,"
            + COLUMN_SPINNER2 + " TEXT,"
            + COLUMN_SPINNER3 + " TEXT,"
            + COLUMN_CHECKBOXES + " TEXT,"
            + COLUMN_EDITTEXT + " TEXT" + ")";
    db.execSQL(CREATE_TABLE);
}

This approach keeps your code clean by separating database logic from UI logic, and ensures all your form data gets saved in one go. Great job figuring out the core fix of adding that multi-parameter insert method!

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