带MySQL数据库的能够选择具体工作日的开关按钮Android闹钟设定代码

以下是一个基于Android的带有MySQL数据库的能够选择具体工作日的开关按钮的闹钟设定代码：

1. 在布局文件中添加以下代码：

<Switch
    android:id="@+id/switchMonday"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Monday"
    android:checked="true" />

<Switch
    android:id="@+id/switchTuesday"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Tuesday"
    android:checked="true" />

<Switch
    android:id="@+id/switchWednesday"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Wednesday"
    android:checked="true" />

<Switch
    android:id="@+id/switchThursday"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Thursday"
    android:checked="true" />

<Switch
    android:id="@+id/switchFriday"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Friday"
    android:checked="true" />

<Switch
    android:id="@+id/switchSaturday"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Saturday"
    android:checked="true" />

<Switch
    android:id="@+id/switchSunday"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Sunday"
    android:checked="true" />

<Button
    android:id="@+id/buttonSave"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Save" />

2. 在Java文件中添加以下代码：

public class MainActivity extends AppCompatActivity {

    private Switch switchMonday, switchTuesday, switchWednesday, switchThursday, switchFriday, switchSaturday, switchSunday;
    private Button buttonSave;

    private String URL = "http://YOUR_DOMAIN_NAME/insert.php"; // Replace YOUR_DOMAIN_NAME with your actual domain name
    private RequestQueue requestQueue;
    private StringRequest request;

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

        switchMonday = findViewById(R.id.switchMonday);
        switchTuesday = findViewById(R.id.switchTuesday);
        switchWednesday = findViewById(R.id.switchWednesday);
        switchThursday = findViewById(R.id.switchThursday);
        switchFriday = findViewById(R.id.switchFriday);
        switchSaturday = findViewById(R.id.switchSaturday);
        switchSunday = findViewById(R.id.switchSunday);

        buttonSave = findViewById(R.id.buttonSave);

        requestQueue = Volley.newRequestQueue(this);

        buttonSave.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                saveData();
            }
        });
    }

    private void saveData() {
        String monday = switchMonday.isChecked() ? "1" : "0";
        String tuesday = switchTuesday.isChecked() ? "1" : "0";
        String wednesday = switchWednesday.isChecked() ? "1" : "0";
        String thursday = switchThursday.isChecked() ? "1" : "0";
        String friday = switchFriday.isChecked() ? "1" : "0";
        String saturday = switchSaturday.isChecked() ? "1" : "0";
        String sunday = switchSunday.isChecked() ? "1" : "0";

        final ProgressDialog progressDialog = new ProgressDialog(this);
        progressDialog.setMessage("Saving data...");
        progressDialog.setCancelable(false);
        progressDialog.show();

        request = new StringRequest(Request.Method.POST, URL, new Response.Listener<String>() {
            @Override
            public void onResponse(String response) {
                progressDialog.dismiss();
                Toast.makeText(getApplicationContext(), "Data saved successfully", Toast.LENGTH_SHORT).show();
            }
        }, new Response.ErrorListener() {
            @Override
            public void onErrorResponse(VolleyError error) {
                progressDialog.dismiss();
                Toast.makeText(getApplicationContext(), error.getMessage(), Toast.LENGTH_SHORT).show();
            }
        }) {
            @Override
            protected Map<String, String> getParams() throws AuthFailureError {
                Map<String, String> params = new HashMap<>();
                params.put("monday", monday);
                params.put("tuesday", tuesday);
                params.put("wednesday", wednesday);
                params.put("thursday", thursday);
                params.put("friday", friday);
                params.put("saturday", saturday);
                params.put("sunday", sunday);
                return params;
            }
        };

        requestQueue.add(request);
    }
}

3. 创建一个名为"insert.php"的PHP文件，并将以下代码复制粘贴到该文件中：

<?php
    // Replace YOUR_MYSQL_HOST, YOUR_MYSQL_USERNAME, YOUR_MYSQL_PASSWORD, and YOUR_MYSQL_DATABASE_NAME with your actual MySQL database credentials
    $con = mysqli_connect("YOUR_MYSQL_HOST", "YOUR_MYSQL_USERNAME", "YOUR_MYSQL_PASSWORD", "YOUR_MYSQL_DATABASE_NAME") or die("Connection failed");

    $monday = $_POST['monday'];
    $tuesday = $_POST['tuesday'];
    $wednesday = $_POST['wednesday'];
    $thursday = $_POST['thursday'];
    $friday = $_POST['friday'];
    $saturday = $_POST['saturday'];
    $sunday = $_POST['sunday'];

    $query = "INSERT INTO alarms (monday, tuesday, wednesday, thursday, friday, saturday, sunday) VALUES ('$monday', '$tuesday', '$wednesday', '$thursday', '$friday', '$saturday', '$sunday')";

    if(mysqli_query($con, $query)) {
        echo "Data saved successfully";
    } else {
        echo "Error saving data";
    }

    mysqli_close($con);
?>

这样，当用户点击“保存”按钮时，将向MySQL数据库插入所选工作日的值，并显示相应的消息。