edit.java

一套完整的档案管理系统

  /* 初始化页面类*/
package com.stsc.archive.jygl;
//
import java.io.IOException;
import java.util.Hashtable;
import java.util.Locale;
import java.util.Properties;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.io.IOException;
import java.util.Hashtable;
import java.util.Locale;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionServlet;
import org.apache.struts.util.MessageResources;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
import com.stsc.archive.jygl.*;
import java.util.Date;

public final class Edit extends Action {

    public ActionForward perform(ActionMapping mapping,
				 ActionForm form,
				 HttpServletRequest request,
				 HttpServletResponse response)
	throws IOException, ServletException {
System.out.println("mapping.getAttribute(): = " + mapping.getAttribute());
System.out.println("mapping.getScope(): = " + mapping.getScope());

	
     String lendtime		= "";     
     int	lendperiod      =30 ; 
	 String borrowname		= "";
     String title		    = "";
     String archivalcode	= "";
	 String fileno			= "";
     String remark    		= "";
     String lendhandler		= "";
     int	lendnum         =0; 
	 String effect			= "";
     String returnhandler   = "";
	 String returntime		= "";
	 String maturity  		= "";
	 String serialno        = "";
	 String status       	= "";
	 int    lendfileid      =0;
	 String todayStr        ="";
	 int    returnnum       =0;
     int   tmp_totalnum     = 0;	
     int   tmp_num          = 0;
	 String  sql            = "";

	 java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
	 todayStr = sdf.format(new java.util.Date());
	 
	 
	 STPoolDataSet data = new STPoolDataSet();
	 STResultSet rs;
     Properties dbBase = new Properties();
	 dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
	// Extract attributes we will need
	Locale locale = getLocale(request);
	MessageResources messages = getResources();
	HttpSession session = request.getSession();

	// Validate the request parameters specified by the user
	ActionErrors errors = new ActionErrors();

    String action = request.getParameter("action");
    if (action==null) action="Create";
        
     serialno = request.getParameter("serialno");
    if (serialno==null) serialno = "";
   
    	

        
          JyForm  jyform =null;
    //建立新的借阅登记初始化数据       
	if (action.equals("Create")) {
        jyform  = new JyForm(); 
	    lendtime=todayStr;
//      sql="select * from fLoanable where SerialNo='"+serialno+"'"; 
        sql="select * from fLoanable where SerialNo=(select  FlowNo from fArchive  Where SerialNo="+Integer.parseInt(serialno)+")";
		//由于在fArchive中的流水号变为FlowNo使用以下sql
		rs  =data.getSTResult(sql,dbBase);		
		//向fLoanable表中插入可借数量和总数量
		if((rs.getRecCount())==0){
		    sql="INSERT INTO fLoanable(SerialNo,TotalNum,LoanableNum) Select  FlowNo,Copys,Copys from fArchive Where SerialNo="+Integer.parseInt(serialno)+"";
			data.executeSQL(sql,dbBase);		
		}else{
            sql=" select   (fArchive.Copys-fLoanable.TotalNum) as tmpnum,fArchive.Copys  from fArchive,fLoanable Where  fArchive.FlowNo=fLoanable.SerialNo and fArchive.SerialNo="+Integer.parseInt(serialno)+"";
			rs  =data.getSTResult(sql,dbBase);	
			while(rs!=null&&rs.next()){
				tmp_num      = rs.getInt("tmpnum");
			    tmp_totalnum = rs.getInt("Copys");
			}
            System.out.print("####################### tmp_num=="+tmp_num);
			if(tmp_num!=0){
				sql="UPDATE fLoanable set TotalNum="+tmp_totalnum+",LoanableNum=LoanableNum+"+ tmp_num +"  Where  SerialNo= (select FlowNo from  fArchive where SerialNo="+Integer.parseInt(serialno)+")";		
				System.out.println("####################### 1 sql=="+sql);	
				data.executeSQL(sql,dbBase);		
            } 
		}

		int serialno_jy=Integer.parseInt(request.getParameter("serialno"));
		sql="select * from fArchive WHERE SerialNo="+serialno_jy+"";
		rs=data.getSTResult(sql,dbBase);
		while (rs!=null && rs.next())
		{
// 由于在fArchive中的流水号改为flowno 
//			serialno       = String.valueOf(rs.getInt("SerialNo"));
            serialno        =rs.getString("FlowNo");
			title          = rs.getString("Title") ;
		    archivalcode   = rs.getString("ArchivalCode");
		}
	
	
	} 
	jyform = (JyForm) form;
	jyform.setAction(action); 
	
    //编辑页面初始化数据
	  if(action.equals("Edit")){
		lendfileid=Integer.parseInt(request.getParameter("lendfileid"));
		sql="select * from  fLendFile WHERE LendfileId="+lendfileid+"";
		rs = data.getSTResult(sql, dbBase);
		while (rs!=null && rs.next()) 
				{
					serialno       = rs.getString("SerialNo");
					fileno         = rs.getString("FileNo");
					title          = rs.getString("Title") ;
					archivalcode   = rs.getString("ArchivalCode");
					borrowname	   = rs.getString("BorrowName");
				    lendtime       = String.valueOf(rs.getDate("LendTime"));
					lendhandler    = rs.getString("LendHandler");
					lendnum        = rs.getInt("LendNum");
					lendperiod     = rs.getInt("LendPeriod");
					returnhandler  = rs.getString("ReturnHandler");
				    returntime     = String.valueOf(rs.getDate("ReturnTime"));
				}
   }
  
  //查看页面初始化数据
   if(action.equals("See")){
		lendfileid=Integer.parseInt(request.getParameter("lendfileid"));
		sql="select * from  fLendFile WHERE LendfileId="+lendfileid+"";
		rs = data.getSTResult(sql, dbBase);
		while (rs!=null && rs.next()) 
				{
					serialno       = rs.getString("SerialNo");
					fileno         = rs.getString("FileNo");
					title          = rs.getString("Title") ;
					archivalcode   = rs.getString("ArchivalCode");
					borrowname	   = rs.getString("BorrowName");
					lendtime       = String.valueOf(rs.getDate("LendTime"));
					lendhandler    = rs.getString("LendHandler");
					lendnum        = rs.getInt("LendNum");
					lendperiod     = rs.getInt("LendPeriod");
					returnhandler  = rs.getString("ReturnHandler");
				    returntime     = String.valueOf(rs.getDate("ReturnTime"));
				}
   }

//归还登记页面初始化数据s
 if(action.equals("Ghdj")){
		lendfileid=Integer.parseInt(request.getParameter("lendfileid"));
		sql="select * from  fLendFile WHERE LendfileId="+lendfileid+"";
		rs = data.getSTResult(sql, dbBase);
		while (rs!=null && rs.next()) 
				{
					serialno       = rs.getString("SerialNo");
					fileno         = rs.getString("FileNo");
					title          = rs.getString("Title") ;
					archivalcode   = rs.getString("ArchivalCode");
					borrowname	   = rs.getString("BorrowName");
					lendtime       = String.valueOf(rs.getDate("LendTime"));
					lendhandler    = rs.getString("LendHandler");
					lendnum        = rs.getInt("LendNum");
					lendperiod     = rs.getInt("LendPeriod");
					returnhandler  = rs.getString("ReturnHandler");
				    returntime     = String.valueOf(rs.getDate("ReturnTime"));                
				    returnnum      = rs.getInt("ReturnNum");
				}
   }


		  
			  try {
				jyform.setserialno(serialno);
				jyform.setfileno(fileno);
				jyform.settitle(title);
				jyform.setarchivalcode(archivalcode);
				jyform.setborrowname(borrowname);
			    jyform.setlendtime(lendtime);			
				jyform.setlendhandler(lendhandler);
				jyform.setlendnum(lendnum);
				jyform.setlendperiod(lendperiod);
				jyform.setreturnhandler(returnhandler);
				jyform.setreturnnum(returnnum); 
				System.out.println("%%*******   returntime=="+returntime.trim()); 
				if(!returntime.equals("null")){
				System.out.println("this is in if");
				jyform.setreturntime(returntime);
				}else{
                 System.out.println("this is in else");
				  jyform.setreturntime(todayStr);
				}
				jyform.setAction(action);
                  
		} catch (Throwable t) {
			System.out.println("SubscriptionForm.populate" + t);
            servlet.log("SubscriptionForm.populate", t);
            throw new ServletException("SubscriptionForm.populate", t);
        }

	// Report any errors we have discovered back to the original form
	if (!errors.empty()) {
	    saveErrors(request, errors);
	    return (new ActionForward(mapping.getInput()));
	}
   session.setAttribute("jydj", jyform);//新加的
	// Forward control to the specified success URI
//System.out.println("mapping.findForward(\"success\")=" + mapping.findForward("success"));
	return (mapping.findForward("success"));

    }


}