CREATE DEFINER = 'root'@'localhost'
PROCEDURE test.page1_xxx001_add(IN par varchar(255))
  DETERMINISTIC
BEGIN
  INSERT INTO test.goods (Name)
    VALUES (par);
  SELECT
    LAST_INSERT_ID() AS id;
END

  try (Connection con = dataSource.getConnection(); CallableStatement proc = con.prepareCall("{call page1_xxx001_add('" + par[1] + "')}");) {
            rs = proc.executeQuery();
            rs.next();

            userSession.getBasicRemote().sendText(par[0] + "|" + rs.getString("id"));
        } catch (SQLException | IOException ex) {
            ex.printStackTrace();
        }