Java中Long型数据类型对应MySQL数据库中哪种类型?

/ mysql / 没有评论 / 3308浏览

Java中Long型数据类型对应MySQL数据库中哪种类型?

Long型id数据对应MySQL数据库中 bigint 数据类型;

System.out.println(1==1L);        //ture
System.out.println(1L);        //1
System.out.println(1L+"2");        //12
java类mysql数据库
java.lang.BytebyteTINYINT
java.lang.ShortshortSMALLINT
java.lang.IntegerintegerINGEGER
java.lang.LonglongBIGINT
java.lang.FloatfloatFLOAT
java.lang.DoubledoubleDOUBLE
java.lang.BigDecimalbig_decimalNUMERIC
java.lang.BooleanbooleanBIT
java.lang.StringstringVARCHAR
java.lang.Booleanyes_noCHAR(1)('Y'或'N')
java.lang.Booleantrue_falseCHAR(1)(‘Y’或'N')
java.uitl.Date / java.sql.DatedateDATE
java.sql.TimetimeTIME
java.sql.TimestamptimestampTIMESTAMP
java.uitl.CalendarcelendarTIMESTAMP
java.uitl.CalendarcalendarTIMESTAMP
java.io.SerializableserializableVARBINARY/BLOB
java.sql.ClobclobCLOB
java.sql.BlobblobBLOB
java.lang.ClassclassVARCHAR
java.uitl.LocalelocaleVARCHAR
java.uitl.TimeZonetimezoneVARCHAR
java.uitl.CurrencycurrencyVARCHAR