62,614
社区成员
发帖
与我相关
我的任务
分享
/**
* 通过sql语句查询数据
* @param sql
* @return [description]
*/
public List<Map<String,String>> query(String sql){
List<Map<String,String>> lists=new ArrayList<Map<String,String>>();
try {
conn = DriverManager.getConnection(url, user, password);
statement = conn.createStatement();
ResultSet rs = statement.executeQuery(sql);
lists=this.ResultSetToList(rs);
rs.close();
conn.close();
return lists;
} catch(Exception e) {
e.printStackTrace();
}
return lists;
}
/**
* 把结果转化成list返回
* @param rs
* @return [description]
*/
public static List<Map<String,String>> ResultSetToList(ResultSet rs) {
try {
ResultSetMetaData md = rs.getMetaData(); // 获得结果集结构信息(字段数、字段名等)
int columnCount = md.getColumnCount();
List<Map<String,String>> list = new ArrayList<Map<String,String>>();
while (rs.next()) {
Map<String, String> rowData = new HashMap<String, String>();
for (int i = 1; i <= columnCount; i++) {
rowData.put(md.getColumnName(i), rs.getString(i));
}
list.add(rowData);
}
return list;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}