gitmagochi

Untitled

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();
        }
    }
}