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

package com.qrsx.buyflowers.beans; 
 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Collection; 
 
public class OrdersBean extends DBConnection{ 
	private PreparedStatement ptst=null; 
	private ResultSet rs=null; 
	private Collection collection; 
 
	public OrdersBean() throws ClassNotFoundException, SQLException { 
		super(); 
		// TODO Auto-generated constructor stub 
	} 
    public Collection getOrdersByName(String name){ 
    	OrdersClass order=null; 
    	String sql="select * from orders where usersName=?"; 
    	try { 
			ptst=con.prepareStatement(sql); 
			ptst.setString(1, name); 
			rs=ptst.executeQuery(); 
			collection=new ArrayList(); 
			while(rs.next()){ 
				order=new OrdersClass(); 
				order.setOrdersDatetime(rs.getString("ordersDatetime")); 
				order.setOrdersId(rs.getString("ordersId")); 
				order.setOrdersPrice(Float.parseFloat(rs.getString("ordersPrice"))); 
				order.setUsersName(name); 
				collection.add(order); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
    	return collection; 
    } 
}