wareclasslist.java

jsp mysql 实现网上购物系统

package com.mybusiness.web;



import java.sql.*;
import java.util.Vector;
import com.mybusiness.util.*;
import com.mybusiness.web.ware.wareclass;

/**
 *         商品类别列表
 
 */

public class wareclasslist extends DataBase {
	private Vector classlist;		//商品类别向量数组
	
	//建立数据库的连接
	public wareclasslist() throws Exception{
		super();
	}
    //得到商品类别向量数组
	public Vector getClasslist() {
		return classlist;
	}
	//输出商品类别名的数据库语句
	public String getSql() {
		sqlStr = "select id,classname from my_wareclass 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");
				wareclass bc = new wareclass(id,classname);
				classlist.addElement(bc);
			}
			rs.close();
			return true;
		}
		catch (SQLException sqle){
			System.out.println(sqle);
            return false;
		}
	}
};