|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectmaito.util.DbTools
public class DbTools
A class that contains methods for database related things.
Method Summary | |
---|---|
static java.sql.Connection |
createDbConnection(java.util.Properties dbConfig)
|
static java.sql.Connection |
createDbConnection(java.util.Properties dbConfig,
java.lang.String dbName)
|
static java.lang.String |
escSQL(java.lang.String s)
Escapes some special SQL characters |
static java.lang.String |
formatDate(java.util.Date theDate)
Formats a java.util.Date to the standard sql format YYYY-MM-DD |
static java.lang.String |
safeStr(java.lang.String s)
Escapes single quotes and returns the string quoted with single quotes. |
static java.lang.String |
SQLstr(java.lang.String s,
int maxLen)
Formats a string for SQL statement |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public static java.sql.Connection createDbConnection(java.util.Properties dbConfig) throws java.sql.SQLException
java.sql.SQLException
public static java.sql.Connection createDbConnection(java.util.Properties dbConfig, java.lang.String dbName) throws java.sql.SQLException
java.sql.SQLException
public static java.lang.String escSQL(java.lang.String s)
public static java.lang.String safeStr(java.lang.String s)
public static java.lang.String formatDate(java.util.Date theDate)
theDate
- the date to format
public static java.lang.String SQLstr(java.lang.String s, int maxLen)
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |