一个有趣的内存数据库

import java.sql.*; Class.forName("jstels.jdbc.engine.EngineDriver"); Class.forName("com.ibm.db2.jcc.DB2Driver");Connection MemonyConn = DriverManager.getConnection("jdbc:jstels:engine");Connection HNBASDBConn = DriverManager.getConnection("jdbc:db2://10.154.144.11:50000/hndpdb","hndp","hndp99");//获取HJVM内存状态def MemoryStatus={totle=(int)(Runtime.getRuntime().totalMemory()/1024);free=(int)(Runtime.getRuntime().freeMemory()/1024);status=(totle-free)/1024 println "内存使用了：${status}M"println new java.util.Date().toString()}MemoryStatus(); ( (jstels.jdbc.engine.EngineConnection) MemonyConn).loadTableFromDB(HNBASDBConn,"select * from HNDP.B_FUNCTIONCONFIG", "B_ALARM"); MemoryStatus(); Statement stmt =MemonyConn.createStatement(); ResultSet rs = stmt.executeQuery("select COUNT(*) from B_ALARM"); while (rs.next()) { for (int j = 1; j <= rs.getMetaData().getColumnCount(); j++) { print rs.getString(j) + "/t"; } println "" } MemoryStatus(); output:内存使用了：27.77734375MTue May 12 06:03:08 CST 2009内存使用了：30.7646484375MTue May 12 06:03:15 CST 200913427内存使用了：31.72265625MTue May 12 06:03:15 CST 2009