gitmagochi

MySQL 연결
Java에서 MySQL 연결 예시
public class CreateCharacterHandler implements RequestHandler<Map<String, Object>, String> {
@Override
public String handleRequest(Map<String, Object> input, Context context) {
// AWS Secrets Manager 클라이언트 생성
AWSSecretsManager client = AWSSecretsManagerClientBuilder.standard().build();
String secretName = "gitmagotchi/database/credentials"; // AWS Secrets Manager에서 설정한 Secret 이름
String secret, connectionUrl, username, password;
// Secret 검색
try {
GetSecretValueRequest getSecretValueRequest = new GetSecretValueRequest().withSecretId(
secretName);
GetSecretValueResult getSecretValueResult = client.getSecretValue(
getSecretValueRequest);
secret = getSecretValueResult.getSecretString();
// JSON 파싱
JSONObject secretObj = new JSONObject(secret);
connectionUrl = secretObj.getString("url");
username = secretObj.getString("username");
password = secretObj.getString("password");
} catch (Exception e) {
throw new RuntimeException(e);
}
// 데이터베이스 연결 및 쿼리 실행
try (Connection conn = DriverManager.getConnection(connectionUrl, username, password)) {
String sql = "INSERT INTO character (user_id, name, exp, face_url, character_url) VALUES (?, ?, ?, ?, ?)";
try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
pstmt.setString(1, (String) input.get("name"));
pstmt.setString(2, (String) input.get("faceUrl"));
pstmt.setString(3, (String) input.get("characterUrl"));
int affectedRows = pstmt.executeUpdate();
// 성공적으로 삽입된 경우
if (affectedRows > 0) {
return "Character created successfully";
} else {
return "No character was created";
}
}
} catch (Exception e) {
e.printStackTrace();
return "Error in database operation: " + e.getMessage();
}
}
}