1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
<!-- Generated by javadoc (build 1.4.2_03) on Sun Jan 31 16:35:17 CET 2010 -->
7
Callback (SQLite Java Wrapper)
10
<META NAME="keywords" CONTENT="SQLite.Callback interface">
12
<LINK REL ="stylesheet" TYPE="text/css" HREF="../stylesheet.css" TITLE="Style">
14
<SCRIPT type="text/javascript">
15
function windowTitle()
17
parent.document.title="Callback (SQLite Java Wrapper)";
23
<BODY BGCOLOR="white" onload="windowTitle();">
26
<!-- ========= START OF TOP NAVBAR ======= -->
27
<A NAME="navbar_top"><!-- --></A>
28
<A HREF="#skip-navbar_top" title="Skip navigation links"></A>
29
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
31
<TD COLSPAN=3 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
32
<A NAME="navbar_top_firstrow"><!-- --></A>
33
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
34
<TR ALIGN="center" VALIGN="top">
35
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
36
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
37
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
38
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
42
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
48
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
49
<A HREF="../SQLite/BusyHandler.html" title="interface in SQLite"><B>PREV CLASS</B></A>
50
<A HREF="../SQLite/Constants.html" title="class in SQLite"><B>NEXT CLASS</B></A></FONT></TD>
51
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
52
<A HREF="../index.html" target="_top"><B>FRAMES</B></A>
53
<A HREF="Callback.html" target="_top"><B>NO FRAMES</B></A>
54
<SCRIPT type="text/javascript">
57
document.writeln('<A HREF="../allclasses-noframe.html"><B>All Classes</B></A>');
62
<A HREF="../allclasses-noframe.html"><B>All Classes</B></A>
68
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
69
SUMMARY: NESTED | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD>
70
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
71
DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD>
74
<A NAME="skip-navbar_top"></A>
75
<!-- ========= END OF TOP NAVBAR ========= -->
78
<!-- ======== START OF CLASS DATA ======== -->
83
Interface Callback</H2>
85
<DT><B>All Known Implementing Classes:</B> <DD><A HREF="../SQLite/TableResult.html" title="class in SQLite">TableResult</A></DD>
89
<DT>public interface <B>Callback</B></DL>
92
Callback interface for SQLite's query results.
97
class TableFmt implements SQLite.Callback {
98
public void columns(String cols[]) {
99
System.out.println("<TH><TR>");
100
for (int i = 0; i < cols.length; i++) {
101
System.out.println("<TD>" + cols[i] + "</TD>");
103
System.out.println("</TR></TH>");
105
public boolean newrow(String cols[]) {
106
System.out.println("<TR>");
107
for (int i = 0; i < cols.length; i++) {
108
System.out.println("<TD>" + cols[i] + "</TD>");
110
System.out.println("</TR>");
115
SQLite.Database db = new SQLite.Database();
117
System.out.println("<TABLE>");
118
db.exec("select * from TEST", new TableFmt());
119
System.out.println("</TABLE>");
128
<!-- ======== NESTED CLASS SUMMARY ======== -->
131
<!-- =========== FIELD SUMMARY =========== -->
134
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
137
<!-- ========== METHOD SUMMARY =========== -->
139
<A NAME="method_summary"><!-- --></A>
140
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
141
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
142
<TD COLSPAN=2><FONT SIZE="+2">
143
<B>Method Summary</B></FONT></TD>
145
<TR BGCOLOR="white" CLASS="TableRowColor">
146
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
147
<CODE> void</CODE></FONT></TD>
148
<TD><CODE><B><A HREF="../SQLite/Callback.html#columns(java.lang.String[])">columns</A></B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>[] coldata)</CODE>
151
Reports column names of the query result.</TD>
153
<TR BGCOLOR="white" CLASS="TableRowColor">
154
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
155
<CODE> boolean</CODE></FONT></TD>
156
<TD><CODE><B><A HREF="../SQLite/Callback.html#newrow(java.lang.String[])">newrow</A></B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>[] rowdata)</CODE>
159
Reports row data of the query result.</TD>
161
<TR BGCOLOR="white" CLASS="TableRowColor">
162
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
163
<CODE> void</CODE></FONT></TD>
164
<TD><CODE><B><A HREF="../SQLite/Callback.html#types(java.lang.String[])">types</A></B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>[] types)</CODE>
167
Reports type names of the columns of the query result.</TD>
173
<!-- ============ FIELD DETAIL =========== -->
176
<!-- ========= CONSTRUCTOR DETAIL ======== -->
179
<!-- ============ METHOD DETAIL ========== -->
181
<A NAME="method_detail"><!-- --></A>
182
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
183
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
184
<TD COLSPAN=1><FONT SIZE="+2">
185
<B>Method Detail</B></FONT></TD>
189
<A NAME="columns(java.lang.String[])"><!-- --></A><H3>
192
public void <B>columns</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>[] coldata)</PRE>
194
<DD>Reports column names of the query result.
195
This method is invoked first (and once) when
196
the SQLite engine returns the result set.<BR><BR>
199
<DT><B>Parameters:</B><DD><CODE>coldata</CODE> - string array holding the column names</DL>
204
<A NAME="newrow(java.lang.String[])"><!-- --></A><H3>
207
public boolean <B>newrow</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>[] rowdata)</PRE>
209
<DD>Reports row data of the query result.
210
This method is invoked for each row of the
211
result set. If true is returned the running
212
SQLite query is aborted.<BR><BR>
215
<DT><B>Parameters:</B><DD><CODE>rowdata</CODE> - string array holding the column values of the row</DL>
220
<A NAME="types(java.lang.String[])"><!-- --></A><H3>
223
public void <B>types</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>[] types)</PRE>
225
<DD>Reports type names of the columns of the query result.
226
This is available from SQLite 2.6.0 on and needs
227
the PRAGMA show_datatypes to be turned on.<BR><BR>
230
<DT><B>Parameters:</B><DD><CODE>types</CODE> - string array holding column types</DL>
233
<!-- ========= END OF CLASS DATA ========= -->
237
<!-- ======= START OF BOTTOM NAVBAR ====== -->
238
<A NAME="navbar_bottom"><!-- --></A>
239
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
240
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
242
<TD COLSPAN=3 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
243
<A NAME="navbar_bottom_firstrow"><!-- --></A>
244
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
245
<TR ALIGN="center" VALIGN="top">
246
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
247
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
248
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
249
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
253
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
259
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
260
<A HREF="../SQLite/BusyHandler.html" title="interface in SQLite"><B>PREV CLASS</B></A>
261
<A HREF="../SQLite/Constants.html" title="class in SQLite"><B>NEXT CLASS</B></A></FONT></TD>
262
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
263
<A HREF="../index.html" target="_top"><B>FRAMES</B></A>
264
<A HREF="Callback.html" target="_top"><B>NO FRAMES</B></A>
265
<SCRIPT type="text/javascript">
268
document.writeln('<A HREF="../allclasses-noframe.html"><B>All Classes</B></A>');
273
<A HREF="../allclasses-noframe.html"><B>All Classes</B></A>
279
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
280
SUMMARY: NESTED | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD>
281
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
282
DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD>
285
<A NAME="skip-navbar_bottom"></A>
286
<!-- ======== END OF BOTTOM NAVBAR ======= -->
289
<small>Contact: <a HREF="mailto:chw@ch-werner.de">Christian Werner</a></small>