farchive.java

一套完整的档案管理系统

    }

    /**
     * Return the pagenumber.
     */
    public int getPagenumber() {
		return (this.pagenumber);
    }

    /**
     * Set the pagenumber.
     *
     * @param pagenumber The new pagenumber
     */
    public void setPagenumber(int pagenumber) {
        this.pagenumber = pagenumber;
    }

    /**
     * Return the duty.
     */
    public String getDuty() {
		return (this.duty);
    }

    /**
     * Set the duty.
     *
     * @param duty The new duty
     */
    public void setDuty(String duty) {
        this.duty = (duty==null)?"":duty;
    }

    /**
     * Return the otherduty.
     */
    public String getOtherduty() {
		return (this.otherduty);
    }

    /**
     * Set the otherduty.
     *
     * @param otherduty The new otherduty
     */
    public void setOtherduty(String otherduty) {
        this.otherduty = (otherduty==null)?"":otherduty;
    }

    /**
     * Return the electronicfilename.
     */
    public String getElectronicfilename() {
		return (this.electronicfilename);
    }

    /**
     * Set the electronicfilename.
     *
     * @param electronicfilename The new electronicfilename
     */
    public void setElectronicfilename(String electronicfilename) {
        this.electronicfilename = (electronicfilename==null)?"":electronicfilename;
    }

    /**
     * Return the attachmenttitle.
     */
    public String getAttachmenttitle() {
		return (this.attachmenttitle);
    }

    /**
     * Set the attachmenttitle.
     *
     * @param attachmenttitle The new attachmenttitle
     */
    public void setAttachmenttitle(String attachmenttitle) {
        this.attachmenttitle = (attachmenttitle==null)?"":attachmenttitle;
    }

    /**
     * Return the keyword.
     */
    public String getKeyword() {
		return (this.keyword);
    }

    /**
     * Set the keyword.
     *
     * @param keyword The new keyword
     */
    public void setKeyword(String keyword) {
        this.keyword = (keyword==null)?"":keyword;
    }

    /**
     * Return the memo.
     */
    public String getMemo() {
		return (this.memo);
    }

    /**
     * Set the memo.
     *
     * @param memo The new memo
     */
    public void setMemo(String memo) {
        this.memo = (memo==null)?"":memo;
    }

    /**
     * Return the annotation.
     */
    public String getAnnotation() {
		return (this.annotation);
    }

    /**
     * Set the annotation.
     *
     * @param annotation The new annotation
     */
    public void setAnnotation(String annotation) {
        this.annotation = (annotation==null)?"":annotation;
    }

    /**
     * Return the abstractmsg.
     */
    public String getAbstractmsg() {
		return (this.abstractmsg);
    }

    /**
     * Set the Abstract.
     *
     * @param Abstract The new Abstract
     */
    public void setAbstractmsg(String abstractmsg) {
        this.abstractmsg = (abstractmsg==null)?"":abstractmsg;
    }

    /**
     * Return the copys.
     */
    public int getCopys() {
	return (this.copys);
    }

    /**
     * Set the copys.
     *
     * @param copys The new copys
     */
    public void setCopys(int copys) {
        this.copys = copys;
    }

    /**
     * Return the lendnum.
     */
    public int getLendnum() {
	return (this.lendnum);
    }

    /**
     * Set the lendnum.
     *
     * @param lendnum The new lendnum
     */
    public void setLendnum(int lendnum) {
        this.lendnum = lendnum;
    }

    /**
     * Return the securityclass.
     */
    public String getSecurityclass() {
		return (this.securityclass);
    }

    /**
     * Set the securityclass.
     *
     * @param securityclass The new securityclass
     */
    public void setSecurityclass(String securityclass) {
        this.securityclass = (securityclass==null)?"":securityclass;
    }

    /**
     * Return the securityterm.
     */
    public int getSecurityterm() {
		return (this.securityterm);
    }

    /**
     * Set the securityterm.
     *
     * @param securityterm The new securityterm
     */
    public void setSecurityterm(int securityterm) {
        this.securityterm = securityterm;
    }

    /**
     * Return the decryptiondate.
     */
    public Date getDecryptiondate() {
		return (this.decryptiondate);
    }

    /**
     * Set the decryptiondate.
     *
     * @param decryptiondate The new decryptiondate
     */
    public void setDecryptiondate(Date decryptiondate) {
        this.decryptiondate = decryptiondate;
    }

    /**
     * Set the decryptiondate.
     *
     * @param decryptiondate The new decryptiondate
     */
    public void setDecryptiondate(String decryptiondate) {
        java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
        try {
            this.decryptiondate = sdf.parse(decryptiondate);
        }catch(Exception e) {
        }
    }

    /**
     * Return the retentionperiod.
     */
    public String getRetentionperiod() {
		return (this.retentionperiod);
    }

    /**
     * Set the retentionperiod.
     *
     * @param retentionperiod The new retentionperiod
     */
    public void setRetentionperiod(String retentionperiod) {
        this.retentionperiod = (retentionperiod==null)?"":retentionperiod;
    }

    /**
     * Return the archivedate.
     */
    public Date getArchivedate() {
		return (this.archivedate);
    }

    /**
     * Set the archivedate.
     *
     * @param archivedate The new archivedate
     */
    public void setArchivedate(Date archivedate) {
        this.archivedate = archivedate;
    }

    /**
     * Set the archivedate.
     *
     * @param archivedate The new archivedate
     */
    public void setArchivedate(String archivedate) {
        java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
        try {
            this.archivedate =sdf.parse(archivedate);
        }catch(Exception e) {
        }
    }

    /**
     * Return the destroydate.
     */
    public Date getDestroydate() {
	return (this.destroydate);
    }

    /**
     * Set the destroydate.
     *
     * @param destroydate The new destroydate
     */
    public void setDestroydate(Date destroydate) {
        this.destroydate = destroydate;
    }

    /**
     * Set the destroydate.
     *
     * @param destroydate The new destroydate
     */
    public void setDestroydate(String destroydate) {
        java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
        try {
            this.destroydate = sdf.parse(destroydate);
        }catch(Exception e) {
        }
    }


    /**
     * Return the archivalcode.
     */
    public String getArchivalcode() {
		return (this.archivalcode);
    }

    /**
     * Set the archivalcode.
     *
     * @param archivalcode The new archivalcode
     */
    public void setArchivalcode(String archivalcode) {
        this.archivalcode = (archivalcode==null)?"":archivalcode;
    }

	/**
     * Return the archiveno.
     */
    public String getArchiveno() {
		return (this.archiveno);
    }

    /**
     * Set the archiveno.
     *
     * @param archiveno The new archiveno
     */
    public void setArchiveno(String archiveno) {
        this.archiveno = (archiveno==null)?"":archiveno;
    }

    /**
     * Return the handover.
     */
    public String getHandover() {
		return (this.handover);
    }

    /**
     * Set the handover.
     *
     * @param handover The new handover
     */
    public void setHandover(String handover) {
        this.handover = (handover==null)?"":handover;
    }

    /**
     * Return the suggest.
     */
    public String getSuggest() {
		return (this.suggest);
    }

    /**
     * Set the suggest.
     *
     * @param suggest The new suggest
     */
    public void setSuggest(String suggest) {
        this.suggest = (suggest==null)?"":suggest;
    }

    /**
     * Return the recordtransfer.
     */
    public String getRecordtransfer() {
		return (this.recordtransfer);
    }

    /**
     * Set the recordtransfer.
     *
     * @param recordtransfer The new recordtransfer
     */
    public void setRecordtransfer(String recordtransfer) {
        this.recordtransfer = (recordtransfer==null)?"":recordtransfer;
    }

    /**
     * Return the filingtrace.
     */
    public String getFilingtrace() {
		return (this.filingtrace);
    }

    /**
     * Set the filingtrace.
     *
     * @param filingtrace The new filingtrace
     */
    public void setFilingtrace(String filingtrace) {
        this.filingtrace = (filingtrace==null)?"":filingtrace;
    }

    /**
     * Return the filingscripts.
     */
    public String getFilingscripts() {
		return (this.filingscripts);
    }

    /**
     * Set the filingscripts.
     *
     * @param filingscripts The new filingscripts
     */
    public void setFilingscripts(String filingscripts) {
        this.filingscripts = (filingscripts==null)?"":filingscripts;
    }
    
    public String getReappraisedates()
    {
    	return this.reappraisedates;
    }
    public void setReappraisedates(String reappraisedates)
    {
    	this.reappraisedates = reappraisedates;
    }

 /**   
    public Date getreappraisedates() {
		return (this.reappraisedates);
    }
    public void setReappraisedates(Date reappraisedates) {
        this.reappraisedates = reappraisedates;
    }
    public void setReappraisedates(String reappraisedates) {
        java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
        try {
            this.reappraisedates = sdf.parse(reappraisedates);
        }catch(Exception e) {
        }
    }
  */  
