jsp连接mysql遇到问题，请大家多多帮忙！

Question

out.println(rs.getString(1))
-----
有没有 先 rs.next();?

Answer 1

try { 
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } 
catch (Exception E) { 
out.println("Unable to load driver."); } try { 
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=8859_1"); 
Statement s=C.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
ResultSet rs=s.executeQuery("select price from shop"); 
String str=rs.getString(0);
out.println(str);
rs.close(); 
s.close(); 
C.close(); 
} 
catch (SQLException E) { 
out.println("SQLException: " + E.getMessage()); 
out.println("SQLState: " + E.getSQLState()); 
out.println("VendorError: " + E.getErrorCode()); 
} 
代码，好像没有rs.next()~~

Answer 2

加上rs.next()就好用了～～
多谢各位！！！