public static void main(String[] args) {
??Connection conn = null;
??PreparedStatement ps = null;
??ResultSet rs = null;
??String url = "jdbc:db2://192.168.3.23:50000/dbname",
????? username = "username",
????? password = "password";
??try {
???Class.forName("com.ibm.db2.jcc.DB2Driver");
???conn = DriverManager.getConnection(url, username, password);
???ps = conn.prepareStatement("select?colname from tablename");
???rs = ps.executeQuery();
???while (rs.next()) {
????System.out.println(rs.getString(1));
???}
??} catch (Exception e) {
???e.printStackTrace();
??} finally {
???try {
????if (rs != null) rs.close();
????if (ps != null) ps.close();
????if (conn != null) conn.close();
???} catch (SQLException e) {
????e.printStackTrace();
???}
??}
?}