java 代码
- /*
- * Generated by MyEclipse Struts
- * Template path: templates/java/JavaClass.vtl
- */
- package com.axon.fable.sams.view.action;
- import java.io.IOException;
- import java.io.OutputStream;
- import java.util.List;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import jxl.Workbook;
- import jxl.write.WriteException;
- import jxl.write.biff.RowsExceededException;
- import org.apache.struts.action.ActionForm;
- import org.apache.struts.action.ActionForward;
- import org.apache.struts.action.ActionMapping;
- import org.hibernate.HibernateException;
- import org.hibernate.Query;
- import org.hibernate.Session;
- import org.hibernate.Transaction;
- import com.axon.fable.empolderpackage.out.OutJavaScript;
- import com.axon.fable.empolderpackage.page.Pager;
- import com.axon.fable.empolderpackage.string.MyPublic;
- import com.axon.fable.sams.common.BaseAction;
- import com.axon.fable.sams.exception.AppBusinessException;
- import com.axon.fable.sams.exception.AppSystemException;
- /**
- * MyEclipse Struts
- * Creation date: 06-28-2007
- *
- * XDoclet definition:
- * @struts.action path="/axon" name="axonForm" input="/samspage/zm/axon.jsp" parameter="method" scope="request" validate="true"
- * @struts.action-forward name="success" path="/samspage/zm/content.jsp"
- */
- public class StshipoperationAction extends BaseAction {
- /*
- * Generated Methods
- */
- private static Session session=null;
- private static Transaction ts=null;
- private static Query queryC=null;
- private static Query queryR=null;
- private static Query query=null;
- private static List list=null;
- private static Integer startRow;
- private static Integer ncurrentPage;
- private static Integer cell;
- private static String property;
- private static String sql;
- private static String type;
- private static String condition ;//是否导出当前页
- private static String currentPage;
- private static String from ;
- private static String pactdata;
- private static String voyagename;
- private static String voyageno;
- private static String dwt ;
- private static String hirefrom ;
- private static String deliveryposion ;
- private static String redeliveryposion ;
- private static String sheepowner ;
- private static String addr;
- private static String addcomm;
- private static String rent;
- private static String fileName ;
- private static OutputStream os;
- @Override
- public ActionForward findAll(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
- // TODO Auto-generated method stub
- return null;
- }
- @Override
- public ActionForward findById(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
- // TODO Auto-generated method stub
- return null;
- }
- @Override
- public ActionForward save(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
- // TODO Auto-generated method stub
- return null;
- }
- public static String strNull(Object nullStr,String newStr,Integer cell){
- if(nullStr==null||nullStr.equals("")){return newStr;}else{cell+=1;return nullStr+"";}
- }
- public static String getStr(String str,Integer cell){
- if(str==null||str.trim().equals("")){return "";}else{cell+=1;return ","+str;}
- }
- public static String getExcelTile(String title){
- if(title==null)
- return "";
- if(title.equals("modela.stsid"))
- return "编号";
- if(title.equals("modelc.pactdata"))
- return "合同日期";
- if(title.equals("modela.voyagename"))
- return "航名";
- if(title.equals("modela.voyageno"))
- return "航次";
- if(title.equals("modelc.dwt"))
- return "DWT";
- if(title.equals("modelc.hirefrom"))
- return "受载期";
- if(title.equals("modela.deliveryposion"))
- return "交船地点";
- if(title.equals("modela.redeliveryposion"))
- return "还船地点";
- if(title.equals("modelc.sheepowner"))
- return "联系人";
- if(title.equals("modelc.addr"))
- return "经纪人拥金";
- if(title.equals("modelc.addcomm"))
- return "ADD COMM";
- if(title.equals("modelc.rent"))
- return "租金";
- return "";
- }
- public ActionForward exporVoyagesInfoToExcel(ActionMapping mapping, ActionForm form,
- HttpServletRequest request, HttpServletResponse response) {
- list=null;
- startRow=0;
- ncurrentPage=1;
- cell=0;
- type =request.getParameter("type");
- condition =request.getParameter("condition");//是否导出当前页
- currentPage =request.getParameter("currentPage");
- from =request.getParameter("from");
- pactdata = request.getParameter("modelc.pactdata");
- voyagename = request.getParameter("modela.voyagename");
- voyageno = request.getParameter("modela.voyageno");
- dwt = request.getParameter("modelc.dwt");
- hirefrom = request.getParameter("modelc.hirefrom");
- deliveryposion = request.getParameter("modela.deliveryposion");
- redeliveryposion = request.getParameter("modela.redeliveryposion");
- sheepowner = request.getParameter("modelc.sheepowner");
- addr = request.getParameter("modelc.addr");
- addcomm = request.getParameter("modelc.addcomm");
- rent = request.getParameter("modelc.rent");
- if(type!=null&&type.trim().equals("1")){
- type ="已还船舶--费用未结清";
- }else{
- type ="已还船舶--费用已结清";
- }
- property =getStr(pactdata,cell)+getStr(voyagename,cell)+getStr(voyageno,cell)+getStr(dwt,cell)+getStr(hirefrom,cell)
- +getStr(deliveryposion,cell)+getStr(redeliveryposion,cell)+getStr(sheepowner,cell)+getStr(addr,cell)+getStr(addcomm,cell)
- +getStr(rent,cell);
- property = property.substring(1);
- String split[] = property.split(",");
- // System.out.println("-----------------------------property:"+property);
- if(currentPage!=null&&!currentPage.trim().equals("")){
- ncurrentPage =Integer.parseInt(currentPage);
- }else{
- OutJavaScript.outString(response, "Sorry! Failed to get information of pager.");
- return null;
- }
- try {
- session =getServiceLocator().getBaseHibernateDAO().getSession();
- sql ="select count(*) "+from;
- query =session.createQuery(sql);
- list = query.list();
- for (int i = 0; i < list.size(); i++) {
- totalSize =(Integer)list.get(i);
- if(totalSize!=0){
- pager =new Pager(ncurrentPage,totalSize);
- }
- }
- query =getServiceLocator().getBaseHibernateDAO().getSession().createQuery("select " +property+from);
- if(condition!=null&&condition.trim().equals("1")){//分页数据
- startRow = (ncurrentPage - 1)*pager.getPageSize();
- query.setFirstResult(startRow);
- query.setMaxResults(pager.getPageSize());
- // System.out.println("---------------------------------------------------query:"+query);
- }
- list = query.list();
- fileName = "shipInfo";
- os = response.getOutputStream();
- response.reset();
- response.setHeader("Content-disposition",
- "attachment; filename=" +fileName + ".xls");
- response.setContentType("application/msexcel");
- jxl.write.WritableWorkbook wbook = Workbook.createWorkbook(os);
- jxl.write.WritableSheet wsheet = wbook.createSheet("the first sheet", 0);
- for (int i = 0; i < split.length; i++) {
- jxl.write.Label wlabel0;
- wlabel0 = new jxl.write.Label(i, 0, getExcelTile(split[i]));
- wsheet.addCell(wlabel0);
- }
- jxl.write.Label wlabel1;
- for(int i=0;i<list.size();i++) {
- if(split.length==1){
- Object strval = (Object) list.get(i);
- String javaScript=""+MyPublic.toHtmlStr(strval==null?"":strval.toString().trim())+"";
- wlabel1 = new jxl.write.Label(0, i+1,strval==null?"":strval.toString().trim() );
- wsheet.addCell(wlabel1);
- }else{
- Object[] strval = (Object[]) list.get(i);
- for(int j=0;j<strval.length;j++) {
- String javaScript=""+MyPublic.toHtmlStr(strval[j]==null?"":strval[j].toString().trim())+"";
- //System.out.println("===================script:"+javaScript);
- wlabel1 = new jxl.write.Label(j, i+1,strval[j]==null?"":strval[j].toString().trim() );
- wsheet.addCell(wlabel1);
- }
- }
- }
- wbook.write();
- response.flushBuffer();
- wbook.close();
- os.close();
- } catch (IOException e) {
- // TODO Auto-generated catch block
- OutJavaScript.outString(response, "Sorry! Export Excel exception.");
- e.printStackTrace();
- } catch (HibernateException e1) {
- // TODO Auto-generated catch block
- OutJavaScript.outString(response, "Sorry! Database exception.");
- e1.printStackTrace();
- } catch (AppSystemException e1) {
- // TODO Auto-generated catch block
- OutJavaScript.outString(response, "Sorry! System exception.");
- e1.printStackTrace();
- } catch (AppBusinessException e1) {
- // TODO Auto-generated catch block
- OutJavaScript.outString(response, "Sorry! Database exception.");
- e1.printStackTrace();
- } catch (RowsExceededException e) {
- // TODO Auto-generated catch block
- OutJavaScript.outString(response, "Sorry! Export Excel exception.");
- e.printStackTrace();
- } catch (WriteException e) {
- // TODO Auto-generated catch block
- OutJavaScript.outString(response, "Sorry! Export Excel exception.");
- e.printStackTrace();
- }
- return null;
- }
- @Override
- public ActionForward update(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
- // TODO Auto-generated method stub
- return null;
- }
- }