执行while(rs.next())进不了。语句如下:packagemysql01;importjava.sql.*;publicclassMySqlConnector{//加载java连接mysql驱动publicstaticfinalStringDBDRIVER="com.mysql.jdbc.Dri...
执行while(rs.next())进不了。
语句如下:
package mysql01;
import java.sql.*;public class MySqlConnector { //加载java连接mysql驱动 public static final String DBDRIVER = "com.mysql.jdbc.Driver"; //声明mysql的链接、用户名和密码(密码为空) static String URL ="jdbc:mysql://localhost/hanxg"; static String USER ="root"; static String PASSWORD = "654321"; public static void main(String[] args) { // TODO Auto-generated method stub java.sql.Connection conn = null; //String name ="13400555"; try { Class.forName(DBDRIVER); } catch(ClassNotFoundException e){ e.printStackTrace(); } try{ //建立sql连接 conn = DriverManager.getConnection(URL,USER,PASSWORD); //执行sql语句 Statement stmt = conn.createStatement(); String sql = "select * from name_password"; ResultSet rs = stmt.executeQuery(sql); System.out.println(rs.next()); while(rs.next()){ System.out.println("rs有值"); } rs.close(); stmt.close(); } catch (SQLException e){ e.printStackTrace(); } try{ conn.close(); }catch (SQLException e){ e.printStackTrace(); } }}
执行到 System.out.println(rs.next()); 可以打印出true(即可以执行到表示执行到查询语言都是正常的,而且是有结果的)
但是while(rs.next()){ System.out.println("rs有值"); }
不能执行,请高手指点啊,跪求
展开