commonsql.java

一套完整的档案管理系统

package com.stsc.archive.manage;

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.archive.xml.*;

public final class CommonSql
{
	/**
	根据流水号恢复文件表
	*/
/*	public void restoreArchive(fArchive archive)
	{
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        
        //先清除原有数据
        int serialno = archive.getSerialno();
        STPoolDataSet data = new STPoolDataSet();
        String sql = "DELETE FROM fArchive WHERE SerialNo=" + serialno;
        data.executeSQL(sql, dbBase);
        
        sql = "INSERT INTO fArchive(SerialNo, Status, Deleted, RepFlag, ArchiveType, FileType, Title, LiteratureType, TitleRemark, FileNo, FileDate, KeyWord, Code, Category, PageNumber, Duty, OtherDuty, ElectronicFileName, AttachmentTitle, Memo, Copys, LendNum, SecurityClass, SecurityTerm, DecryptionDate, RetentionPeriod, ArchiveDate, ArchiveDate, DestroyDate, ArchivalCode, DossierNo, ArchiveNo, UnitNo, FilingTrace, HandOver, FilingScripts, ReAppraiseDates, Annotation, abstract, Suggest, RecordTransfer) VALUES(" + archive.getSerialno() + "," + archive.getStatus() + ",";
	}
	public void restoreArchive(fArchiveVector myvector)
	{
		for(int i=0; i<myvector.getLength(); i++)
		{
			restoreArchive(myvector.get(i));
		}
	}
*/	
	/**
	根据流水号得到fArchiveVector
	*/
/*	public fArchiveVector getArchive(int serialno)
	{
		System.out.println("-----begin getArchive-----serialno="+Integer.toString(serialno));
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        
        STPoolDataSet data = new STPoolDataSet();
        String sql = "SELECT * FROM fArchive WHERE SerialNo=" + serialno;
        STResultSet rs = data.getSTResult(sql, dbBase);
        
        if (rs!=null && rs.next())
        {
        	fArchive archive = new fArchive();
        	
        	archive.setSerialno(rs.getInt("SerialNo"));System.out.println("aaaaaaaaa");
        	archive.setStatus(rs.getInt("Status"));System.out.println("ca");
        	archive.setDeleted(rs.getString("Deleted"));
        	archive.setRepflag(rs.getInt("RepFlag"));
        	archive.setArchivetype(rs.getString("ArchiveType"));
        	archive.setFiletype(rs.getString("FileType"));
        	archive.setTitle(rs.getString("Title"));
        	archive.setLiteraturetype(rs.getString("LiteratureType"));
        	archive.setTitleremark(rs.getString("TitleRemark"));
        	archive.setFileno(rs.getString("FileNo"));
        	archive.setFiledate(rs.getDate("FileDate"));
        	archive.setKeyword(rs.getString("KeyWord"));
        	archive.setCode(rs.getString("Code"));
        	archive.setCategory(rs.getString("Category"));
        	archive.setPagenumber(rs.getInt("PageNumber"));
        	archive.setDuty(rs.getString("Duty"));
        	archive.setOtherduty(rs.getString("OtherDuty"));
        	archive.setElectronicfilename(rs.getString("ElectronicFileName"));
        	archive.setAttachmenttitle(rs.getString("AttachmentTitle"));
        	archive.setMemo(rs.getString("Memo"));
        	archive.setCopys(rs.getInt("Copys"));
        	archive.setLendnum(rs.getInt("LendNum"));
        	archive.setSecurityclass(rs.getString("SecurityClass"));
        	archive.setSecurityterm(rs.getInt("SecurityTerm"));
        	archive.setDecryptiondate(rs.getDate("DecryptionDate"));
        	archive.setRetentionperiod(rs.getInt("RetentionPeriod"));
        	archive.setArchivedate(rs.getDate("ArchiveDate"));
        	archive.setDestroydate(rs.getDate("DestroyDate"));System.out.println("bbbbbbbbbb");
        	archive.setArchivalcode(rs.getString("ArchivalCode"));
        	archive.setDossierno(rs.getString("DossierNo"));
        	archive.setArchiveno(rs.getString("ArchiveNo"));
        	archive.setUnitno(rs.getString("UnitNo"));
        	archive.setFilingtrace(rs.getString("FilingTrace"));
        	archive.setHandover(rs.getString("HandOver"));
        	archive.setFilingscripts(rs.getString("FilingScripts"));
        	archive.setReappraisedates(rs.getString("ReAppraiseDates"));System.out.println("aaaaaaaaa");
        	archive.setAnnotation(rs.getString("Annotation"));
        	archive.setAbstractmsg(rs.getString("Abstract"));
        	archive.setSuggest(rs.getString("Suggest"));
        	archive.setRecordtransfer(rs.getString("RecordTransfer"));
        	
        	fArchiveVector myvector = new fArchiveVector();
        	myvector.add(archive);
        	return myvector;
        }
        else
        {
        	return null;
        }
	}
*/	
	public String Iso2Gb(String str)
	{
		String ret=(str==null) ? "" : str;
		return ret;
/*		try
		{
  			byte[] byteStr=str.getBytes("ISO-8859-1");
  			return new String(byteStr,"gb2312");
		}
		catch(Exception e)
		{
  			return ret;
		}*/
	}
	
