資料庫操作：java串連DB2執行個體代碼示範

package com.qiaole.conn;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DB2 {
 public static void main(String[] args) {
  try {
   Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
   // COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver
   String url = "jdbc:db2://localhost:50000/sample";
   Connection conn = DriverManager.getConnection(url, "happy",
     "qiaole1");
   String sql = "SELECT * FROM HAPPY.TEST";
   PreparedStatement psStatement = conn.prepareStatement(sql);
   ResultSet rSet = psStatement.executeQuery();
   System.out.println("/tDB2查詢資料");
   while (rSet.next()) {
    System.out.println(rSet.getInt(1) + "/t" + rSet.getString(2)
      + "/t" + rSet.getInt(3));
   }
  } catch (InstantiationException e) {
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }
}

 

需要添加的包：