lineitemdaoimpl.java

网上商城

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.LineItemDao;
import com.witbridge.netstore.model.Items;
import com.witbridge.netstore.model.LineItem;
import com.witbridge.netstore.model.Oder;
import com.witbridge.netstore.util.DBUtil;

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

	public int addLineItem(LineItem lineItem) {
			return addLineItem(null,lineItem);
	}

	public int addLineItem(Connection con, LineItem lineItem) {
		try {
		if(con==null){
				conn=DBUtil.getIstance().getConn();
			
		}else{
			conn=con;
		}
		pt=conn.prepareStatement(Constants.INSERT_LINEITEM);
		pt.setString(1,lineItem.getOder().getOdernumber());
		pt.setLong(2,lineItem.getItem().getItemId());
		pt.setInt(3,lineItem.getQuantity());
		i=pt.executeUpdate();
//		DBUtil.release(pt);
		return i;
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
		return 0;
	}
	}
	
	

	public int deleteLineItem(Items item,Oder order){
		try {
			conn=DBUtil.getIstance().getConn();
			pt=conn.prepareStatement(Constants.DELECT_LINEITEM);
			pt.setLong(1,item.getItemId());
			pt.setString(2,order.getOdernumber());
			int i=pt.executeUpdate();
			DBUtil.release(pt);
			return i;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}
	}
}