统计计数输出的问题

Question

ResultSet rs=stmt.executeQuery("SELECT COUNT(user_id) FROM userphoto WHERE user_id='"+uid+"'"); 
if(rs.next())
  out.println(rs.getInt(1));
或者
ResultSet rs=stmt.executeQuery("SELECT COUNT(user_id) userCount  FROM userphoto WHERE user_id='"+uid+"'"); 
if(rs.next())
   out.println(rs.getInt("userCount"));

Answer 1

SELECT COUNT(user_id) FROM userphoto WHERE user_id='"+uid+"'返回一个值，我该怎么读取这个值呢

Answer 2

还是上面的方法呀
int usersCount=0;
ResultSet rs=stmt.executeQuery("SELECT COUNT(user_id) FROM userphoto WHERE user_id='"+uid+"'"); 
if(rs.next())
  usersCount=rs.getInt(1);//根据column的编号读取或
int usersCount=0;
ResultSet rs=stmt.executeQuery("SELECT COUNT(user_id) usersCount  FROM userphoto WHERE user_id='"+uid+"'"); 
if(rs.next())
   usersCount=rs.getInt("usersCount");//根据别名读出