【Java开源代码栏目提醒】:本文主要为网学会员提供volumnFilesearchAction.java,希望对需要volumnFilesearchAction.java网友有所帮助,学习一下!
package com.stsc.archive.backup;//modify
import com.stsc.archive.second.fileinfoForm;//add,lxm
import com.stsc.archive.second.FileKind;//add,lxm
import com.stsc.archive.second.FileKindList;//add,lxm
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 java.text.ParseException;
import com.stsc.archive.manage.*;//----------增加-------------------
//import com.stsc.archive.file.Constants;
public final class volumnFilesearchAction extends Action
{
public String Iso2Gb(String str)
{
String ret=(str==null) ? "" : str;
// try
// {
// byte[] byteStr=str.getBytes("ISO-8859-1");
// return new String(byteStr,"gb2312");
// }
// catch(Exception e)
//{
return ret;
//}
}
public ActionForward perform(ActionMapping mapping, ActionForm form,
HttpServletRequest req,HttpServletResponse res)
{
//----选择文件的SQL语句-----------------------------------------------------------------
String archivetype=req.getParameter("archivetype");
//System.out.println(Iso2Gb(archivetype));
String volumnno=req.getParameter("volumnno");
//System.out.println(Iso2Gb(volumnno));
String volumntitle=req.getParameter("volumntitle");
String code=req.getParameter("code");
String category=req.getParameter("category");
String retentionperiod=req.getParameter("retentionperiod");
String startdate=req.getParameter("startdate");
String enddate=req.getParameter("enddate");
String totalnum=req.getParameter("totalnum");
String totalpage=req.getParameter("totalpage");
String duty=req.getParameter("duty");
String security=req.getParameter("security");
String archiveunit=req.getParameter("archiveunit");
String remark=req.getParameter("remark");
String status=req.getParameter("status");
String sql="";
HttpSession session=req.getSession();
User userInfo=(User)session.getAttribute(Constants.CURRENT_USER_KEY);//----------增加------------
boolean info=userInfo.hasPopedom(4);//--------增加-------------------
boolean info1=userInfo.hasPopedom(5);//-----------增加------------------------
if(archivetype.equals("") == true && volumnno.equals("") == true && volumntitle.equals("") == true && code.equals("") == true && category.equals("") == true && retentionperiod.equals("") == true && startdate.equals("") == true && enddate.equals("") == true && totalnum.equals("") == true && totalpage.equals("") == true && duty.equals("") == true && security.equals("") == true && archiveunit.equals("") == true && remark.equals("") == true && status.equals("") == true)
{
sql="SELECT * FROM fVolumn where Deleted<>'1'";
}
else{
sql="SELECT * FROM fVolumn where Deleted<>'1'";
}
//System.out.println(sql);
//-------改过-------------
if(security!=null && security.equals("") == false)
{
sql+="AND Security='" + Iso2Gb(security)+"'";
}
else{
if(info==false && info1==false)
{
sql+="And Security='普通'";
}
else if(info==true && info1==false)
{
sql+="And Security<>'机密'";
}
}//----------------改完---------------------
if(archivetype!=null && archivetype.equals("") == false)
{
sql+="And ArchiveType='" + Iso2Gb(archivetype) +"'";
}
if(volumnno!=null && volumnno.equals("") == false)
{
sql+="And VolumnNo='" + Iso2Gb(volumnno)+"'";
}
if( volumntitle!=null && volumntitle.equals("") == false)
{
sql+="And VolumnTitle='" + Iso2Gb(volumntitle)+"'";
}
if(code!=null && code.equals("") == false)
{
sql+="And Code='" + Iso2Gb(code)+"'";
}
if(category!=null && category.equals("") == false)
{
sql+="And Category='" + Iso2Gb(category)+"'";
}
if(retentionperiod!=null && retentionperiod.equals("") == false)
{
sql+="And RetentionPeriod='" + Iso2Gb(retentionperiod)+"'";
}
if(startdate!=null && startdate.equals("") == false)
{
sql+="And StartDate=cdate('" + Iso2Gb(startdate)+"')";
}
if(enddate!=null && enddate.equals("") == false)
{
sql+="And EndDate=cdate('" + Iso2Gb(enddate)+"')";
}
if(totalnum!=null && totalnum.equals("") == false)
{
sql+="And TotalNum=" + Integer.parseInt(totalnum);
}
if(totalpage!=null && totalpage.equals("") == false)
{
sql+="And TotalPage=" + Integer.parseInt(totalpage);
}
if(duty!=null && duty.equals("") == false)
{
sql+="And Duty='" + Iso2Gb(duty)+"'";
}
if(archiveunit!=null && archiveunit.equals("") == false)
{
sql+="And ArchiveUnit='" + Iso2Gb(archiveunit)+"'";
}
if(remark!=null && remark.equals("") == false)
{
sql+="And Remark='" + Iso2Gb(remark)+"'";
}
if(status!=null && status.equals("") == false)
{
sql+="And Status='" + Iso2Gb(status)+"'";
}
//------------------------------------------------------------------------
System.out.println(sql);
Properties dbBase= new Properties();
dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
STPoolDataSet data=new STPoolDataSet();
STResultSet rs=data.getSTResult(sql,dbBase);
//------------数据类型的转化还没进行
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
String startdate2=null;
String enddate2=null;
//-------------------------------------增加---------
String[] volumnid1=new String[rs.getRecCount()];
System.out.println(rs.getRecCount());
int i=0;
String[] m=new String[rs.getRecCount()];
FileKindList shore=new FileKindList();
//System.out.println("怎么回事");
while(rs!=null && rs.next())
{
//---把自动编号存进数组---------------
volumnid1[i]=Integer.toString(rs.getInt("VolumnID"));//--------------增加--------------
i++;//-----------------增加--------------
//------成功存入----------------------
FileKind filename=new FileKind();
filename.setarchivetype(rs.getString("ArchiveType"));
filename.setvolumnno(rs.getString("VolumnNo"));
//System.out.println(rs.getString("VolumnNo"));
filename.setvolumntitle(rs.getString("VolumnTitle"));
filename.s
上一篇:
VolumnAndArchiveVector.java
下一篇:
经济酒店发展:China''s economy hotel market development strategies