executeQuery

package org.west.demo4;

import java.sql.*;

public class Test {
    public static void main(String[] args) {
        Connection connection=null;
        PreparedStatement ps=null;
        ResultSet resultSet=null;
        try {
            //加载类驱动
            Class.forName("com.mysql.jdbc.Driver");
            //建立连接
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbcstudy", "root", "123456");

            String sql="select id,Sname,pwd from t_user where id>?";
            //通过connection 获取prepareStatement对象对sql语句进行预编译 防止sql注入
            ps = connection.prepareStatement(sql);
            //paramenterindex:1  表示第一个占位符所需要输入的数值
            ps.setString(1,"2");
            //executeQuery()执行查找元素返回的结果集
            resultSet = ps.executeQuery();
            while(resultSet.next()){
                //columnindex 表示的是数据库的第一列的需要查询的那个列的属性的信息  比如 id
                System.out.println(resultSet.getString(1));
                //Sname
                System.out.println(resultSet.getString(2));
                //pwd
               System.out.println(resultSet.getString(3));
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }finally{
            if(connection!=null){
                try {
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(ps!=null){
                try {
                    ps.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(resultSet!=null){
                try {
                    resultSet.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

        }
    }
}