|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
com.thortech.xl.util.adapters.tcUtilJDBCOperations
public class tcUtilJDBCOperations
This class that has JDBC Operations and compliments the tcUtilJDBCClass class Authors: Louis Cheng and Jatan Rajvanshi August 1, 2002.
Constructor Summary | |
---|---|
tcUtilJDBCOperations() Default Constructor |
|
tcUtilJDBCOperations(java.lang.String psDriver, java.lang.String psUrl, java.lang.String psUsername, java.lang.String psPassword) Contructor that sets the parameters for connecting to a database |
Method Summary | |
---|---|
java.lang.String |
getMaxStringValueFromPatternMatch(java.lang.String psTableName, java.lang.String psColumnName, java.lang.String psBeforeWildCard, java.lang.String psAfterWildCard) Retrieves the maximum value within a group of results that match a specified as psBeforeWildCard%psAfterWildCard. |
java.lang.String |
getRandomRow(java.lang.String psTablename, java.lang.String psColumnname, java.lang.String psConstraint, java.lang.String psValue) Executes a simple select statement to get back a single column from a single table for a double constraint-value pair If more than one record is returned, this method returns any one of the records at random.Hence the name The following query is executed: SELECT columnname FROM tablename WHERE firstConstraint=firstValue |
static void |
main(java.lang.String[] args) Main Method |
java.lang.String |
selectStatementDoubleConstraints(java.lang.String psTablename, java.lang.String psColumnname, java.lang.String psFirstConstraint, java.lang.String psFirstValue, java.lang.String psSecondConstraint, java.lang.String psSecondValue) Executes a simple select statement to get back a single column from a single table for a double constraint-value pair If more than one record is returned, this method returns the first record.The following query is executed: SELECT columnname FROM tablename WHERE firstConstraint=firstValue AND secondConstraint=secondValue |
java.lang.String |
selectStatementSingleConstraint(java.lang.String psTablename, java.lang.String psColumnname, java.lang.String psConstraint, java.lang.String psValue) Executes a simple select statement to get back a single column from a single table for a single constraint-value pair If more than one record is returned, this method returns the first record.The following query is executed: SELECT columnname FROM tablename WHERE constraint=value |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public tcUtilJDBCOperations()
public tcUtilJDBCOperations(java.lang.String psDriver, java.lang.String psUrl, java.lang.String psUsername, java.lang.String psPassword)
psDriver
- The class name of the jdbc driverpsUrl
- The URL of the databasepsUsername
- The username required to access the databasepsPassword
- The password for the above usernameMethod Detail |
---|
public java.lang.String selectStatementSingleConstraint(java.lang.String psTablename, java.lang.String psColumnname, java.lang.String psConstraint, java.lang.String psValue)
psTablename
- The name of the table on which the query is madepsColumnname
- The column which is returnedpsConstraint
- The constraint column namepsValue
- The value of the constraint which is to be matchedpublic java.lang.String selectStatementDoubleConstraints(java.lang.String psTablename, java.lang.String psColumnname, java.lang.String psFirstConstraint, java.lang.String psFirstValue, java.lang.String psSecondConstraint, java.lang.String psSecondValue)
psTablename
- The name of the table on which the query is madepsColumnname
- The column which is returnedpsFirstConstraint
- The first constraint column namepsFirstValue
- The value of the first constraint which is to be matchedpsSecondConstraint
- The second constraint column namepsSecondValue
- The value of the second constraint which is to be matchedpublic java.lang.String getRandomRow(java.lang.String psTablename, java.lang.String psColumnname, java.lang.String psConstraint, java.lang.String psValue)
psTablename
- The name of the table on which the query is madepsColumnname
- The column which is returnedpsConstraint
- The constraint column namepsValue
- The value of the constraint which is to be matchedpublic java.lang.String getMaxStringValueFromPatternMatch(java.lang.String psTableName, java.lang.String psColumnName, java.lang.String psBeforeWildCard, java.lang.String psAfterWildCard)
psTableName
- table namepsColumnName
- name of the column being checkedpsBeforeWildCard
- pattern before wildcard(%)psAfterWildCard
- patter after wildcard(%)public static void main(java.lang.String[] args)
args
-
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |