package org.pan.web;

import java.sql.*;
import java.util.Vector;
import org.pan.util.*;
import org.pan.web.book.bookclass;

/**
 * Title:        圖書類別列表
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      多智能網絡有限公司
 * @author:		 siny pan
 * @version 1.0
 */

public class bookclasslist extends DataBase {
	private Vector classlist;		//圖書類別向量數組
	
	public bookclasslist() throws Exception{
		super();
	}

	public Vector getClasslist() {
		return classlist;
	}
	
	public String getSql() {
		sqlStr = "select id,classname from my_Bookclass order by id";
		return sqlStr;
	}

	public boolean excute() throws Exception {
		int id = 0;
		String classname = "";
		int rscount = 0;
		try {
			rs = stmt.executeQuery(getSql());
			rscount = stmt.getMaxRows();
			classlist = new Vector(rscount+1);
			classlist.clear();
			while (rs.next()){				
				id = rs.getInt("id");
				classname = rs.getString("classname");
				bookclass bc = new bookclass(id,classname);
				classlist.addElement(bc);
			}
			rs.close();
			return true;
		}
		catch (SQLException sqle){
			System.out.println(sqle);
            return false;
		}
	}
};