三表查询怎么取属性值？

Question

应该是这样：
ResultSet rs=smt.executeQuery(sql);
    if(rs.next())
    {
      out.print(getStr(rs.getString(0)));
      out.print(rs.getString(1));
      out.print(rs.getString(2));
      out.print(getStr(rs.getString(3)));
      out.print(rs.getString(4));
    }  

Answer 1

to bixuehui(伯克) 我按你的改了。取不出任何值。

Answer 2

这样
    int count=0;
    ResultSet rs=smt.executeQuery(sql);
    count=rs.last();
    
    if(count!=0)
    {
      rs.first();
      out.print(getStr(rs.getString(1)));
      out.print(rs.getString(2));
      out.print(rs.getString(3));
      out.print(getStr(rs.getString(4)));
      out.print(rs.getString(5));
    }

Answer 3

bixuehui(伯克)改的不对，应该是从1开始。out.print(getStr(rs.getString(1)));
           //getStr是干啥的？

Answer 4

谢谢 boyu_song(I'm sorry) 接分。

Answer 5

to trumplet(检查) 
getStr是我一个转换函数。

Answer 6

to junye() 
I'm sorry!
ResultSet rs=smt.executeQuery(sql);
    while(rs.next())
    {
      out.print(getStr(rs.getString(1)));
      out.print(rs.getString(2));
      out.print(rs.getString(3));
      out.print(getStr(rs.getString(4)));
      out.print(rs.getString(5));
    }