package java0928_jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Java232_Jdbc { public static void main(String[] args) { Connection conn = null; Statement stmt = null; ResultSet rs = null; try { // 1. 드라이버 로딩 Class.forName("oracle.jdbc.OracleDriver"); // 2. 서버 연결 String url = "jdbc:oracle:thin://@127.0.0.1:1521:xe"; String username = "hr"; String password = "a1234"; conn = DriverManager.getConnection(url, username, password); // 3. 쿼리문을 실행하기 위한 Statement타입의 객체를 리턴 stmt = conn.createStatement(); // 4. 쿼리문을 실행한다. String sql = "SELECT * FROM departments ORDER BY department_id"; rs = stmt.executeQuery(sql); while (rs.next()) { int departId = rs.getInt("department_id"); String departName = rs.getString("department_name"); int manId = rs.getInt("manager_id"); int locId = rs.getInt("location_id"); System.out.printf("%d %s %d %s \n", departId, departName, manId, locId); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (rs != null) try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } if (stmt != null) try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } if (conn != null) try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }