String getBase = "jdbc:mysql://localhost:3306/test?characterEncoding=UTF8&useUnicode=true";
        String getBase_login = "root";
        String getBase_password = "1234";
        StringBuilder sbb = new StringBuilder();
        try (Connection con = DriverManager.getConnection(getBase, getBase_login, getBase_password);
                CallableStatement proc = con.prepareCall("{call page1_xxx07('" + sy.toString() + "')}");) {
            rs = proc.executeQuery();
           ................................
        } catch (SQLException ex) {
            Logger.getLogger(SSLServer.class.getName()).log(Level.SEVERE, null, ex);
        }

    public void listbox(String param, String name) {
        String[] st = param.split(" ");
        StringBuilder sy = new StringBuilder();
        for (String sf : st) {
            sy.append(" name like ''%").append(sf).append("%'' and");
        }
        sy.setLength(sy.length() - 4);
        String getBase = "jdbc:mysql://localhost:3306/test?characterEncoding=UTF8&useUnicode=true";
        String getBase_login = "root";
        String getBase_password = "1234";
        StringBuilder sbb = new StringBuilder();
        try (Connection con = DriverManager.getConnection(getBase, getBase_login, getBase_password);
                CallableStatement proc = con.prepareCall("{call page1_xxx07('" + sy.toString() + "')}");) {
            rs = proc.executeQuery();
            sbb.append(name);
            if (rs != null) {
                sbb.append(list_names(rs).toString());
            }
            webSocket_.send(sbb.toString());
        } catch (SQLException ex) {
            Logger.getLogger(SSLServer.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

CREATE DEFINER = 'root'@'localhost'
PROCEDURE test.page1_xxx07(IN `name` varchar(255))
BEGIN
  SET @name = `name`;
  IF (LENGTH(`name`) > 0)
  THEN
    IF `name` = '±'
    THEN
      SELECT
        pass.id,
        pass.name
      FROM pass LIMIT 15;

    ELSE

      SET @sql = 'SELECT SQL_SMALL_RESULT  pass.id, pass.name FROM pass WHERE ';

      SET @sql = CONCAT(@sql, `name`, ' limit 5');
            

      PREPARE SSql FROM @sql;
     
      EXECUTE SSql;
     
      DEALLOCATE PREPARE SSql;
    END IF;

  END IF;
END