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
    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 () → 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