fvolumn.java

一套完整的档案管理系统

//package com.stsc.archive.xml;
package com.stsc.archive.backup;

/*
  与数据库中表fArchive相对应的bean
*/

import java.util.Properties;
import java.util.Date;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
import com.stsc.archive.manage.Constants;

public class fVolumn
{
	private int volumnid = 0;
	private String archivetype = "";
	private String volumnno = "";	
	private String volumntitle = "";
	private String code = "";
	private String category = "";
	private String retentionperiod = "";
	private Date startdate = null;
	private Date enddate = null;
	private int totalnum = 0;
	private int totalpage = 0;
	private String duty = "";
	private String securityclass = ""; 
	private String archiveunit = "";
	private String keyword = "";
	private String remark = "";
	private String status = "";
	private String abstract1 = "";
	private String deleted = "";	//5.22add
	
	/**
	从数据库中读取数据
	*/
	public boolean getDataFromDb(int volumnId)
	{
		Properties dbBase = new Properties();
		dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        
        STPoolDataSet data = new STPoolDataSet();
        String sql = "SELECT * FROM fVolumn WHERE VolumnID=" + volumnId;
		System.out.println(sql);
        STResultSet rs = data.getSTResult(sql, dbBase);

		if (rs!=null && rs.next())
        {
        	setVolumnid(rs.getInt("VolumnID"));
        	setArchivetype(rs.getString("ArchiveType"));
        	setVolumnno(rs.getString("VolumnNo"));	System.out.println(rs.getString("VolumnNo"));
        	setVolumntitle(rs.getString("VolumnTitle"));
        	setCode(rs.getString("Code"));
        	setCategory(rs.getString("Category"));
        	setRetentionperiod(rs.getString("RetentionPeriod"));
        	setStartdate(rs.getDate("StartDate"));
        	setEnddate(rs.getDate("EndDate"));
        	setTotalnum(rs.getInt("TotalNum"));
        	setTotalpage(rs.getInt("TotalPage"));
        	setDuty(rs.getString("Duty"));
        	setSecurityclass(rs.getString("Security"));
        	setArchiveunit(rs.getString("ArchiveUnit"));
        	setKeyword(rs.getString("KeyWord"));
        	setRemark(rs.getString("Remark"));
        	setStatus(rs.getString("Status"));
        	setAbstract1(rs.getString("Abstract"));
        	setDeleted(rs.getString("Deleted"));	//add
        	
        	return true;
        }
        else
        {
        	return false;
        }
	}
	public boolean getDataFromDb(String volumnno)
	{
		if((volumnno == null) || (volumnno.length() < 1))
		{
			return false;
		}
		
		Properties dbBase = new Properties();
		dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        
        STPoolDataSet data = new STPoolDataSet();
        String sql = "SELECT * FROM fVolumn WHERE VolumnNo='" + volumnno + "'";System.out.println(sql);
        STResultSet rs = data.getSTResult(sql, dbBase);
        
        if (rs!=null && rs.next())
        {
        	setVolumnid(rs.getInt("VolumnID"));
        	setArchivetype(rs.getString("ArchiveType"));
        	setVolumnno(rs.getString("VolumnNo"));
        	setVolumntitle(rs.getString("VolumnTitle"));
        	setCode(rs.getString("Code"));
        	setCategory(rs.getString("Category"));
        	setRetentionperiod(rs.getString("RetentionPeriod"));
        	setStartdate(rs.getDate("StartDate"));
        	setEnddate(rs.getDate("EndDate"));
        	setTotalnum(rs.getInt("TotalNum"));
        	setTotalpage(rs.getInt("TotalPage"));
        	setDuty(rs.getString("Duty"));
        	setSecurityclass(rs.getString("Security"));
        	setArchiveunit(rs.getString("ArchiveUnit"));
        	setKeyword(rs.getString("KeyWord"));
        	setRemark(rs.getString("Remark"));
        	setStatus(rs.getString("Status"));
        	setAbstract1(rs.getString("Abstract"));
        	setDeleted(rs.getString("Deleted"));	//add
        	
        	return true;
        }
        else
        {
        	return false;
        }
    }
    
    /**
	保存数据到数据库
	*/
	public void saveToDb()
	{
		if((volumnno == null) || (volumnno.length() < 1))
		{
			return;
		}
		
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT); 
		
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        
        //先清除原有数据
        STPoolDataSet data = new STPoolDataSet();
        String sql = "DELETE FROM fVolumn WHERE VolumnNo='" + volumnno + "'";
        data.executeSQL(sql, dbBase);
        
        sql = "INSERT INTO fVolumn(VolumnID, ArchiveType, VolumnNo, VolumnTitle, Code, Category, ";
        sql += "RetentionPeriod, StartDate, EndDate, TotalNum, TotalPage, Duty, Security, ArchiveUnit, ";
        sql += "KeyWord, Remark, Status, Abstract, Deleted) VALUES(";
        sql += volumnid + ",'";
        sql += archivetype + "', '";
        sql += volumnno + "', '";
        sql += volumntitle + "', '";
        sql += code + "', '";
        sql += category + "', '";
        sql += retentionperiod + "',";
        
