java连接DB2数据库示例代码

会用到2个包 db2jcc.jar  和 db2jcc_license_cu.jar  这两个包在db2的安装目录IBM\SQLLIB\java下。拷贝到jdk\jre\lib\ext目录下 OK!

 

 

import java.sql.*;
import java.util.*;
import java.io.*;
class test
{
  public static void main(String args[]) throws SQLException, Exception
  {
  try
  {

   Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
String url = "jdbc:db2://localhost:50000/SAMPLE";

   String user="db2admin";
   String password="123";
   Connection conn= DriverManager.getConnection(url,user,password);
   System.out.print("connection  Done!OK!!!\n");
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM OSPY.DEPARTMENT";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
            System.out.println(rs.getString(1) + " " + rs.getString(2));
         }
  }catch(SQLException sqle)
  {
   System.out.print(sqle);
   }

  }
}