231226 JAVA Test

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