("2"))
{
sql=" select * from KJB2_KJXX_YYB "
+" where READERID="+strREADERID+" and ZT='生效' and DQSJ>='"+strNow+"'";
}
return searchData(sql);
}
//分页取得书籍
public Vector getPageBorBooks(String zgbh,String type,int page)
{
String sql="";
String strNow = ds.getDateTime();
strNow = strNow.substring(0,10);
sql="select READERID from KJB2_KJXX_READER where GH='"+zgbh+"' and(ZT='注册' or ZT='挂失')";
Hashtable hash = (Hashtable)searchOneData(sql);
String strREADERID=ds.toString((String)hash.get("READERID"));
if(strREADERID.equals("")) strREADERID="-1";
//在借的所有书籍
if(type.equals("0"))
{
sql="select * from KJB2_KJXX_JYB where READERID="+strREADERID+" and ZT='"+strZero+"' order by JYSJ";
System.out.println(sql);
}
//借阅历史
if(type.equals("1"))
{
sql="select * from KJB2_KJXX_JYB where READERID="+strREADERID+" and ZT='"+strOne+"' order by GHRQ";
}
//所有有效预约书
if(type.equals("2"))
{
sql=" select * from KJB2_KJXX_YYB "
+" where READERID="+strREADERID+" and ZT='生效' and DQSJ>='"+strNow+"'";
}
return getOnePage(sql,page,20);
}
//续借
public int[] setContinue(String zgbh,String jyid)
{
String sql="";
sql="select KXJSJ from KJB2_KJXX_RULE,KJB2_KJXX_READER "
+" where KJB2_KJXX_READER.GH='"+zgbh+"' and KJB2_KJXX_READER.RULEID=KJB2_KJXX_RULE.RULEID ";
Hashtable hash = (Hashtable)searchOneData(sql);
String strKXJSJ=ds.toString((String)hash.get("KXJSJ"));
sql=" update KJB2_KJXX_JYB set XJCS=XJCS+1,DQSJ=to_char((to_date(DQSJ,'yyyy-MM-dd')+"+strKXJSJ+"),'yyyy-MM-dd') "
+" where JYID="+jyid+"";
System.out.println("sqlsql:"+sql);
/*return deleteRecord(sql);*/
createStatement();
clearBatch();
addBatch(sql);
int result[]=executeBatch();
closeStm();
return result;
}
//取消预约
public int setConcel(String yyid)
{
String sql="";
sql="update KJB2_KJXX_YYB set ZT='取消' where YYID="+yyi
上一篇:
borrow.java
下一篇:
计算机仿真论文1