Example #1
0
 public static void main(String[] args) {
   // TODO Auto-generated method stub
   Scanner scan = new Scanner(System.in);
   System.out.print("사번:");
   int empno = scan.nextInt();
   EmpDAO dao = new EmpDAO();
   EmpDTO d = dao.empDetail(empno);
   System.out.println("사번:" + d.getEmpno());
   System.out.println("이름:" + d.getEname());
   System.out.println("직위:" + d.getJob());
   System.out.println("사수:" + d.getMgr());
   System.out.println("입사일:" + d.getHiredate());
   System.out.println("급여:" + d.getSal());
   System.out.println("성과급:" + d.getComm());
   System.out.println("부서번호:" + d.getDeptno());
 }
Example #2
0
 public void getFindData(String column, String fdata) {
   for (int i = model.getRowCount() - 1; i >= 0; i--) {
     model.removeRow(i);
   }
   EmpDAO dao = new EmpDAO();
   ArrayList<EmpDTO> list = dao.empFindData(column, fdata);
   for (EmpDTO d : list) {
     String[] data = {
       String.valueOf(d.getEmpno()),
       d.getEname(),
       d.getJob(),
       d.getHiredate().toString(),
       String.valueOf(d.getDeptno())
     };
     model.addRow(data);
   }
 }
Example #3
0
 @Override
 public void mouseClicked(MouseEvent e) {
   // TODO Auto-generated method stub
   if (e.getSource() == table) {
     if (e.getClickCount() == 2) {
       int row = table.getSelectedRow();
       String sabun = model.getValueAt(row, 0).toString();
       EmpDAO dao = new EmpDAO();
       EmpDTO d = dao.empDetailData(Integer.parseInt(sabun));
       String msg =
           "사번:"
               + d.getEmpno()
               + "\n"
               + "이름:"
               + d.getEname()
               + "\n"
               + "직위:"
               + d.getJob()
               + "\n"
               + "사수번호:"
               + d.getMgr()
               + "\n"
               + "입사일:"
               + d.getHiredate().toString()
               + "\n"
               + "급여:"
               + d.getSal()
               + "\n"
               + "성과급:"
               + d.getComm()
               + "\n"
               + "부서번호:"
               + d.getDeptno();
       JOptionPane.showMessageDialog(this, msg);
     }
   }
 }