bookclasslist.java

课程设计期间开发的JSP系统,后台采用SQL.这是一个很好的系统,适合初学者研究

package model;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.pan.web.book.bookclass;



public class bookclasslist extends DataBase {
	private List<bookclass> classlist;		//图书类别向量数组
	
	public bookclasslist() throws Exception{
		super();
	}

	public List<bookclass> 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 ArrayList<bookclass>();
			classlist.clear();
			while (rs.next()){				
				id = rs.getInt("id");
				classname = rs.getString("classname");
				bookclass bc = new bookclass(id,classname);
				classlist.add(bc);
			}
			rs.close();
			return true;
		}
		catch (SQLException sqle){
			System.out.println(sqle);
            return false;
		}
	}
};