mysql分页sql
string sql = select * from emp order by empno limit ?,?;
preparestatement stmt = con.preparestatement(sql);
stmt.setint(1, begin);
stmt.setint(2, end);
resultset rs = stmt.executequery();
while (rs.next()) {
system.out.println(rs.getint(empno) + ,
+ rs.getstring(ename) + ,
+ rs.getdouble(sal) + , + rs.getdate(hiredate));}
一直对rs.getxxx()的用法比较模糊，求介绍下用法 返回的结果集rs是不是既可以按列名rs.getxxx(xxx)也可以按rs.getxxx(1)这样读取啊？ 另外上面的代码中输出语句里面我可以不可以写成 while (rs.next()) { system.out.println(rs.getint(1) + , + rs.getstring(2) + , + rs.getdouble(3) + , + rs.getdate(4));}