java.lang.Boolean if the configuration property tinyInt1isBit is set to true (the default) and the storage size is 1, or java.lang.Integer if not.
BOOL, BOOLEAN
TINYINT
See TINYINT, above as these are aliases for TINYINT(1), currently.
SMALLINT[(M)] [UNSIGNED]
SMALLINT [UNSIGNED]
java.lang.Integer (regardless if UNSIGNED or not)
MEDIUMINT[(M)] [UNSIGNED]
MEDIUMINT [UNSIGNED]
java.lang.Integer, if UNSIGNED java.lang.Long (C/J 3.1 and earlier), or java.lang.Integer for C/J 5.0 and later
INT,INTEGER[(M)] [UNSIGNED]
INTEGER [UNSIGNED]
java.lang.Integer, if UNSIGNED java.lang.Long
BIGINT[(M)] [UNSIGNED]
BIGINT [UNSIGNED]
java.lang.Long, if UNSIGNED java.math.BigInteger
FLOAT[(M,D)]
FLOAT
java.lang.Float
DOUBLE[(M,B)]
DOUBLE
java.lang.Double
DECIMAL[(M[,D])]
DECIMAL
java.math.BigDecimal
DATE
DATE
java.sql.Date
DATETIME
DATETIME
java.sql.Timestamp
TIMESTAMP[(M)]
TIMESTAMP
java.sql.Timestamp
TIME
TIME
java.sql.Time
YEAR[(2|4)]
YEAR
If yearIsDateType configuration property is set to false, then the returned object type is java.sql.Short. If set to true (the default) then an object of type java.sql.Date (with the date set to January 1st, at midnight).
CHAR(M)
CHAR
java.lang.String (unless the character set for the column is BINARY, then byte[] is returned.
VARCHAR(M) [BINARY]
VARCHAR
java.lang.String (unless the character set for the column is BINARY, then byte[] is returned.