[java] Apache Derby에서 데이터를 삽입, 조회, 수정, 삭제하는 방법은 무엇인가요?

28 Nov 2023

java

1. 데이터 삽입 (INSERT)

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DerbyExample {
    public static void main(String[] args) {
        String url = "jdbc:derby:/path/to/database";
        String username = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, username, password);
             PreparedStatement stmt = conn.prepareStatement("INSERT INTO table_name (column1, column2) VALUES (?, ?)")) {
            
            stmt.setString(1, "value1");
            stmt.setString(2, "value2");
            
            stmt.executeUpdate();
            System.out.println("Data inserted successfully.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

2. 데이터 조회 (SELECT)

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DerbyExample {
    public static void main(String[] args) {
        String url = "jdbc:derby:/path/to/database";
        String username = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, username, password);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery("SELECT * FROM table_name")) {

            while (rs.next()) {
                String column1Value = rs.getString("column1");
                String column2Value = rs.getString("column2");
                System.out.println(column1Value + " - " + column2Value);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

3. 데이터 수정 (UPDATE)

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DerbyExample {
    public static void main(String[] args) {
        String url = "jdbc:derby:/path/to/database";
        String username = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, username, password);
             PreparedStatement stmt = conn.prepareStatement("UPDATE table_name SET column1 = ? WHERE column2 = ?")) {
             
            stmt.setString(1, "new_value");
            stmt.setString(2, "condition_value");
            
            int rowsUpdated = stmt.executeUpdate();
            System.out.println(rowsUpdated + " rows updated successfully.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

4. 데이터 삭제 (DELETE)

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DerbyExample {
    public static void main(String[] args) {
        String url = "jdbc:derby:/path/to/database";
        String username = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, username, password);
             PreparedStatement stmt = conn.prepareStatement("DELETE FROM table_name WHERE column1 = ?")) {
             
            stmt.setString(1, "value_to_delete");
            
            int rowsDeleted = stmt.executeUpdate();
            System.out.println(rowsDeleted + " rows deleted successfully.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

위의 예제 코드에서 jdbc:derby:/path/to/database는 Derby 데이터베이스의 경로를 나타내며, username 및 password는 데이터베이스에 연결하기 위한 사용자 자격 증명입니다. table_name과 column1, column2는 적절한 테이블 및 열 이름으로 대체해야 합니다.

더 자세한 내용은 Apache Derby 공식 문서를 참조하세요:

Apache Derby Documentation