|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Object | +--gridbus.gmd.service.DatabaseHandler
| 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 |
public DatabaseHandler()
throws java.lang.ClassNotFoundException,
java.sql.SQLException
| Method Detail |
public int getNoOfServices(java.lang.String pn)
throws DBQueryException
DBQueryException
public java.lang.String registerProvider(java.lang.String pn,
java.lang.String ln,
java.lang.String pw)
pn - ln - pw -
public java.sql.ResultSet getProviderList()
throws DBQueryException
DBQueryException
public java.sql.ResultSet getServiceTypeList()
throws DBQueryException
DBQueryException
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)
sName - sType - pName - hPrice - sPrice - contact - description -
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)
sName - sType - pName - hPrice - sPrice - contact - description -
public java.sql.ResultSet getServiceDetail(java.lang.String serviceName)
throws DBQueryException
serviceName -
DBQueryException
public java.sql.ResultSet getServiceList(java.lang.String providerName)
throws DBQueryException
providerName -
DBQueryException
public java.sql.ResultSet getAllProviders()
throws DBQueryException
DBQueryExceptionpublic java.lang.String removeOneService(java.lang.String serviceName)
serviceName -
public java.lang.String getProviderName(java.lang.String ln,
java.lang.String pw)
public java.lang.String removeProvider(java.lang.String providerName)
public boolean checkProvider(java.lang.String providerName)
providerName -
public boolean checkLoginName(java.lang.String loginName)
loginName -
public java.sql.ResultSet getProviderServices(java.lang.String providerName)
throws DBQueryException
providerName -
DBQueryException
public java.sql.ResultSet getServicetypeServices(java.lang.String serviceType)
throws DBQueryException
serviceType -
DBQueryException
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||