/**
* 根据SQL查询返回一个List对象 <br>
* @param Sql <br>
* @return <br>
*/
public static List getListBySQL(String Sql){
ResultSet rs = null;
PreparedStatement ps = null;
Connection conn = null;
List<Map> list = new ArrayList<Map>();
try {
conn = DBConnectionFactory.getInstance().getConnection();// 获得数据库连接
ps = conn.prepareStatement(Sql);
rs = ps.executeQuery();
if (rs == null) return Collections.EMPTY_LIST;
ResultSetMetaData rsmd = rs.getMetaData(); // 得到结果集(rs)的结构信息,比如字段数、字段名等
int columnCount = rsmd.getColumnCount(); // 返回此 ResultSet 对象中的列数
while (rs.next()){
Map<String, Object> rowData = new HashMap<String, Object>();
for (int i = 1; i <= columnCount; i++) {
rowData.put(rsmd.getColum
* 根据SQL查询返回一个List对象 <br>
* @param Sql <br>
* @return <br>
*/
public static List getListBySQL(String Sql){
ResultSet rs = null;
PreparedStatement ps = null;
Connection conn = null;
List<Map> list = new ArrayList<Map>();
try {
conn = DBConnectionFactory.getInstance().getConnection();// 获得数据库连接
ps = conn.prepareStatement(Sql);
rs = ps.executeQuery();
if (rs == null) return Collections.EMPTY_LIST;
ResultSetMetaData rsmd = rs.getMetaData(); // 得到结果集(rs)的结构信息,比如字段数、字段名等
int columnCount = rsmd.getColumnCount(); // 返回此 ResultSet 对象中的列数
while (rs.next()){
Map<String, Object> rowData = new HashMap<String, Object>();
for (int i = 1; i <= columnCount; i++) {
rowData.put(rsmd.getColum