db_orders_detail.java

精通Jsp-Web开发技术与典型应用 源码

package ch24.JavaBean;

import java.io.PrintWriter;
import java.sql.*;
import java.util.Vector;
import ch24.JavaBean.DB_Conn;
import ch24.JavaBean.Orders_detail;

public class DB_orders_detail
{
	DB_Conn db_conn=new DB_Conn();
	PrintWriter out=null;
	//存储详细订单数据
	public boolean store_orders_detail(Orders_detail orders)
	{
		db_conn.ConnectDB();
		try
		{
			int goods_id=orders.getGoods_id();
			float goods_price=orders.getGoods_price();
			String orderid=orders.getOrderid();
			int qty=orders.getQty();
			int rnum=orders.getRnum();
			String goods_name=orders.getGoods_name();
			String sql="insert into orders_detail values('"+orderid+"',"+rnum+","+goods_id+",'"+goods_name+"',"+goods_price+","+qty+")";
			db_conn.sm.executeUpdate(sql);
			return true;
		}
		catch (SQLException SqlE) 
		{
			SqlE.printStackTrace();
			return false;
		} 
		catch (Exception E) 
		{
			E.printStackTrace();
			return false;
		}
		finally 
		{
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}

	public Vector get_orders_detail(String orderid)
	{
		db_conn.ConnectDB();
		ResultSet rs=null;
		try
		{ 
			Vector vector=new Vector();
			String sql="select * from orders_detail where orderid='"+orderid+"'";
			rs=db_conn.sm.executeQuery(sql);
			while(rs.next())
			{
				Orders_detail orders_detail=new Orders_detail();
				orders_detail.setGoods_id(rs.getInt("goods_id"));
				orders_detail.setGoods_name(rs.getString("goods_name"));
				orders_detail.setGoods_price(rs.getFloat("goods_price"));
				orders_detail.setOrderid(rs.getString("orderid"));
				orders_detail.setQty(rs.getInt("qty"));
				orders_detail.setRnum(rs.getInt("rnum"));
				vector.addElement(orders_detail);
			}
			return vector;
		}
		catch (SQLException SqlE) 
		{
			SqlE.printStackTrace();
			return null;
		} 
		catch (Exception E) 
		{
			E.printStackTrace();
			return null;
		}
		finally 
		{
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}
}