1、ExtJs:代碼挺多的，部分功能同事幫實(shí)現(xiàn)Action:增刪除改查分頁(yè)全在里面。public class UserCRUDAction extends ActionSupport implements ServletRequestAware, ServletResponseAware private HttpServletResponse response;private HttpServletRequest request;private Integer empno;private String ename;private String job;private Integer sal;pri

2、vate String start;private String limit;public String getStart( return start;public void setStart(String start this.start = start;public String getLimit( return limit;public void setLimit(String limit this.limit = limit;public Integer getEmpno( return empno;public void setEmpno(Integer empno this.emp

3、no = empno;public String getEname( return ename;public void setEname(String ename this.ename = ename;public String getJob( return job;public void setJob(String job this.job = job;public Integer getSal( return sal;public void setSal(Integer sal this.sal = sal;public void setServletResponse(HttpServle

4、tResponse response this.response=response;public void setServletRequest(HttpServletRequest request this.request=request;public String userList(throws Exceptionif(start=null|(.equals(startthis.start = 0;if(limit=null|(.equals(limitthis.limit = 10;UserDAO dao=new UserDAOImpl(;response.setHeader(Cache-

5、Control, no-cache;response.setContentType(text/json;charset=UTF-8;response.getWriter(.write(sb.toString(;return null;public String addUser(throws ExceptionUser u=new User(;u.setEmpno(new Random(.nextInt(1000;u.setEname(ename;u.setJob(job;u.setSal(sal;u.setDeptno(20;UserDAO dao=new UserDAOImpl(;dao.a

6、ddUser(u;response.reset(;response.getWriter(.write(success:true;return null;public String updateUser(throws ExceptionUser u=new User(;u.setEmpno(empno;u.setEname(ename;u.setJob(job;u.setSal(sal;UserDAO dao=new UserDAOImpl(;dao.updateUser(u;response.reset(;response.getWriter(.write(success:true;retur

7、n null;public String delUser(throws ExceptionUserDAO dao=new UserDAOImpl(;dao.delUser(empno;response.reset(;response.getWriter(.write(success:true;return null;DAO:public class UserDAOImpl implements UserDAO public void addUser(User u Connection con=null;PreparedStatement stmt=null;trycon=DbUtil.getC

8、onnection(;stmt=con.prepareStatement(insert into emp(empno,ename,job,sal,deptno values(?,?,?,?,?;stmt.setInt(1, u.getEmpno(;stmt.setString(2, u.getEname(;stmt.setString(3, u.getJob(;stmt.setInt(4, u.getSal(;stmt.setInt(5, u.getDeptno(;stmt.executeUpdate(;catch(Exception ee.printStackTrace(;finallypu

9、blic void updateUser(User u Connection con=null;PreparedStatement stmt=null;trycon=DbUtil.getConnection(;stmt=con.prepareStatement(update emp set ename=?,job=?,sal=? where empno=?;stmt.setString(1, u.getEname(;stmt.setString(2, u.getJob(;stmt.setInt(3,u.getSal(;stmt.setInt(4, u.getEmpno(;stmt.execut

10、eUpdate(;catch(Exception ee.printStackTrace(;finallypublic void delUser(Integer empno Connection con=null;PreparedStatement stmt=null;trycon=DbUtil.getConnection(;stmt=con.prepareStatement(delete from emp where empno=?;stmt.setInt(1, empno;stmt.executeUpdate(;catch(Exception ee.printStackTrace(;finallyOverridepublic int getCount(String ename Connection con=null; PreparedStatement stmt=null; ResultSet rs=null;int count