Sort out part of the java code and compare the data types with oracle,mysql,sql server
After searching for the comparison of data types on the Internet, there is almost no comparison of the three databases, so I wrote the comparison of some fields. If there is anything wrong, please do not hesitate to comment.
JAVA field oracle field mysql field sql server field intnumberintintjava.lang.doublenumber (pjings) doublefloatjava.lang.Stringvarchar2varcharvarcharjava.sql.Datedatedate (year) datetime2java.sql.Timedatetimedatetime2java.math.BigDecimalnumberbigintdecimal (money,smallmoney,numeric) java.lang.floatnumberfloatrealjava.lang.shortnumbervarcharvarcharjava.lang.booleannumberbitbit
Java.lang.bytevarchar2varcharvarcharjava.lang.longnumberintegerbigint
