【Java开源代码栏目提醒】:网学会员--在 Java开源代码编辑为广大网友搜集整理了:tsyyBean.java绩等信息,祝愿广大网友取得需要的信息,参考学习。
/**********************************************************
Copyright (C),2004-8-12, Beijing USTB.
All rights reserved.
Filename:tsyyBean.java
Author: 郝文瑞
Version 1.0
Date:2004-8-12
Description:书籍预约
Other:
Variable List:
Function List:
History:
***********************************************************/
package kjb2.library.bean;
import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import kjb.main.*;
public class tsyyBean extends ParentBean
{
private String id = "-1";
//设置馆ID
public void setID(String i)
{
id = i;
}
//取得所有信息内容
public Vector getData()
{
String sql = "";
sql = "select * from KJB2_KJXX_YYB,KJB2_KJXX_Book,KJB2_KJXX_Reader where KJB2_KJXX_YYB.ZT='生效' and KJB2_KJXX_Book.BookClassID=KJB2_KJXX_YYB.BookClassID and KJB2_KJXX_Reader.ReaderID=KJB2_KJXX_YYB.ReaderID order by YYID";
return searchData(sql);
}
//分页取得所有信息
public int getsqh(String sqh)
{
String sql="select * from KJB2_KJXX_Store where SQH='"+sqh+"'";
Vector vect=searchData(sql);
return vect.size();
}
public int getzjh(String zjh)
{
String sql="select * from KJB2_KJXX_Reader where ZJH='"+zjh+"'";
Vector vect=searchData(sql);
return vect.size();
}
public Vector getPageData(int page)
{
String sql ="";
sql = "select * from KJB2_KJXX_YYB,KJB2_KJXX_Book,KJB2_KJXX_Reader where KJB2_KJXX_YYB.ZT='生效' and KJB2_KJXX_Book.BookClassID=KJB2_KJXX_YYB.BookClassID and KJB2_KJXX_Reader.ReaderID=KJB2_KJXX_YYB.ReaderID order by YYID";
return getOnePage(sql,page,20);
}
//根据某库取得此库的详细信息
public Hashtable getOneData()
{
String sql="";
sql = "select * from KJB2_KJXX_YYB,KJB2_KJXX_Book,KJB2_KJXX_Reader where KJB2_KJXX_YYB.ZT='生效' and KJB2_KJXX_Book.BookClassID=KJB2_KJXX_YYB.BookClassID and KJB2_KJXX_Reader.ReaderID=KJB2_KJXX_YYB.ReaderID and YYID="+id+"";
return searchOneData(
sql);
}
//新增库
public int adddata(Hashtable hash)
{
int intID = makeID("KJB2_KJXX_YYB","YYID","","",false);
String strsqh = ds.toString((String)hash.get("SQH"));
String strzjh = ds.toString((String)hash.get("ZJH"));
String stryysj= ds.toString((String)hash.get("YYSJ"));
String sql="select * from KJB2_KJXX_Reader where ZJH='"+strzjh+"'";
Hashtable hash1=searchOneData(sql);
String strrid = ds.toString((String)hash1.get("READERID"));
String strruleid = ds.toString((String)hash1.get("RULEID"));
sql="select to_char((to_date('"+stryysj+"','yyyy-MM-dd')+KYYSJ),'yyyy-MM-dd') as KYYSJ from KJB2_KJXX_Rule where RULEID="+strruleid;
hash1=searchOneData(sql);
String strkyysj= ds.toString((String)hash1.get("KYYSJ"));
sql="select * from KJB2_KJXX_Store where SQH='"+strsqh+"'";
hash1=searchOneData(sql);
String strbid = ds.toString((String)hash1.get("BOOKCLASSID"));
String strsid = ds.toString((String)hash1.get("STOREID"));
Vector vect = new Vector();
vect.add("KJB2_KJXX_YYB");
vect.add(addVector("YYID",String.valueOf(intID),"NUM"));
vect.add(addVector("BOOKCLASSID",strbid,"NUM"));
vect.add(addVector("STOREID",strsid,"NUM"));
vect.add(addVector("READERID",strrid,"NUM"));
vect.add(addVector("YYSJ",stryysj,"CHAR"));
vect.add(addVector("DQSJ",strkyysj,"CHAR"));
vect.add(addVector("ZT","生效","CHAR"));
return insertRecord(vect);
}
//新增库
public int addYY(String readerID,String BOOKCLASSID)
{
int intID = makeID("KJB2_KJXX_YYB","YYID","","",false);
String stryysj = (ds.getDateTime()).substring(0,10);
String strruleid = toName("KJB2_KJXX_Reader","READERID","RULEID",readerID);
String sql="select to_char((to_date('"+stryysj+"','yyyy-MM-dd')+KYYSJ),'yyyy-MM-dd') as KYYSJ from KJB2_KJXX_Rule where RULEID="+strruleid;
Hashtable hash1=searchOneData(sql);
String strkyysj= ds.toString((String)hash1.get("KYYSJ"));
System.out.println("RULEID:"+strruleid+"\n"+"strkyysj:"+strkyysj+"stryysj:"+stryysj);
Vector vect = new Vector();
vect.add("KJB2_KJXX_YYB");
vect.add(addVector("YYID",String.valueOf(intID),"NUM"));
vect.add(addVector("BOOKCLASSID",BOOKCLASSID,"NUM"));
vect.add(addVector("STOREID","-1","NUM"));
vect.