jdbc_app.java

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

import java.sql.*; 

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

      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(); 
   } 
}