/**	
	//对数据的操作.
	public void save(String action,String serialno){
		java.text.SimpleDateFormat sdf1 = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
		Properties dbBase = new Properties();
    dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
	 STPoolDataSet data = new STPoolDataSet();
			//如果标准单项类的操作类型为更新，则进行以下操作
			if(action.equals("Edit")){
				String sql2="UPDATE  fArchive SET Title ='"+title+"',FILETYPE='"+filetype+"',";
				sql2+=" LiteratureType='"+literaturetype+"',TitleRemark='"+titleremark+"',code='"+code+"',";
				sql2+=" Category='"+category+"',archivetype='"+archivetype+"',";
				sql2+=" fileno='"+fileno+"',filedate=cdate('"+sdf1.format(getFiledate())+"'),pagenumber="+pagenumber+",";
				sql2+=" duty='"+duty+"',otherduty='"+otherduty+"',electronicfilename='"+electronicfilename+"',";
				sql2+=" keyword='"+keyword+"',memo='"+memo+"',annotation='"+annotation+"',";
				sql2+=" abstract='"+abstractmsg+"',lendnum="+lendnum+",securityclass='"+securityclass+"',";
				sql2+=" securityterm='"+securityterm+"',decryptiondate=cdate('"+sdf1.format(decryptiondate)+"'),retentionperiod="+retentionperiod+",";
				sql2+=" archivedate=cdate('"+sdf1.format(archivedate)+"'),destroydate=cdate('"+sdf1.format(destroydate)+"'),archiveno='"+archiveno+"',";
				sql2+=" handover='"+handover+"',suggest='"+suggest+"',archivalcode='"+archivalcode+"',";
				sql2+=" recordtransfer='"+recordtransfer+"',filingtrace='"+filingtrace+"',filingscripts='"+filingscripts+"',";
				sql2+=" reappraisedates=cdate('"+sdf1.format(reappraisedates)+"'),attachmenttitle='"+attachmenttitle+"'";
				sql2+=" WHERE SERIALNO="+serialno;
				data.executeSQL(sql2,dbBase);
			}
			//如果单位单项类的操作类型为删除，则进行以下操作
			else if(action.equals("Delete")){
				String sql3 = " DELETE  FROM fArchive WHERE SERIALNO="+Integer.parseInt(serialno);
				data.executeSQL(sql3,dbBase);
			}
			//如果单位单项类的操作类型为增加，则进行以下操作
			else if(action.equals("Create")){
				String sql1="INSERT INTO fArchive(FileType,Title,LiteratureType,ArchiveType,Code,Category,";
				sql1+=" TitleRemark,FileNo,FileDate,PageNumber,Duty,OtherDuty,ElectronicFileName,KeyWord,Memo,";
				sql1+=" Annotation,Abstract,Copys,LendNum,SecurityClass,SecurityTerm,DecryptionDate,RetentionPeriod,";
				sql1+=" ArchiveDate,DestroyDate,ArchiveNo,HandOver,Suggest,RecordTransfer,FilingTrace,FilingScripts,ReAppraiseDates,archivalcode,attachmenttitle) ";
				sql1+=" VALUES('"+filetype+"','"+title+"','"+literaturetype+"','"+archivetype+"'";
				sql1+=" ,'"+code+"','"+category+"','"+titleremark+"','"+fileno+"',cdate('"+sdf1.format(getFiledate())+"'),"+pagenumber+",'"+duty+"','"+otherduty+"'";
				sql1+=" ,'"+electronicfilename+"','"+keyword+"','"+memo+"','"+annotation+"','"+abstractmsg+"',"+copys+","+lendnum+"";
				sql1+=" ,'"+securityclass+"',"+securityterm+",cdate('"+sdf1.format(decryptiondate)+"'),"+retentionperiod+",cdate('"+sdf1.format(archivedate)+"'),cdate('"+sdf1.format(destroydate)+"')";
				sql1+=" ,'"+archiveno+"','"+handover+"','"+suggest+"','"+recordtransfer+"','"+filingtrace+"'";
				sql1+=" ,'"+filingscripts+"',cdate('"+sdf1.format(reappraisedates)+"'),'"+archivalcode+"','"+attachmenttitle+"')";
				System.out.println("sql========");
				data.executeSQL(sql1,dbBase);
		    }
	}

	//对数据的操作.
	public String searchsql(String action,String serialno){
		//java.text.SimpleDateFormat sdf1 = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
		//Properties dbBase = new Properties();
		//dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
		//STPoolDataSet data = new STPoolDataSet();
			//如果标准单项类的操作类型为查询，则进行以下操作
		String sql="";
		if (serialno!="")
		{
			sql="SELECT * FROM FARCHIVE WHERE SERIALNO="+serialno;
		}else{
			sql="SELECT * FROM FARCHIVE ORDER BY SERIALNO";
		}
		return sql;
	}
*/
}