        if(startdate == null)
        {
        	sql += "null,";
        }
        else
        {
        	sql += "cdate('" + sdf.format(startdate) + "'),";
        }
        
        if(enddate == null)
        {
        	sql += "null,";
        }
        else
        {
        	sql += "cdate('" + sdf.format(enddate) + "'), ";
        }
        
        sql += totalnum + ", ";
        sql += totalpage + ", '";
        sql += duty + "', '";
        sql += securityclass + "', '";
        sql += archiveunit + "', '";
        sql += keyword + "', '";
        sql += remark + "', '";
        sql += status + "', '";
        sql += abstract1 + "','";
        sql += deleted + "')";	//add
        
        System.out.println(sql);           
		data.executeSQL(sql, dbBase);
    }
    
	
	public int getVolumnid()
	{
		return this.volumnid;
	}
	public void setVolumnid(int volumnid)
	{
		this.volumnid = volumnid;
	}
	
	public String getArchivetype()
	{
		return this.archivetype; 
	}
	public void setArchivetype(String archivetype)
	{
		this.archivetype = (archivetype==null)?"":archivetype;
	}
	
	public String getVolumnno()
	{
		return this.volumnno;
	}
	public void setVolumnno(String volumnno)
	{
		this.volumnno = (volumnno==null)?"":volumnno;
	}
	
	public String getVolumntitle()
	{
		return this.volumntitle;
	}
	public void setVolumntitle(String volumntitle)
	{
		this.volumntitle = (volumntitle==null)?"":volumntitle;
	}
	
	public String getCode()
	{
		return this.code;
	}
	public void setCode(String code)
	{
		this.code = (code==null)?"":code;
	}
	
	public String getCategory()
	{
		return this.category;
	}
	public void setCategory(String category)
	{
		this.category = (category==null)?"":category;
	}
	
	public String getRetentionperiod()
	{
		return this.retentionperiod;
	}
	public void setRetentionperiod(String retentionperiod)
	{
		this.retentionperiod = (retentionperiod==null)?"":retentionperiod;
	}
	
	public Date getStartdate()
	{
		return this.startdate;
	}
	public void setStartdate(Date startdate)
	{
		this.startdate = startdate;
	}
	public void setStartdate(String startdate)
	{
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
        try 
        {
            this.startdate = sdf.parse(startdate);
        }catch(Exception e) 
        {
        	this.startdate = null;
        }
    }
    
    public Date getEnddate()
	{
		return this.enddate;
	}
	public void setEnddate(Date enddate)
	{
		this.enddate = enddate;
	}
	public void setEnddate(String enddate)
	{
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
        try 
        {
            this.enddate = sdf.parse(enddate);
        }catch(Exception e) 
        {
        	this.enddate = null;
        }
    }
    
    public int getTotalnum()
    {
    	return this.totalnum;
    }
    public void setTotalnum(int totalnum)
    {
    	this.totalnum = totalnum;
    }
    
    public int getTotalpage()
    {
    	return this.totalpage;
    }
    public void setTotalpage(int totalpage)
    {
    	this.totalpage = totalpage;
    }
    
    public String getDuty()
    {
    	return this.duty;
    }
    public void setDuty(String duty)
    {
    	this.duty = (duty==null)?"":duty;
    }
    
    public String getSecurityclass()
    {
    	return this.securityclass;
    }
    public void setSecurityclass(String securityclass)
    {
    	this.securityclass = (securityclass==null)?"":securityclass;
    }
    
    public String getArchiveunit()
    {
    	return this.archiveunit;
    }
    public void setArchiveunit(String archiveunit)
    {
    	this.archiveunit = (archiveunit==null)?"":archiveunit;
    }
    
    public String getKeyword()
    {
    	return this.keyword;
    }
    public void setKeyword(String keyword)
    {
    	this.keyword = (keyword==null)?"":keyword;
    }
    
    public String getRemark()
    {
    	return this.remark;
    }
    public void setRemark(String remark)
    {
    	this.remark = (remark==null)?"":remark;
    }
    
    public String getStatus()
    {
    	return this.status;
    }
    public void setStatus(String status)
    {
    	this.status = (status==null)?"":status;
    }
    
    public String getAbstract1()
    {
    	return this.abstract1;
    }
    public void setAbstract1(String abstract1)
    {
    	this.abstract1 = (abstract1==null)?"":abstract1;
    }
    
    //add
    public String getDeleted()
    {
    	return this.deleted;
    }
    public void setDeleted(String deleted)
    {
    	this.deleted = (deleted == null)?"":deleted;
    }
}