viewlog.java

一套完整的档案管理系统

package com.stsc.archive.file;

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 com.stsc.util.PageCt;

public final class viewLog 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)
	{
				
		Properties dbBase=new Properties();
		dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
		
		STPoolDataSet data=new STPoolDataSet();
		HttpSession session = req.getSession();		
	       String sql1="SELECT * FROM fHandleLog";
	       //STResultSet rs=data.getSTResult(sql1,dbBase);
	       
	      ArchiveList log=new ArchiveList();

		  //


		  //ResultSet rs0 = sqlbean.executeQuery("select count(*) from UserList );
			///rs0.next();
			//查询记录
			STResultSet rs=data.getSTResult(sql1,dbBase);
			long data_num=rs.getRecCount();
			//System.out.println("data_num====="+data_num);
			long Current_Page = 0;
			PageCt PageCt=new PageCt();
			String currentpage=(String)req.getParameter("currentpage");
			if (currentpage != null && !currentpage.equals(""))
			{
			  Current_Page = Integer.parseInt(req.getParameter("currentpage"));
			}
			String Query_Page=(String)req.getParameter("Query_Page");
			if (Query_Page!=null && !Query_Page.equals(""))
			{
			  Current_Page = Integer.parseInt(req.getParameter("Query_Page"))-1;
			}
			PageCt.Init(Current_Page,data_num,session);
			long l_start = PageCt.getStart();
			//System.out.println("l_start==================="+l_start);
			long l_end = PageCt.getEnd();
			//System.out.println("l_end==================="+l_end);
			long i=0;
			//System.out.println("PageCt==================="+PageCt.getTotalnum());
			while((i<l_start) && rs.next())
			{
				  i++;
			}  
			//输出查询结果
			long j=0;
	       while(rs!=null && rs.next() && (i<l_end))
	       {
			   j=i+1;
			   //System.out.println("j==================="+j);
	        Archive filename=new Archive();
			filename.setHandleid(rs.getInt("handleid"));
	        filename.setEntername(rs.getString("entername"));
			filename.setUsername(rs.getString("username"));
			filename.setHandletime(rs.getDate("HandleTime"));
			filename.setHandlecontent(rs.getString("HandleContent"));
	        log.addLog(filename);
			i++;

	       }
	       
		
        session.setAttribute("mylog", log);
		session.setAttribute("PageCt_handle", PageCt);
        System.out.println("mylog.java 123");
        
        return mapping.findForward("success");
      }
}