【Java开源代码栏目提醒】:网学会员Java开源代码为您提供CommonSql.java参考,解决您在CommonSql.java学习中工作中的难题,参考学习。
package com.stsc.archive.manage;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.Properties;
import org.apache.struts.util.MessageResources;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
//import com.stsc.archive.xml.*;
public final class CommonSql
{
/**
根据流水号恢复文件表
*/
/* public void restoreArchive(fArchive archive)
{
Properties dbBase = new Properties();
dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
//先清除原有数据
int serialno = archive.getSerialno();
STPoolDataSet data = new STPoolDataSet();
String sql = "DELETE FROM fArchive WHERE SerialNo=" + serialno;
data.executeSQL(sql, dbBase);
sql = "INSERT INTO fArchive(SerialNo, Status, Deleted, RepFlag, ArchiveType, FileType, Title, LiteratureType, TitleRemark, FileNo, FileDate, KeyWord, Code, Category, PageNumber, Duty, OtherDuty, ElectronicFileName, AttachmentTitle, Memo, Copys, LendNum, SecurityClass, SecurityTerm, DecryptionDate, RetentionPeriod, ArchiveDate, ArchiveDate, DestroyDate, ArchivalCode, DossierNo, ArchiveNo, UnitNo, FilingTrace, HandOver, FilingScripts, ReAppraiseDates, Annotation, abstract, Suggest, RecordTransfer) VALUES(" + archive.getSerialno() + "," + archive.getStatus() + ",";
}
public void restoreArchive(fArchiveVector myvector)
{
for(int i=0; i<myvector.getLength(); i++)
{
restoreArchive(myvector.get(i));
}
}
*/
/**
根据流水号得到fArchiveVector
*/
/* public fArchiveVector getArchive(int serialno)
{
System.out.println("-----begin getArchive-----serialno="+Integer.toString(serialno));
Properties dbBase = new Properties();
dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
STPoolDataSet data = new STPoolDataSet();
String sql = "SELECT * FROM fArchive WHERE SerialNo=" + serialno;
STResultSet rs = data.getSTResult(sql, dbBase);
if (rs!=null && rs.next())
{
fArchive archive = new fArchive();
archive.setSerialno(rs.getInt("SerialNo"));System.out.println("aaaaaaaaa");
archive.setStatus(rs.getInt("Status"));System.out.println("ca");
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.getString("FileNo"));
archive.setFiledate(rs.getDate("FileDate"));
archive.setKeyword(rs.getString("KeyWord"));
archive.setCode(rs.getString("Code"));
archive.setCategory(rs.getString("Category"));
archive.setPagenumber(rs.getInt("PageNumber"));
archive.setDuty(rs.getString("Duty"));
archive.setOtherduty(rs.getString("OtherDuty"));
archive.setElectronicfilename(rs.getString("ElectronicFileName"));
archive.setAttachmenttitle(rs.getString("AttachmentTitle"));
archive.setMemo(rs.getString("Memo"));
archive.setCopys(rs.getInt("Copys"));
archive.setLendnum(rs.getInt("LendNum"));
archive.setSecurityclass(rs.getString("SecurityClass"));
archive.setSecurityterm(rs.getInt("SecurityTerm"));
archive.setDecryptiondate(rs.getDate("DecryptionDate"));
archive.setRetentionperiod(rs.getInt("RetentionPeriod"));
archive.setArchivedate(rs.getDate("ArchiveDate"));
archive.setDestroydate(rs.getDate("DestroyDate"));System.out.println("bbbbbbbbbb");
archive.setArchivalcode(rs.getString("ArchivalCode"));
archive.setDossierno(rs.getString("DossierNo"));
archive.setArchiveno(rs.getString("ArchiveNo"));
archive.setUnitno(rs.getString("UnitNo"));
archive.setFilingtrace(rs.getString("FilingTrace"));
archive.setHandover(rs.getString("HandOver"));
archive.setFilingscripts(rs.getString("FilingScripts"));
archive.setReappraisedates(rs.getString("ReAppraiseDates"));System.out.println("aaaaaaaaa");
archive.setAnnotation(rs.getString("Annotation"));
archive.setAbstractmsg(rs.getString("Abstract"));
archive.setSuggest(rs.getString("Suggest"));
archive.setRecordtransfer(rs.getString("RecordTransfer"));
fArchiveVector myvector = new fArchiveVector();
myvector.add(archive);
return myvector;
}
else
{
return null;
}
}
*/
public String Iso2Gb(String str)
{
String ret=(str==null) ? "" : str;
return ret;
/* try
{
byte[] byteStr=str.getBytes("ISO-8859-1");
return new String(byteStr,"gb2312");
}
catch(Exception e)
{
return ret;
}*/
}
public void ToUserManager(ActionForm form, HttpServletRequest req)
{
Properties dbBase = new Properties();
dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
STPoolDataSet data = new STPoolDataSet();
//---------------------------------------------------------------------------------
String sql = "SELECT * FROM fUserName where EnterName<>'admin' ORDER BY EnterName ";//6.9,add admin
System.out.println(sql);
STResultSet rs = data.getSTResult(sql, dbBase);
UserList userList = new UserList();
while(rs!=null && rs.next())
{
User tuser = new User();
tuser.setEnterName(rs.getString("EnterName"));
tuser.setUserName(rs.getString("UserName"));
tuser.setDepartment(rs.getString("Department"));
tuser.setRowsPerPage(rs.getInt("RowsPerPage"));
// System.out.println(rs.getString("EnterName"));
userList.addUser(tuser);
}
// Save our logged-in user in the session
HttpSession session = req.getSession();
session.setAttribute(Constants.USER_MANAGE_KEY, userList);
//=============================================================-----------------
/** //for test
System.out.println("---------begin xml write----------------------");
try
{
System.out.println("---------begin xml write-----ok-------");
rwXmlDoc mydoc = new rwXmlDoc();
mydoc.writeXMLFile("c:\\xml\\testUser.xml", userList);
UserList mylist = null;
mylist = mydoc.readXMLFile("webapps\\work\\myuser.xml");
System.out.println("---------end xml write----------------------");
}
catch(Exception e)
{
System.out.println("rwXmlDoc error!");
}*/
}
public void ToViewPopedom(ActionForm form, HttpServletRequest req, int iRoleId)
{
Properties dbBase = new Properties();
dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
STPoolDa
上一篇:
CommonsLogger.java
下一篇:
Function GetIp(IP) 获得ip asp