在Shell脚本中通过JDBC连接到DB2

source /path/to/db2jcc.jar

DB_URL=jdbc:db2://localhost:50000/sample
DB_USER=myuser
DB_PASSWORD=mypassword

#!/bin/bash

# 导入DB2 JDBC驱动
source /path/to/db2jcc.jar

# 设置JDBC连接参数
DB_URL=jdbc:db2://localhost:50000/sample
DB_USER=myuser
DB_PASSWORD=mypassword

# 连接到DB2数据库
java -cp /path/to/db2jcc.jar:. ConnectDB2 "$DB_URL" "$DB_USER" "$DB_PASSWORD"

chmod +x connect_db2.sh
./connect_db2.sh

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

public class ConnectDB2 {
    public static void main(String[] args) {
        String dbUrl = args[0];
        String dbUser = args[1];
        String dbPassword = args[2];

        try {
            // 加载DB2 JDBC驱动
            Class.forName("com.ibm.db2.jcc.DB2Driver");
            
            // 连接到DB2数据库
            Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
            
            // 执行数据库操作...
            
            // 关闭数据库连接
            conn.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}