public List<Emp> getEmp() throws SQLException {
        List<Emp> map = new ArrayList<Emp>();
        
        try {
            myCon = ConnectionFactory.getCon();
            PreparedStatement ps = myCon.prepareStatement("select empno, ename,job,sal from EMP");
            ResultSet results = ps.executeQuery();
            while (results.next()) {
                Emp form = new Emp();
                form.setId(results.getInt("empno"));
                form.setName(results.getString("ename"));
                form.setJob(results.getString("job"));
                form.setSal(results.getInt("sal"));
                map.add(form);
            }
            results.close();
            ps.close();
            myCon.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return map;
    } 

public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws java.io.IOException, ServletException {
        try {
            response.setContentType("application/json;charset=utf-8");
            EmpDao emp = new EmpDao();
            JSONObject json = new JSONObject();
            json.put("rows", emp.getEmp());
            json.append("page", 1);
            json.append("total", emp.getEmp().size());
            PrintWriter pw = response.getWriter();
            pw.print(json.toString());
            pw.close();
        } catch (JSONException ex) {
            Logger.getLogger(EmpServlet.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(EmpServlet.class.getName()).log(Level.SEVERE, null, ex);
        }
    }