jdbc_net.java

来自「java程序」· Java 代码 · 共 37 行

import java.sql.*; 

public class JDBC_net 
{ 
   public static void main(String args[]) throws Exception 
   {
   	
   	/* 方法一: net */
   	Class.forName("COM.ibm.db2.jdbc.net.DB2Driver"); 
   	System.out.println("JDBC Driver For DB2 Loaded OK!"); 
   	
   	
        Connection conn = DriverManager.getConnection("jdbc:db2://182.119.204.134/sample", "administrator", "123456");       
        
        System.out.println("Connect to DB2 OK!"); 
      	/* End net */
      	
	

      Statement  stmt = conn.createStatement(); 
      ResultSet  rslt = stmt.executeQuery("SELECT empno, firstnme FROM employee where empno < '00010' "); 

      System.out.println ("数据库查询结果：");      
      while (rslt.next()) 
      {
          System.out.println("Hello, " 
                            + rslt.getString(1) // You can use getString(columnNumber) 
                            + " is "  
                            + rslt.getString("firstnme")); // Or, you can use getString(columnName) 
      } 

      rslt.close(); 
      stmt.close(); 
      conn.close(); 
   } 
}