AuctionTable v2

/*
 * This program is free software: you can redistribute it and/or modify it under
 * the terms of the GNU General Public License as published by the Free Software
 * Foundation, either version 3 of the License, or (at your option) any later
 * version.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
 * details.
 *
 * You should have received a copy of the GNU General Public License along with
 * this program. If not, see <http://www.gnu.org/licenses/>.
 */
package net.sf.l2j.gameserver.l2spike.datatables;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;
import java.util.logging.Logger;

import net.sf.l2j.L2DatabaseFactory;
import net.sf.l2j.gameserver.l2spike.auction.AuctionItem;

/**
 * @author Anarchy
 *
 */
public class AuctionTable
{
	private static Logger log = Logger.getLogger(AuctionTable.class.getName());

	private Map<Integer, AuctionItem> items;
	private int maxId;

	public static AuctionTable getInstance()
	{
		return SingletonHolder._instance;
	}

	protected AuctionTable()
	{
		items = new ConcurrentHashMap<>();
		maxId = 0;

		load();
	}

	private void load()
	{
		try (Connection con = L2DatabaseFactory.getInstance().getConnection())
		{
			PreparedStatement stm = con.prepareStatement("SELECT * FROM auction_table");
			ResultSet rset = stm.executeQuery();

			while (rset.next())
			{
				int auctionId = rset.getInt("auctionid");
				int ownerId = rset.getInt("ownerid");
				int itemId = rset.getInt("itemid");
				int count = rset.getInt("count");
				int enchant = rset.getInt("enchant");
				int costId = rset.getInt("costid");
				int costCount = rset.getInt("costcount");

				items.put(auctionId, new AuctionItem(auctionId, ownerId, itemId, count, enchant, costId, costCount));

				if (auctionId > maxId)
					maxId = auctionId;
			}

			rset.close();
			stm.close();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}

		log.info("AuctionTable: Loaded "+items.size()+" items.");
	}

	public void addItem(AuctionItem item)
	{
		items.put(item.getAuctionId(), item);

		try (Connection con = L2DatabaseFactory.getInstance().getConnection())
		{
			PreparedStatement stm = con.prepareStatement("INSERT INTO auction_table VALUES (?,?,?,?,?,?,?)");
			stm.setInt(1, item.getAuctionId());
			stm.setInt(2, item.getOwnerId());
			stm.setInt(3, item.getItemId());
			stm.setInt(4, item.getCount());
			stm.setInt(5, item.getEnchant());
			stm.setInt(6, item.getCostId());
			stm.setInt(7, item.getCostCount());

			stm.execute();
			stm.close();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}

	public void deleteItem(AuctionItem item)
	{
		items.remove(item.getAuctionId());

		try (Connection con = L2DatabaseFactory.getInstance().getConnection())
		{
			PreparedStatement stm = con.prepareStatement("DELETE FROM auction_table WHERE auctionid=?");
			stm.setInt(1, item.getAuctionId());

			stm.execute();
			stm.close();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}

	public AuctionItem getItem(int auctionId)
	{
		return items.get(auctionId);
	}

	public Map<Integer, AuctionItem> getItems()
	{
		return items;
	}

	public int getNextAuctionId()
	{
		maxId++;
		return maxId;
	}

	private static class SingletonHolder
	{
		protected static final AuctionTable _instance = new AuctionTable();
	}
}