2023年7月13日发(作者：)

MysqlSQLServer数据类型与java基本数据类型的对应问题描述：假如现在你要对mysql数据库进⾏插⼊操作。因为要插⼊很多数据，为了效率，因此，你创建了⼀个PreparedStatement：insert into tablevalues(?,?,?,?,?)其中table表各列的数据类型分别为INTEGER,BIGINT,CHAR,TEXT,BINARY现在你要向创建的PreparedStatement中的五个 ? 赋值。你已经知道PreparedStatement类有setBlog()、setBoolean()、setInt()、setDate()、setFloat()等等set⽅法，但是当你要向⼀个Mysql数据类型为BINARY的列赋值是，你不知道⽤PreparedStatement类的哪个set⽅法，setInt()？setString？还是setBytes()？没错，是setBytes()⽅法。可是如果mysql类型是decimal呢？是image呢？是bit呢？这个时候，如果你⼿⾥有⼀张Mysql/SQLServer数据类型与java基本数据类型的对应关系的表，那么⼀切问题都迎刃⽽解了。好了，废话不多说，下⾯的列表就给出了Mysql/SQLServer数据类型与java基本数据类型的对应，⽽且给出了⽤整型表⽰的列类型和列名。有了这张表，以后调⽤set⽅法就有据可循了：****************************************************Mysql *******************************************列 ClassNameColumnType0: rColumnType:41: rColumnType:-62: ColumnType:123: nColumnType:-74: rColumnType:55: rColumnType:46: rColumnType:47: lumnType:-58: ColumnType:89: ColumnType:810: olumnType:711: ColumnType:1212: ColumnType:1213: ColumnType:114: ColumnType:1215: lumnType:9116: lumnType:9217: lumnType:9118: ColumnType:amp19: ColumnType:amp20: [BColumnType:-321: [BColumnType:-422: [BColumnType:-423: [BColumnType:-424: ColumnType:1225: ColumnType:-126: ColumnType:-127: ColumnType:-128: ColumnType:129: ColumnType:1

****************************************************MSSQL*******************************************

列 ClassName0: r1: 2: byte[]3: n4: 5: ampColumnTypeDisplaySizeColumnType:411ColumnType:-520ColumnType:-2100ColumnType:-71ColumnType:110ColumnType:9323TYPENAMEINT IDENTITYBIGINTBINARYBITCHARDATETIMEDisplaySize2556553516777215-777215-133TypeNameINTEGERTINYINTUNKNOWNTINYINTSMALLINTMEDIUMINTINTEGERBIGINTDOUBLEDOUBLEFLOATUNKNOWNUNKNOWNCHARVARCHARDATETIMEYEARTIMESTAMPDATETIMETINYBLOBBLOBMEDIUMBLOBBLOBTINYBLOBTEXTMEDIUMBLOBTEXTCHARCHAR5: ampColumnType:9323DATETIME6: ampColumnType:9323DATETIME7: imalColumnType:320DECIMAL8: ColumnType:622FLOAT9: byte[]ColumnType:-42147483647IMAGE10:imalColumnType:321MONEY11: ColumnType:110NCHAR12: ColumnType:-NTEXT13:imalColumnType:220NUMERIC14: ColumnType:1250NVARCHAR15: olumnType:713REAL16: ampColumnType:9316SMALLDATETIME17: rColumnType:56SMALLINT18:imalColumnType:312SMALLMONEY19: ColumnType:128000SQL_VARIANT20: ColumnType:-TEXT21: byte[]ColumnType:-216TIMESTAMP22: rColumnType:-63TINYINT23: ColumnType:136UNIQUEIDENTIFIER24: byte[]ColumnType:-3100VARBINARY25: ColumnType:1250VARCHAR