public List<T> get(WhereUtil wUtil, String orderby) throws Exception { Connection conn = null; ResultSet rSet = null; List<T> t = null; try { conn = DBManager.getConnection(); String sql = String.format("select * from %s %s", getTableName(), wUtil.getWhere()); if (orderby != null) { sql = String.format("%s %s", sql, orderby); } rSet = execSql(sql, conn, wUtil.getParams()); if (null == rSet) { return null; } else { @SuppressWarnings("unchecked") ResultSetToObject<T> rObject = new ResultSetToObject<T>(); t = rObject.mapRersultSetToList(rSet); return t; } } catch (Exception e) { // TODO: handle exception } finally { DBManager.freeConnection(conn); } return t; }
public List<T> get(String sql, Object... params) { Connection conn = null; ResultSet rSet = null; List<T> t = null; try { conn = DBManager.getConnection(); rSet = execSql(sql, conn, params); if (null == rSet) { return null; } else { @SuppressWarnings("unchecked") ResultSetToObject<T> rObject = new ResultSetToObject<T>(); t = rObject.mapRersultSetToList(rSet); return t; } } catch (Exception e) { // TODO: handle exception } finally { DBManager.freeConnection(conn); } return t; }
public T get(int id) throws SQLException { Connection connection = null; ResultSet rSet = null; T t = null; try { connection = DBManager.getConnection(); String sql = String.format("Select * from %s where %s=?", getTableName(), getTablePK()); rSet = execSql(sql, connection, id); if (null == rSet) { return null; } else { @SuppressWarnings("unchecked") ResultSetToObject<T> rObject = new ResultSetToObject<T>(); t = rObject.RersultSetToObject(rSet, getTClass()); return t; } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { DBManager.freeConnection(connection); } return t; }
/** ********************** 本类使用私有方法 ****************************** */ private List<T> convert(ResultSet rSet) throws SQLException { ResultSetToObject<T> rObject = new ResultSetToObject<T>(); List<T> result = rObject.mapRersultSetToList(rSet); return result; }