AIX平台上使用JAVA程序连接到DB2数据库

最新推荐文章于 2021-08-13 09:23:05 发布

匿_名_用_户

最新推荐文章于 2021-08-13 09:23:05 发布

阅读量954

点赞数

分类专栏： DB2 文章标签： DB2 数据库

本文链接：https://blog.csdn.net/qingsong3333/article/details/50739422

版权

DB2 专栏收录该内容

181 篇文章 9 订阅

订阅专栏

[摘要]

本文中描述了一个比较简单的场景：在AIX环境下，写一个简单的JAVA程序，连接到DB2数据库并访问表的数据。

[背景知识要求]

要求对DB2和JAVA开发有一定的基础知识

[环境]

$ db2level
DB21085I Instance "e97q6c" uses "64" bits and DB2 code release "SQL09076" with
level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120629", "IP23414", and Fix Pack
"6".
Product is installed at "/opt/IBM/db2/V9.7.6".

AIX: 6100-08-02-1316

DB名： qsmiao

[过程]

1.）确保数据库SERVER的端口处于监听状态

$ db2 get dbm cfg | grep -i "SVCENAME"
TCP/IP Service name (SVCENAME) = db2c_e97q6c

[db2b /home/db2users/e97q6c]$ cat /etc/services | grep -i db2c_e97q6c
db2c_e97q6c 61111/tcp

[db2b /home/db2users/e97q6c]$ netstat -an | grep -i 61111
tcp4 0 0 *.61111 *.* LISTEN

2.）在FirstClass.java中编辑并保存以下代码

import java.sql.*;  
  
public class FirstClass {  
  
    public static void main(String args[]) {  
  
        try {  
            Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();  
              
            String url = "jdbc:db2://localhost:61111/qsmiao";  
            String user = "e97q6c";  
            String password = "e97q6c";  
              
            System.out.println("try");  
            Connection conn = DriverManager.getConnection(url, user, password);  
            System.out.println("success");  
              
            PreparedStatement   ps = conn.prepareStatement("SELECT * FROM E97Q6C.T1");  
              
              
            ResultSet rs = ps.executeQuery();  
            while (rs.next())  
            {  
                int id = rs.getInt("ID");  
                String name = rs.getString("NAME");  
                System.out.println("ID: " + id );  
                System.out.println("NAME: " + name);  
            }  
              
            conn.close();  
              
        } catch (Exception sqle) {  
            System.out.println(sqle);  
        }  
          
        return;  
    }  
}

3.）编译并执行JAVA程序

$ /opt/IBM/db2/V9.7.6/java/jdk64/bin/javac FirstClass.java

$ /opt/IBM/db2/V9.7.6/java/jdk64/bin/java FirstClass
try
success
ID: 11
NAME: hehe
ID: 22
NAME: you
ID: 33

NAME: and