| ChangeFlightDates.java |
1 package com.orindasoft.demo.generated.sql;
2
3 import java.sql.*;
4
5 import com.orindasoft.pub.LogInterface;
6 import com.orindasoft.pub.OracleResourceUser;
7 import com.orindasoft.pub.CSException;
8
9 /**
10 * ChangeFlightDates.sql
11 *
12 * <p>Generated by JDBCWizard./a> build 2776 at 2011/03/07 19:55:47.693 GMT
13 * <p>JDBCWizard./a> is made by Orinda Software Ltd, Dublin, Ireland
14 * <p>Target Database: Oracle 10.2.0
15 * <p> -------------------------------------------------------------------------
16 * <p> WARNING: This code will stop working around the time JDBCWizard./a> expires.
17 * <p> This restriction only exists in the demo version of JDBCWizard./a>.
18 * <p> -------------------------------------------------------------------------
19 * <p> JDBCWizard./a> Tips 16 of 19:
20 * <p> JDBCWizard./a>'s com.orindasoft.pub library contains functionality
21 * <p> common to generated code, such as parameter binding and logging.
22 * <p> If you buy the full version of JDBCWizard./a> you get the source code
23 * <p> to com.orindasoft.pub as well as the ability to generate all the access
24 * <p> code you want.
25 * <p> -------------------------------------------------------------------------
26 *
27 * <p>Copyright Orinda Software 2003-2009
28 * <p>File Name ChangeFlightDates.sql
29 * <p>This class runs the SQL statement below:
30 * <code><pre>
31 * -------------------------------------------------------------
32 * TRUNCATE TABLE BOOKINGS
33 * -------------------------------------------------------------
34 * </pre></code>
35 * @author devteam60@orindabuild.com
36 * @version 1.1
37 */
38 public class ChangeFlightDates extends AbstractSqlStatement implements OracleResourceUser
39 {
40
41 /**
42 * Sql statement text
43 */
44 private static final String SQLTEXT = "TRUNCATE TABLE BOOKINGS"; // 1 0 characters
45
46 /**
47 * Constructor that calls the Constructor of AbstractSqlStatement
48 * @param Connection theConnection a database connection
49 * @param LogInterface theLog a logging object
50 *
51 */
52 public ChangeFlightDates (Connection theConnection, LogInterface theLog)
53 {
54 super(theConnection, theLog);
55 theLog.debug("ChangeFlightDates started"); //DEBUG
56 }
57
58
59
60
61 /**
62 * Associate parameters with statement
63 */
64 protected void bindParams() throws CSException
65 {
66 theLog.debug("ChangeFlightDates - Binding Parameters"); //DEBUG
67 theLog.debug("Starting to bind parameters");
68 theLog.debug("Associating parameters with statement");
69 theParameters.bindParameters(theStatement);
70 theLog.debug("Finished binding parameters");
71 }
72
73
74 /**
75 * Return the SQL statement.
76 *
77 *
78 */
79 public String getProcCallStatement()
80 {
81 return (SQLTEXT);
82 }
83
84 } // Generated by JDBCWizard./a> 6.0.2776
85