itemdaoimpl.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 java.util.ArrayList;
import java.util.List;

import com.sun.mail.imap.protocol.Item;
import com.witbridge.netstore.dao.ItemDao;
import com.witbridge.netstore.model.Items;
import com.witbridge.netstore.util.DBUtil;
import com.witbridge.netstore.dao.impl.Constants;

public class ItemDaoImpl implements ItemDao {
	Connection conn=null;
	PreparedStatement pt=null;
	Statement st=null;
	ResultSet rs=null;
	
	public int addItem(Items item) {
		try {
			conn=DBUtil.getIstance().getConn();
			PreparedStatement pt=conn.prepareStatement(Constants.ADD_ITEM);
			pt.setLong(1,item.getItemId());
			pt.setString(2,item.getItemName());
			pt.setString(3,item.getModelnumber());
			pt.setString(4,item.getDescription());
			pt.setString(5,item.getFeatrue());
			pt.setString(6,item.getSmallimage());
			pt.setString(7,item.getLageimage());
			pt.setDouble(8,item.getBaseprice());
			int i=pt.executeUpdate();
			DBUtil.release(pt);
			return i;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}
	}
	public int deleteItem(Long itemId) {
		try {
			conn=DBUtil.getIstance().getConn();
			PreparedStatement pt=conn.prepareStatement(Constants.DELECT_ITEM);
			pt.setLong(1,itemId);
			int i=pt.executeUpdate();
			DBUtil.release(pt);
			return i;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}
	}
	
	public List<Items> assembleItems(ResultSet rs){
		List<Items> items=new ArrayList<Items>();
		try{
			while(rs.next()){
				Items item=new Items();
				item.setBaseprice(rs.getDouble("BASE_PRICE"));
				item.setDescription(rs.getString("DESCRIPTION"));
				item.setFeatrue(rs.getString("FEATURE"));
				item.setItemId(rs.getLong("ID"));
				item.setItemName(rs.getString("NAME"));
				item.setSmallimage(rs.getString("SMALL_IMAGE_URL"));
				item.setLageimage(rs.getString("LARGE_IMAGE_URL"));
				item.setModelnumber(rs.getString("MODEL_NUMBER"));
				items.add(item);
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return items;
	}
	
	public List<Items> getAllItems() {
		List<Items> items = null;
		try {
			
			conn=DBUtil.getIstance().getConn();
			st=conn.createStatement();
			rs=st.executeQuery(Constants.SELECT_ITEM);
			items=assembleItems(rs);
			DBUtil.release(st, rs);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return items;
	}
	
	public Items getItem(Long itemId) {
		Items item=new Items();
		try {
			conn=DBUtil.getIstance().getConn();
			pt=conn.prepareStatement(Constants.SELECT_ITEM_KEY);
			pt.setLong(1,itemId);
			rs=pt.executeQuery();
			while(rs.next()){
				item.setBaseprice(rs.getDouble("BASE_PRICE"));
				item.setDescription(rs.getString("DESCRIPTION"));
				item.setFeatrue(rs.getString("FEATURE"));
				item.setItemId(rs.getLong("ID"));
				item.setItemName(rs.getString("NAME"));
				item.setSmallimage(rs.getString("SMALL_IMAGE_URL"));
				item.setLageimage(rs.getString("LARGE_IMAGE_URL"));
				item.setModelnumber(rs.getString("MODEL_NUMBER"));
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DBUtil.release(pt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return item;
	}
	
	public int updateItem(Items item) {
		try {
			conn=DBUtil.getIstance().getConn();
			pt=conn.prepareStatement(Constants.UPDATE_ITEM);
			pt.setString(1,item.getItemName());
			pt.setLong(2,item.getItemId());
			
			int i=pt.executeUpdate();
			DBUtil.release(pt);
			return i;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}
	}
	
}