	public void ToUserManager(ActionForm form, HttpServletRequest req)
	{
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        STPoolDataSet data = new STPoolDataSet();
        
		//---------------------------------------------------------------------------------
		String sql = "SELECT * FROM fUserName where EnterName<>'admin' ORDER BY EnterName ";//6.9,add admin
		System.out.println(sql);
		STResultSet rs = data.getSTResult(sql, dbBase);
		UserList userList = new UserList();
    
        while(rs!=null && rs.next()) 
        {
        	User tuser = new User();
        	
        	tuser.setEnterName(rs.getString("EnterName"));
        	tuser.setUserName(rs.getString("UserName"));
        	tuser.setDepartment(rs.getString("Department"));
			tuser.setRowsPerPage(rs.getInt("RowsPerPage"));
            
//			System.out.println(rs.getString("EnterName"));
            userList.addUser(tuser);
        }
        
        // Save our logged-in user in the session
		HttpSession session = req.getSession();
        session.setAttribute(Constants.USER_MANAGE_KEY, userList);
        //=============================================================-----------------
       
/**       	//for test 
       	System.out.println("---------begin xml write----------------------");
       	try
       	{
	       	System.out.println("---------begin xml write-----ok-------");
	        rwXmlDoc mydoc = new rwXmlDoc();
	        mydoc.writeXMLFile("c:\\xml\\testUser.xml", userList);
	   		UserList mylist = null;
	   		mylist = mydoc.readXMLFile("webapps\\work\\myuser.xml");
	   		System.out.println("---------end xml write----------------------");
    	}
    	catch(Exception e)
		{
  			System.out.println("rwXmlDoc error!");
		}*/
	}
	  
	public void ToViewPopedom(ActionForm form, HttpServletRequest req, int iRoleId)
	{
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        STPoolDataSet data = new STPoolDataSet();
        
        //----------------------------------------------------------------------------------------
        String sql = "SELECT EnterName,UserName FROM fUserName where EnterName<>'admin' AND (EnterName IN (SELECT EnterName from fUserRole WHERE RoleID=" + iRoleId + ")) ORDER BY EnterName";//6.9,add admin
        System.out.println("begin viewPopedomAction db...");
        STResultSet rs = data.getSTResult(sql, dbBase);
        System.out.println("viewPopedomAction db end");
        
        PopedomUserList users = new PopedomUserList();
        
        while(rs!=null && rs.next()) 
        {
        	User user = new User();
        	
        	user.setEnterName(rs.getString("EnterName"));
        	user.setUserName(rs.getString("UserName"));
        	
        	users.addUser(user);
        }
        users.setRoleid(iRoleId);
        
        HttpSession session = req.getSession();
        session.setAttribute("popedomUsers", users);
        
        //--------为隐藏域所用------------------------
        RoleUser roleuser = new RoleUser();
        roleuser.setRoleid(iRoleId);
        session.setAttribute("ROLEID", roleuser);
        //============================================
        
        String strRole = "";
        sql = "SELECT Role FROM fRole WHERE RoleID=" + iRoleId;
        rs = data.getSTResult(sql, dbBase);
        while(rs!=null && rs.next()) 
        {
        	strRole = rs.getString("Role");
        }
        session.setAttribute("role", strRole);
        System.out.println(strRole);
        //========================================================================================
	}
	
	public static String getBackupPath()
	{
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        STPoolDataSet data = new STPoolDataSet();
		String sql = "SELECT BackupRoute FROM fOfficalText";
		STResultSet rs = data.getSTResult(sql, dbBase);
		System.out.println(sql);
		String backupRoute = null;
        if (rs!=null && rs.next()) 
		{
			backupRoute = rs.getString("BackupRoute");
		}
		if(backupRoute == null)
		{
			backupRoute = "";
		}
		System.out.println("log root="+backupRoute);
		return backupRoute;
	}
}