Create Procedure sp_shop_base (@shop_id int, @ msg char (50) output) AsSELECT shop_name, shop_phone, shop_email, shop_cash, shop_addressFROM shop_shopWHERE shop_id = @shop_idSELECT @msg = 'Retrieval Finished'return 1
Program: <% @ page contenttype = "text / html; charset = GB2312"%>
JSP storage procedure - JavaBean - JDBC-ODBC - SQL Server title> Head> <% @ page language = "java" import = "java.sql. *"%>
<% ResultSet RS = Bka.executeQuery ("{Call sp_shop_base ('2', '')}"); while (rs.next ()) {out.println (rs.getstring (1)); Out.println (RS. GetString (2)); out.println (rs.getstring (3)); out.println (rs.getstring (4)); out.println (rs.getstring (5));}}}}}}}}}}}} @close ();% >