java JDBC连接MySQL数据库调用存储过程进行查询

主程序代码

package Mysql;

import util.JDBCUtils;
import java.sql.*;
import java.util.Scanner;

public class SaveProcess {
   
    public static void main(String[] args) {
   
        Scanner sc = new Scanner(System.in);
        System.out.println("请输入需要查询的名字，或姓名当中的一个字。");
        String nm = sc.next();
        search(nm);
    }
    public static void search(String name) {
   
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;

        //1.获取连接对象
        try {
   
            //1.获取连接对象
            conn = JDBCUtils.getConnection();
            //2.定义sql语句
            String sql ="CALL reader_namelist(?)";
            //3.获取执行sql的对象
            pstmt =  conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            //4.准备参数
            pstmt.setString(1,name);
            //5.执行查询操作
            rs = pstmt.executeQuery();


            //处理结果集
            if(rs.next()){