searchresultaction.java

一套完整的档案管理系统

package com.stsc.archive.second;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.Properties;

import org.apache.struts.util.MessageResources;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
import java.util.Date;
import java.text.SimpleDateFormat;

import com.stsc.archive.manage.User;


public final class searchresultAction extends Action
{
	
      public ActionForward perform(ActionMapping mapping,ActionForm form,
             HttpServletRequest req,HttpServletResponse res)
      {
      	String[] enterName=req.getParameterValues("enterName");
      	if(enterName!=null){
      	Properties dbBase=new Properties();
      	dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
      	STPoolDataSet data=new STPoolDataSet();

			HttpSession session=req.getSession();//-----------提到了前面-------------------
      	User userInfo=(User)session.getAttribute(Constants.CURRENT_USER_KEY);//--------------增加--------------
      	boolean info=userInfo.hasPopedom(6);//----------增加-----------------------------
      	String volumnno=null;//------------增加-----------------------
	if(info) {  //---------有删除权限的（增加了这句）-------------------------------------
      	if(enterName.length>0 && enterName!=null)
      	{
      		for(int i=0;i<enterName.length;i++)
      		{
      			//删除这个案卷号的文件------------------------------------
      			String sql2="SELECT * FROM fVolumn WHERE VolumnID=" + Integer.parseInt(enterName[i]);
      			STResultSet rs2=data.getSTResult(sql2,dbBase);
      			
      			if((rs2!=null) && rs2.next())
      			{
      			volumnno=rs2.getString("VolumnNo");
      			//System.out.println(volumnno);
      		        }
      		       
      			String sql3="DELETE * FROM fArchive WHERE VolumnNo='" + volumnno + "'";
      			//System.out.println(sql3);
      			//System.out.println("哪里除了问题?");
      			data.executeSQL(sql3,dbBase);
      			//删除完毕---------------------------------------------------
      			
      			String sql1="DELETE * FROM fVolumn WHERE VolumnID=" + Integer.parseInt(enterName[i]);
      			//System.out.println(sql1);
      			data.executeSQL(sql1,dbBase);
      	                
      			
      		}
      		
      	}
}
      	
      else{
      	if(enterName.length>0 && enterName!=null)
      	{
      		for(int i=0;i<enterName.length;i++)
      		{
      			String sql1="UPDATE fVolumn SET Deleted='1' WHERE VolumnID=" + Integer.parseInt(enterName[i]);
      			//System.out.println(sql1);
      			data.executeSQL(sql1,dbBase);
      		        //删除这个案卷号的文件-----------------------------------------
      			String sql2="SELECT  FROM fVolumn WHERE VolumnID=" + Integer.parseInt(enterName[i]);
      			//System.out.println(sql2);
      			STResultSet rs2=data.getSTResult(sql2,dbBase);
      			
      			//System.out.println("好象没打出来!");
      			if((rs2 != null) && rs2.next())
      			{
      			
      			    volumnno=rs2.getString("VolumnNo");
      			    //System.out.println(volumnno);
      		         }
      			   
      			    String sql3="UPDATE fArchive SET Deleted='1' WHERE VolumnNo='" + volumnno +"'";
      			    data.executeSQL(sql3,dbBase);
      			    
      		        
      			//删除完毕--------------------------------------------------------
      		}
      }
	  }
      //-----------------------------------------------------------------------------
      
      	//System.out.println("过了sql1语句");
      	
      	//HttpSession session=req.getSession();
      	String sql=(String)session.getAttribute("my");
      	//System.out.println(sql);
      	//System.out.println("经过了sql语句");
		STResultSet rs=data.getSTResult(sql,dbBase);
      	SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
      	String startdate2=null;
      	String enddate2=null;
		FileKindList shore=new FileKindList();

      

		while(rs!=null && rs.next())
		{
			//System.out.println("进入while语句");
			FileKind filename=new FileKind();
			
			filename.setarchivetype(rs.getString("ArchiveType"));
			
		        filename.setvolumnno(rs.getString("VolumnNo"));
		       
			filename.setvolumntitle(rs.getString("VolumnTitle"));
			
			filename.setcode(rs.getString("Code"));
			
			filename.setcategory(rs.getString("Category"));
			
			filename.setretentionperiod(rs.getString("RetentionPeriod"));
			if(rs.getDate("StartDate")==null && rs.getDate("EndDate")==null)
			{
				startdate2="0";
				enddate2="0";
			}
			else if(rs.getDate("StartDate")==null && rs.getDate("EndDate")!=null)
			{
				startdate2="0";
				enddate2=sdf.format(rs.getDate("EndDate"));
			}
			else if(rs.getDate("StartDate")!=null && rs.getDate("EndDate")==null)
			{
				startdate2=sdf.format(rs.getDate("StartDate"));
				enddate2="0";
			}
			else
			{
				startdate2=sdf.format(rs.getDate("StartDate"));
				enddate2=sdf.format(rs.getDate("EndDate"));
			}
			filename.setstartdate(startdate2);
			
			filename.setenddate(enddate2);
			
			filename.settotalnum(Integer.toString(rs.getInt("TotalNum")));
			
			filename.settotalpage(Integer.toString(rs.getInt("TotalPage")));
			
			filename.setduty(rs.getString("Duty"));
			
			filename.setsecurity(rs.getString("Security"));
			
			filename.setarchiveunit(rs.getString("ArchiveUnit"));
			
			filename.setremark(rs.getString("Remark"));
			
			filename.setstatus(rs.getString("Status"));
			
			filename.setvolumnid(rs.getInt("VolumnID"));
			
			filename.setdeleted(rs.getString("Deleted"));
		        System.out.println(filename.getdeleted());
			shore.addFileName(filename);
			
		}
		
		//System.out.println("出了while语句");
		session.setAttribute("myhashtable",shore);
      		//System.out.println("searchresultAction.java");
		}
		return mapping.findForward("success");

	}
}