
复制import java.sql.CallableStatement; import java.sql.Connection; import java.sql.Driver; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; Description: Copyright: (c) 2005 @author @version 1.0 @since 2005-11-1 Version History: Date By Relative Bug Description public class TestUDB { public static void main(String args[]) { try { Class.forName(”com.ibm.DB2.jcc.DB2Driver”).newInstance(); String url = “jdbc:DB2://192.1.16.64:60004/testdb”; String userid = “DB2test5″; String password = “password”; Connection conn = DriverManager.getConnection(url,实战演示 userid, password); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(”SELECT * FROM tbCode”); if (rs == null) { System.out.print(”No resultset!”); } else { while (rs.next()) { System.out.println(rs.getString(1)); } System.out.println(”Output over!”); } stmt.close(); conn.close(); } catch (SQLException ex) { ex.printStackTrace(); } catch (java.lang.Exception ex) { ex.printStackTrace(); } } } 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.