edu.iastate.utils.sql
Class JDBCUtils

java.lang.Object
  edu.iastate.utils.sql.JDBCUtils

Direct Known Subclasses:

pgJDBCUtils

public class JDBCUtils

extends java.lang.Object

Field Summary

(package private) static java.util.Map

jdbcTypeName

Constructor Summary

JDBCUtils()

Method Summary

static boolean	clearTable(java.sql.Connection db, java.lang.String tableName) Delete all information in a table
static java.util.Vector	getAllTable(java.sql.Connection db) Listing All Table Names in a Database
static java.lang.String	getColumnNoNull(java.sql.ResultSet rs, int index)
static java.lang.String	getColumnNoNull(java.sql.ResultSet rs, java.lang.String field)
static int	getCount(java.sql.Connection db, java.lang.String sql) Get count
static int	getCount(java.sql.Connection db, java.lang.String tableName, java.lang.String where)
static java.lang.String	getJdbcTypeName(int jdbcType)
static boolean	insertDatabase(java.sql.Connection db, java.lang.String tableName, java.util.Map field_value)
static boolean	insertDatabase(java.sql.Connection db, java.lang.String tableName, java.lang.String[] fields, java.lang.String[] values) Insert a new record
static boolean	insertOrUpdateDatabase(java.sql.Connection db, java.lang.String tableName, java.util.Map field_value, java.lang.String Pk) Insert a record.
static boolean	isTableExist(java.sql.Connection db, java.lang.String tableName)
static void	query(java.sql.Connection db, java.lang.String sql)
static java.lang.String	replaceDatabaseDangerousCharacters(java.lang.String str) replace ( ) '
static java.lang.String	toDBString(java.lang.String s)
static boolean	updateDatabase(java.sql.Connection db, java.lang.String sql)
static boolean	updateDatabase(java.sql.Connection db, java.lang.String tableName, java.util.Map field_value, java.lang.String where) Update a record.
static boolean	updateDatabase(java.sql.Connection db, java.lang.String tableName, java.lang.String[] fields, java.lang.String[] values, java.lang.String where)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

jdbcTypeName

static java.util.Map jdbcTypeName

Constructor Detail

JDBCUtils

public JDBCUtils()

Method Detail

insertDatabase

public static boolean insertDatabase(java.sql.Connection db,
                                     java.lang.String tableName,
                                     java.util.Map field_value)

Parameters:

db - Connection

tableName - String

field_value - Map

Returns:

boolean

isTableExist

public static boolean isTableExist(java.sql.Connection db,
                                   java.lang.String tableName)

getColumnNoNull

public static java.lang.String getColumnNoNull(java.sql.ResultSet rs,
                                               int index)

Parameters:

rs - ResultSet

index - int

Returns:

String

Since:

2005-03-06

getColumnNoNull

public static java.lang.String getColumnNoNull(java.sql.ResultSet rs,
                                               java.lang.String field)

Parameters:

rs - ResultSet

field - String

Returns:

String

Since:

2005-03-06

getAllTable

public static java.util.Vector getAllTable(java.sql.Connection db)

Listing All Table Names in a Database

Parameters:

db - Connection

Returns:

Vector

Since:

2005-03-06

clearTable

public static boolean clearTable(java.sql.Connection db,
                                 java.lang.String tableName)

Delete all information in a table

Parameters:

db - Connection

tableName - String

Since:

2005-02-24

updateDatabase

public static boolean updateDatabase(java.sql.Connection db,
                                     java.lang.String sql)

replaceDatabaseDangerousCharacters

public static java.lang.String replaceDatabaseDangerousCharacters(java.lang.String str)

replace ( ) '

Parameters:

str - String

Returns:

String

Since:

2005-02-24

toDBString

public static java.lang.String toDBString(java.lang.String s)

getCount

public static int getCount(java.sql.Connection db,
                           java.lang.String sql)

Get count

Parameters:

db - Connection

sql - String eg "SELECT COUNT(*) FROM my_table"

Returns:

int

Since:

2005-02-22

getCount

public static int getCount(java.sql.Connection db,
                           java.lang.String tableName,
                           java.lang.String where)

Parameters:

db - Connection

tableName - String

where - String

Returns:

int

Since:

2005-02-22

query

public static void query(java.sql.Connection db,
                         java.lang.String sql)

insertDatabase

public static boolean insertDatabase(java.sql.Connection db,
                                     java.lang.String tableName,
                                     java.lang.String[] fields,
                                     java.lang.String[] values)

Insert a new record

Parameters:

tableName - String

fields - String[]

values - String[]

Since:

2005-02-20

updateDatabase

public static boolean updateDatabase(java.sql.Connection db,
                                     java.lang.String tableName,
                                     java.util.Map field_value,
                                     java.lang.String where)

Update a record. Map contains the key-value pair

Parameters:

db - Connection

tableName - String

field_value - Map

updateDatabase

public static boolean updateDatabase(java.sql.Connection db,
                                     java.lang.String tableName,
                                     java.lang.String[] fields,
                                     java.lang.String[] values,
                                     java.lang.String where)

insertOrUpdateDatabase

public static boolean insertOrUpdateDatabase(java.sql.Connection db,
                                             java.lang.String tableName,
                                             java.util.Map field_value,
                                             java.lang.String Pk)

Insert a record. If the record already exists in the database(duplicated PK), update the record Note: Pk should be one of the key in the map(hashtable)

Parameters:

db - Connection

tableName - String

field_value - Map

Pk - String

Returns:

boolean

Since:

2005-03-03

getJdbcTypeName

public static java.lang.String getJdbcTypeName(int jdbcType)