ResultSet结果集

package org.west.demo3;

import java.sql.*;

public class MyTest {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbcstudy", "root", "123456");

        String sql="select * from t_user where id>?";
        PreparedStatement ps = connection.prepareStatement(sql);
        ps.setString(1,"2");
        ResultSet rs= ps.executeQuery();
        while(rs.next()){
            System.out.println(rs.getInt(1)+"---"+rs.getString(2)+"-------"+rs.getString(3));
        }
    }
}

resultset.getString()

返回所对应的字段  比如你的表中字段为id,name,password
rs.getString(1)就是返回id列的值
rs.getString(2)就是返回name列的值
或者也可以写成rs.getString("id");
rs.getString("name");