Java and MySql database types

MySql connector JAVA type name display length Database Type JAVA type JDBC Type Index (int) Description VARCHARLNVARCHARjava. lang. String12CHARNCHARjava. lang. String1BLOBLNBLOBjava. lang. byte []-4TEXT65535VARCHARjava. lang. S

MySql ----------------------------------- JAVA type name display length Database Type JAVA type JDBC Type Index (int) Description varchar ln varchar java. lang. string 12 char n char java. lang. string 1 blob ln blob java. lang. byte []-4 TEXT 65535 VARCHAR java. lang. S

MySql <-----------------------------------> JAVA

Type name	Display Length	Database Type	JAVA type	JDBC index (int)	Description
VARCHAR	L + N	VARCHAR	Java. lang. String	12
CHAR	N	CHAR	Java. lang. String	1
BLOB	L + N	BLOB	Java. lang. byte []	-4
TEXT	65535	VARCHAR	Java. lang. String	-1
INTEGER	4	INTEGER UNSIGNED	Java. lang. Long	4
TINYINT	3	TINYINT UNSIGNED	Java. lang. Integer	-6
SMALLINT	5	SMALLINT UNSIGNED	Java. lang. Integer	5
MEDIUMINT	8	MEDIUMINT UNSIGNED	Java. lang. Integer	4
BIT	1	BIT	Java. lang. Boolean	-7
BIGINT	20	BIGINT UNSIGNED	Java. math. BigInteger	-5
FLOAT	4 + 8	FLOAT	Java. lang. Float	7
DOUBLE	22	DOUBLE	Java. lang. Double	8
DECIMAL	11	DECIMAL	Java. math. BigDecimal	3
BOOLEAN	1	Same as TINYINT
ID	11	PK (integer unsigned)	Java. lang. Long	4
DATE	10	DATE	Java. SQL. Date	91
TIME	8	TIME	Java. SQL. Time	92
DATETIME	19	DATETIME	Java. SQL. Timestamp	93
TIMESTAMP	19	TIMESTAMP	Java. SQL. Timestamp	93
YEAR	4	YEAR	Java. SQL. Date	91

For bolb, it is generally used to store images in a database. The principle is to compress the images into binary data and then store them in a storage method that corresponds to byte [] arrays in java.

For the boolen type, in the mysql database, I personally think it is better to replace the int type, it is not very convenient for bit operations, especially in projects with web page development, it indicates 0/1, the corresponding java type Integer is better.