br.com.sankhya.jape.sql

Class EasySQL

java.lang.Object

br.com.sankhya.jape.sql.EasySQL

public class EasySQL
extends java.lang.Object

Author:

Cláudio Gualberto

Constructor Summary

Constructors

Constructor and Description
EasySQL(JdbcWrapper conn)

Method Summary

Modifier and Type	Method and Description
void	close()
java.util.Map	executeProcedure(java.lang.String name, java.util.Collection inputParam, java.util.Collection outputParamNames)
java.math.BigDecimal	getBigDecimal(int col)
java.math.BigDecimal	getBigDecimal(java.lang.String colName)
java.util.Date	getDate(int col)
java.util.Date	getDate(java.lang.String colName)
double	getDouble(int col)
double	getDouble(java.lang.String colName)
int	getInt(int col)
int	getInt(java.lang.String colName)
java.lang.String	getString(int col)
java.lang.String	getString(java.lang.String colName)
java.sql.Timestamp	getTimestamp(int col)
java.sql.Timestamp	getTimestamp(java.lang.String colName)
void	nativeSelect(java.lang.String query)
boolean	next()
void	reset()
void	select(java.lang.String columns, java.lang.String from)
void	select(java.lang.String columns, java.lang.String from, java.lang.String criteria)
void	setMaxRows(int maxRows)
void	setParam(java.lang.String name, java.lang.Object value)
void	update(java.lang.String query)

Methods inherited from class java.lang.Object

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

Constructor Detail

EasySQL

public EasySQL(JdbcWrapper conn)

Method Detail

close

public void close()

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String colName)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

getDouble

public double getDouble(java.lang.String colName)
                 throws java.lang.Exception

Throws:

java.lang.Exception

getInt

public int getInt(java.lang.String colName)
           throws java.lang.Exception

Throws:

java.lang.Exception

getString

public java.lang.String getString(java.lang.String colName)
                           throws java.lang.Exception

Throws:

java.lang.Exception

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String colName)
                                throws java.lang.Exception

Throws:

java.lang.Exception

getDate

public java.util.Date getDate(java.lang.String colName)
                       throws java.lang.Exception

Throws:

java.lang.Exception

getBigDecimal

public java.math.BigDecimal getBigDecimal(int col)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

getDouble

public double getDouble(int col)
                 throws java.lang.Exception

Throws:

java.lang.Exception

getInt

public int getInt(int col)
           throws java.lang.Exception

Throws:

java.lang.Exception

getString

public java.lang.String getString(int col)
                           throws java.lang.Exception

Throws:

java.lang.Exception

getTimestamp

public java.sql.Timestamp getTimestamp(int col)
                                throws java.lang.Exception

Throws:

java.lang.Exception

getDate

public java.util.Date getDate(int col)
                       throws java.lang.Exception

Throws:

java.lang.Exception

next

public boolean next()
             throws java.lang.Exception

Throws:

java.lang.Exception

reset

public void reset()

select

public void select(java.lang.String columns,
                   java.lang.String from)
            throws java.lang.Exception

Throws:

java.lang.Exception

select

public void select(java.lang.String columns,
                   java.lang.String from,
                   java.lang.String criteria)
            throws java.lang.Exception

Throws:

java.lang.Exception

nativeSelect

public void nativeSelect(java.lang.String query)
                  throws java.lang.Exception

Throws:

java.lang.Exception

update

public void update(java.lang.String query)
            throws java.lang.Exception

Throws:

java.lang.Exception

executeProcedure

public java.util.Map executeProcedure(java.lang.String name,
                                      java.util.Collection inputParam,
                                      java.util.Collection outputParamNames)
                               throws java.lang.Exception

Throws:

java.lang.Exception

setMaxRows

public void setMaxRows(int maxRows)

setParam

public void setParam(java.lang.String name,
                     java.lang.Object value)