使用IBM i (OS/400)管理数据库和表格

本示例展示了如何在IBM i (OS/400)上使用SQL语句管理数据库和表格。可以创建、修改和删除表格，还可以向表格中添加和删除数据。这个示例使用的是jtopen库的JDBC驱动程序。

import java.sql.*;
import com.ibm.as400.access.*;

public class SQLManager {
   public static void main(String[] args) {
      Connection connection = null;
      Statement statement = null;
      String tableName = "Employee";
      try {
         // 连接到IBM i (OS/400)
         AS400JDBCDataSource ds = new AS400JDBCDataSource("myAS400");
         ds.setDatabaseName("myDatabase");
         ds.setUser("myUserName");
         ds.setPassword("myPassword");
         connection = ds.getConnection();

         // 创建表格
         statement = connection.createStatement();
         String createTableSQL = "CREATE TABLE " + tableName + " (ID INT, NAME VARCHAR(20), AGE INT)";
         statement.executeUpdate(createTableSQL);

         // 添加数据到表格
         String insertSQL = "INSERT INTO " + tableName + " (ID, NAME, AGE) VALUES(1, 'Tom', 25)";
         statement.executeUpdate(insertSQL);

         // 查询表格中的数据
         String selectSQL = "SELECT * FROM " + tableName;
         ResultSet resultSet = statement.executeQuery(selectSQL);
         while (resultSet.next()) {
            int id = resultSet.getInt("ID");
            String name = resultSet.getString("NAME");
            int age = resultSet.getInt("AGE");
            System.out.println("ID: " + id + "  Name: " + name + "  Age: " + age);
         }

         // 修改表格中的数据
         String updateSQL = "UPDATE " + tableName + " SET AGE=30 WHERE ID=1";
         statement.executeUpdate(updateSQL);

         // 删除表格中的数据
         String deleteSQL = "DELETE FROM " + tableName + " WHERE ID=1";
         statement.executeUpdate(deleteSQL);

         // 删除表格
         String dropTableSQL = "DROP TABLE " + tableName;
         statement.executeUpdate(dropTableSQL);
      } catch (Exception e) {
         e.printStackTrace();
      } finally {
         try { if (statement!=null) statement.close(); } catch(Exception e) {}
         try { if (connection!=null) connection.close(); } catch(Exception e) {}
      }
   }
}

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