API 1.1.0-SNAPSHOT¶
Base Package: com.manticore.jdbc
Base¶
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
rewriteStatementWithNamedParameters (sqlStr, parameters) → String
String sqlStr
Map parameters
returns String
rewriteStatementWithNamedParameters (sqlStr, parameters) → String
String sqlStr
Object parameters
returns String
MNamedParameter¶
extends: Object implements: Comparable
MNamedParameter (id, position)
String id
int position
getParameterValueArray (parameters) → LinkedList
Collection parameters
returns LinkedList
add (position)
Integer position
@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 () → TreeSet
returns TreeSet
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
execute (parameterValues) → boolean
Map parameterValues
returns boolean
execute (parameterValues) → boolean
Object parameterValues
returns boolean
executeUpdate (parameterValues) → int
Map parameterValues
returns int
executeUpdate (parameterValues) → int
Object parameterValues
returns int
executeQuery (parameterValues) → ResultSet
Map parameterValues
returns ResultSet
executeQuery (parameterValues) → ResultSet
Object parameterValues
returns ResultSet
close ()
cancel ()
addBatch (parameterValues)
Map parameterValues
addBatch (parameterValues)
Object parameterValues
executeBatch () → int
returns int
addAndExecuteBatch (parameterValues) → int
Map parameterValues
returns int
clearBatch ()
getResultSet () → ResultSet
returns ResultSet
getUpdateCount () → int
returns int
getNamedParametersByAppearance () → List
returns List
getNamedParametersByName () → List
returns List