我的代码:
String sql = "select " + field + " from " + key;
Statement st = null;
ResultSet rs = null;
CachedRowSet crs;
ResultSetMetaData rsmd;
String[] fieldArray;
try {
st = conn.createStatement();
rs = st.executeQuery(sql); crs = new CachedRowSetImpl();
rsmd = rs.getMetaData();
crs.populate(rs);
我想计算RS 里面某一列数据的和 ,平均值 等!
String sql = "select " + field + " from " + key;
Statement st = null;
ResultSet rs = null;
CachedRowSet crs;
ResultSetMetaData rsmd;
String[] fieldArray;
try {
st = conn.createStatement();
rs = st.executeQuery(sql); crs = new CachedRowSetImpl();
rsmd = rs.getMetaData();
crs.populate(rs);
我想计算RS 里面某一列数据的和 ,平均值 等!
但是你可以在sql语句中写啊,然后再执行
要不最笨的方法就是for循环列值一个一个加再平均
select count(要计算和的字段名) as sum,avg(要计算平均值的字段名) as pj from table