www.pudn.com > BuyFlowers.rar > OrderDetailBean.java

package com.qrsx.buyflowers.beans; 
 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
 
 
public class OrderDetailBean extends DBConnection{ 
 
	private PreparedStatement ptst=null; 
	private ResultSet rs=null; 
	public OrderDetailBean() throws ClassNotFoundException, SQLException { 
		super(); 
		// TODO Auto-generated constructor stub 
	} 
 
	public OrderDetail getOrderDetail(String ordersId){ 
		OrderDetail od=new OrderDetail(); 
		String sql="select * from ordersDetails where ordersId=?"; 
		try { 
			ptst=con.prepareStatement(sql); 
			ptst.setString(1, ordersId); 
			rs=ptst.executeQuery(); 
			rs.next(); 
			od.setGoodsCount(Integer.parseInt(rs.getString("goodsCount"))); 
			od.setGoodsPrice(rs.getString("goodsPrice")); 
			od.setGoodsName(rs.getString("goodsName")); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		return od; 
	} 
}