EXTJS桌面系统-完整实例

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package com.poa.struts.action; import java.io.File; import java.io.IOException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import org.hibernate.Session; import com.poa.hibernate.Dao; import com.poa.hibernate.HibernateSessionFactory; import com.poa.po.Book; import com.poa.po.Booktype; import com.poa.po.Pay; import com.poa.po.Paytype; import com.poa.util.JsonUtil; import com.poa.vo.Books; import com.poa.vo.Pays; /** * MyEclipse Struts * Creation date: 09-30-2009 * * XDoclet definition: * @struts.action parameter="method" validate="true" */ public class PayAction extends DispatchAction { /* * Generated Methods */ /** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */ Dao dao = new Dao(); public Dao getDao() { return dao; } public void setDao(Dao dao) { this.dao = dao; } public ActionForward findAll(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { Session session = HibernateSessionFactory.getSession(); if(request.getSession().getAttribute("userId").toString() == ""){ return mapping.findForward("login"); } String userId = request.getSession().getAttribute("userId").toString(); String jsonString = ""; List<Paytype> pt = new ArrayList<Paytype>(); pt = session.createQuery("from Paytype where userid = "+userId+" order by id asc").list(); if(pt!=null){ jsonString = JsonUtil.pageFromListWithoutConfig(0, pt.size(), pt); }else{ jsonString ="{success:false,errors:{reason:'you didn't create payType!!'}}"; } try { response.setContentType("text/jsonString;charset=UTF-8"); response.getWriter().write(jsonString); response.getWriter().flush(); response.getWriter().close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public ActionForward addType(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { if(request.getSession().getAttribute("userId").toString() == ""){ return mapping.findForward("login"); } String title = request.getParameter("title"); String detail = request.getParameter("detail"); String json = ""; String userId = request.getSession().getAttribute("userId").toString(); Paytype bt = new Paytype(); bt.setDetail(detail); bt.setTitle(title); bt.setUserid(Long.parseLong(userId)); try{ dao.Save(bt); json = "{success:true}"; response.setContentType("text/json;charset=UTF-8"); response.getWriter().write(json); response.getWriter().flush(); response.getWriter().close(); }catch(Exception e){ try{ json = "{success:false}"; response.setContentType("text/json;charset=UTF-8"); response.getWriter().write(json); response.getWriter().flush(); response.getWriter().close(); }catch(Exception e1){ e1.printStackTrace(); } e.printStackTrace(); } return null; } public ActionForward findpayTypeById(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)throws Exception { String id = request.getParameter("Id"); if(request.getSession().getAttribute("userId").toString() == ""){ return mapping.findForward("login"); } String json = ""; String userId = request.getSession().getAttribute("userId").toString(); Paytype bt = new Paytype(); Map map = new HashMap(); map.put("id", id); map.put("userid", userId); bt = (Paytype) dao.findResult("Paytype", map); if(bt!=null){ json = "{success:true,data:"+JsonUtil.getJsonFromBean(bt)+"}"; response.setContentType("text/json;charset=UTF-8"); response.getWriter().write(json); response.getWriter().flush(); response.getWriter().close(); }else{ json = "{success:false}"; response.setContentType("text/json;charset=UTF-8"); response.getWriter().write(json); response.getWriter().flush(); response.getWriter().close(); } return null; } public ActionForward updatepayType(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)throws Exception { if(request.getSession().getAttribute("userId").toString() == ""){ return mapping.findForward("login"); } String title = request.getParameter("title"); String json=""; String detail = request.getParameter("detail"); String id = request.getParameter("id"); String userId = request.getSession().getAttribute("userId").toString(); Paytype bt = new Paytype(); Map map = new HashMap(); map.put("id", id); map.put("userid", userId); bt = (Paytype) dao.findResult("Paytype", map); if(bt!=null){ bt.setDetail(detail); bt.setTitle(title); dao.Update(bt); json = "{success:true,Id:'"+id+"'}"; response.setContentType("text/json;charset=UTF-8"); response.getWriter().write(json); response.getWriter().flush(); response.getWriter().close(); }else{ json = "{success:false}"; response.setContentType("text/json;charset=UTF-8"); response.getWriter().write(json); response.getWriter().flush(); response.getWriter().close(); } return null; } public ActionForward deletePayType(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { if(request.getSession().getAttribute("userId").toString() == ""){ return mapping.findForward("login"); } String id = request.getParameter("Id"); String json=""; Map map = new HashMap(); map.put("id", id); Paytype bt = (Paytype) dao.findResult("Paytype", map); dao.Delete(bt); if(bt != null){ json = "{success:true}"; }else{ json = "{success:false}"; } try { response.setContentType("text/json;charset=UTF-8"); response.getWriter().write(json); response.getWriter().flush(); response.getWriter().close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public ActionForward findAllpay(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { if(request.getSession().getAttribute("userId").toString() == ""){ return mapping.findForward("login"); } Session session=HibernateSessionFactory.getSession(); String userid="" ; String jsonString = ""; try{ userid = String.valueOf(request.getSession().getAttribute("userId")); }catch(Exception e){ userid = ""; } List<Pays> ps = new ArrayList<Pays>(); List list = session.createSQLQuery("select p.id,pt.id, p.pay_name,p.author,p.brief,p.price,p.times,pt.title from pay p ,paytype pt where p.type_id = pt.id and p.userid = "+userid).list(); for (int i=0;i<list.size();i++){ Object[] obj = (Object[])list.get(i); Pays p = new Pays(); p.setAuthor(obj[3].toString()); p.setBrief(obj[4].toString()); p.setId(Integer.parseInt(obj[0].toString())); p.setPayName(obj[2].toString()); p.setPayTypeId(Integer.parseInt(obj[1].toString())); p.setPrice(Integer.parseInt(o