protected void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); response.setCharacterEncoding("utf-8"); PrintWriter out = response.getWriter(); request.setCharacterEncoding("utf-8"); String page = request.getParameter("page"); EmpDAO dao = new EmpDAO(); if (page != null) { int p = Integer.parseInt(page); List<Emp> empList = dao.findAll(p); JSONObject jobj = new JSONObject(); jobj.put("ret", 0); jobj.put("msg", "ok"); jobj.put("list", empList); out.print(jobj); } else { List<Emp> empList = dao.findAll(); // 相应JSON的格式:{ret:xxxx,msg:xxxxx,......} // JSONArray arr = JSONArray.fromCollection(empList); JSONObject jobj = new JSONObject(); jobj.put("ret", 0); jobj.put("msg", "ok"); jobj.put("list", empList); out.print(jobj); } // for (Emp emp : empList) { // out.print(emp.toString()+"<br />"); // } }
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()); }
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); } }
@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); } } }