st = conn.createStatement();
rs = st.executeQuery(sqlString);
ResultSetMetaData meta=rs.getMetaData();
tdlength = meta.getColumnCount();//取得查询结果的列数
//遍历列数,判断各列类型然后取值
for(int j=1;j<=tdlength;j++){
int type = meta.getColumnType(j);
//System.out.println(Types.DATE+"==="+type);
if(Types.VARCHAR==type){
res.put("tr"+i+"td"+j, rs.getString(j));
}else if(Types.DATE==type){
if("00:00:00".equals(rs.getTime(j).toString())){
res.put("tr"+i+"td"+j, MESFormat.dateFormat(rs.getDate(j)));
}else {
res.put("tr"+i+"td"+j, MESFormat.dateTosFormat(rs.getTimestamp(j)));
}
}else if(Types.INTEGER==type){
res.put("tr"+i+"td"+j, rs.getInt(j));
}else if(Types.CHAR==type){
res.put("tr"+i+"td"+j, rs.getString(j));
}else if(Types.DOUBLE==type){
res.put("tr"+i+"td"+j, rs.getDouble(j));
}else if(Types.BOOLEAN==type){
res.put("tr"+i+"td"+j, rs.getBoolean(j));
}else if(Types.FLOAT==type){
res.put("tr"+i+"td"+j, rs.getFloat(j));
}else if(Types.NCHAR==type){
res.put("tr"+i+"td"+j, rs.getString(j));
}else if(Types.TIMESTAMP==type){
res.put("tr"+i+"td"+j, MESFormat.dateTosFormat(rs.getTimestamp(j)));
}else if(Types.NUMERIC==type){
res.put("tr"+i+"td"+j, rs.getBigDecimal(j));
}else if(Types.NULL==type){
res.put("tr"+i+"td"+j, "");
}else if(Types.OTHER==type){
res.put("tr"+i+"td"+j, "-");
}
}