orderdao.java

jsp/servlet/javaBean应用：网上购书系统

package dao;

import java.sql.*;
import java.util.*;
import bean.OrderBean;

public class OrderDao {
	
	BaseDao dao=new BaseDao();
	List titles=new ArrayList();
	Connection conn=null;
	PreparedStatement psmt=null;
	ResultSet rest=null;
	String sql=null;
	int i;
	
	//添加订单
	public int addOrder(OrderBean order){
		sql="insert orderInfo values(?,?,?,?,?)";
		String[] param={order.getName(),order.getCode(),order.getPhone(),order.getCardid(),String.valueOf(order.getTotal())};
		try{
			i=dao.executeDB(sql, param);
		}catch(Exception ex){
			ex.printStackTrace();
			System.out.println(ex.getMessage());
		}
		return i;
	}
}