db_orders_detail.java

张新曼 精通JSP Web 开发技术与典型应用 随书光盘源码

package ch15.JavaBean;

import java.io.PrintWriter;
import java.sql.SQLException;
import ch15.JavaBean.DB_Conn;
import ch15.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();
		}
	}
}