page.java

精通Jsp-Web开发技术与典型应用 源码

package ch18.JavaBean;

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

import ch18.JavaBean.DB_Conn;
import ch18.JavaBean.Goods;

public class Page
{   
	//获得查询返回结果集
	public Vector getResultSet()
	{
		DB_Conn db_conn=new DB_Conn();
		ResultSet rs=null;
		try
		{
			db_conn.ConnectDB();
			String sql="select * from goods";
			rs=db_conn.sm.executeQuery(sql);
			Vector vector=new Vector();
			while(rs.next())
			{
				Goods goods=new Goods();
				goods.setGoods_id(rs.getInt("goods_id"));
				goods.setGoods_name(rs.getString("goods_name"));
				goods.setTypeid(rs.getInt("typeid"));
				goods.setGoods_price(rs.getFloat("goods_price"));
				goods.setGoods_discount(rs.getFloat("goods_discount"));
				goods.setGoods_desc(rs.getString("goods_desc"));
				goods.setSupplier(rs.getString("supplier"));
				goods.setQty(rs.getInt("qty"));
				goods.setIspreferred(rs.getInt("ispreferred"));
				goods.setGoods_pic(rs.getString("goods_pic"));
				vector.addElement(goods);
			}
			return vector;
		}
		catch(SQLException SqlE)
		{
			SqlE.printStackTrace();
			return null;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
		finally
		{
			db_conn.CloseDB();
		}
	}
	public String int2str(int id)
	{
		String new_str="";
		if(id==0)
		{
			new_str="No";
		}
		if(id==1)
		{
			new_str="Yes";
		}
		return new_str;
	}
	
}