import com.common.ConnectionFactory;
public class WebCommon {
public List getTbData(String tbname) {
ResultSet rs = null;
List rsall = new ArrayList();
HashMap rsTree;
try {
Connection conn = ConnectionFactory.getConnection();
Statement stm = conn.createStatement();
// stm = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
// ResultSet.CONCUR_READ_ONLY);
String sql = "select * from " + tbname;
rs = stm.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();// 取数据库的列名 我觉得名比1,2,3..更好用
int numberOfColumns = rsmd.getColumnCount();
while (rs.next()) {
rsTree = new HashMap(numberOfColumns);// 注意要new
for (int r = 1; r < numberOfColumns + 1; r++) {
rsTree.put(rsmd.getColumnName(r), rs.getObject(r));
}
rsall.add(rsTree);
}
} catch (Exception e) {
e.printStackTrace();
}
return rsall;
}
}
以上代码部署成webservice以后就遇到以下问题
[WARN] Unable to locate a BeanInfo cache for class java.util.HashMap (stopClass=class java.util.AbstractMap). This will negatively affect performance!