info.aduna.gee.publication.servlets.db
Class ShopDatabase

java.lang.Object
  info.aduna.gee.publication.servlets.db.ShopDatabase

public class ShopDatabase
extends Object

Class ShopDatabase contains utility methods for adding and removing shop information.

Constructor Summary

ShopDatabase()

Method Summary

protected static Product	_constructProduct(ResultSet rs, String host)
protected static String	_escape(String source)
protected static int	_getNextSortorder(String host, String id)
static void	addOption(String host, String id, String description, int isVolumeDiscountOption)
static void	addOptionlist(String host, String id, String[] options)
static void	addOptionvalue(String host, String id, String value, String price, String pricetype)
static void	addProduct(String host, String id, String descr, String unitdescr, String price, String optionlist, String required)
static boolean	containsOption(String host, String id)
static boolean	containsOptionlist(String host, String id)
static boolean	containsOptionvalue(String host, String id, String value)
static boolean	containsProduct(String host, String id)
static void	deleteOption(String host, String id)
static void	deleteOptionlist(String host, String id)
static void	deleteOptionvalue(String host, String id, String value)
static void	deleteProduct(String host, String id)
static Product	getCompleteProduct(String serializedProduct, String host)
static Option	getOption(String host, String id)
static String	getOptionlist(String host, String productID)
static List	getOptionlists(String host)
static List	getOptions(String host)
static OptionValue	getOptionvalue(String host, String id, String value)
static Product	getProduct(String id, String host) Get a product from the database.
static List	getProducts(String host)
static String	getRequiredProducts(String host)
static List	getSelectedOptions(String host, String optionlistID)
static void	updateOption(String host, String id, String description, int isVolumeDiscountOption)
static void	updateOptionlist(String host, String id, String[] options)
static void	updateOptionvalue(String host, String id, String value, String price, String pricetype)
static void	updateProduct(String host, String id, String descr, String unitdescr, String price, String optionlist, String required)

Methods inherited from class java.lang.Object

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

Constructor Detail

ShopDatabase

public ShopDatabase()

Method Detail

getProduct

public static Product getProduct(String id,
                                 String host)

Get a product from the database.

Parameters:

id - the ID of the product in the database

Returns:

a Product with all its options and optionvalues

getProducts

public static List getProducts(String host)

Returns:

a list of all Products

_constructProduct

protected static Product _constructProduct(ResultSet rs,
                                           String host)

getCompleteProduct

public static Product getCompleteProduct(String serializedProduct,
                                         String host)
                                  throws IOException

Throws:

IOException

addProduct

public static void addProduct(String host,
                              String id,
                              String descr,
                              String unitdescr,
                              String price,
                              String optionlist,
                              String required)

updateProduct

public static void updateProduct(String host,
                                 String id,
                                 String descr,
                                 String unitdescr,
                                 String price,
                                 String optionlist,
                                 String required)

containsProduct

public static boolean containsProduct(String host,
                                      String id)

deleteProduct

public static void deleteProduct(String host,
                                 String id)

getRequiredProducts

public static String getRequiredProducts(String host)

getOptionlist

public static String getOptionlist(String host,
                                   String productID)

getOptionlists

public static List getOptionlists(String host)

getSelectedOptions

public static List getSelectedOptions(String host,
                                      String optionlistID)

addOptionlist

public static void addOptionlist(String host,
                                 String id,
                                 String[] options)

updateOptionlist

public static void updateOptionlist(String host,
                                    String id,
                                    String[] options)

containsOptionlist

public static boolean containsOptionlist(String host,
                                         String id)

deleteOptionlist

public static void deleteOptionlist(String host,
                                    String id)

getOption

public static Option getOption(String host,
                               String id)

getOptions

public static List getOptions(String host)

addOption

public static void addOption(String host,
                             String id,
                             String description,
                             int isVolumeDiscountOption)

updateOption

public static void updateOption(String host,
                                String id,
                                String description,
                                int isVolumeDiscountOption)

containsOption

public static boolean containsOption(String host,
                                     String id)

deleteOption

public static void deleteOption(String host,
                                String id)

getOptionvalue

public static OptionValue getOptionvalue(String host,
                                         String id,
                                         String value)

addOptionvalue

public static void addOptionvalue(String host,
                                  String id,
                                  String value,
                                  String price,
                                  String pricetype)

updateOptionvalue

public static void updateOptionvalue(String host,
                                     String id,
                                     String value,
                                     String price,
                                     String pricetype)

containsOptionvalue

public static boolean containsOptionvalue(String host,
                                          String id,
                                          String value)

deleteOptionvalue

public static void deleteOptionvalue(String host,
                                     String id,
                                     String value)

_getNextSortorder

protected static int _getNextSortorder(String host,
                                       String id)

_escape

protected static String _escape(String source)