一个有趣的内存数据库

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