testpool.java

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

package com.ideas.util;

import java.sql.*;

public class TestPool {
  public static void main(String[] args) {
    DBConnectionManager connMgr = DBConnectionManager.getInstance();
    Connection con = connMgr.getConnection("idb");
    if (con == null) {
      System.out.println("不能获取数据库连接.");
      return;
    }
    ResultSet rs = null;
    ResultSetMetaData md = null;
    Statement stmt = null;
    try {
      stmt = con.createStatement();
      // rs = stmt.executeUpdate("SELECT * FROM aix_cpu");
      for (int i = 1; i < 8000; i++) {
        String random = String.valueOf( (int) ( (Math.random() * 100)));
        String sql="Update sfserror set warning='" + random +
                           "' where id = " + String.valueOf(10000 + i);
        stmt.executeUpdate(sql);
      }

      rs = stmt.executeQuery("SELECT * FROM cpu");
      md = rs.getMetaData();

      while (rs.next()) {

        for (int i = 1; i < md.getColumnCount(); i++) {
          System.out.print(rs.getString(i) + " ");
        }
        System.out.println("<BR>");
      }
      System.out.println("</body></html>");
      stmt.close();
      rs.close();
    }
    catch (SQLException e) {
      e.printStackTrace(System.out);
    }

  }

}