package com.lovo.dao;

import java.sql.SQLException;
import java.util.List;

import com.lovo.po.BlockPO;

public interface BlockDAO {
	/**
	 * 添加版塊
	 * @param po
	 * @throws SQLException
	 */
	public void insert(BlockPO po) throws SQLException;
	/**
	 * 刪除版塊
	 * @param id
	 * @throws SQLException
	 */
	public void delete(int id) throws SQLException;
	/**
	 * 刪除版塊
	 * @param areaID
	 * @throws SQLException
	 */
	public void deleteByAreaID(int areaID) throws SQLException;
	/**
	 * 修改版塊信息
	 * @param po
	 * @throws SQLException
	 */
	public void update(BlockPO po) throws SQLException;
	/**
	 * 查詢一個區域下的所有版塊
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public List<BlockPO> queryBlockByAreaId(int id) throws SQLException;
	/**
	 * 查詢某一個版塊
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public BlockPO queryBlockById(int id) throws SQLException;
}