2024年2月19日发(作者：)

return queryList(sql,RESULT_R, new Object[0]);}/*** 返回 Integer 类型的集合* @param sql* @param paras* @return*/public static List queryIntList(String paras) {return queryList(sql,RESULT_R, paras);}/*** 返回 Double 类型的集合* @param sql* @return*/public static List queryDoubleList(String sql) {return queryList(sql,RESULT_, new Object[0]);}/*** 返回 Double 类型的集合* @param sql* @return*/public static List queryDoubleList(String paras) {return queryList(sql,RESULT_, paras);}/*** 返回 Long 类型的集合* @param sql* @return*/public static List queryLongList(String sql) {return queryList(sql,RESULT_, new Object[0]);

}/*** 返回 Long 类型的集合* @param sql* @return*/public static List queryLongList(String paras) {return queryList(sql,RESULT_, paras);}/**** 返回 @param resType 类型的集合* @param sql* @param resType* @param paras* @return List*/public static List queryList(String sql, String paras) {List result = new ArrayList();Config config = fig();PreparedStatement pst = null;ResultSet rs = null;Connection conn=null;try {conn = nection();pst = eStatement(sql);lect().fillStatement(pst, paras);rs = eQuery();int colAmount = aData().getColumnCount();if (colAmount > 1) {while (()) {Object[] temp = new Object[colAmount];for (int i = 0; i

temp[i] = ect(i + 1);}

addObjValue(result, resType, ng());}} else if (colAmount == 1) {while (()) {addObjValue(result, resType, ect(1).toString());}}} catch (SQLException e) {tackTrace();} finally {try {if (rs != null) ();if (pst != null) ();if (conn != null) (conn);} catch (SQLException e) {tackTrace();}}return result;}public static void addObjValue(List result,String resType,String value) {switch (resType) {case RESULT_R:(f(value));break;case RESULT_:(f(value));break;case RESULT_:(f(value));break;}}}