DB2 连接测试代码

最新推荐文章于 2024-07-28 20:21:28 发布

原创最新推荐文章于 2024-07-28 20:21:28 发布 · 239 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

java基础专栏收录该内容

7 篇文章

订阅专栏

package spring.batch.controller;

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

public class Test1 {
   public static void main(String[] args) {

      try {
         // 需要引入db2jcc4.jar
         Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
      } catch (InstantiationException e) {
         throw new RuntimeException(e);
      } catch (IllegalAccessException e) {
         throw new RuntimeException(e);
      } catch (ClassNotFoundException e) {
         throw new RuntimeException(e);
      }

      // 必须使用IP
      String url = "jdbc:db2://192.168.10.7:50000/SAMPLE";
      try {
         Connection con = DriverManager.getConnection(url, "db2admin", "你的密码");
         System.out.println(con);
      } catch (SQLException e) {
         throw new RuntimeException(e);
      }
   }
}