| DAOFactoryServiceInterface.java |
1 package com.orindasoft.demo.generated;
2
3
4 import com.orindasoft.pub.CSException;
5 import com.orindasoft.pub.CSDBException;
6 import com.orindasoft.pub.SqlUtils;
7 import com.orindasoft.pub.OracleResourceUser;
8 import com.orindasoft.demo.generated.plsql.*;
9 // JSR-181 Support is enabled if your target JVM is 1.6 or higher...
10 import javax.jws.*;
11 // If you need to change the behaviour of @WebService use the 'Extra Java' field of
12 // 'Extra Options' tab - any @WebService specified there will replace the one below
13 @WebService
14 /**
15 * WSDL Compatible Web Services Interface used by classes generated by JDBCWizard./a>
16 *
17 * <p>Generated by JDBCWizard./a> build 2776 at 2011/03/07 19:55:48.327 GMT
18 * <p>JDBCWizard./a> is made by Orinda Software Ltd, Dublin, Ireland
19 * <p>Target Database: Oracle 10.2.0
20 * <p> -------------------------------------------------------------------------
21 * <p> WARNING: This code will stop working around the time JDBCWizard./a> expires.
22 * <p> This restriction only exists in the demo version of JDBCWizard./a>.
23 * <p> -------------------------------------------------------------------------
24 * <p> JDBCWizard./a> Tips 16 of 19:
25 * <p> JDBCWizard./a>'s com.orindasoft.pub library contains functionality
26 * <p> common to generated code, such as parameter binding and logging.
27 * <p> If you buy the full version of JDBCWizard./a> you get the source code
28 * <p> to com.orindasoft.pub as well as the ability to generate all the access
29 * <p> code you want.
30 * <p> -------------------------------------------------------------------------
31 *
32 * <p>Copyright Orinda Software 2003-2009
33 * @author devteam60@orindabuild.com
34 * @version 1.1
35 */
36 public interface DAOFactoryServiceInterface
37 {
38 /**
39 * SequentialNumberGenerator - Access Sequence SEQUENTIAL_NUMBER_GENERATOR
40 */
41 public long serviceSequenceSequentialNumberGenerator() throws DAOFactoryServiceException;
42
43 /**
44 * Call Class CursorExampleDirectFlightAvailable as a service
45 * @param String paramPFromcity VARCHAR2
46 * @param String paramPTocity VARCHAR2
47 * @return boolean
48 * @throws DAOFactoryServiceException
49 */
50 // JSR-181 support - make this method part of a web service
51 @WebMethod
52 public boolean servicePlsqlCursorExampleDirectFlightAvailable
53 (@WebParam(name="paramPFromcity") String paramPFromcity
54 ,@WebParam(name="paramPTocity") String paramPTocity) throws DAOFactoryServiceException;
55 /**
56 * Call Class CursorExampleFindDirectFlights as a service
57 * @param String paramPFromcity VARCHAR2
58 * @param String paramPTocity VARCHAR2
59 * @param double paramPOrderby NUMBER
60 * @return com.orindasoft.demo.generated.plsql.CursorExampleFlightsRefcursorTypeAttrs[]
61 * @throws DAOFactoryServiceException
62 */
63 // JSR-181 support - make this method part of a web service
64 @WebMethod
65 public com.orindasoft.demo.generated.plsql.CursorExampleFlightsRefcursorTypeAttrs[] servicePlsqlCursorExampleFindDirectFlights
66 (@WebParam(name="paramPFromcity") String paramPFromcity
67 ,@WebParam(name="paramPTocity") String paramPTocity
68 ,@WebParam(name="paramPOrderby") double paramPOrderby) throws DAOFactoryServiceException;
69 /**
70 * Call Class CursorExampleGetlists as a service
71 * @return com.orindasoft.demo.generated.plsql.CursorExampleGetlistsReturn
72 * @throws DAOFactoryServiceException
73 */
74 // JSR-181 support - make this method part of a web service
75 @WebMethod
76 public com.orindasoft.demo.generated.plsql.CursorExampleGetlistsReturn servicePlsqlCursorExampleGetlists() throws DAOFactoryServiceException;
77 /**
78 * Call Class ObjectArrayExampleAddBookingsObjectArray as a service
79 * @param CustomersAttrs paramPCustomer PL/SQL RECORD
80 * @param BookingsTypeAttrs[] paramPBookingTable TABLE
81 * @return String
82 * @throws DAOFactoryServiceException
83 */
84 // JSR-181 support - make this method part of a web service
85 @WebMethod
86 public String servicePlsqlObjectArrayExampleAddBookingsObjectArray
87 (@WebParam(name="paramPCustomer") CustomersAttrs paramPCustomer
88 ,@WebParam(name="paramPBookingTable") BookingsTypeAttrs[] paramPBookingTable) throws DAOFactoryServiceException;
89 /**
90 * Call Class ObjectArrayExampleGetObjectArrayOfFlights as a service
91 * @param String paramPCity VARCHAR2
92 * @return FlightsTypeAttrs[]
93 * @throws DAOFactoryServiceException
94 */
95 // JSR-181 support - make this method part of a web service
96 @WebMethod
97 public FlightsTypeAttrs[] servicePlsqlObjectArrayExampleGetObjectArrayOfFlights
98 (@WebParam(name="paramPCity") String paramPCity) throws DAOFactoryServiceException;
99 /**
100* Call Class PackageArrayExampleAddBookingsPlsqlArray as a service
101* @param CustomersAttrs paramPCustomer PL/SQL RECORD
102* @param BookingsAttrs[] paramPBookingTable VARRAY
103* @return String
104* @throws DAOFactoryServiceException
105*/
106// JSR-181 support - make this method part of a web service
107@WebMethod
108public String servicePlsqlPackageArrayExampleAddBookingsPlsqlArray
109 (@WebParam(name="paramPCustomer") CustomersAttrs paramPCustomer
110 ,@WebParam(name="paramPBookingTable") BookingsAttrs[] paramPBookingTable) throws DAOFactoryServiceException;
111/**
112* Call Class PackageArrayExampleGetPlsqlArrayOfFlights as a service
113* @param String paramPCity VARCHAR2
114* @return FlightsAttrs[]
115* @throws DAOFactoryServiceException
116*/
117// JSR-181 support - make this method part of a web service
118@WebMethod
119public FlightsAttrs[] servicePlsqlPackageArrayExampleGetPlsqlArrayOfFlights
120 (@WebParam(name="paramPCity") String paramPCity) throws DAOFactoryServiceException;
121/**
122* Call Class PackageIdxarrayExampleAddBookingsPlsqlArray as a service
123* @param CustomersAttrs paramPCustomer PL/SQL RECORD
124* @param BookingsAttrs[] paramPBookingTable PL/SQL TABLE
125* @return String
126* @throws DAOFactoryServiceException
127*/
128// JSR-181 support - make this method part of a web service
129@WebMethod
130public String servicePlsqlPackageIdxarrayExampleAddBookingsPlsqlArray
131 (@WebParam(name="paramPCustomer") CustomersAttrs paramPCustomer
132 ,@WebParam(name="paramPBookingTable") BookingsAttrs[] paramPBookingTable) throws DAOFactoryServiceException;
133/**
134* Call Class PackageIdxarrayExampleGetPlsqlArrayOfFlights as a service
135* @param String paramPCity VARCHAR2
136* @return FlightsAttrs[]
137* @throws DAOFactoryServiceException
138*/
139// JSR-181 support - make this method part of a web service
140@WebMethod
141public FlightsAttrs[] servicePlsqlPackageIdxarrayExampleGetPlsqlArrayOfFlights
142 (@WebParam(name="paramPCity") String paramPCity) throws DAOFactoryServiceException;
143/**
144* Call Class ChangeFlightDates as a service
145* @return void
146* @throws DAOFactoryServiceException
147*/
148// JSR-181 support - make this method part of a web service
149@WebMethod
150public void serviceSqlChangeFlightDates() throws DAOFactoryServiceException;
151/**
152* Call Class CustcomerAdd as a service
153* @param String Paramname STRING
154* @param String Paramaddress STRING
155* @param String Paramcity STRING
156* @param String Paramstate STRING
157* @param double Paramzip NUMBER
158* @param java.util.Date Parambdate DATE
159* @param String Paramphone STRING
160* @return void
161* @throws DAOFactoryServiceException
162*/
163// JSR-181 support - make this method part of a web service
164@WebMethod
165public void serviceSqlCustcomerAdd
166 (@WebParam(name="Paramname") String Paramname
167 ,@WebParam(name="Paramaddress") String Paramaddress
168 ,@WebParam(name="Paramcity") String Paramcity
169 ,@WebParam(name="Paramstate") String Paramstate
170 ,@WebParam(name="Paramzip") double Paramzip
171 ,@WebParam(name="Parambdate") java.util.Date Parambdate
172 ,@WebParam(name="Paramphone") String Paramphone) throws DAOFactoryServiceException;
173/**
174* Call Class CustomerDelete as a service
175* @param String ParamParam1 STRING
176* @return void
177* @throws DAOFactoryServiceException
178*/
179// JSR-181 support - make this method part of a web service
180@WebMethod
181public void serviceSqlCustomerDelete
182 (@WebParam(name="ParamParam1") String ParamParam1) throws DAOFactoryServiceException;
183/**
184* Call Class CustomerUpdate as a service
185* @param String Paramaddress STRING
186* @param String Paramcity STRING
187* @param String Paramstate STRING
188* @param double Paramzip NUMBER
189* @param java.util.Date Parambdate DATE
190* @param String Paramphone STRING
191* @param String Paramname STRING
192* @return void
193* @throws DAOFactoryServiceException
194*/
195// JSR-181 support - make this method part of a web service
196@WebMethod
197public void serviceSqlCustomerUpdate
198 (@WebParam(name="Paramaddress") String Paramaddress
199 ,@WebParam(name="Paramcity") String Paramcity
200 ,@WebParam(name="Paramstate") String Paramstate
201 ,@WebParam(name="Paramzip") double Paramzip
202 ,@WebParam(name="Parambdate") java.util.Date Parambdate
203 ,@WebParam(name="Paramphone") String Paramphone
204 ,@WebParam(name="Paramname") String Paramname) throws DAOFactoryServiceException;
205/**
206* Call Class GetFlights as a service
207* @param String Paramcity STRING
208* @return com.orindasoft.demo.generated.sql.GetFlightsCursorAttr[]
209* @throws DAOFactoryServiceException
210*/
211// JSR-181 support - make this method part of a web service
212@WebMethod
213public com.orindasoft.demo.generated.sql.GetFlightsCursorAttr[] serviceSqlGetFlights
214 (@WebParam(name="Paramcity") String Paramcity) throws DAOFactoryServiceException;
215} // Generated by JDBCWizard./a> 6.0.2776
216