将 ArrayList 数据发送到 MySQL 表的教程

public class Profile {
    private Integer id;
    private String id_card;
    private String name;
    private String phone;
    private String address;

    public Profile() {
        super();
    }

    public Profile(Integer id, String id_card, String name, String phone,
                   String address) {
        super();
        this.id = id;
        this.id_card = id_card;
        this.name = name;
        this.phone = phone;
        this.address = address;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getIdCard() {
        return id_card;
    }

    public void setIdCard(String id_card) {
        this.id_card = id_card;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}

private List<Profile> processResponse(String response){
    List<Profile> myProfileList = new ArrayList<>();

    try {
        JSONObject jsonObj = new JSONObject(response);
        JSONArray jsonArray = jsonObj.getJSONArray("params_name1");

        for(int i = 0; i < jsonArray.length(); i++){
            JSONObject obj = jsonArray.getJSONObject(i);

            Profile myProfile = new Profile();
            myProfile.setId(obj.getInt("id"));
            myProfile.setIdCard(obj.getString("id_card"));
            myProfile.setName(obj.getString("full_name"));
            myProfile.setPhone( obj.getString("phone_num") );
            myProfile.setAddress(obj.getString("adress1"));

            myProfileList.add(myProfile);
        }
    } catch (JSONException e) {
        e.printStackTrace(); // 建议使用更完善的错误处理机制
    }
    return myProfileList;
}

ArrayList<String> namesList = new ArrayList<>(Arrays.asList( "alex", "brian", "charles") );

List<Profile> list = new ArrayList<>();
int iNum = 0;
for(String name : namesList)
{
    iNum++;
    Profile myProfile = new Profile();
    myProfile.setId(iNum);
    myProfile.setName(name);
    list.add(myProfile);
}

private class SendDataTask extends AsyncTask<List<Profile>, Void, Boolean> {

    @Override
    protected Boolean doInBackground(List<Profile>... lists) {
        List<Profile> profileList = lists[0];
        // TODO: Implement your network logic here to send data to PHP script.
        // You can use HttpURLConnection or libraries like Retrofit or Volley.
        // Example using HttpURLConnection (requires proper exception handling):

        for (Profile profile : profileList) {
            try {
                URL url = new URL("http://your-server.com/your-php-script.php"); // Replace with your PHP script URL
                HttpURLConnection connection = (HttpURLConnection) url.openConnection();
                connection.setRequestMethod("POST");
                connection.setDoOutput(true);

                // Prepare data to send (e.g., using URLEncodedFormEntity)
                String postData = "id=" + profile.getId() + "&name=" + profile.getName() + "&address=" + profile.getAddress(); // And other fields

                OutputStream os = connection.getOutputStream();
                BufferedWriter writer = new BufferedWriter(new OutputStreamWriter(os, "UTF-8"));
                writer.write(postData);
                writer.flush();
                writer.close();
                os.close();

                int responseCode = connection.getResponseCode();
                if (responseCode != HttpURLConnection.HTTP_OK) {
                    // Handle error (e.g., log the error)
                    Log.e("SendDataTask", "HTTP error code: " + responseCode);
                    return false;
                }

                // Read the response from the server (optional)
                BufferedReader reader = new BufferedReader(new InputStreamReader(connection.getInputStream()));
                String line;
                StringBuilder response = new StringBuilder();
                while ((line = reader.readLine()) != null) {
                    response.append(line);
                }
                reader.close();
                connection.disconnect();

                Log.d("SendDataTask", "Server response: " + response.toString());
            } catch (Exception e) {
                // Handle exceptions (e.g., network errors)
                Log.e("SendDataTask", "Exception during network request: " + e.getMessage(), e);
                return false;
            }
        }
        return true; // Indicate success
    }

    @Override
    protected void onPostExecute(Boolean success) {
        if (success) {
            // Update UI to indicate success
            Toast.makeText(getApplicationContext(), "Data sent successfully!", Toast.LENGTH_SHORT).show();
        } else {
            // Update UI to indicate failure
            Toast.makeText(getApplicationContext(), "Failed to send data.", Toast.LENGTH_SHORT).show();
        }
    }
}

<?php
// Database credentials
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Get data from POST request
$id = $_POST["id"];
$name = $_POST["name"];
$address = $_POST["address"];

// Prepare SQL statement
$sql = "INSERT INTO your_table (id, name, address) VALUES ('$id', '$name', '$address')";

// Execute SQL statement
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Close connection
$conn->close();
?>

public void publishContact(View v) {
    List<Profile> list = new ArrayList<>();
    // Fill the list with Profile objects (e.g., from grantUp() method)
    ArrayList<String> namesList = new ArrayList<>(Arrays.asList( "alex", "brian", "charles") );

    int iNum = 0;
    for(String name : namesList)
    {
        iNum++;
        Profile myProfile = new Profile();
        myProfile.setId(iNum);
        myProfile.setName(name);
        list.add(myProfile);
    }

    // Execute the AsyncTask to send the data
    new SendDataTask().execute(list);
}