maito.util
Class DbTools

java.lang.Object
  extended by maito.util.DbTools

public class DbTools
extends java.lang.Object

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

createDbConnection

public static java.sql.Connection createDbConnection(java.util.Properties dbConfig)
                                              throws java.sql.SQLException
Throws:
java.sql.SQLException

createDbConnection

public static java.sql.Connection createDbConnection(java.util.Properties dbConfig,
                                                     java.lang.String dbName)
                                              throws java.sql.SQLException
Throws:
java.sql.SQLException

escSQL

public static java.lang.String escSQL(java.lang.String s)
Escapes some special SQL characters


safeStr

public static java.lang.String safeStr(java.lang.String s)
Escapes single quotes and returns the string quoted with single quotes. null values create NULL -string


formatDate

public static java.lang.String formatDate(java.util.Date theDate)
Formats a java.util.Date to the standard sql format YYYY-MM-DD

Parameters:
theDate - the date to format
Returns:
formatte date string

SQLstr

public static java.lang.String SQLstr(java.lang.String s,
                                      int maxLen)
Formats a string for SQL statement