cataloguevo.java

dgbas公文管理核心java源码

		return auditedDestoryWord;
	}

	/**
	*
	* @param aAuditedDestoryWord - the new value for auditedDestoryWord
	*/
	public void setAuditedDestoryWord(String aAuditedDestoryWord){
		auditedDestoryWord = aAuditedDestoryWord;
	}


	/**
	*
	* @return the Date value of destoryDate.
	*/
	public Date getDestoryDate(){
		return destoryDate;
	}

	/**
	*
	* @param aDestoryDate - the new value for destoryDate
	*/
	public void setDestoryDate(Date aDestoryDate){
		destoryDate = aDestoryDate;
	}


	/**
	*
	* @return the Date value of decryptDate.
	*/
	public Date getDecryptDate(){
		return decryptDate;
	}

	/**
	*
	* @param aDecryptDate - the new value for decryptDate
	*/
	public void setDecryptDate(Date aDecryptDate){
		decryptDate = aDecryptDate;
	}


	/**
	*
	* @return the String value of transferNote.
	*/
	public String getTransferNote(){
		return transferNote;
	}

	/**
	*
	* @param aTransferNote - the new value for transferNote
	*/
	public void setTransferNote(String aTransferNote){
		transferNote = aTransferNote;
	}


	/**
	*
	* @return the Date value of extendTransferDate.
	*/
	public Date getExtendTransferDate(){
		return extendTransferDate;
	}

	/**
	*
	* @param aExtendTransferDate - the new value for extendTransferDate
	*/
	public void setExtendTransferDate(Date aExtendTransferDate){
		extendTransferDate = aExtendTransferDate;
	}


	/**
	*
	* @return the Date value of transferDate.
	*/
	public Date getTransferDate(){
		return transferDate;
	}

	/**
	*
	* @param aTransferDate - the new value for transferDate
	*/
	public void setTransferDate(Date aTransferDate){
		transferDate = aTransferDate;
	}


	/**
	*
	* @return the String value of receiveWord.
	*/
	public String getReceiveWord(){
		return receiveWord;
	}

	/**
	*
	* @param aReceiveWord - the new value for receiveWord
	*/
	public void setReceiveWord(String aReceiveWord){
		receiveWord = aReceiveWord;
	}


	/**
	*
	* @return the String value of sendWord.
	*/
	public String getSendWord(){
		return sendWord;
	}

	/**
	*
	* @param aSendWord - the new value for sendWord
	*/
	public void setSendWord(String aSendWord){
		sendWord = aSendWord;
	}


	/**
	*
	* @return the String value of issueWord.
	*/
	public String getIssueWord(){
		return issueWord;
	}

	/**
	*
	* @param aIssueWord - the new value for issueWord
	*/
	public void setIssueWord(String aIssueWord){
		issueWord = aIssueWord;
	}


	/**
	*
	* @return the String value of yearNo.
	*/
	public String getYearNo(){
		return yearNo;
	}

	/**
	*
	* @param aYearNo - the new value for yearNo
	*/
	public void setYearNo(String aYearNo){
		yearNo = aYearNo;
	}


	/**
	*
	* @return the String value of categoryNo.
	*/
	public String getCategoryNo(){
		return categoryNo;
	}

	/**
	*
	* @param aCategoryNo - the new value for categoryNo
	*/
	public void setCategoryNo(String aCategoryNo){
		categoryNo = aCategoryNo;
	}


	/**
	*
	* @return the String value of caseNo.
	*/
	public String getCaseNo(){
		return caseNo;
	}

	/**
	*
	* @param aCaseNo - the new value for caseNo
	*/
	public void setCaseNo(String aCaseNo){
		caseNo = aCaseNo;
	}


	/**
	*
	* @return the String value of volumeNo.
	*/
	public String getVolumeNo(){
		return volumeNo;
	}

	/**
	*
	* @param aVolumeNo - the new value for volumeNo
	*/
	public void setVolumeNo(String aVolumeNo){
		volumeNo = aVolumeNo;
	}


	/**
	*
	* @return the String value of itemNo.
	*/
	public String getItemNo(){
		return itemNo;
	}

	/**
	*
	* @param aItemNo - the new value for itemNo
	*/
	public void setItemNo(String aItemNo){
		itemNo = aItemNo;
	}


	/**
	*
	* @return the String value of eletronicsNo.
	*/
	public String getEletronicsNo(){
		return eletronicsNo;
	}

	/**
	*
	* @param aEletronicsNo - the new value for eletronicsNo
	*/
	public void setEletronicsNo(String aEletronicsNo){
		eletronicsNo = aEletronicsNo;
	}


	/**
	*
	* @return the String value of eletronicsPath.
	*/
	public String getEletronicsPath(){
		return eletronicsPath;
	}

	/**
	*
	* @param aEletronicsPath - the new value for eletronicsPath
	*/
	public void setEletronicsPath(String aEletronicsPath){
		eletronicsPath = aEletronicsPath;
	}


	/**
	*
	* @return the String value of eletronicsName.
	*/
	public String getEletronicsName(){
		return eletronicsName;
	}

	/**
	*
	* @param aEletronicsName - the new value for eletronicsName
	*/
	public void setEletronicsName(String aEletronicsName){
		eletronicsName = aEletronicsName;
	}


	/**
	*
	* @return the String value of microficheNo.
	*/
	public String getMicroficheNo(){
		return microficheNo;
	}

	/**
	*
	* @param aMicroficheNo - the new value for microficheNo
	*/
	public void setMicroficheNo(String aMicroficheNo){
		microficheNo = aMicroficheNo;
	}


	/**
	*
	* @return the Date value of documentCreateDate.
	*/
	public Date getDocumentCreateDate(){
		return documentCreateDate;
	}

	/**
	*
	* @param aDocumentCreateDate - the new value for documentCreateDate
	*/
	public void setDocumentCreateDate(Date aDocumentCreateDate){
		documentCreateDate = aDocumentCreateDate;
	}


	/**
	*
	* @return the String value of mediaType.
	*/
	public String getMediaType(){
		return mediaType;
	}

	/**
	*
	* @param aMediaType - the new value for mediaType
	*/
	public void setMediaType(String aMediaType){
		mediaType = aMediaType;
	}


	/**
	*
	* @return the int value of amount.
	*/
	public int getAmount(){
		return amount;
	}

	/**
	*
	* @param aAmount - the new value for amount
	*/
	public void setAmount(int aAmount){
		amount = aAmount;
	}


	/**
	*
	* @return the String value of unit.
	*/
	public String getUnit(){
		return unit;
	}

	/**
	*
	* @param aUnit - the new value for unit
	*/
	public void setUnit(String aUnit){
		unit = aUnit;
	}


	/**
	*
	* @return the Date value of archiveDate.
	*/
	public Date getArchiveDate(){
		return archiveDate;
	}

	/**
	*
	* @param aArchiveDate - the new value for archiveDate
	*/
	public void setArchiveDate(Date aArchiveDate){
		archiveDate = aArchiveDate;
	}

        /**
        *
        * @return the String value of creater.
        */
        public String getCreater(){
                return creater;
        }

        /**
        *
        * @param aCreater - the new value for creater
        */
        public void setCreater(String aCreater){
                creater = aCreater;
        }


        /**
        *
        * @return the String value of departmentName.
        */
        public String getDepartmentName(){
                return departmentName;
        }

        /**
        *
        * @param aDepartmentName - the new value for departmentName
        */
        public void setDepartmentName(String aDepartmentName){
                departmentName = aDepartmentName;
        }


        /**
        *
        * @return the String value of undertakerName.
        */
        public String getUndertakerName(){
                return undertakerName;
        }

        /**
        *
        * @param aUndertakerName - the new value for undertakerName
        */
        public void setUndertakerName(String aUndertakerName){
                undertakerName = aUndertakerName;
        }


        /**
        *
        * @return true if merage is set to true.
        */
        public boolean isMerage(){
                return merage;
        }

        /**
        *
        * @param aMerage - the new value for merage
        */
        public void setMerage(boolean aMerage){
                merage = aMerage;
        }


        /**
        *
        * @return the String value of primaryFileNo.
        */
        public String getPrimaryFileNo(){
                return primaryFileNo;
        }

        /**
        *
        * @param aPrimaryFileNo - the new value for primaryFileNo
        */
        public void setPrimaryFileNo(String aPrimaryFileNo){
                primaryFileNo = aPrimaryFileNo;
        }
        public static CatalogueVO[] find(String whereClause)
        {
        	DbConn dbConn = new DbConn();
        	Connection con = dbConn.getConnection();
        	PreparedStatement preparedStatement = null;
        	ResultSet rs = null;
        	CatalogueVO result=null;
        	Collection results = new ArrayList();
        	String sqlString;
        	try {
            		if (whereClause != null) 
                		sqlString = FIND_ALL_SQL + whereClause;
                        else 
                	   	sqlString = FIND_ALL_SQL;
		        preparedStatement = con.prepareStatement(sqlString);
		        System.out.println(sqlString);
            		rs = preparedStatement.executeQuery();
            		while(rs.next())
            		{
            			result = new CatalogueVO();
            			result.setCatalogueName(rs.getString("CatalogueName"));
            			result.setCatalogueFunction(rs.getString("CatalogueFunction"));
            			result.setCaseReason(rs.getString("CaseReason"));
            			result.setPrimarySender(rs.getString("PrimarySender"));
            			result.setPrimaryReceiver(rs.getString("PrimaryReceiver"));
            			result.setDocumentType(rs.getString("DocumentType"));
            			result.setCopyType(rs.getString("CopyType"));
            			result.setSecurityLevel(rs.getString("SecurityLevel"));
            			result.setStatus(rs.getString("Status"));
            			result.setAppliedRestriction(rs.getString("AppliedRestriction"));
            			result.setYearNo(rs.getString("YearNo"));
            			result.setCategoryNo(rs.getString("CategoryNo"));
            			result.setCaseNo(rs.getString("CaseNo"));
            			result.setVolumeNo(rs.getString("VolumeNo"));
            			result.setItemNo(rs.getString("ItemNo"));
            			result.setDocumentCreateDate(rs.getDate("DocumentCreateDate"));
            			result.setDecryptDate(rs.getDate("DecryptDate"));
            			result.setDepartmentName(rs.getString("DepartmentName"));
            			result.setUndertakerName(rs.getString("UndertakerName"));
            			result.setCreater(rs.getString("Creater"));
            			result.setPrimaryFileNo(rs.getString("PrimaryArchiveNo"));
            			results.add(result);
            			System.out.println("bb");
            			
            		}
            		
            		
        	  }
        	 catch (SQLException se) {
            			System.out.println(se.getMessage());
            		
        	}
        finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
                if (con != null) {
                    con.close();
                }
            }
            catch (SQLException se) {
                System.out.println(se.getMessage());
                return null;
                
            }
        }
        return (CatalogueVO[])results.toArray(new CatalogueVO[0]);
        
     
    }
 public static CatalogueVO ReadXml(String XmlFileName)
        {
            try{
                XmlFileName="C:\\xml\\313190000L092072901.di";
        	Document document = XmlUtil.parseXmlFile(XmlFileName,true);
        	//Element root = XmlUtil.createElement(document, ArchiveCatalogueIF.ROOT_TAG, "");
        	Element root=document.getDocumentElement(); 
        	System.out.println(XmlUtil.getElementValue("