JAVA DbUtil 数据库工具类，编写的通用查询减少Dao层代码量

package util;


import java.io.IOException;
import java.io.InputStream;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Properties;


public class DbUtil {
public static Connection getConnection() {
Connection con = null;
try {
InputStream is = DbUtil.class.getClassLoader().getResourceAsStream("db.properties");


Properties p = new Properties();
p.load(is);


Class.forName(p.getProperty("drivername"));
con = DriverManager.getConnection(p.getProperty("url"), p.getProperty("username"),p.getProperty("password"));


} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return con;


}


public static void closeResource(ResultSet rs, Statement st, Connection con) {
try {
if (rs != null) {
rs.close();
}
if (st != null) {
st.close();
}
if (con != null) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}


//3.执行通用查询
public static List<Map<String,String>> genericQuery(String sql,Object[] o){
Connection con = getConnection();
List<Map<String,String>> list = null;
PreparedStatement ps= null;
try {
ps = con.prepareStatement(sql);
if (o != null) {
for (int i = 1; i <= o.length; i++) {
ps.setObject(i, o[i - 1]);
}
}
ResultSet rs=ps.executeQuery();

ResultSetMetaData rsmd = rs.getMetaData();
list = new ArrayList<Map<String,String>>();
while(rs.next()) {
Map<String,String> m = new HashMap<String,String>();
for(int i=1;i<=rsmd.getColumnCount();i++) {
m.put(rsmd.getColumnName(i), rs.getString(i));
}
list.add(m);
}
closeResource(rs, ps, con);

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;

}
public static Map<String,String> genericQuerySingle(String sql,Object[] o){
Connection con = getConnection();
Map<String,String> m = null;
PreparedStatement ps= null;
try {
ps = con.prepareStatement(sql);
if(o!=null) {
for(int i=1;i<=o.length;i++) {
ps.setObject(i, o[i-1]);
}
}
ResultSet rs=ps.executeQuery();

ResultSetMetaData rsmd = rs.getMetaData();
rs.next();
m = new HashMap<String,String>();
for(int i=1;i<=rsmd.getColumnCount();i++) {
m.put(rsmd.getColumnName(i), rs.getString(i));
}
closeResource(rs, ps, con);

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return m;

}

public static <T> List<T> genericQuery(String sql, Object[] o, Class<T> c) {
Connection con = getConnection();
List<T> list = null;
PreparedStatement ps = null;
try {
ps = con.prepareStatement(sql);
if (o != null) {
for (int i = 1; i <= o.length; i++) {
ps.setObject(i, o[i - 1]);
}
}
ResultSet rs = ps.executeQuery();


ResultSetMetaData rsmd = rs.getMetaData();
list = new ArrayList<T>();
while (rs.next()) {
T t = c.newInstance();
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
String columnName = rsmd.getColumnName(i);
Method m = c.getDeclaredMethod(
"set" + columnName.replaceFirst(columnName.substring(0, 1),
columnName.substring(0, 1).toUpperCase()),
c.getDeclaredField(columnName).getType());
m.invoke(t, rs.getObject(i));


}
list.add(t);
}
closeResource(rs, ps, con);


} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (NoSuchMethodException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SecurityException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (NoSuchFieldException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalArgumentException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InvocationTargetException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


return list;
}


public static int genericDML(String sql,Object[] o) {
Connection con = getConnection();
PreparedStatement ps;
int result = 0;
try {
ps=con.prepareStatement(sql);
for(int i=1;i<=o.length;i++) {
ps.setObject(i, o[i-1]);
}
result = ps.executeUpdate();
closeResource(null, ps, con);


} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return result;
}
}