API 1.3-SNAPSHOT

Base Package: com.manticore.jdbc

Base

AggregateFunction

[SUM, COUNT]

MJdbcTools

extends: Object

MJdbcTools ()

getSQLDate (cal) → Date

Calendar cal

returns Date

getSQLDate (d) → Date

Date d

returns Date

getSQLTimestamp (cal) → Timestamp

Calendar cal

returns Timestamp

getSQLTimestamp (d) → Timestamp

Date d

returns Timestamp

getSQLDateStr (d) → String

Date d

returns String

getSQLDateStr (c) → String

Calendar c

returns String

getSQLDateTimeStr (d) → String

Date d

returns String

getSQLDateTimeStr (ts) → String

Timestamp ts

returns String

getSQLDateTimeStr (c) → String

Calendar c

returns String

getSQLHash (sqlStr) → String

String sqlStr

returns String

Object o

returns String

rewriteStatementWithNamedParameters (sqlStr, parameters) → String

String sqlStr

Object> parameters

returns String

rewriteStatementWithNamedParameters (sqlStr, parameters) → String

String sqlStr

Object[] parameters

returns String

Object> keys

returns Object>

@SuppressWarnings

getPivotFromQuery (rs, function, aggregateColumnName, categoryColumnName, categoryFormat, buildTotals, repeatHeader) → Object[][]

The getPivotFromQuery function takes a ResultSet and converts it into a pivot table. The function is designed to create columns for each key of the Category Column and to aggregate the values of the Aggregate Column for each Category.

ResultSet rs

AggregateFunction function

String aggregateColumnName

String categoryColumnName

Format categoryFormat

boolean buildTotals

boolean repeatHeader

returns Object[][]

MNamedParameter

extends: Object implements: MNamedParameter>

MNamedParameter (id, position)

String id

int position

getParameterValueArray (parameters) → Object>

MNamedParameter> parameters

returns Object>

add (position)

Integer position

@Override

compareTo (o) → int

MNamedParameter o

returns int

@Override

hashCode () → int

returns int

@Override

equals (obj) → boolean

Object obj

returns boolean

@Override

toString () → String

returns String

setType (type, typeName, className, precision, scale, nullable)

int type

String typeName

String className

int precision

int scale

int nullable

getScale () → Integer

returns Integer

getId () → String

returns String

setLabel (label) → MNamedParameter

String label

returns MNamedParameter

setValue (value) → MNamedParameter

Object value

returns MNamedParameter

getLabel () → String

returns String

getValue () → Object

returns Object

getPositions () → Integer>

returns Integer>

getType () → Integer

returns Integer

getTypeName () → String

returns String

getPrecision () → Integer

returns Integer

getNullable () → Integer

returns Integer

getClassName () → String

returns String

MPreparedStatement

extends: Object implements: Closeable

MPreparedStatement (conn, sqlStr, batchSize)

Connection conn

String sqlStr

int batchSize

MPreparedStatement (conn, sqlStr)

Connection conn

String sqlStr

String sqlStr

returns String

Object> parameterValues

returns Object>

Object> parameterValues

returns void

Object[] parameterValues

returns void

execute (parameterValues) → boolean

Object> parameterValues

returns boolean

execute (parameterValues) → boolean

Object[] parameterValues

returns boolean

executeUpdate (parameterValues) → int

Object> parameterValues

returns int

executeUpdate (parameterValues) → int

Object[] parameterValues

returns int

executeQuery (parameterValues) → ResultSet

Object> parameterValues

returns ResultSet

executeQuery (parameterValues) → ResultSet

Object[] parameterValues

returns ResultSet

close ()

cancel ()

addBatch (parameterValues)

Object> parameterValues

addBatch (parameterValues)

Object[] parameterValues

executeBatch () → int[]

returns int[]

addAndExecuteBatch (parameterValues) → int[]

Object> parameterValues

returns int[]

clearBatch ()

getResultSet () → ResultSet

returns ResultSet

getUpdateCount () → int

returns int

returns void

getNamedParametersByAppearance () → MNamedParameter>

returns MNamedParameter>

getNamedParametersByName () → MNamedParameter>

returns MNamedParameter>