orderdetaildao.java

来自「网上书城 购物车 创建SESSION等 具体网上书城 类库」· Java 代码 · 共 26 行

package com.wl.db.dao;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.wl.db.vo.*;
import com.wl.db.DBManager;

public class OrderDetailDAO {
	private static final DBManager DBManager = null;
	public void OrderDetailDAO(){
		
	}
	public void add_orderdetail(OrderDetail orderdetail) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		String sql="insert into T_orderDetail value(?,?,?,?,?)";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setInt(1,orderdetail.getOrderID());
		pt.setInt(2,orderdetail.getRowNum());
		pt.setInt(3,orderdetail.getBooks_id());
		pt.setString(4,orderdetail.getBooks_name());
		pt.setInt(5,orderdetail.getHavebooks());
		pt.executeUpdate();
		db.closeConnection();
	}
}