orderdao.java

网上书城 购物车 创建SESSION等 具体网上书城 类库

package com.wl.db.dao;
import java.sql.*;

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

public class OrderDAO {
	private static final DBManager DBManager = null;
	public OrderDAO(){
		
	}
	public void add_order(Orders order) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		String sql="insert into T_order values(?,?,?,?,?,?,?,?,?,?)";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setString(1,order.getOrderID());
		pt.setInt(2,order.getUserID());
		pt.setString(3,order.getUserName());
		pt.setString(4,order.getOrderDate());
		pt.setString(5,order.getAddress());
		pt.setString(6,order.getCoster());
		pt.setString(7,order.getPostNum());
		pt.setFloat(8,order.getOrderSum());
		pt.setString(9,order.getDealDate());
		pt.setString(10,order.getStatus());
		pt.setString(11,order.getNote());
		pt.executeUpdate();
		db.closeConnection();
	}
}