br.ufscar.saci.util

Class SqlUtil

java.lang.Object

br.ufscar.saci.util.SqlUtil

public class SqlUtil
extends Object

Constructor Summary

Constructors

Constructor and Description
SqlUtil()

Method Summary

Methods

Modifier and Type	Method and Description
static List<String>	getTerms(String key)
static Integer	getTinyInt(ResultSet rs, String field) Fix tiny int problem in mysql.
static String	queryDateOnTimestamp(String name) This is much more optimized than date(my_value).

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlUtil

public SqlUtil()

Method Detail

getTerms

public static List<String> getTerms(String key)

getTinyInt

public static Integer getTinyInt(ResultSet rs,
                 String field)

Fix tiny int problem in mysql. Tiny int is ambigous in mysql. It's either boolean or 1-byte integer. In some cases (like rs.getObject) this becomes a problem. Here is a fix. Alternative fix: look for mysql parameter "tinyInt1isBit=false"

queryDateOnTimestamp

public static String queryDateOnTimestamp(String name)

This is much more optimized than date(my_value).

Downside: you have to pass the date two times