ordersbean.java

j2ee框架下的mvc模式的一个网上销售系统

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;
    }
}