savejydj.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 javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
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 com.stsc.archive.manage.*;

/*
      保存，删除，编辑类

*/
public final class SaveJydj extends Action {


    
    public ActionForward perform(ActionMapping mapping,
				 ActionForm form,
				 HttpServletRequest request,
				 HttpServletResponse response)
	throws IOException, ServletException {


	// Extract attributes we will need
	Locale locale = getLocale(request);
	MessageResources messages = getResources();
	HttpSession session = request.getSession();
    JyForm JyForm = (JyForm)form;
 	ActionErrors errors = new ActionErrors();       
	// Validate the request parameters specified by the user
//	ArchiveList archiveList = (ArchiveList) session.getAttribute(Constants.ARCHIVELIST_KEY);
 /*
		if (archiveList == null) {
	    return (mapping.findForward("failure"));            
        }
*/
        
		
		String action = request.getParameter("action");
        System.out.println("&&&&&&  action====="+action);
		if (action==null) action="Create";
        User userInfo = (User)(session.getAttribute(Constants.CURRENT_USER_KEY));	
		Properties dbBase = new Properties();
        System.out.println("&&&&&&&&&&&&&&&&"+Constants.DATABASE_KEY);      
		dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
 
        STPoolDataSet data = new STPoolDataSet();	
        STResultSet rs;
        JycxList jycxlist = new JycxList();
       

		String fileno  		 = "";
		String title		 = "";
		String borrowname	 = ""; 
        String lendtime      = "";
		String lendhandler   = "";
		int    lendnum       = 0;
		String archivalcode  = "";
		int    lendperiod    = 30;
		String serialno      = "";
		String returntime    = "";
		String returnhandler = "";
        int    returnnum     = 0 ; 
        String sql           = "";
// 分页显示数据
       	int tmp_totalnum = 0;	

		int total = 0;
		int totalPage = 0;
		int curPage=0;
        int page_num=10;			
	    int perpage = 0;
		int gopage=1;
		int j=1; 	
		
     try
		{
			page_num = userInfo.getRowsPerPage();
		    System.out.println("########## page_num="+page_num);
		}
		catch (Exception e)
		{
			page_num = 10;
            System.out.println("########## 8888888888 page_num="+page_num);
		}
		 
		 
		   int    lendfileid=0;    
            
		   //归还登记	
			if(action.equals("Ghdj")){				
				returnnum     =Integer.parseInt(request.getParameter("returnnum"));
				returntime    = request.getParameter("returntime");   
				returnhandler = request.getParameter("returnhandler");
				lendfileid    =Integer.parseInt(request.getParameter("lendfileid"));
				serialno      = request.getParameter("serialno");
				sql="UPDATE  fLendFile SET ReturnHandler ='"+returnhandler+"',ReturnTime=cdate('"+returntime+"'),ReturnNum="+returnnum+",Status='已归还' WHERE LendFileId="+lendfileid+" and   LendNum="+returnnum;
			    data.executeSQL(sql,dbBase);
				sql="UPDATE  fLendFile SET ReturnHandler ='"+returnhandler+"',ReturnTime=cdate('"+returntime+"'),ReturnNum="+returnnum+",Status='未全归还' WHERE LendFileId="+lendfileid+" and   LendNum <>"+returnnum;
			    data.executeSQL(sql,dbBase);
			 
				sql="select * from fLoanable where SerialNo='"+serialno+"'"; 
				rs  =data.getSTResult(sql,dbBase);
				while (rs!=null&&rs.next())
				{
					tmp_totalnum = rs.getInt("LoanableNum");
				}
                System.out.println("%%%%%%%%% tmp_totalnum="+tmp_totalnum);
				sql="UPDATE  fLoanable  SET LoanableNum="+(tmp_totalnum+returnnum)+"";
			    data.executeSQL(sql,dbBase);
                

			}
		
			//修改借阅记录
			if(action.equals("Edit")){
				 fileno  		 = request.getParameter("fileno");
				 title		   = request.getParameter("title");
				 borrowname	   = request.getParameter("borrowname");
				 lendtime      = request.getParameter("lendtime");
				 lendhandler   = request.getParameter("lendhandler");
				 lendnum	   =  Integer.parseInt(request.getParameter("lendnum"));
				 archivalcode  = request.getParameter("archivalcode");
				 lendperiod    = Integer.parseInt(request.getParameter("lendperiod"));
				 serialno      = request.getParameter("serialno");
				 lendfileid    =Integer.parseInt(request.getParameter("lendfileid"));
			    int tmp_lendnum=0;
				sql = " select LendNum   from  fLendFile  where LendFileId="+lendfileid;
				rs  =data.getSTResult(sql,dbBase);
				while (rs!=null&&rs.next())
				{
					tmp_lendnum = rs.getInt("LendNum");
				}			
				sql="UPDATE  fLendFile SET Title ='"+title+"',SerialNo='"+serialno+"',BorrowName='"
				+borrowname+"',LendHandler='"+lendhandler+"',LendNum="+lendnum+",ArchivalCode='"+archivalcode
				+"',LendPeriod="+lendperiod+",LendTime=cdate('"+lendtime+"')  WHERE LendFileId="+lendfileid;
					data.executeSQL(sql,dbBase);
				
				
			    sql="select * from fLoanable where SerialNo='"+serialno+"'"; 
				rs  =data.getSTResult(sql,dbBase);
				while (rs!=null&&rs.next())
				{
					tmp_totalnum = rs.getInt("LoanableNum");
				}
				sql="UPDATE  fLoanable  SET LoanableNum="+(tmp_totalnum+(tmp_lendnum-lendnum))+"";
				data.executeSQL(sql,dbBase);
		
			
			}

			//删除借阅记录
			 if(action.equals("Delete")){
				 String []temp     =request.getParameterValues("lendfileid"); 
				 gopage=  Integer.parseInt(request.getParameter("goPage"));
				 if(temp!=null){ 
					 for( int i=0;i<temp.length;i++){
						 int temp_int=Integer.parseInt(temp[i]);
						 sql = " DELETE  FROM fLendFile WHERE LendFileId="+temp_int;
						 data.executeSQL(sql,dbBase);
					 } 
				 }
			}

			//建立新的借阅记录
			 if(action.equals("Create")){
				 fileno  		 = request.getParameter("fileno");
				 title		   = request.getParameter("title");
				 borrowname	   = request.getParameter("borrowname");
				 lendtime      = request.getParameter("lendtime");
				 lendhandler   = request.getParameter("lendhandler");
				 lendnum	   =  Integer.parseInt(request.getParameter("lendnum"));
				 archivalcode  = request.getParameter("archivalcode");
				 lendperiod    = Integer.parseInt(request.getParameter("lendperiod"));
				 serialno      = request.getParameter("serialno");
				 lendfileid    =Integer.parseInt(request.getParameter("lendfileid"));

				int LoanableNum  =0;
				sql="INSERT INTO fLendFile(SerialNo,Title,BorrowName,LendHandler,LendNum,ArchivalCode,LendPeriod,LendTime,Status) VALUES('"+serialno+"','"+title+"','"+borrowname+"','"+lendhandler+"','"+lendnum+"','"+archivalcode+"','"+lendperiod+"',cdate('"+lendtime+"'),'未归还')";
				data.executeSQL(sql,dbBase);

				sql="select * from fLoanable where SerialNo='"+serialno+"'"; 
				rs  =data.getSTResult(sql,dbBase);
				while (rs!=null&&rs.next())
				{
					tmp_totalnum = rs.getInt("LoanableNum");
				}

				if((rs.getRecCount())==0){									
//					String sql12="select * from fArchive where SerialNo="+Integer.parseInt(serialno)+"";
					sql ="select * from fArchive where FlowNo='"+serialno+"'";
					rs  =data.getSTResult(sql,dbBase);
					while(rs!=null&&rs.next()){
					  tmp_totalnum=rs.getInt("Copys");				  
					}
					sql="INSERT INTO fLoanable(SerialNo,TotalNum,LoanableNum) VALUES('"+serialno+"',"+tmp_totalnum+","+(tmp_totalnum-lendnum)+")"; 
				    data.executeSQL(sql,dbBase);
				}else{
				       
					sql="UPDATE  fLoanable  SET LoanableNum="+(tmp_totalnum-lendnum)+"";
				    data.executeSQL(sql,dbBase);
				}			
			
			}
  
 
			sql="select * from  fLendFile order by LendFileId DESC";
			rs = data.getSTResult(sql, dbBase);

		   total = rs.getRecCount();
			if((total%page_num)!=0){
			  totalPage=total/page_num+1; 
			}else{
			  totalPage=total/page_num;
			}
			if(totalPage==0){
				 gopage=0;
			}else{
				if(gopage==0){
					gopage=1;
				}
				if(gopage > totalPage){
					gopage=1;
				}
			}
			
			while (rs!=null && rs.next()) 
			{
				if( j>=((gopage-1)*page_num+1)&&j<=(gopage*page_num)){
				JyForm jyform = new JyForm();
				jyform.setlendfileid(rs.getInt("LendFileId"));
				jyform.setfileno(rs.getString("FileNo"));
				jyform.setserialno(rs.getString("SerialNo"));
				jyform.settitle(rs.getString("Title"));
				jyform.setarchivalcode(rs.getString("ArchivalCode"));
				jyform.setborrowname(rs.getString("BorrowName"));
				jyform.setlendtime(String.valueOf(rs.getDate("LendTime")));
				jyform.setlendhandler(rs.getString("LendHandler"));
				jyform.setlendnum(rs.getInt("LendNum"));
				jyform.setlendperiod(rs.getInt("LendPeriod"));
				jyform.setreturnhandler(rs.getString("ReturnHandler"));
				jyform.setreturntime(String.valueOf(rs.getDate("ReturnTime")));
				//分页显示
				jycxlist.setGoPage(gopage);
				jycxlist.setTotal(total);
				jycxlist.setCurPage(gopage);
				jycxlist.setTotalPage(totalPage);
				jycxlist.addArchive(jyform);
			    }
				j++;
			 }
	

	// Report any errors we have discovered back to the original form
	if (!errors.empty()) {
	    saveErrors(request, errors);
	    return (new ActionForward(mapping.getInput()));
	}
   session.setAttribute(Constants.JYCXLIST_KEY, jycxlist);
	// Forward control to the specified success URI
	return (mapping.findForward("success"));
    }


}