bookclasslist.java

jsp开发常用信息管理系统适合初学者学习 网上购物

package ch09.web;

import java.sql.SQLException;
import java.util.Vector;

import ch09.web.book.bookclass;

/**
 * @author <a href='[e-mail]'>chengwei</a>
 * 图书类别列表
 */

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 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;
		}
	}
}