62,614
社区成员
发帖
与我相关
我的任务
分享
public Collection executeQuery1(String sql) {
BaseDao bd = new BaseDao();
Collection coll = new ArrayList();
System.out.println(sql);
try {
ResultSet rs = bd.executeQuery(sql);
int count = rs.getMetaData().getColumnCount();
System.out.println(count);
String[] fields = new String[count];
for (int i = 0; i < count; i++) {
fields[i] = (String) rs.getMetaData().getColumnName(i + 1);
System.out.println(fields[i]);
}
for (int i = 0; i < count; i++) {
HashMap hash = new HashMap();
for (int ii = 0; ii < count; ii++) {
Object value = null;
if ("DATETIME".equals(rs.getMetaData().getColumnTypeName(ii +
1).toString())) {
value = Tools.toShortTimeString(rs.getString(
fields[ii]));
}
else if("INTEGER".equals(rs.getMetaData().getColumnTypeName(ii +
1).toString())){
value=Integer.parseInt(rs.getString(rs.getInt(fields[ii])));
}
else if("BIT".equals(rs.getMetaData().getColumnTypeName(ii+1).toString())){
value=Boolean.parseBoolean(rs.getString(fields[ii]));
}
else if("CURRENCY".equals(rs.getMetaData().getColumnTypeName(ii+1).toString())){
value=Double.parseDouble(rs.getString(fields[ii]));
}
else {
value = rs.getString(fields[ii]);
}
hash.put(fields[ii], value);
}
coll.add(hash);
System.out.println(i);
if (!rs.next()) {
break;
}
}
} catch (Exception ex) {
System.out.println(ex.toString() + "BaseDb");
} finally {
bd.close();
}
return coll;
}