gridbus.gmd.service
Class DatabaseHandler

java.lang.Object
  |
  +--gridbus.gmd.service.DatabaseHandler

public class DatabaseHandler
extends java.lang.Object


Constructor Summary
DatabaseHandler()
           
 
Method Summary
 java.lang.String addOneService(java.lang.String sName, java.lang.String sType, java.lang.String pName, java.lang.String hPrice, java.lang.String sPrice, java.lang.String contact, java.lang.String description)
          Method addOneService.
 boolean checkLoginName(java.lang.String loginName)
          Method checkLoginName.
 boolean checkProvider(java.lang.String providerName)
          Method checkProvider.
 java.sql.ResultSet getAllProviders()
          Method getAllProviders.
 int getNoOfServices(java.lang.String pn)
          Method getNoOfServices.
 java.sql.ResultSet getProviderList()
          Method getProviderList.
 java.lang.String getProviderName(java.lang.String ln, java.lang.String pw)
          Method getProviderName.
 java.sql.ResultSet getProviderServices(java.lang.String providerName)
          Method getProviderServices.
 java.sql.ResultSet getServiceDetail(java.lang.String serviceName)
          Method getServiceDetail.
 java.sql.ResultSet getServiceList(java.lang.String providerName)
          Method getServiceList.
 java.sql.ResultSet getServiceTypeList()
          Method getServiceTypeList.
 java.sql.ResultSet getServicetypeServices(java.lang.String serviceType)
          Method getServicetypeServices.
 java.lang.String registerProvider(java.lang.String pn, java.lang.String ln, java.lang.String pw)
          Method registerProvider.
 java.lang.String removeOneService(java.lang.String serviceName)
          Method removeOneService.
 java.lang.String removeProvider(java.lang.String providerName)
          Method removeProvider.
 java.lang.String updateService(java.lang.String sName, java.lang.String sType, java.lang.String pName, java.lang.String hPrice, java.lang.String sPrice, java.lang.String contact, java.lang.String description)
          Method updateService.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

DatabaseHandler

public DatabaseHandler()
                throws java.lang.ClassNotFoundException,
                       java.sql.SQLException
Method Detail

getNoOfServices

public int getNoOfServices(java.lang.String pn)
                    throws DBQueryException
Method getNoOfServices.

Returns:
int
Throws:
DBQueryException

registerProvider

public java.lang.String registerProvider(java.lang.String pn,
                                         java.lang.String ln,
                                         java.lang.String pw)
Method registerProvider.

Parameters:
pn -
ln -
pw -
Returns:
String

getProviderList

public java.sql.ResultSet getProviderList()
                                   throws DBQueryException
Method getProviderList.

Returns:
ResultSet
Throws:
DBQueryException

getServiceTypeList

public java.sql.ResultSet getServiceTypeList()
                                      throws DBQueryException
Method getServiceTypeList.

Returns:
ResultSet
Throws:
DBQueryException

addOneService

public java.lang.String addOneService(java.lang.String sName,
                                      java.lang.String sType,
                                      java.lang.String pName,
                                      java.lang.String hPrice,
                                      java.lang.String sPrice,
                                      java.lang.String contact,
                                      java.lang.String description)
Method addOneService.

Parameters:
sName -
sType -
pName -
hPrice -
sPrice -
contact -
description -
Returns:
String

updateService

public java.lang.String updateService(java.lang.String sName,
                                      java.lang.String sType,
                                      java.lang.String pName,
                                      java.lang.String hPrice,
                                      java.lang.String sPrice,
                                      java.lang.String contact,
                                      java.lang.String description)
Method updateService.

Parameters:
sName -
sType -
pName -
hPrice -
sPrice -
contact -
description -
Returns:
String

getServiceDetail

public java.sql.ResultSet getServiceDetail(java.lang.String serviceName)
                                    throws DBQueryException
Method getServiceDetail.

Parameters:
serviceName -
Returns:
ResultSet
Throws:
DBQueryException

getServiceList

public java.sql.ResultSet getServiceList(java.lang.String providerName)
                                  throws DBQueryException
Method getServiceList.

Parameters:
providerName -
Returns:
ResultSet
Throws:
DBQueryException

getAllProviders

public java.sql.ResultSet getAllProviders()
                                   throws DBQueryException
Method getAllProviders.

Returns:
ResultSet
Throws:
DBQueryException

removeOneService

public java.lang.String removeOneService(java.lang.String serviceName)
Method removeOneService.

Parameters:
serviceName -
Returns:
String

getProviderName

public java.lang.String getProviderName(java.lang.String ln,
                                        java.lang.String pw)
Method getProviderName.

Returns:
String

removeProvider

public java.lang.String removeProvider(java.lang.String providerName)
Method removeProvider.

Returns:
String

checkProvider

public boolean checkProvider(java.lang.String providerName)
Method checkProvider.

Parameters:
providerName -
Returns:
boolean

checkLoginName

public boolean checkLoginName(java.lang.String loginName)
Method checkLoginName.

Parameters:
loginName -
Returns:
boolean

getProviderServices

public java.sql.ResultSet getProviderServices(java.lang.String providerName)
                                       throws DBQueryException
Method getProviderServices.

Parameters:
providerName -
Returns:
ResultSet
DBQueryException

getServicetypeServices

public java.sql.ResultSet getServicetypeServices(java.lang.String serviceType)
                                          throws DBQueryException
Method getServicetypeServices.

Parameters:
serviceType -
Returns:
ResultSet
DBQueryException