public class EasySQL
extends java.lang.Object
| Constructor and Description |
|---|
EasySQL(JdbcWrapper conn) |
| 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) |
public EasySQL(JdbcWrapper conn)
public void close()
public java.math.BigDecimal getBigDecimal(java.lang.String colName)
throws java.lang.Exception
java.lang.Exceptionpublic double getDouble(java.lang.String colName)
throws java.lang.Exception
java.lang.Exceptionpublic int getInt(java.lang.String colName)
throws java.lang.Exception
java.lang.Exceptionpublic java.lang.String getString(java.lang.String colName)
throws java.lang.Exception
java.lang.Exceptionpublic java.sql.Timestamp getTimestamp(java.lang.String colName)
throws java.lang.Exception
java.lang.Exceptionpublic java.util.Date getDate(java.lang.String colName)
throws java.lang.Exception
java.lang.Exceptionpublic java.math.BigDecimal getBigDecimal(int col)
throws java.lang.Exception
java.lang.Exceptionpublic double getDouble(int col)
throws java.lang.Exception
java.lang.Exceptionpublic int getInt(int col)
throws java.lang.Exception
java.lang.Exceptionpublic java.lang.String getString(int col)
throws java.lang.Exception
java.lang.Exceptionpublic java.sql.Timestamp getTimestamp(int col)
throws java.lang.Exception
java.lang.Exceptionpublic java.util.Date getDate(int col)
throws java.lang.Exception
java.lang.Exceptionpublic boolean next()
throws java.lang.Exception
java.lang.Exceptionpublic void reset()
public void select(java.lang.String columns,
java.lang.String from)
throws java.lang.Exception
java.lang.Exceptionpublic void select(java.lang.String columns,
java.lang.String from,
java.lang.String criteria)
throws java.lang.Exception
java.lang.Exceptionpublic void nativeSelect(java.lang.String query)
throws java.lang.Exception
java.lang.Exceptionpublic void update(java.lang.String query)
throws java.lang.Exception
java.lang.Exceptionpublic java.util.Map executeProcedure(java.lang.String name,
java.util.Collection inputParam,
java.util.Collection outputParamNames)
throws java.lang.Exception
java.lang.Exceptionpublic void setMaxRows(int maxRows)
public void setParam(java.lang.String name,
java.lang.Object value)