www.pudn.com > BuyFlowers.rar > AdminCart.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 AdminCart extends DBConnection { 
 
	private PreparedStatement ptst = null; 
 
	private Collection collection = null; 
 
	private ResultSet rs = null; 
 
	private OrdersClass order = null; 
 
	public AdminCart() throws ClassNotFoundException, SQLException { 
		super(); 
		// TODO Auto-generated constructor stub 
	} 
 
	// 增加订单 
	public void addOrder(String orderName, String totalPrice) { 
		String sql = "insert into orders(usersName,ordersPrice) values(?,?);"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, orderName); 
			ptst.setString(2, totalPrice); 
			ptst.executeUpdate(); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
 
	} 
 
	// 删除订单 
	public void deleteOrder(String ordersId) { 
		String sql = "delete from orders where ordersId=?;"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, ordersId); 
			ptst.executeUpdate(); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
	} 
 
	// 获取所有订单 
	public Collection getOrders() { 
		String sql = "select * from orders;"; 
		try { 
			ptst = con.prepareStatement(sql); 
			rs = ptst.executeQuery(); 
			collection = new ArrayList(); 
			while (rs.next()) { 
				order = new OrdersClass(); 
				order.setOrdersId(rs.getString("ordersId")); 
				order.setOrdersPrice(Float.parseFloat(rs 
						.getString("ordersPrice"))); 
				order.setUsersName(rs.getString("usersName")); 
				order.setOrdersDatetime(rs.getString("ordersDatetime")); 
				collection.add(order); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
 
		return collection; 
	} 
 
	// 按订单号查询 
	public Collection getOrdersByOrderId(String ordersId) { 
		String sql = "select * from orders where ordersId=?"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, ordersId); 
			rs = ptst.executeQuery(); 
			collection = new ArrayList(); 
			while (rs.next()) { 
				order = new OrdersClass(); 
				order.setOrdersId(rs.getString("ordersId")); 
				order.setOrdersPrice(Float.parseFloat(rs 
						.getString("ordersPrice"))); 
				order.setUsersName(rs.getString("usersName")); 
				order.setOrdersDatetime(rs.getString("ordersDatetime")); 
				collection.add(order); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		return collection; 
	} 
	 
	// 按用户名查询 
	public Collection getOrdersByUserName(String usersName){ 
		String sql="select * from orders where usersName=?;"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, usersName); 
			rs = ptst.executeQuery(); 
			collection = new ArrayList(); 
			while (rs.next()) { 
				order = new OrdersClass(); 
				order.setOrdersId(rs.getString("ordersId")); 
				order.setOrdersPrice(Float.parseFloat(rs 
						.getString("ordersPrice"))); 
				order.setUsersName(rs.getString("usersName")); 
				order.setOrdersDatetime(rs.getString("ordersDatetime")); 
				collection.add(order); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		return collection; 
		 
	} 
}