Java > Open Source Codes > com > nilostep > xlsql > jdbc > xlCallableStatement


1 /*
2  * x l S Q L
3  * (c) Jim Caprioli, NiLOSTEP.com
4  * See xlSQL-license.txt for license details
5  *
6  */
7
8 package com.nilostep.xlsql.jdbc;
9
10 import java.sql.*;
11
12 public class xlCallableStatement extends xlPreparedStatement
13                                             implements CallableStatement {
14
15     private xlConnection xlCon;
16     private CallableStatement dbCstm;
17
18     /**
19     * Constructs a new CallableStatementImpl object.
20     *
21     */
22     public xlCallableStatement(xlConnection con, CallableStatement clst,
23                                             String sql) throws SQLException {
24         super (con, clst, sql);
25         dbCstm = clst;
26     }
27     
28     /**
29     * Implements method in interface java.sql.CallableStatement
30     * @see java.sql.CallableStatement#getArray
31     */
32     public Array getArray(int i) throws SQLException {
33         return dbCstm.getArray(i);
34     }
35     
36     /**
37     * Implements method in interface java.sql.CallableStatement
38     * @see java.sql.CallableStatement#getArray
39     */
40     public Array getArray(String parameterName) throws SQLException {
41         return dbCstm.getArray(parameterName);
42     }
43     
44     /**
45     * Implements method in interface java.sql.CallableStatement
46     * @see java.sql.CallableStatement#getBigDecimal
47     */
48     public java.math.BigDecimal getBigDecimal(String parameterName) throws SQLException {
49         return dbCstm.getBigDecimal(parameterName);
50     }
51     
52     /**
53     * Implements method in interface java.sql.CallableStatement
54     * @see java.sql.CallableStatement#getBigDecimal
55     */
56     public java.math.BigDecimal getBigDecimal(int parameterIndex) throws SQLException {
57         return dbCstm.getBigDecimal(parameterIndex);
58     }
59     
60     /**
61     * Implements method in interface java.sql.CallableStatement
62     * @see java.sql.CallableStatement#getBigDecimal
63     */
64     public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException {
65         return dbCstm.getBigDecimal(parameterIndex,scale);
66     }
67     
68     /**
69     * Implements method in interface java.sql.CallableStatement
70     * @see java.sql.CallableStatement#getBlob
71     */
72     public Blob getBlob(int i) throws SQLException {
73         return dbCstm.getBlob(i);
74     }
75     
76     /**
77     * Implements method in interface java.sql.CallableStatement
78     * @see java.sql.CallableStatement#getBlob
79     */
80     public Blob getBlob(String parameterName) throws SQLException {
81         return dbCstm.getBlob(parameterName);
82     }
83     
84     /**
85     * Implements method in interface java.sql.CallableStatement
86     * @see java.sql.CallableStatement#getBoolean
87     */
88     public boolean getBoolean(int parameterIndex) throws SQLException {
89         return dbCstm.getBoolean(parameterIndex);
90     }
91     
92     /**
93     * Implements method in interface java.sql.CallableStatement
94     * @see java.sql.CallableStatement#getBoolean
95     */
96     public boolean getBoolean(String parameterName) throws SQLException {
97         return dbCstm.getBoolean(parameterName);
98     }
99     
100     /**
101     * Implements method in interface java.sql.CallableStatement
102     * @see java.sql.CallableStatement#getByte
103     */
104     public byte getByte(int parameterIndex) throws SQLException {
105         return dbCstm.getByte(parameterIndex);
106     }
107     
108     /**
109     * Implements method in interface java.sql.CallableStatement
110     * @see java.sql.CallableStatement#getByte
111     */
112     public byte getByte(String parameterName) throws SQLException {
113         return dbCstm.getByte(parameterName);
114     }
115     
116     /**
117     * Implements method in interface java.sql.CallableStatement
118     * @see java.sql.CallableStatement#getBytes
119     */
120     public byte[] getBytes(int parameterIndex) throws SQLException {
121         return dbCstm.getBytes(parameterIndex);
122     }
123     
124     /**
125     * Implements method in interface java.sql.CallableStatement
126     * @see java.sql.CallableStatement#getBytes
127     */
128     public byte[] getBytes(String parameterName) throws SQLException {
129         return dbCstm.getBytes(parameterName);
130     }
131     
132     /**
133     * Implements method in interface java.sql.CallableStatement
134     * @see java.sql.CallableStatement#getClob
135     */
136     public Clob getClob(int i) throws SQLException {
137         return dbCstm.getClob(i);
138     }
139     
140     /**
141     * Implements method in interface java.sql.CallableStatement
142     * @see java.sql.CallableStatement#getClob
143     */
144     public Clob getClob(String parameterName) throws SQLException {
145         return dbCstm.getClob(parameterName);
146     }
147     
148     /**
149     * Implements method in interface java.sql.CallableStatement
150     * @see java.sql.CallableStatement#getDate
151     */
152     public java.sql.Date getDate(int parameterIndex) throws SQLException {
153         return dbCstm.getDate(parameterIndex);
154     }
155     
156     /**
157     * Implements method in interface java.sql.CallableStatement
158     * @see java.sql.CallableStatement#getDate
159     */
160     public java.sql.Date getDate(String parameterName) throws SQLException {
161         return dbCstm.getDate(parameterName);
162     }
163     
164     /**
165     * Implements method in interface java.sql.CallableStatement
166     * @see java.sql.CallableStatement#getDate
167     */
168     public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws SQLException {
169         return dbCstm.getDate(parameterIndex, cal);
170     }
171     
172     /**
173     * Implements method in interface java.sql.CallableStatement
174     * @see java.sql.CallableStatement#getDate
175     */
176     public java.sql.Date getDate(String parameterName, java.util.Calendar cal) throws SQLException {
177         return dbCstm.getDate(parameterName, cal);
178     }
179     
180     /**
181     * Implements method in interface java.sql.CallableStatement
182     * @see java.sql.CallableStatement#getDouble
183     */
184     public double getDouble(int parameterIndex) throws SQLException {
185         return dbCstm.getDouble(parameterIndex);
186     }
187     
188     /**
189     * Implements method in interface java.sql.CallableStatement
190     * @see java.sql.CallableStatement#getDouble
191     */
192     public double getDouble(String parameterName) throws SQLException {
193         return dbCstm.getDouble(parameterName);
194     }
195     
196     /**
197     * Implements method in interface java.sql.CallableStatement
198     * @see java.sql.CallableStatement#getFloat
199     */
200     public float getFloat(int parameterIndex) throws SQLException {
201         return dbCstm.getFloat(parameterIndex);
202     }
203     
204     /**
205     * Implements method in interface java.sql.CallableStatement
206     * @see java.sql.CallableStatement#getFloat
207     */
208     public float getFloat(String parameterName) throws SQLException {
209         return dbCstm.getFloat(parameterName);
210     }
211     
212     /**
213     * Implements method in interface java.sql.CallableStatement
214     * @see java.sql.CallableStatement#getInt
215     */
216     public int getInt(String parameterName) throws SQLException {
217         return dbCstm.getInt(parameterName);
218     }
219     
220     /**
221     * Implements method in interface java.sql.CallableStatement
222     * @see java.sql.CallableStatement#getInt
223     */
224     public int getInt(int parameterIndex) throws SQLException {
225         return dbCstm.getInt(parameterIndex);
226     }
227     
228     /**
229     * Implements method in interface java.sql.CallableStatement
230     * @see java.sql.CallableStatement#getLong
231     */
232     public long getLong(int parameterIndex) throws SQLException {
233         return dbCstm.getLong(parameterIndex);
234     }
235     
236     /**
237     * Implements method in interface java.sql.CallableStatement
238     * @see java.sql.CallableStatement#getLong
239     */
240     public long getLong(String parameterName) throws SQLException {
241         return dbCstm.getLong(parameterName);
242     }
243     
244     /**
245     * Implements method in interface java.sql.CallableStatement
246     * @see java.sql.CallableStatement#getObject
247     */
248     public Object getObject(int parameterIndex) throws SQLException {
249         return dbCstm.getObject(parameterIndex);
250     }
251     
252     /**
253     * Implements method in interface java.sql.CallableStatement
254     * @see java.sql.CallableStatement#getObject
255     */
256     public Object getObject(String parameterName) throws SQLException {
257         return dbCstm.getObject(parameterName);
258     }
259     
260     /**
261     * Implements method in interface java.sql.CallableStatement
262     * @see java.sql.CallableStatement#getObject
263     */
264     public Object getObject(int i, java.util.Map map) throws SQLException {
265         return dbCstm.getObject(i, map);
266     }
267     
268     /**
269     * Implements method in interface java.sql.CallableStatement
270     * @see java.sql.CallableStatement#getObject
271     */
272     public Object getObject(String parameterName, java.util.Map map) throws SQLException {
273         return dbCstm.getObject(parameterName, map);
274     }
275     
276     /**
277     * Implements method in interface java.sql.CallableStatement
278     * @see java.sql.CallableStatement#getRef
279     */
280     public Ref getRef(int i) throws SQLException {
281         return dbCstm.getRef(i);
282     }
283     
284     /**
285     * Implements method in interface java.sql.CallableStatement
286     * @see java.sql.CallableStatement#getRef
287     */
288     public Ref getRef(String parameterName) throws SQLException {
289         return dbCstm.getRef(parameterName);
290     }
291     
292     /**
293     * Implements method in interface java.sql.CallableStatement
294     * @see java.sql.CallableStatement#getShort
295     */
296     public short getShort(String parameterName) throws SQLException {
297         return dbCstm.getShort(parameterName);
298     }
299     
300     /**
301     * Implements method in interface java.sql.CallableStatement
302     * @see java.sql.CallableStatement#getShort
303     */
304     public short getShort(int parameterIndex) throws SQLException {
305         return dbCstm.getShort(parameterIndex);
306     }
307     
308     /**
309     * Implements method in interface java.sql.CallableStatement
310     * @see java.sql.CallableStatement#getString
311     */
312     public String getString(String parameterName) throws SQLException {
313         return dbCstm.getString(parameterName);
314     }
315     
316     /**
317     * Implements method in interface java.sql.CallableStatement
318     * @see java.sql.CallableStatement#getString
319     */
320     public String getString(int parameterIndex) throws SQLException {
321         return dbCstm.getString(parameterIndex);
322     }
323     
324     /**
325     * Implements method in interface java.sql.CallableStatement
326     * @see java.sql.CallableStatement#getTime
327     */
328     public java.sql.Time getTime(String parameterName) throws SQLException {
329         return dbCstm.getTime(parameterName);
330     }
331     
332     /**
333     * Implements method in interface java.sql.CallableStatement
334     * @see java.sql.CallableStatement#getTime
335     */
336     public java.sql.Time getTime(int parameterIndex) throws SQLException {
337         return dbCstm.getTime(parameterIndex);
338     }
339     
340     /**
341     * Implements method in interface java.sql.CallableStatement
342     * @see java.sql.CallableStatement#getTime
343     */
344     public java.sql.Time getTime(String parameterName, java.util.Calendar cal) throws SQLException {
345         return dbCstm.getTime(parameterName, cal);
346     }
347     
348     /**
349     * Implements method in interface java.sql.CallableStatement
350     * @see java.sql.CallableStatement#getTime
351     */
352     public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws SQLException {
353         return dbCstm.getTime(parameterIndex, cal);
354     }
355     
356     /**
357     * Implements method in interface java.sql.CallableStatement
358     * @see java.sql.CallableStatement#getTimestamp
359     */
360     public java.sql.Timestamp getTimestamp(String parameterName) throws SQLException {
361         return dbCstm.getTimestamp(parameterName);
362     }
363     
364     /**
365     * Implements method in interface java.sql.CallableStatement
366     * @see java.sql.CallableStatement#getTimestamp
367     */
368     public java.sql.Timestamp getTimestamp(int parameterIndex) throws SQLException {
369         return dbCstm.getTimestamp(parameterIndex);
370     }
371     
372     /**
373     * Implements method in interface java.sql.CallableStatement
374     * @see java.sql.CallableStatement#getTimestamp
375     */
376     public java.sql.Timestamp getTimestamp(String parameterName, java.util.Calendar cal) throws SQLException {
377         return dbCstm.getTimestamp(parameterName, cal);
378     }
379     
380     /**
381     * Implements method in interface java.sql.CallableStatement
382     * @see java.sql.CallableStatement#getTimestamp
383     */
384     public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws SQLException {
385         return dbCstm.getTimestamp(parameterIndex, cal);
386     }
387     
388     /**
389     * Implements method in interface java.sql.CallableStatement
390     * @see java.sql.CallableStatement#getURL
391     */
392     public java.net.URL getURL(int parameterIndex) throws SQLException {
393         return dbCstm.getURL(parameterIndex);
394     }
395     
396     /**
397     * Implements method in interface java.sql.CallableStatement
398     * @see java.sql.CallableStatement#getURL
399     */
400     public java.net.URL getURL(String parameterName) throws SQLException {
401         return dbCstm.getURL(parameterName);
402     }
403     
404     /**
405     * Implements method in interface java.sql.CallableStatement
406     * @see java.sql.CallableStatement#registerOutParameter
407     */
408     public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException {
409         dbCstm.registerOutParameter(parameterIndex, sqlType);
410     }
411     
412     /**
413     * Implements method in interface java.sql.CallableStatement
414     * @see java.sql.CallableStatement#registerOutParameter
415     */
416     public void registerOutParameter(String parameterName, int sqlType) throws SQLException {
417         dbCstm.registerOutParameter(parameterName, sqlType);
418     }
419     
420     /**
421     * Implements method in interface java.sql.CallableStatement
422     * @see java.sql.CallableStatement#registerOutParameter
423     */
424     public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException {
425         dbCstm.registerOutParameter(parameterName, sqlType, typeName);
426     }
427     
428     /**
429     * Implements method in interface java.sql.CallableStatement
430     * @see java.sql.CallableStatement#registerOutParameter
431     */
432     public void registerOutParameter(int paramIndex, int sqlType, int scale) throws SQLException {
433         dbCstm.registerOutParameter(paramIndex, sqlType, scale);
434     }
435     
436     /**
437     * Implements method in interface java.sql.CallableStatement
438     * @see java.sql.CallableStatement#registerOutParameter
439     */
440     public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException {
441         dbCstm.registerOutParameter(parameterName, sqlType, scale);
442     }
443     
444     /**
445     * Implements method in interface java.sql.CallableStatement
446     * @see java.sql.CallableStatement#registerOutParameter
447     */
448     public void registerOutParameter(int paramIndex, int sqlType, String typeName) throws SQLException {
449         dbCstm.registerOutParameter(paramIndex, sqlType, typeName);
450     }
451     
452     /**
453     * Implements method in interface java.sql.CallableStatement
454     * @see java.sql.CallableStatement#setAsciiStream
455     */
456     public void setAsciiStream(String parameterName, java.io.InputStream x, int length) throws SQLException {
457         dbCstm.setAsciiStream(parameterName, x, length);
458     }
459     
460     /**
461     * Implements method in interface java.sql.CallableStatement
462     * @see java.sql.CallableStatement#setBigDecimal
463     */
464     public void setBigDecimal(String parameterName, java.math.BigDecimal x) throws SQLException {
465         dbCstm.setBigDecimal(parameterName, x);
466     }
467     
468     /**
469     * Implements method in interface java.sql.CallableStatement
470     * @see java.sql.CallableStatement#setBinaryStream
471     */
472     public void setBinaryStream(String parameterName, java.io.InputStream x, int length) throws SQLException {
473         dbCstm.setBinaryStream(parameterName, x, length);
474     }
475     
476     /**
477     * Implements method in interface java.sql.CallableStatement
478     * @see java.sql.CallableStatement#setBoolean
479     */
480     public void setBoolean(String parameterName, boolean x) throws SQLException {
481         dbCstm.setBoolean(parameterName, x);
482     }
483     
484     /**
485     * Implements method in interface java.sql.CallableStatement
486     * @see java.sql.CallableStatement#setByte
487     */
488     public void setByte(String parameterName, byte x) throws SQLException {
489         dbCstm.setByte(parameterName, x);
490     }
491     
492     /**
493     * Implements method in interface java.sql.CallableStatement
494     * @see java.sql.CallableStatement#setBytes
495     */
496     public void setBytes(String parameterName, byte[] x) throws SQLException {
497         dbCstm.setBytes(parameterName, x);
498     }
499     
500     /**
501     * Implements method in interface java.sql.CallableStatement
502     * @see java.sql.CallableStatement#setCharacterStream
503     */
504     public void setCharacterStream(String parameterName, java.io.Reader reader, int length) throws SQLException {
505         dbCstm.setCharacterStream(parameterName, reader, length);
506     }
507     
508     /**
509     * Implements method in interface java.sql.CallableStatement
510     * @see java.sql.CallableStatement#setDate
511     */
512     public void setDate(String parameterName, java.sql.Date x) throws SQLException {
513         dbCstm.setDate(parameterName, x);
514     }
515     
516     /**
517     * Implements method in interface java.sql.CallableStatement
518     * @see java.sql.CallableStatement#setDate
519     */
520     public void setDate(String parameterName, java.sql.Date x, java.util.Calendar cal) throws SQLException {
521         dbCstm.setDate(parameterName, x, cal);
522     }
523     
524     /**
525     * Implements method in interface java.sql.CallableStatement
526     * @see java.sql.CallableStatement#setDouble
527     */
528     public void setDouble(String parameterName, double x) throws SQLException {
529         throw new SQLException("not supported");
530     }
531     
532     /**
533     * Implements method in interface java.sql.CallableStatement
534     * @see java.sql.CallableStatement#setFloat
535     */
536     public void setFloat(String parameterName, float x) throws SQLException {
537         dbCstm.setFloat(parameterName, x);
538     }
539     
540     /**
541     * Implements method in interface java.sql.CallableStatement
542     * @see java.sql.CallableStatement#setInt
543     */
544     public void setInt(String parameterName, int x) throws SQLException {
545         dbCstm.setInt(parameterName, x);
546     }
547     
548     /**
549     * Implements method in interface java.sql.CallableStatement
550     * @see java.sql.CallableStatement#setLong
551     */
552     public void setLong(String parameterName, long x) throws SQLException {
553         dbCstm.setLong(parameterName, x);
554     }
555     
556     /**
557     * Implements method in interface java.sql.CallableStatement
558     * @see java.sql.CallableStatement#setNull
559     */
560     public void setNull(String parameterName, int sqlType) throws SQLException {
561         dbCstm.setNull(parameterName, sqlType);
562     }
563     
564     /**
565     * Implements method in interface java.sql.CallableStatement
566     * @see java.sql.CallableStatement#setNull
567     */
568     public void setNull(String parameterName, int sqlType, String typeName) throws SQLException {
569         dbCstm.setNull(parameterName, sqlType, typeName);
570     }
571     
572     /**
573     * Implements method in interface java.sql.CallableStatement
574     * @see java.sql.CallableStatement#setObject
575     */
576     public void setObject(String parameterName, Object x) throws SQLException {
577         dbCstm.setObject(parameterName, x);
578     }
579     
580     /**
581     * Implements method in interface java.sql.CallableStatement
582     * @see java.sql.CallableStatement#setObject
583     */
584     public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException {
585         dbCstm.setObject(parameterName, x, targetSqlType);
586     }
587     
588     /**
589     * Implements method in interface java.sql.CallableStatement
590     * @see java.sql.CallableStatement#setObject
591     */
592    public void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException {
593         dbCstm.setObject(parameterName, x, targetSqlType);
594     }
595     
596     /**
597     * Implements method in interface java.sql.CallableStatement
598     * @see java.sql.CallableStatement#setShort
599     */
600     public void setShort(String parameterName, short x) throws SQLException {
601         dbCstm.setShort(parameterName, x);
602     }
603     
604     /**
605     * Implements method in interface java.sql.CallableStatement
606     * @see java.sql.CallableStatement#setString
607     */
608     public void setString(String parameterName, String x) throws SQLException {
609         dbCstm.setString(parameterName, x);
610     }
611     
612     /**
613     * Implements method in interface java.sql.CallableStatement
614     * @see java.sql.CallableStatement#setTime
615     */
616     public void setTime(String parameterName, java.sql.Time x) throws SQLException {
617         dbCstm.setTime(parameterName, x);
618     }
619     
620     /**
621     * Implements method in interface java.sql.CallableStatement
622     * @see java.sql.CallableStatement#setTime
623     */
624     public void setTime(String parameterName, java.sql.Time x, java.util.Calendar cal) throws SQLException {
625         dbCstm.setTime(parameterName, x, cal);
626     }
627     
628     /**
629     * Implements method in interface java.sql.CallableStatement
630     * @see java.sql.CallableStatement#setTimestamp
631     */
632     public void setTimestamp(String parameterName, java.sql.Timestamp x) throws SQLException {
633         dbCstm.setTimestamp(parameterName, x);
634     }
635     
636     /**
637     * Implements method in interface java.sql.CallableStatement
638     * @see java.sql.CallableStatement#setTimestamp
639     */
640     public void setTimestamp(String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws SQLException {
641         dbCstm.setTimestamp(parameterName, x, cal);
642     }
643     
644     /**
645     * Implements method in interface java.sql.CallableStatement
646     * @see java.sql.CallableStatement#setURL
647     */
648     public void setURL(String parameterName, java.net.URL val) throws SQLException {
649         dbCstm.setURL(parameterName, val);
650     }
651     
652     /**
653     * Implements method in interface java.sql.CallableStatement
654     * @see java.sql.CallableStatement#wasNull
655     */
656     public boolean wasNull() throws SQLException {
657         return dbCstm.wasNull();
658     }
659 }

A to Z: JavaDoc & Examples

---

Daily Java News & Articles

---

Open Source Projects

---

Open Source Codes

---

Free Computer Books

---

Remove Frame

---

Popular Tags