Java 및 Alibaba Cloud SDK를 사용하여 클라우드 데이터베이스 시스템 구축

import com.aliyuncs.DefaultAcsClient;
import com.aliyuncs.IAcsClient;
import com.aliyuncs.exceptions.ClientException;
import com.aliyuncs.exceptions.ServerException;
import com.aliyuncs.profile.DefaultProfile;
import com.aliyuncs.rds.model.v20140815.*;

DefaultProfile profile = DefaultProfile.getProfile("cn-hangzhou", "<your-access-key>", "<your-secret-key>");
IAcsClient client = new DefaultAcsClient(profile);

CreateDatabaseRequest request = new CreateDatabaseRequest();
request.setDBInstanceId("<your-db-instance-id>");
request.setDBName("<your-db-name>");
try {
    CreateDatabaseResponse response = client.getAcsResponse(request);
    System.out.println("Database created: " + response.getRequestId());
} catch (ClientException e) {
    e.printStackTrace();
}

InsertDataRequest request = new InsertDataRequest();
request.setDBInstanceId("<your-db-instance-id>");
request.setDBName("<your-db-name>");
request.setTableName("<your-table-name>");

// 设置插入的数据
JSONObject data = new JSONObject();
data.put("id", 1);
data.put("name", "John Doe");

request.setItems(Collections.singletonList(data.toJSONString()));

try {
    InsertDataResponse response = client.getAcsResponse(request);
    System.out.println("Data inserted: " + response.getRequestId());
} catch (ClientException e) {
    e.printStackTrace();
}

GetDataRequest request = new GetDataRequest();
request.setDBInstanceId("<your-db-instance-id>");
request.setDBName("<your-db-name>");
request.setTableName("<your-table-name>");
request.setPrimaryKeyValue("id=1");

try {
    GetDataResponse response = client.getAcsResponse(request);
    List<JSONObject> items = JSON.parseArray(response.getItems(), JSONObject.class);
    for (JSONObject item : items) {
        System.out.println("id: " + item.getInteger("id") + ", name: " + item.getString("name"));
    }
} catch (ClientException e) {
    e.printStackTrace();
}

DeleteDataRequest request = new DeleteDataRequest();
request.setDBInstanceId("<your-db-instance-id>");
request.setDBName("<your-db-name>");
request.setTableName("<your-table-name>");
request.setPrimaryKeyValue("id=1");

try {
    DeleteDataResponse response = client.getAcsResponse(request);
    System.out.println("Data deleted: " + response.getRequestId());
} catch (ClientException e) {
    e.printStackTrace();
}