Macromedia Dreamweaver UltraDev - Creating pages that use stored procedures: Creating a JSP page that uses a stored procedure

Home > Products > UltraDev > Support > Defining Dynamic Content

Creating a JSP page that uses a stored procedure

This section describes how to use UltraDev to create a JSP page that calls a stored procedure in your database. Before you begin, make sure your database contains a stored procedure. To create and store one in your database, consult your database documentation and a good Transact-SQL manual.

To create a JSP page that calls a stored procedure:

1	In UltraDev, open the page that will run the stored procedure.
2	Open the Server Behaviors panel (Window > Server Behaviors), click the plus (+) button, and choose Callable (Stored Procedure).
	The Callable (Stored Procedure) dialog box appears.

3	Enter a name for the stored procedure and choose a connection to the database containing the stored procedure.
4	If the stored procedure returns a recordset, select the Return Recordset option and enter a name for the recordset.
5	In the Database Items box, expand the Stored Procedures branch, select the stored procedure from the list, and click the Procedure button.
	UltraDev automatically fills in the Callable Text and Variables boxes.
6	If the stored procedure returns a recordset, test it if you want by entering a value in the Default Value column in the Variables box and clicking Test to test it.
	UltraDev runs the stored procedure and displays the recordset, if any.

After you close the Callable (Stored Procedure) dialog box, UltraDev inserts JSP code in your page that, when run on the server, calls a stored procedure in the database. The stored procedure in turn performs a database operation, such as generating a recordset or inserting a record.

If the stored procedure generates a recordset, the procedure will appear in UltraDev in both the Server Behaviors panel and the Data Bindings panel (Window > Data Bindings). Use the Data Bindings panel to display the recordset's content on your page by selecting a recordset column in the panel and dragging it to the page. UltraDev inserts code in the page that, when run on the server, displays the content of the column of one record.

If the stored procedure takes parameters, you might create a page that gathers the parameter values and submits them to the page with the stored procedure. For example, you may create a page that uses URL parameters or an HTML form to gather parameter values from users.