Database -Mysql,Oracle
MY SQL / ECLIPSE 연결하기 연동
은은하게미친자
2022. 6. 24. 10:09
728x90
C:\Program Files (x86)\MySQL\Connector J 8.0
mysql-connector-java-8.0.29.jar
mysql-connector-java-8.0.29.jar
2.40MB
web_lib폴더 만들어서 복사하깅
* 연결 예제
|
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
|
/*
* 데이터베이스 연결 테스트 : my sql
* jar 파일 : mysql-connector-java-버전.jar (mysql-connector-java-8.0.29.jar)
*
* - DriverManager 클래스 - 드라이브 연결관리
* - Connection 클래스 : url, username, password
*/
package kr.co.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnTest01 {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver").newInstance(); // 불러오면 DriverManager가 관리함.
// URL 에 PORT 포함
String url = "jdbc:mysql://localhost:3306/scott?characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false";
String user = "root";
String password = "123456";
conn = DriverManager.getConnection(url, user, password);
System.out.println("연결성공!!");
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
|
cs |
|
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
package kr.co.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class DbSelectAll2 {
public static void main(String[] args) {
// empEntity = empBean = empVo = empDTO = empDomain
Connection conn = null;
ArrayList<EmpEntity> list = new ArrayList<EmpEntity>();
try {
Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
Statement stmt = null; // java.sql
ResultSet rs = null; // java.sql
String url = "jdbc:mysql://localhost:3306/scott?characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false";
String id = "root";
String pw = "123456";
conn = DriverManager.getConnection(url, id, pw);
System.out.println("DB CONNECT");
//======================== 질의문을 작성
String query = "select empno, ename, job , hiredate from emp";
// stmt 생성
stmt = conn.createStatement();
// 질의문 실행
rs = stmt.executeQuery(query);
System.out.println("emp 전체 조회");
System.out.println("empno ename job hiredate");
// 인덱스로 받을수도잇고, 필드로도 받을수잇음.
while(rs.next()) {
//my sql db 는 인덱스 1부터
int empno = rs.getInt(1);
String ename = rs.getNString(2);
String job = rs.getString(3);
String hiredate = rs.getString(4);
EmpEntity emp = new EmpEntity(empno, ename, job, 0, hiredate, 0.0, 0.0, 0);
list.add(emp);
}
for (EmpEntity s : list) {
System.out.println(s.toString());
}
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
|
cs |
728x90