insertorderlistmess.java

网上购物源代码

/**
 * 
 */
package com.chinaaccpDao;

import java.sql.Connection;
import java.sql.PreparedStatement;

import com.chinaaccpbean.CartBean;

/**
 * @author Administrator
 *
 */
public class InsertOrderListMess {

	public boolean GetOrderListMess(CartBean cb,int id)
	{
		Connection con = null;
		try {
			con = ConnectionLee.GetCon();
			String sql = "insert into OrderMess(orderid,productid,quantity,price,totalfee) values(?,?,?,?,?)";
			PreparedStatement ps = con.prepareStatement(sql);
			ps.setInt(1, id);
			ps.setInt(2, cb.getId());
			ps.setInt(3, cb.getCount());
			ps.setDouble(4, cb.getPrice());
			ps.setDouble(5, cb.getTotalfee());
			int row = ps.executeUpdate();
			if(row>0)
			{
				return true;
			}
			else
				return false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return false;
	}
}