orderdao.java

来自「用mvc实现购物车,简单使用,欢迎大家来下载啊」· Java 代码 · 共 33 行

package com.xaccp.db.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.xaccp.db.DBManager;
import com.xaccp.entity.Order;

public class OrderDAO {
	public int addOrder(Order order){
		int i = 0;
		String sql = "insert into T_Order values (?,?)";
		Object [] obj = {order.getOrderName(),order.getOrderTotal()};
		DBManager db = new DBManager();
		db.openDB();
		i = db.executeSQL(sql,obj);
		db.closedDB();
		if(i>0){
			db.openDB();
			ResultSet rs = db.executeQuery("select @@identity as Id");
			try {
				rs.next();
				return rs.getInt("Id");
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				db.closedDB();
			}
		}
		return -1;
	}
}