查看“针对customers表的查询操作举例”的源代码

https://www.bilibili.com/video/BV1eJ411c7rf?p=17
{| class="wikitable"
|+Java与SQL对应数据类型转换表
!Java 类型
!SQL 类型
|-
|boolean
|BIT
|-
|byte
|TINYINT
|-
|short
|SMALLINT
|-
|int
|INTEGER
|-
|long
|BIGINT
|-
|String
|CHAR, VARCHAR, LONGVARCHAR
|-
|byte array
|BINARY,，VAR BINARY
|-
|java.sql.Date
|DATE
|-
|java.sql.Time
|TIME
|-
|java.sql.Timestamp
|TIMESTAMP
|}