在 IBM i (OS/400) 中创建 DB2 数据库并添加数据

本示例代码演示了如何在 IBM i (OS/400) 上创建一个新的 DB2 数据库，以及如何通过 SQL 语句向其中添加数据。通过使用 JDBC 驱动程序，我们可以在 Java 应用程序中执行这些操作。这个示例是基于 IBM i 7.4 和 Java 11。

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

public class Db2Example {

    private final String DATABASE_URL = "jdbc:as400://my-ibmi.example.com/mydatabase";
    private final String DATABASE_USERNAME = "myuser";
    private final String DATABASE_PASSWORD = "mypassword";

    public void createDb2Database(String databaseName) {
        try (Connection connection = DriverManager.getConnection(DATABASE_URL, DATABASE_USERNAME, DATABASE_PASSWORD);
             PreparedStatement preparedStatement = connection.prepareStatement("CREATE DATABASE " + databaseName)) {
            preparedStatement.executeUpdate();
            System.out.println("Database " + databaseName + " created successfully");
        } catch (SQLException e) {
            System.err.println("Error creating database " + databaseName + ": " + e.getMessage());
        }
    }

    public void insertDataIntoDb2Database(String databaseName, String tableName, int id, String name) {
        try (Connection connection = DriverManager.getConnection(DATABASE_URL + "/"+ databaseName, DATABASE_USERNAME, DATABASE_PASSWORD);
             PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO " + tableName + " VALUES(?, ?)")) {
            preparedStatement.setInt(1, id);
            preparedStatement.setString(2, name);
            preparedStatement.executeUpdate();
            System.out.println("Data inserted successfully into " + tableName);
        } catch (SQLException e) {
            System.err.println("Error inserting data into " + tableName + ": " + e.getMessage());
        }
    }

}

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