如何根据sql查询的结果集ResultSet获取sql中某列对应的子结果集?
已执行如下sql(包含列InnerCode,ExDiviDate,AdjustingFactor,AdjustingConst,RatioAdjustingFactor)获取ResultSet,如何根据这个结果集获取其中某列(例如“ExDiviDate”)对应的子结果集,各位大牛帮忙看下:
sqlTable = "select InnerCode,ExDiviDate,AdjustingFactor,AdjustingConst,RatioAdjustingFactor from con_forecast" Statement state = conn1.createStatement(); //如连接成功返回STATEMENT对象 Statement stateTable = conn1.createStatement();//如连接成功返回STATEMENT对象 ResultSet set = state.executeQuery(sqlTable);