dao

Class ItemDao

java.lang.Object

dao.AMysqlDao

dao.ItemDao

All Implemented Interfaces:

IGenericDao<ItemBean,java.lang.Integer>, IItemDao

public class ItemDao
extends AMysqlDao
implements IItemDao

Constructor Summary

Constructors

Constructor and Description
ItemDao()

Method Summary

Modifier and Type	Method and Description
ItemBean	create(ItemBean instance) Create new record from object instance and save into database
boolean	delete(ItemBean instance) Delete record from database
boolean	deleteCategory(CategoryBean instance)
java.util.List<CategoryBean>	getCategories()
CategoryBean	getCategory(int id)
java.util.List<ItemBean>	getDiscountItems()
java.util.List<ItemBean>	getDiscountItems(int limit)
java.util.List<ItemBean>	getHotItems(int limit)
byte[]	getItemImage(int idItem) Get image bytes from Blob
java.util.List<ItemBean>	getItems() Get list of all items
java.util.List<ItemBean>	getItemsByCategory(int idCategory)
java.util.List<ItemBean>	getItemsByCategory(java.lang.String name)
java.util.List<ItemBean>	getItemsByCategory(java.lang.String name, int limit)
ItemBean	read(java.lang.Integer instance) Loading record from database to Bean object
ItemBean	update(ItemBean instance) Update record

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ItemDao

public ItemDao()
        throws java.lang.ClassNotFoundException

Throws:

java.lang.ClassNotFoundException

Method Detail

create

public ItemBean create(ItemBean instance)
                throws java.sql.SQLException

Description copied from interface: IGenericDao

Create new record from object instance and save into database

Specified by:

create in interface IGenericDao<ItemBean,java.lang.Integer>

Parameters:

instance - Bean object

Returns:

Bean object

Throws:

java.sql.SQLException

read

public ItemBean read(java.lang.Integer instance)
              throws java.sql.SQLException

Description copied from interface: IGenericDao

Loading record from database to Bean object

Specified by:

read in interface IGenericDao<ItemBean,java.lang.Integer>

Parameters:

instance - (PK)

Returns:

Bean object

Throws:

java.sql.SQLException

update

public ItemBean update(ItemBean instance)
                throws java.sql.SQLException

Description copied from interface: IGenericDao

Update record

Specified by:

update in interface IGenericDao<ItemBean,java.lang.Integer>

Parameters:

instance - Bean object

Returns:

Bean object

Throws:

java.sql.SQLException

delete

public boolean delete(ItemBean instance)
               throws java.sql.SQLException

Description copied from interface: IGenericDao

Delete record from database

Specified by:

delete in interface IGenericDao<ItemBean,java.lang.Integer>

Parameters:

instance - Bean object

Returns:

TRUE if object was deleted, FALSE otherwise

Throws:

java.sql.SQLException

getItems

public java.util.List<ItemBean> getItems()
                                  throws java.sql.SQLException

Description copied from interface: IItemDao

Get list of all items

Specified by:

getItems in interface IItemDao

Returns:

List of items (goods)

Throws:

java.sql.SQLException

getHotItems

public java.util.List<ItemBean> getHotItems(int limit)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getItemsByCategory

public java.util.List<ItemBean> getItemsByCategory(java.lang.String name)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getItemsByCategory

public java.util.List<ItemBean> getItemsByCategory(java.lang.String name,
                                                   int limit)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getItemsByCategory

public java.util.List<ItemBean> getItemsByCategory(int idCategory)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getDiscountItems

public java.util.List<ItemBean> getDiscountItems()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getDiscountItems

public java.util.List<ItemBean> getDiscountItems(int limit)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getItemImage

public byte[] getItemImage(int idItem)
                    throws java.sql.SQLException

Description copied from interface: IItemDao

Get image bytes from Blob

Specified by:

getItemImage in interface IItemDao

Parameters:

idItem - (PK)

Returns:

Bytes of image

Throws:

java.sql.SQLException

getCategories

public java.util.List<CategoryBean> getCategories()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getCategory

public CategoryBean getCategory(int id)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteCategory

public boolean deleteCategory(CategoryBean instance)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException