通用查询数据库辅助类，可实现任意查询语句的查询，，还可以进行多结果集查询。
类的代码：
1 package com.hongyuan.db; java.math.BigDecimal; 4 import java.net.URL; 5 import java.sql.Array; 6 import java.sql.Blob; 7 import java.sql.Clob; 8 import java.sql.Connection; 9 import java.sql.Date; 10 import java.sql.PreparedStatement; 11 import java.sql.ResultSet; 12 import java.sql.SQLException; 13 import java.sql.SQLXML; 14 import java.sql.Statement; 15 import java.sql.Time; 16 import java.sql.Timestamp; 17 import java.util.ArrayList; 18 import java.util.List; javax.sql.DataSource; 21 import javax.sql.rowset.CachedRowSet; com.sun.rowset.CachedRowSetImpl; DBUtil { 26private DataSource ds = null; DataSource getDs() { 29return ds; 30 } setDs(DataSource ds) { 33this.ds = ds; 34 } DBUtil() { 37 } DBUtil(DataSource ds) { 40this.ds = ds; 41 }Connection getConnection() throws SQLException { 44return ds.getConnection(); 45 } close(Connection conn, Statement s, ResultSet rs) 48throws SQLException { 49if (rs != null) 50 rs.close(); 51if (s != null) 52 s.close(); 53if (conn != null) 54 conn.close(); 55 }Object query(String sql) throws SQLException {.query(sql, null); 59 }Object query(String sql, List params) throws SQLException { 62Connection conn = null; 63PreparedStatement ps = null; 64ResultSet rs = null; 65try { 66conn = this.getConnection(); 67ps = conn.prepareStatement(sql);(null != params) {.initParam(ps, params); 72 }isResultSet = ps.execute(); 75List result = new ArrayList(); 76do { 77if (isResultSet) { 78CachedRowSet crs = new CachedRowSetImpl(); 79 crs.populate(ps.getResultSet()); 80 result.add(crs); 81} else { 82result.add(new Integer(ps.getUpdateCount())); 83 } 84} while ((isResultSet = ps.getMoreResults()) == true 85|| ps.getUpdateCount() != -1);(result.size() == 0) {; 89} else if (result.size() == 1) { 90return result.get(0); 91} else { 92return result; 93 } 94} catch (SQLException e) {SQLException(“无法执行的sql语句!”); 96} finally { 97 DBUtil.close(conn, ps, rs); 98 } 99 } initParam(PreparedStatement ps, List params)102throws SQLException {103for (int i = 0; i < params.size(); i++) {104Object param = params.get(i);105if (param instanceof Byte) {106ps.setByte(i + 1, (Byte) param);107} else if (param instanceof Short) {108ps.setShort(i + 1, (Short) param);109} else if (param instanceof Integer) {110ps.setInt(i + 1, (Integer) param);111} else if (param instanceof Long) {112ps.setLong(i + 1, (Long) param);113} else if (param instanceof Float) {114ps.setFloat(i + 1, (Float) param);115} else if (param instanceof Double) {116ps.setDouble(i + 1, (double) param);117} else if (param instanceof BigDecimal) {118ps.setBigDecimal(i + 1, (BigDecimal) param);119} else if (param instanceof Boolean) {120ps.setBoolean(i + 1, (Boolean) param);121} else if (param instanceof String) {122ps.setString(i + 1, (String) param);123} else if (param instanceof Time) {124ps.setTime(i + 1, (Time) param);125} else if (param instanceof Date) {126ps.setDate(i + 1, (Date) param);127} else if (param instanceof Timestamp) {128ps.setTimestamp(i + 1, (Timestamp) param);129} else if (param instanceof Array) {130ps.setArray(i + 1, (Array) param);131} else if (param instanceof Blob) {132ps.setBlob(i + 1, (Blob) param);133} else if (param instanceof Clob) {134ps.setClob(i + 1, (Clob) param);135} else if (param instanceof SQLXML) {136ps.setSQLXML(i + 1, (SQLXML) param);137} else if (param instanceof URL) {138 ps.setURL(i, (URL) param);139} else {140ps.setObject(i + 1, param);141 }142 }143 }144 }如此锐气，二十后生有之，六旬男子则更多见。
