exemodifypaymentaction.java

完整的合同管理信息系统

package com.ICT.AFC.contractmoney.payment;

import org.apache.struts.action.*;
import java.io.*;
import javax.servlet.http.*;
import com.ICT.AFC.DB.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext;
import javax.sql.*;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.struts.upload.*;

public class exeModifyPaymentAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest httpServletRequest,
                               HttpServletResponse httpServletResponse) {
    /**@todo: complete the business logic here, this is just a skeleton.*/
    exeModifyPaymentActionForm exeModifyPaymentActionForm = (
        exeModifyPaymentActionForm)
        actionForm;
    String PageForward = "modifyPaymentResult";
    //httpServletResponse.setContentType("text/html; charset=gb2312");
    HttpSession session = httpServletRequest.getSession();
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");
    DB db = new DB(dataSource);
    int ii = 0;
    String filePath = "";
    String aa = httpServletRequest.getParameter("checkbox1");
    if (aa.equals("3")) {
      ii = 3;
    }
    else {if(aa.equals("2"))
            ii=2;
            else
              ii=1;
    }

    try {
      boolean modifyResult = modifyOperate(db, exeModifyPaymentActionForm,
                                        filePath, httpServletRequest,ii);
      if (modifyResult) {
        session.setAttribute("modifyResult", "1");
      }
      else {
        session.setAttribute("modifyResult", "0");

      }
    }
    catch (Exception e) {
    }
    finally {
      //throw new java.lang.UnsupportedOperationException("Method perform() not yet implemented.");
      return (actionMapping.findForward(PageForward));
    }
  }

  public boolean modifyOperate(DB db,
                               exeModifyPaymentActionForm
                               exeModifyPaymentActionForm,
                               String filePath,
                               HttpServletRequest httpServletRequest,int ii) throws
      Exception {if (ii==2)
    {
    FormFile file = exeModifyPaymentActionForm.getPaymentFile(); //取得上传的文件
    try {
      InputStream stream = file.getInputStream(); //把文件读入
      //ByteArrayOutputStream baos=new ByteArrayOutputStream();
      String aa=httpServletRequest.getRealPath("/");
      OutputStream bos=new FileOutputStream(aa+"upload/payment/"+file.getFileName()); //建立一个上传文件的输出流
      filePath=aa+"upload/payment/"+file.getFileName();
      //System.out.println(filePath+"/"+file.getFileName());
      int bytesRead = 0;
      byte[] buffer = new byte[8192];
      while ( (bytesRead = stream.read(buffer, 0, 8192)) != -1) {
        bos.write(buffer, 0, bytesRead); //将文件写入服务器
      }
      bos.close();
      stream.close();
    }
    catch (Exception e) {
      System.err.print(e);
    }}else
      {filePath="nullnull";}

    String PAYDATE = exeModifyPaymentActionForm.getPaymentDate();
    String PAYID = httpServletRequest.getParameter("pid");
    String MONEY = exeModifyPaymentActionForm.getPaymentMoney();
    String REMARK = exeModifyPaymentActionForm.getPaymentRemark();
    String WRITER = "sdf";
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    String strSql="";
    if(ii==3 || ii==2){
     strSql = "update M_MONEY set money='" + MONEY +
        "', paydate='" + PAYDATE +
        "', remark='" + REMARK +
        "', writer='" + WRITER + "', recordtime='" + sdf.format(new Date()) +
        "', uploadpath='"+ filePath +"' where payid="+PAYID;
  }else{strSql = "update M_MONEY set money='" + MONEY +
      "', paydate='" + PAYDATE +
      "', remark='" + REMARK +
      "', writer='" + WRITER + "', recordtime='" + sdf.format(new Date()) +
      "' where payid=" + PAYID;


    }
    if (db.ExecSql(strSql) == 0) {
      db.close();
      return false;
    }
    else {
      db.close();
      return true;
    }
  }

}