|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
com.thortech.xl.util.adapters.tcUtilJDBCClass
public class tcUtilJDBCClass
JDBC Utility class
Field Summary | |
---|---|
static java.sql.Connection |
ioCon DB Connection |
static java.sql.ResultSet |
ioResultSet Result Set |
static java.sql.Statement |
ioStatement SQL Statement |
static int |
mnCount Result set Count |
Constructor Summary | |
---|---|
tcUtilJDBCClass() Creates a new tcUtilJDBCClass object. |
Method Summary | |
---|---|
void |
close() This method closes the conenction |
void |
connect(java.lang.String s, java.lang.String s1, java.lang.String s2, java.lang.String s3) Creates a coonection to the Database |
int |
executeDeleteStatement(java.lang.String s) This method executes the Delete Statement |
int |
executeInsertStatement(java.lang.String s) This method executes the Insert Statement |
java.util.Vector |
executeSelectStatement(java.lang.String s) This method executes the Select Query |
java.lang.Object[] |
executeSelectStatementAll(java.lang.String s) This method executes the Select Query |
int |
executeUpdateStatement(java.lang.String s) This method executes the Update Statement |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static java.sql.Connection ioCon
public static java.sql.Statement ioStatement
public static java.sql.ResultSet ioResultSet
public static int mnCount
Constructor Detail |
---|
public tcUtilJDBCClass()
Method Detail |
---|
public void connect(java.lang.String s, java.lang.String s1, java.lang.String s2, java.lang.String s3)
s
- JDBC Drivers1
- jdbc URLs2
- User Names3
- Passwordpublic void close()
public java.util.Vector executeSelectStatement(java.lang.String s)
s
- SQL Querypublic java.lang.Object[] executeSelectStatementAll(java.lang.String s)
s
- SQL Querypublic int executeInsertStatement(java.lang.String s)
s
- SQL Querypublic int executeUpdateStatement(java.lang.String s)
s
- SQL Querypublic int executeDeleteStatement(java.lang.String s)
s
- SQL Query
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |