tsyybean.java

Java Library systemJava Library systemJava Library systemJava Library systemJava Library system

/**********************************************************
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.add(addVector("READERID",readerID,"NUM"));
		vect.add(addVector("YYSJ",stryysj,"CHAR"));
		vect.add(addVector("DQSJ",strkyysj,"CHAR"));
		vect.add(addVector("ZT","生效","CHAR"));
		return insertRecord(vect);
	}




	//删除库信息
	public int deldata()
	{
		Vector vect = new Vector();
		vect.add("KJB2_KJXX_YYB");			
		vect.add(addVector("ZT","取消","CHAR"));		
		vect.add("YYID="+id);
		return updateRecord(vect);
	}
	//查找所有的统一函数
	private Vector searchData(String sql) 
	{
		Vector vect = new Vector();
		ResultSet rs = selectRecord(sql);

		//取得列数和列名
		Statement stmt = null;
		try{
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			while(rs.next())
			{	
				Hashtable hash = new Hashtable();
				for(int i=1;i<=cols;i++)
				{
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field,value);
				}
				vect.add(hash);
			}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return vect;	
	}

	//查找一条记录统一函数
	private Hashtable searchOneData(String sql) 
	{
		Hashtable hash = new Hashtable();
		ResultSet rs = selectRecord(sql);

		Statement stmt = null;
		try{
			//取得列数和列名
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			if(rs.next())
			{	
				for(int i=1;i<=cols;i++)
				{
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field,value);
				}
			}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return hash;
	}	
public static void main(String args[])
	{
		try
		{
			tsyyBean mb = new tsyyBean();
		Hashtable hashadd=new Hashtable();
		hashadd.put("SQH","00001");
		hashadd.put("ZJH","35");
		hashadd.put("YYSJ","2001-1-5");
		int i=mb.adddata(hashadd);	
		System.out.println("begin\r\n\r\n");
		//System.out.println("max:"+mb.getData()+"");		
		System.out.println(i+"");
		//System.out.println(i+"");		  
		//System.out.println(mb.delData(hash1)+"");
		System.out.println();
		System.out.println("\r\n\r\nend");
		}catch(Exception e){}
	}
}