一个有趣的内存数据库

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.77734375M Tue May 12 06:03:08 CST 2009 内存使用了：30.7646484375M Tue May 12 06:03:15 CST 2009 13427 内存使用了：31.72265625M Tue May 12 06:03:15 CST 2009