Setting the Prepared (Insert, Update, Delete) dialog box options The purpose of this dialog box is to create a prepared statement that inserts, updates, or deletes records in a database.
Procedure
Enter a name for the prepared statement, choose a connection to the database
containing the records you want to edit, and choose the editing operation you
want the prepared statement to perform—Insert, Update, or Delete.
starts the SQL statement for you based on the type of operation
you choose. For example, here’s the dialog box after choosing Insert:
Complete the SQL statement.
For information on writing SQL statements that modify databases, consult a Transact-SQL
manual.
Use the Variables area to define any SQL variables.
For example, below is an Insert statement that contains three SQL variables.
The values of these variables are provided by URL parameters passed to the page,
as defined in the Run-time Value column of the Variables area.
After you close the dialog box, inserts JSP code in your page that, when run on the server, creates a prepared statement that inserts, updates, or deletes records in the database.
In the above example, next you would probably create a page with an HTML form so users could enter record data. The HTML form would contain three text fields (txtFirstName, txtLastName, and txtDept) and a submit button. As well, the form would use the GET method and submit the text field values to the page containing your prepared statement.
1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 422