JAVA 连接DB2

import  java.sql. * ;


public   class  dbtest 
... {

        public static void main(String[] args)
    ...{
            try
              ...{
               Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
               
               String url="jdbc:db2://172.16.123.126:60000/DOL"; 
               String user="dolown"; 
               String password="dolown"; 
               System.out.println("try");
               Connection conn= DriverManager.getConnection(url,user,password);
               System.out.print("Done!OK!!! ");
               
               PreparedStatement   ps=conn.prepareStatement( "select   DEALERMARKET_NAME  from   TR_EVERYBUSINESS_TOTAL "); 
               ResultSet   rs=ps.executeQuery(); 
               while   (rs.next())
               ...{ 
                       System.out.println( "user_no= "+rs.getString( "DEALERMARKET_NAME ")); 
               }
               conn.close();
              }catch(Exception sqle)
              ...{
               System.out.print(sqle); 
               
               }


    }

}

 

环境：eclipse + ibm的jdk(一定要用ibm的不要用sun的,不然会报错“com.ibm.db2.jcc.c.DisconnectException: encoding not supported!!”)

IBMJDK(带jdk的eclipse)下载地址:

https://www14.software.ibm.com/webapp/iwm/web/reg/download.do?source=idpe&S_TACT=105AGX05&S_CMP=JDK&lang=en_US&S_PKG=win220&cp=UTF-8

要先注册一个IBM的帐号才能下载，

运行程序的时候要先把db2的驱动db2java.zip,db2jcc.jar加载到项目中.

网上有不少连接db2的例子，试了很多都不行，报错，最后才发现是jdk的问题，在这里发表一下，希望给大家节省一一些时间。