Package org.openbravo.data

Class UtilSql

java.lang.Object

org.openbravo.data.UtilSql

public class UtilSql
extends Object

Constructor Summary

Constructors

Constructor	Description
UtilSql()

Method Summary

Modifier and Type	Method	Description
static String	getBlobValue(ResultSet result, String strField)
static String	getDateTimeValue(ResultSet result, String strField, String strDateFormat)
static String	getDateValue(ResultSet result, String strField)
static String	getDateValue(ResultSet result, String strField, String strDateFormat)
static String	getStringCallableStatement(CallableStatement cs, int intField)
static String	getValue(ResultSet result, int pos)
static String	getValue(ResultSet result, String strField)
static boolean	setValue(PreparedStatement ps, int posicion, int tipo, String strDefault, String _strValor)

Methods inherited from class java.lang.Object

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

Constructor Detail

UtilSql

public UtilSql()

Method Detail

setValue

public static boolean setValue(PreparedStatement ps,
                               int posicion,
                               int tipo,
                               String strDefault,
                               String _strValor)

getValue

public static String getValue(ResultSet result,
                              String strField)
                       throws SQLException

Throws:

SQLException

getValue

public static String getValue(ResultSet result,
                              int pos)
                       throws SQLException

Throws:

SQLException

getDateValue

public static String getDateValue(ResultSet result,
                                  String strField,
                                  String strDateFormat)
                           throws SQLException

Throws:

SQLException

getDateTimeValue

public static String getDateTimeValue(ResultSet result,
                                      String strField,
                                      String strDateFormat)
                               throws SQLException

Throws:

SQLException

getDateValue

public static String getDateValue(ResultSet result,
                                  String strField)
                           throws SQLException

Throws:

SQLException

getBlobValue

public static String getBlobValue(ResultSet result,
                                  String strField)
                           throws SQLException

Throws:

SQLException

getStringCallableStatement

public static String getStringCallableStatement(CallableStatement cs,
                                                int intField)
                                         throws SQLException

Throws:

SQLException