【Java开源代码栏目提醒】:网学会员鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“bookclasslist.java”一文,供大家参考学习
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;
}
}
};