【Java开源代码栏目提醒】:网学会员为广大网友收集整理了,VolumnAndArchive.java,希望对大家有所帮助!
//package com.stsc.archive.xml;
package com.stsc.archive.backup;
/*
案卷:相同案卷号的一条案卷记录和文件表集合
*/
import java.io.*; //
Java基础包,包含各种IO操作
import java.util.*; //Java基础包,包含各种标准数据结构操作
import javax.xml.parsers.*; //XML解析器接口
import org.w3c.dom.*; //XML的DOM实现
import org.apache.crimson.tree.XmlDocument;//写XML文件要用到
import javax.xml.transform.*;
import javax.
xml.transform.stream.*;
import javax.xml.transform.dom.*;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
import com.stsc.archive.manage.Constants;
import com.stsc.archive.backup.CopyFile;
public class VolumnAndArchive extends fVolumn
{
private fArchiveVector archiveVector = null;
public fArchiveVector getArchiveVector()
{
return this.archiveVector;
}
//设置案卷表的一条记录
public void setVolumn(fVolumn volumn)
{
setVolumnid(volumn.getVolumnid());
setArchivetype(volumn.getArchivetype());
setVolumnno(volumn.getVolumnno());
setVolumntitle(volumn.getVolumntitle());
setCode(volumn.getCode());
setCategory(volumn.getCategory());
setRetentionperiod(volumn.getRetentionperiod());
setStartdate(volumn.getStartdate());
setEnddate(volumn.getEnddate());
setTotalnum(volumn.getTotalnum());
setTotalpage(volumn.getTotalpage());
setDuty(volumn.getDuty());
setSecurityclass(volumn.getSecurityclass());
setArchiveunit(volumn.getSecurityclass());
setKeyword(volumn.getKeyword());
setRemark(volumn.getRemark());
setStatus(volumn.getStatus());
setAbstract1(volumn.getAbstract1());
setDeleted(volumn.getDeleted()); //add
}
//设置文件表集
public void setArchiveVector(fArchiveVector archiveVector)
{
this.archiveVector = archiveVector;
}
public void setArchiveVector()
{
System.out.println("volumnno="+getVolumnno());
getData(getVolumnno());
}
/**
保存到数据库
*/
public void save()
{
saveToDb();
if(archiveVector != null)
{
for(int i=0; i<archiveVector.getLength(); i++)
{
archiveVector.get(i).saveToDb();
}
}
}
/**
从数据库中读取数据
*/
public boolean getData(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"));
setKey
word(rs.getString("KeyWord"));
setRemark(rs.getString("Remark"));
setStatus(rs.getString("Status"));
setAbstract1(rs.getString("Abstract"));
setDeleted(rs.getString("Deleted")); //add
//---------获取文件表----------------------------
sql = "SELECT * FROM fArchive WHERE VolumnNo='" + volumnno + "'";
rs = data.getSTResult(sql, dbBase);
archiveVector = null; //先清空
while(rs!=null && rs.next())
{
fArchive archive = new fArchive();
//------------------------------------------------------------
archive.setSerialno(rs.getInt("SerialNo"));
archive.setStatus(rs.getInt("Status"));
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.get