81,092
社区成员
发帖
与我相关
我的任务
分享
public static ArrayList<Map> executeQuery(String sql,String[] parameters){
ArrayList<Map> al=new ArrayList<Map>();
Map<String,String> myResult=new HashMap<String,String>();
try {
ResultSetMetaData rsmd = null;
ps=getConnection().prepareStatement(sql);
if(parameters !=null && !parameters.equals("")){
for(int i=0;i<parameters.length;i++){
ps.setString(i+1,parameters[i]);
}
}//if
rs=ps.executeQuery();
while(rs.next()){
rsmd = rs.getMetaData();
int count = rsmd.getColumnCount();
String[] colName = new String[count];
for (int i = 0; i < count; i++){
colName[i] = rsmd.getColumnLabel(i + 1);
myResult.put(rsmd.getColumnLabel(i + 1),(String) rs.getString(colName[i]));
}
al.add(myResult);
}//while
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
close(rs,ps,ct);
}
return al;
}