package com.witbridge.netstore.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.witbridge.netstore.dao.OderDao;
import com.witbridge.netstore.model.Items;
import com.witbridge.netstore.model.Oder;
import com.witbridge.netstore.util.DBUtil;

public class OderDaoImpl implements OderDao {
	Connection conn=null;
	PreparedStatement pt=null;
	Statement st=null;
	ResultSet rs=null;
	int i=0;

	public int addOder(Oder oder) {
		return addOder(null,oder);
	}

	public int addOder(Connection con, Oder oder) {
		try {
			if(con==null){
					conn=DBUtil.getIstance().getConn();
				
			}else{
				conn=con;
			}
			pt=conn.prepareStatement(Constants.IINSERT_ODER);
			pt.setString(1,oder.getOdernumber());
			pt.setLong(2,oder.getCustomer().getCustomerId());
			pt.setDouble(3,oder.getPrice());
			pt.setString(4,oder.getState());
			pt.setString(5,oder.getCity());
			pt.setString(6,oder.getAddress());
			pt.setString(7,oder.getPostalCode());
			pt.setString(8,oder.getPhone());
			i=pt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
//		finally{
//			try {
//				DBUtil.release(pt);
//			} catch (SQLException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
//		}
		return i;
	}
	public int deleteOder(Oder oder){
		try {
			conn=DBUtil.getIstance().getConn();
			pt=conn.prepareStatement(Constants.DELECT_ODER);
			pt.setString(1,oder.getOdernumber());
			int i=pt.executeUpdate();
			DBUtil.release(pt);
			return i;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}
	}
}