package com.sukgi.db;
import java.util.List;
public class Test {
public static void main(String[] args) {
EmployeesDAO dao = new EmployeesDAO();
List<EmployeesDTO> result = dao.selectDepartments();
for (int i = 0; i < result.size(); i++) {
System.out.println(result.get(i).getDept_no() + ":");
System.out.println(result.get(i).getDept_name());
}
System.out.println(result);
List<EmployeesDTO> result2 = dao.selectEmployees();
for (int j = 0; j < result2.size(); j++) {
System.out.print(result2.get(j).getEmp_no()+" : ");
System.out.print(result2.get(j).getBirth_date()+" : ");
System.out.print(result2.get(j).getFirst_name()+" : ");
System.out.print(result2.get(j).getLast_name()+" : ");
System.out.print(result2.get(j).getGender()+" : ");
System.out.println(result2.get(j).getHire_date());
}
}
}
d009:
Customer Service
d005:
Development
d002:
Finance
d003:
Human Resources
d001:
Marketing
d004:
Production
d006:
Quality Management
d008:
Research
d007:
Sales
[com.sukgi.db.EmployeesDTO@10b48321, com.sukgi.db.EmployeesDTO@6b67034, com.sukgi.db.EmployeesDTO@16267862, com.sukgi.db.EmployeesDTO@453da22c, com.sukgi.db.EmployeesDTO@71248c21, com.sukgi.db.EmployeesDTO@442675e1, com.sukgi.db.EmployeesDTO@6166e06f, com.sukgi.db.EmployeesDTO@49e202ad, com.sukgi.db.EmployeesDTO@1c72da34]
10001 : 1953-09-02 : Georgi : Facello : M : 1986-06-26
10002 : 1964-06-02 : Bezalel : Simmel : F : 1985-11-21
10003 : 1959-12-03 : Parto : Bamford : M : 1986-08-28
10004 : 1954-05-01 : Chirstian : Koblick : M : 1986-12-01
10005 : 1955-01-21 : Kyoichi : Maliniak : M : 1989-09-12
10006 : 1953-04-20 : Anneke : Preusig : F : 1989-06-02
10007 : 1957-05-23 : Tzvetan : Zielinski : F : 1989-02-10
10008 : 1958-02-19 : Saniya : Kalloufi : M : 1994-09-15
10009 : 1952-04-19 : Sumant : Peac : F : 1985-02-18
10010 : 1963-06-01 : Duangkaew : Piveteau : F : 1989-08-24
'2023.11.21-2024.05.31' 카테고리의 다른 글
231227 JAVA DBConnection (0) | 2023.12.27 |
---|---|
231226 JAVA EmployeesDTO (0) | 2023.12.27 |
231226 JAVA EmployeesDAO (1) | 2023.12.26 |
231226 JAVA DBConnection (0) | 2023.12.26 |
231226 JAVA DB01 (0) | 2023.12.26 |