WebSphere Studio Application Developer part 31 provides integrated development tools for all e-business development roles, including Web developers, Java developers, business analysts, architects, and enterprise programmers. The customizable, targeted, role-based approach of WebSphere Studio Application Developer will be characteristic of all new products built on the WebSphere Studio Workbench. It is well integrated with WebSphere Application Server and provides built-in server test environments that can be used for testing and profiling Web applications | Click Next and you are taken to the next page in the wizard. Here you specify the settings and the SQL statement. Click Change to update the SQL statement. In the SQL Statement window Figure 9-3 you have several options for entering an SQL statement We recommended that you use the SQL Statement Wizard by clicking SQL Assist see Using the SQL Statement Wizard on page 165 . You can enter the statement manually by typing the statement SELECT CUSTOMERID TITLE FIRSTNAME LASTNAME USERID PASSWORD FROM WHERE customerID This statement gets all fields from the customer table given a customer ID. We use one SQL statement you can click Add to enter multiple statements . Click OK when done. New Java Stored Procedure Definition Specify the settings to define the stored procedure. You can insert specific code fragments into the generated code. Statement Generate one SQL statement SELECT CUSTOMERID TITLE FIRSTNAME LASTNAME USERID PASSWORD Result set Header fragment Imports fragment Data fragment Method fragment Change. Figure 9-3 Specifying the SQL statement for the stored procedure 274 WebSphere Studio Application Developer Version 5 Programming Guide Back in the wizard the new SQL statement is shown in the statement text box. In the remainder of this page of the wizard you can add code fragments that you wish to include in the generated stored procedure. Click Next to go to the next page of the wizard where you specify parameters for the stored procedure Figure 9-4 If you used SQL Assist to create the SQL statement the parameter is already filled in. If you typed the SQL statement you have to create the parameter manually by clicking Add and specifying In as mode customerlD as name and INTEGER as SQL type . Figure 9-4 Specify parameters for the stored procedure Click Next to continue to the next page Figure 9-5 Enter as the Java package for the stored procedure. We leave the default values in the other fields. The Jar ID .
