Java and MySql database types

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.

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.