如何动态获取字段？

Question

for (int i = 0; i < 30; i++) {
StringBuffer hql =new StringBuffer("");
hql.append("select ");
hql.append(sql1+" from (");
hql.append("select t."+sql1);
hql.append(",rownum as rm from ");
hql.append(sql2+" t)");
hql.append("where rm between "+((i)*50000+1)+" and "+((i+1)*50000));

        System.out.println(hql);
    System.out.println("等待中...");
    PreparedStatement ps = myConnect.prepareStatement(hql.toString());
    //多个参数
//  if (params != null) {
//      for (int i = 0; i < params.length; i++) {
//          ps.setString(i + 1, params[i]);
//      }
//  }

    ResultSet rs = ps.executeQuery();   
    StringBuffer  buffer = new StringBuffer();
    while (rs.next()) {
        buffer.append(rs.getString("DPTNO")+" ");
        buffer.append(rs.getString("OPTNO")+" ");
        buffer.append(rs.getString("CURR")+f+(h.equals("Y")?"\r\n":""));

    }

        System.out.println(buffer.toString());

while 里的字段是定死，我想动态的使用。。查询时，想要哪个字段就查哪个。

Answer 1

ResultSetMetaData rsmd = rs.getMetaData()
int columnCount = rsmd.getColumnCount();

while(rs.next) {
for(int i=1; i<=columnCount; i++) {
buffer.append(rs.getString(i));
}
}