cataloguevo.java

dgbas公文管理核心java源码

package com.jasson.business.archive.vo;

import java.util.List;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.List;
import java.util.Vector;
import java.util.Properties;
import java.util.Collection;
import java.util.ArrayList;
import javax.sql.DataSource;
import com.jasson.business.common.ValueObject;
import com.jasson.business.common.DbConn;
import com.jasson.common.*;

import com.jasson.common.DateUtil;
import java.text.SimpleDateFormat;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import java.io.File;
import java.io.IOException;
import java.util.Properties;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.FactoryConfigurationError;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Result;
import javax.xml.transform.Source;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerConfigurationException;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.TransformerFactoryConfigurationError;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.xml.sax.SAXException;

import java.net.URL;
import java.util.Iterator;


import com.jasson.common.XmlException;
import com.jasson.common.XmlUtil;
import com.jasson.business.common.DbConn;
import com.jasson.business.common.DbConn;
import com.jasson.business.archive.ArchiveCatalogueIF;





public class CatalogueVO
    extends ValueObject
    {

    private String fileNo;
    private String catalogueName;
    private String catalogueFunction;
    private String caseName;
    private String abreastName;
    private String alternativeName;
    private String caseReason;
    private String relativeCase;
    private String primarySender;
    private String secondarySender;
    private String primaryReceiver;
    private String secondaryReceiver;
    private String receiverAdjustment;
    private String senderAdjustment;
    private String documentType;
    private String copyType;
    private String securityLevel;
    private String decryptRestriction;
    private int keepingYears;
    private String appliedRestriction;
    private String status;
    private int adjustedKeepingYears;
    private String adjustReason;
    private String auditedDestoryWord;
    private Date destoryDate;
    private Date decryptDate;
    private String transferNote;
    private Date extendTransferDate;
    private Date transferDate;
    private String receiveWord;
    private String sendWord;
    private String issueWord;
    private String yearNo;
    private String categoryNo;
    private String caseNo;
    private String volumeNo;
    private String itemNo;
    private String eletronicsNo;
    private String eletronicsPath;
    private String eletronicsName;
    private String microficheNo;
    private Date documentCreateDate;
    private String mediaType;
    private int amount;
    private String unit;
    private Date archiveDate;
    private String creater;
    private String departmentName;
    private String undertakerName;
    private boolean merage;
    private String primaryFileNo;
    private List annotations;
    private List subjects;
    private List attachments;
    private static final String FIND_ALL_SQL = "SELECT " +
        "T_ARCHIVE_CATALOGUE.FileNo,T_ARCHIVE_CATALOGUE.CatalogueName, " +
        "T_ARCHIVE_CATALOGUE.CatalogueFunction,T_ARCHIVE_CATALOGUE.CaseName, " +
        "T_ARCHIVE_CATALOGUE.AbreastName,T_ARCHIVE_CATALOGUE.AlternativeName, " +
        "T_ARCHIVE_CATALOGUE.CaseReason,T_ARCHIVE_CATALOGUE.RelativeCase, " +
        "T_ARCHIVE_CATALOGUE.PrimarySender,T_ARCHIVE_CATALOGUE.SecondarySender, " +
        "T_ARCHIVE_CATALOGUE.PrimaryReceiver,T_ARCHIVE_CATALOGUE.SecondaryReceiver, " +
        "T_ARCHIVE_CATALOGUE.ReceiverAdjustment,T_ARCHIVE_CATALOGUE.SenderAdjustment, " +
        "T_ARCHIVE_CATALOGUE.DocumentType,T_ARCHIVE_CATALOGUE.CopyType, " +
        "T_ARCHIVE_CATALOGUE.SecurityLevel,T_ARCHIVE_CATALOGUE.DecryptRestriction, " +
        "T_ARCHIVE_CATALOGUE.KeepingYears,T_ARCHIVE_CATALOGUE.AppliedRestriction, " +
        "T_ARCHIVE_CATALOGUE.Status,T_ARCHIVE_CATALOGUE.AdjustedKeepingYears, " +
        "T_ARCHIVE_CATALOGUE.AdjustReason,T_ARCHIVE_CATALOGUE.AuditedDestoryWord, " +
        "T_ARCHIVE_CATALOGUE.DestoryDate,T_ARCHIVE_CATALOGUE.DecryptDate, " +
        "T_ARCHIVE_CATALOGUE.TransferNote,T_ARCHIVE_CATALOGUE.ExtendTransferDate, " +
        "T_ARCHIVE_CATALOGUE.TransferDate,T_ARCHIVE_CATALOGUE.ReceiveWord, " +
        "T_ARCHIVE_CATALOGUE.SendWord,T_ARCHIVE_CATALOGUE.IssueWord, " +
        "T_ARCHIVE_CATALOGUE.YearNo,T_ARCHIVE_CATALOGUE.CategoryNo, " +
        "T_ARCHIVE_CATALOGUE.CaseNo,T_ARCHIVE_CATALOGUE.VolumeNo, " +
        "T_ARCHIVE_CATALOGUE.ItemNo,T_ARCHIVE_CATALOGUE.EletronicsNo, " +
        "T_ARCHIVE_CATALOGUE.EletronicsPath,T_ARCHIVE_CATALOGUE.EletronicsName, " +
        "T_ARCHIVE_CATALOGUE.MicroficheNo,T_ARCHIVE_CATALOGUE.DocumentCreateDate, " +
        "T_ARCHIVE_CATALOGUE.MediaType,T_ARCHIVE_CATALOGUE.Amount, " +
        "T_ARCHIVE_CATALOGUE.Unit,T_ARCHIVE_CATALOGUE.ArchiveDate, " +
        "T_ARCHIVE_CATALOGUE.LastModify,T_ARCHIVE_CATALOGUE.Creater, " +
        "T_ARCHIVE_CATALOGUE.UndertakerID,T_ARCHIVE_CATALOGUE.UndertakerName, " +
        "T_ARCHIVE_CATALOGUE.DepartmentID,T_ARCHIVE_CATALOGUE.DepartmentName, " +
        "T_ARCHIVE_CATALOGUE.ParentDepartmentID,T_ARCHIVE_CATALOGUE.DepartmentName ,T_ARCHIVE_CATALOGUE.PrimaryArchiveNo " +
        "FROM T_ARCHIVE_CATALOGUE ";

    public CatalogueVO() {
    }

	/**
	*
	* @return the String value of fileNo.
	*/
	public String getFileNo(){
		return fileNo;
	}

	/**
	*
	* @param aFileNo - the new value for fileNo
	*/
	public void setFileNo(String aFileNo){
		fileNo = aFileNo;
	}


	/**
	*
	* @return the String value of catalogueName.
	*/
	public String getCatalogueName(){
		return catalogueName;
	}

	/**
	*
	* @param aCatalogueName - the new value for catalogueName
	*/
	public void setCatalogueName(String aCatalogueName){
		catalogueName = aCatalogueName;
	}


	/**
	*
	* @return the String value of catalogueFunction.
	*/
	public String getCatalogueFunction(){
		return catalogueFunction;
	}

	/**
	*
	* @param aCatalogueFunction - the new value for catalogueFunction
	*/
	public void setCatalogueFunction(String aCatalogueFunction){
		catalogueFunction = aCatalogueFunction;
	}


	/**
	*
	* @return the String value of caseName.
	*/
	public String getCaseName(){
		return caseName;
	}

	/**
	*
	* @param aCaseName - the new value for caseName
	*/
	public void setCaseName(String aCaseName){
		caseName = aCaseName;
	}


	/**
	*
	* @return the String value of abreastName.
	*/
	public String getAbreastName(){
		return abreastName;
	}

	/**
	*
	* @param aAbreastName - the new value for abreastName
	*/
	public void setAbreastName(String aAbreastName){
		abreastName = aAbreastName;
	}


	/**
	*
	* @return the String value of alternativeName.
	*/
	public String getAlternativeName(){
		return alternativeName;
	}

	/**
	*
	* @param aAlternativeName - the new value for alternativeName
	*/
	public void setAlternativeName(String aAlternativeName){
		alternativeName = aAlternativeName;
	}


	/**
	*
	* @return the String value of caseReason.
	*/
	public String getCaseReason(){
		return caseReason;
	}

	/**
	*
	* @param aCaseReason - the new value for caseReason
	*/
	public void setCaseReason(String aCaseReason){
		caseReason = aCaseReason;
	}


	/**
	*
	* @return the String value of relativeCase.
	*/
	public String getRelativeCase(){
		return relativeCase;
	}

	/**
	*
	* @param aRelativeCase - the new value for relativeCase
	*/
	public void setRelativeCase(String aRelativeCase){
		relativeCase = aRelativeCase;
	}


	/**
	*
	* @return the String value of primarySender.
	*/
	public String getPrimarySender(){

		return primarySender;
	}

	/**
	*
	* @param aPrimarySender - the new value for primarySender
	*/
	public void setPrimarySender(String aPrimarySender){
		primarySender = aPrimarySender;
	}


	/**
	*
	* @return the String value of secondarySender.
	*/
	public String getSecondarySender(){
		return secondarySender;
	}

	/**
	*
	* @param aSecondarySender - the new value for secondarySender
	*/
	public void setSecondarySender(String aSecondarySender){
		secondarySender = aSecondarySender;
	}


	/**
	*
	* @return the String value of primaryReceiver.
	*/
	public String getPrimaryReceiver(){
		return primaryReceiver;
	}

	/**
	*
	* @param aPrimaryReceiver - the new value for primaryReceiver
	*/
	public void setPrimaryReceiver(String aPrimaryReceiver){
		primaryReceiver = aPrimaryReceiver;
	}


	/**
	*
	* @return the String value of secondaryReceiver.
	*/
	public String getSecondaryReceiver(){
		return secondaryReceiver;
	}

	/**
	*
	* @param aSecondaryReceiver - the new value for secondaryReceiver
	*/
	public void setSecondaryReceiver(String aSecondaryReceiver){
		secondaryReceiver = aSecondaryReceiver;
	}


	/**
	*
	* @return the String value of receiverAdjustment.
	*/
	public String getReceiverAdjustment(){
		return receiverAdjustment;
	}

	/**
	*
	* @param aReceiverAdjustment - the new value for receiverAdjustment
	*/
	public void setReceiverAdjustment(String aReceiverAdjustment){
		receiverAdjustment = aReceiverAdjustment;
	}


	/**
	*
	* @return the String value of senderAdjustment.
	*/
	public String getSenderAdjustment(){
		return senderAdjustment;
	}

	/**
	*
	* @param aSenderAdjustment - the new value for senderAdjustment
	*/
	public void setSenderAdjustment(String aSenderAdjustment){
		senderAdjustment = aSenderAdjustment;
	}


	/**
	*
	* @return the String value of documentType.
	*/
	public String getDocumentType(){
		return documentType;
	}

	/**
	*
	* @param aDocumentType - the new value for documentType
	*/
	public void setDocumentType(String aDocumentType){
		documentType = aDocumentType;
	}


	/**
	*
	* @return the String value of copyType.
	*/
	public String getCopyType(){
		return copyType;
	}

	/**
	*
	* @param aCopyType - the new value for copyType
	*/
	public void setCopyType(String aCopyType){
		copyType = aCopyType;
	}


	/**
	*
	* @return the String value of securityLevel.
	*/
	public String getSecurityLevel(){
		return securityLevel;
	}

	/**
	*
	* @param aSecurityLevel - the new value for securityLevel
	*/
	public void setSecurityLevel(String aSecurityLevel){
		securityLevel = aSecurityLevel;
	}


	/**
	*
	* @return the String value of decryptRestriction.
	*/
	public String getDecryptRestriction(){
		return decryptRestriction;
	}

	/**
	*
	* @param aDecryptRestriction - the new value for decryptRestriction
	*/
	public void setDecryptRestriction(String aDecryptRestriction){
		decryptRestriction = aDecryptRestriction;
	}


	/**
	*
	* @return the int value of keepingYears.
	*/
	public int getKeepingYears(){
		return keepingYears;
	}

	/**
	*
	* @param aKeepingYears - the new value for keepingYears
	*/
	public void setKeepingYears(int aKeepingYears){
		keepingYears = aKeepingYears;
	}


	/**
	*
	* @return the String value of appliedRestriction.
	*/
	public String getAppliedRestriction(){
		return appliedRestriction;
	}

	/**
	*
	* @param aAppliedRestriction - the new value for appliedRestriction
	*/
	public void setAppliedRestriction(String aAppliedRestriction){
		appliedRestriction = aAppliedRestriction;
	}


	/**
	*
	* @return the String value of status.
	*/
	public String getStatus(){
		return status;
	}

	/**
	*
	* @param aStatus - the new value for status
	*/
	public void setStatus(String aStatus){
		status = aStatus;
	}


	/**
	*
	* @return the int value of adjustedKeepingYears.
	*/
	public int getAdjustedKeepingYears(){
		return adjustedKeepingYears;
	}

	/**
	*
	* @param aAdjustedKeepingYears - the new value for adjustedKeepingYears
	*/
	public void setAdjustedKeepingYears(int aAdjustedKeepingYears){
		adjustedKeepingYears = aAdjustedKeepingYears;
	}


	/**
	*
	* @return the String value of adjustReason.
	*/
	public String getAdjustReason(){
		return adjustReason;
	}

	/**
	*
	* @param aAdjustReason - the new value for adjustReason
	*/
	public void setAdjustReason(String aAdjustReason){
		adjustReason = aAdjustReason;
	}


	/**
	*
	* @return the String value of auditedDestoryWord.
	*/
	public String getAuditedDestoryWord(){