Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- System.out.printf("%s, version %s%n",
- conn.getMetaData().getDriverName(),
- conn.getMetaData().getDriverVersion());
- // Microsoft JDBC Driver 7.4 for SQL Server, version 7.4.1.0
- Statement st = conn.createStatement();
- ResultSet rs = st.executeQuery(
- "SELECT CAST(123 AS SQL_VARIANT), CAST('abc' AS SQL_VARIANT), CAST(3.14 AS SQL_VARIANT)");
- rs.next();
- Object o1 = rs.getObject(1);
- System.out.println(o1.getClass().getName());
- // java.lang.Integer
- Object o2 = rs.getObject(2);
- System.out.println(o2.getClass().getName());
- // java.lang.String
- Object o3 = rs.getObject(3);
- System.out.println(o3.getClass().getName());
- // java.math.BigDecimal
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement