在IBM i (OS/400)中使用Java来连接DB2数据库

这是一种在IBM i (OS/400)平台上使用Java语言连接DB2数据库的解决方案。这个示例代码演示了Java如何在IBM i (OS/400)上连接一个DB2数据库，并执行一些查询和更新操作。该代码还解释了如何使用数据库连接池来进行连接管理以提高性能和可靠性。

/**
 * 在IBM i (OS/400)中使用Java来连接DB2数据库
 */

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.sql.DataSource;
import com.ibm.as400.access.AS400JDBCConnectionPoolDataSource;

public class DB2Connection{
    private static final String HOST = "localhost";
    private static final String PORT = "50000";
    private static final String DATABASE = "SAMPLE";
    private static final String USER = "myuser";
    private static final String PASSWORD = "mypassword";
    private static final int MAX_POOL_SIZE = 10;

    public static void main(String[] args) throws Exception{
        // Set up the database connection pool
        AS400JDBCConnectionPoolDataSource pool = new AS400JDBCConnectionPoolDataSource();
        pool.setServerName(HOST);
        pool.setPortNumber(Integer.parseInt(PORT));
        pool.setDatabaseName(DATABASE);
        pool.setUser(USER);
        pool.setPassword(PASSWORD);
        pool.setMaxConnections(MAX_POOL_SIZE);

        // Get a connection from the pool
        DataSource dataSource = (DataSource) pool;
        Connection connection = dataSource.getConnection();

        // Execute a query
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery("SELECT * FROM EMPLOYEES");

        // Process the result set
        while (resultSet.next()) {
            int id = resultSet.getInt("ID");
            String name = resultSet.getString("NAME");
            int age = resultSet.getInt("AGE");
            System.out.printf("ID: %d, NAME: %s, AGE: %d\n", id, name, age);
        }

        // Close the connection
        connection.close();
    }
}

免责申明：文章和图片全部来源于公开网络，如有侵权，请通知删除 server@dude6.com