所述
ResultSetmetaData.getColumnType(intcolumn)返回一个
int指定列类型值发现
java.sql.Types。
例:
Connection connection = DriverManager.getConnection(JDBC_URL, JDBC_USERNAME, JDBC_PASSWORD);PreparedStatement statement = connection.prepareStatement(JDBC_SELECT);ResultSet rs = statement.executeQuery();PrintStream out = System.out;if (rs != null) { while (rs.next()) { ResultSetmetaData rsmd = rs.getmetaData(); for (int i = 1; i <= rsmd.getColumnCount(); i++) { if (i > 1) { out.print(","); } int type = rsmd.getColumnType(i); if (type == Types.VARCHAR || type == Types.CHAR) { out.print(rs.getString(i)); } else { out.print(rs.getLong(i)); } } out.println(); }}


