orderdetailbean.java

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

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