如何在ResultSet中按某个字段进行排序?
从sql server数据表con_forecast中读取InnerCode,con_date,AdjustingFactor列;然后读取KeyMap.csv(包含InnerCode和JTID两列),根据con_forecast中InnerCode值,找到KeyMap文件中对应的JTID值;最后将con_date,AdjustingFactor和JTID一起写入到forecast.csv(关键是要求按JTID进行排序)。现在已生成forecast.csv,各位大牛帮忙看下如何在forecast.csv中实现按JTID的排序?
con_forecast ( InnerCode int, con_date varchar(8), AdjustingFactor int)
InnerCode con_date AdjustingFactor
28 20110831 3
31 20110831 5
keyMap.csv:
InnerCode JTID
31 CN0001
28 CN0002
forecast.csv:
JTID con_date AdjustingFactor
CN0001 20110831 5
CN0002 20110831 3