-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathJava232_Jdbc.java
More file actions
68 lines (57 loc) · 1.58 KB
/
Copy pathJava232_Jdbc.java
File metadata and controls
68 lines (57 loc) · 1.58 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
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();
}
}
}
}