java: 各数据类型

java.sql.Types 数据类型 java 数据类型 CallableStatement set和 registerOutParameter 数据类型 PreparedStatement set 数据类型 mysql 
https://docs.oracle.com/javase/8/docs/api/java/sql/CallableStatement.html
https://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html
https://docs.oracle.com/en/java/javase/14/docs/api/java.sql/java/sql/PreparedStatement.html
https://docs.oracle.com/en/java/javase/14/docs/api/java.sql/java/sql/CallableStatement.html
https://docs.oracle.com/en/java/javase/14/docs/api/java.sql/java/sql/Types.html
https://docs.oracle.com/en/java/javase/14/docs/api/allclasses-index.html
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlqr/Data-Types.html

java MySQL getMetaData

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109

//java 数据类型 与sql.Types类型的转换 找出其规律, 判断变量类型便于互相自动转换 涂聚文 Geovin Du             ArrayList<OutObject> outObjects=new ArrayList<OutObject>();             OutObject outObject=null;              int i=0;             outObject=new OutObject();             outObject.setObject(i);             outObject.setOutInt(1);             outObjects.add(outObject);                String s="geovindu";             outObject=new OutObject();             outObject.setObject(s);             outObject.setOutInt(2);             outObjects.add(outObject);                long l=234343;             outObject=new OutObject();             outObject.setObject(l);             outObject.setOutInt(3);             outObjects.add(outObject);              short ss=1111;             outObject=new OutObject();             outObject.setObject(ss);             outObject.setOutInt(4);             outObjects.add(outObject);              byte b=22;             outObject=new OutObject();             outObject.setObject(b);             outObject.setOutInt(5);             outObjects.add(outObject);             double db=23.2;             outObject=new OutObject();             outObject.setObject(db);             outObject.setOutInt(6);             outObjects.add(outObject);              float ff=23.5f;             outObject=new OutObject();             outObject.setObject(ff);             outObject.setOutInt(7);             outObjects.add(outObject);                char ch='y';             outObject=new OutObject();             outObject.setObject(ch);             outObject.setOutInt(8);             outObjects.add(outObject);                boolean bl=false;             outObject=new OutObject();             outObject.setObject(bl);             outObject.setOutInt(9);             outObjects.add(outObject);             DuGetField duGetField=new DuGetField();             for(OutObject object:outObjects)             {               System.out.println( "DataType:"+ DuGetField.getType(object.getObject())+"  id:"+object.getOutInt());             }            /*            * DataType:Integer  id:1 DataType:String  id:2 DataType:Long  id:3 DataType:Short  id:4 DataType:Byte  id:5 DataType:Double  id:6 DataType:Float  id:7 DataType:Character  id:8 DataType:Boolean  id:9            * */               /*            java.sql.Types 数据类型 Geovin Du 涂聚文            Types.INTEGER;             Types.NVARCHAR;             Types.BIT;             Types.ARRAY;             Types.BIGINT;             Types.BINARY;             Types.BLOB;             Types.BOOLEAN;             Types.CHAR;             Types.CLOB;             Types.DATALINK;             Types.DATE;             Types.DECIMAL;             Types.DISTINCT;             Types.DOUBLE;             Types.FLOAT;             Types.LONGNVARCHAR;             Types.JAVA_OBJECT;             Types.LONGVARBINARY;             Types.NCHAR;             Types.NULL;             Types.NCLOB;             Types.NUMERIC;             Types.OTHER;             Types.REAL;             Types.REF;             Types.REF_CURSOR;             Types.ROWID;             Types.SMALLINT;             Types.SQLXML;             Types.STRUCT;             Types.TIME;             Types.TIME_WITH_TIMEZONE;             Types.TIMESTAMP;             Types.TINYINT;             Types.VARBINARY;             Types.VARCHAR;              */