1: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Frameset//EN""http://www.w3.org/TR/REC-html40/frameset.dtd">
2: <!--NewPage-->
3: <HTML>
4: <HEAD>
5: <!-- Generated by javadoc on Fri Jul 25 10:50:41 CEST 2003 -->
6: <TITLE>
7: : Index
8: </TITLE>
9: <LINK REL ="stylesheet" TYPE="text/css" HREF="stylesheet.css" TITLE="Style">
10: </HEAD>
11: <BODY BGCOLOR="white">
12:
13: <!-- ========== START OF NAVBAR ========== -->
14: <A NAME="navbar_top"><!-- --></A>
15: <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0">
16: <TR>
17: <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
18: <A NAME="navbar_top_firstrow"><!-- --></A>
19: <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3">
20: <TR ALIGN="center" VALIGN="top">
21: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <FONT CLASS="NavBarFont1">Class</FONT> </TD>
22: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="overview-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
23: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
24: <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Index</B></FONT> </TD>
25: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
26: </TR>
27: </TABLE>
28: </TD>
29: <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
30: </EM>
31: </TD>
32: </TR>
33:
34: <TR>
35: <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
36: PREV
37: NEXT</FONT></TD>
38: <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
39: <A HREF="index.html" TARGET="_top"><B>FRAMES</B></A>
40: <A HREF="index-all.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD>
41: </TR>
42: </TABLE>
43: <!-- =========== END OF NAVBAR =========== -->
44:
45: <A HREF="#_A_">A</A> <A HREF="#_C_">C</A> <A HREF="#_D_">D</A> <A HREF="#_E_">E</A> <A HREF="#_F_">F</A> <A HREF="#_G_">G</A> <A HREF="#_M_">M</A> <A HREF="#_O_">O</A> <A HREF="#_Q_">Q</A> <A HREF="#_R_">R</A> <A HREF="#_S_">S</A> <A HREF="#_T_">T</A> <A HREF="#_U_">U</A> <A HREF="#_W_">W</A> <HR>
46: <A NAME="_A_"><!-- --></A><H2>
47: <B>A</B></H2>
48: <DL>
49: <DT><A HREF="FM.html#actionPerformed(java.awt.event.ActionEvent)"><B>actionPerformed(ActionEvent)</B></A> -
50: Method in class <A HREF="FM.html">FM</A>
51: <DD>
52: <DT><A HREF="FM.html#appendLog(java.lang.String, java.lang.String)"><B>appendLog(String, String)</B></A> -
53: Static method in class <A HREF="FM.html">FM</A>
54: <DD>Append one entry to the log file(index.html)
55: </DL>
56: <HR>
57: <A NAME="_C_"><!-- --></A><H2>
58: <B>C</B></H2>
59: <DL>
60: <DT><A HREF="TableComponent.html#clear()"><B>clear()</B></A> -
61: Method in class <A HREF="TableComponent.html">TableComponent</A>
62: <DD>
63: <DT><A HREF="FM.html#closeLog()"><B>closeLog()</B></A> -
64: Static method in class <A HREF="FM.html">FM</A>
65: <DD>closes the log file invoked then the application closes
66: <DT><A HREF="TableComponent.html#convertUml(java.lang.StringBuffer)"><B>convertUml(StringBuffer)</B></A> -
67: Static method in class <A HREF="TableComponent.html">TableComponent</A>
68: <DD>MacOs and Windows Version of the Method
69: converts german umlaute to html ¨aute;
70: </DL>
71: <HR>
72: <A NAME="_D_"><!-- --></A><H2>
73: <B>D</B></H2>
74: <DL>
75: <DT><A HREF="DBBean.html"><B>DBBean</B></A> - class <A HREF="DBBean.html">DBBean</A>.<DD>DBBean - Database bean
76:
77: a Javabean to perform queries on a JDBC Database,
78: or excute any other SQL statement
79:
80:
81: Usage:
82:
83: DBean bean = new DBBean();
84: // setting user and passwd
85: bean.setUserAndPasswd("bla","bla");
86: try
87: {
88: bean.setConnection("jdbc:fmpro:http://localhost");
89: Vector names=bean.getTableNames();
90: Vector[] result=bean.getQueryData(names.get(0).toString());
91: // print results to screen
92: for(int i=0;i<result[1].size();++i)
93: {
94: //print Header
95: System.out.print(" "+result[1].get(i));
96: }
97: System.out.println();
98: for(int j=0;j<result[0].size();++j)
99: {
100: Vector row=(Vector)result[0].get(j);
101: //print rows
102: for(int k=0;k<row.size();++k)
103: System.out.print(" "+row.get(k));
104: System.out.println();
105: }
106: } catch(Exception e)
107: {
108: System.out.println("Error while connecting to database"+ e);
109: }
110:
111:
112: <DT><A HREF="DBBean.html#DBBean()"><B>DBBean()</B></A> -
113: Constructor for class <A HREF="DBBean.html">DBBean</A>
114: <DD>Constructs a database bean
115: <DT><A HREF="DBBean.html#DBBean(java.lang.String)"><B>DBBean(String)</B></A> -
116: Constructor for class <A HREF="DBBean.html">DBBean</A>
117: <DD>Constructs a database bean
118: and tries to connect to database
119: specified in the jdbcConnectionURL
120: <DT><A HREF="DBFront.html"><B>DBFront</B></A> - class <A HREF="DBFront.html">DBFront</A>.<DD> <DT><A HREF="DBFront.html#DBFront()"><B>DBFront()</B></A> -
121: Constructor for class <A HREF="DBFront.html">DBFront</A>
122: <DD>
123: <DT><A HREF="TableComponent.html#disable(boolean)"><B>disable(boolean)</B></A> -
124: Method in class <A HREF="TableComponent.html">TableComponent</A>
125: <DD>
126: </DL>
127: <HR>
128: <A NAME="_E_"><!-- --></A><H2>
129: <B>E</B></H2>
130: <DL>
131: <DT><A HREF="TableComponent.html#enlarge(int, int)"><B>enlarge(int, int)</B></A> -
132: Method in class <A HREF="TableComponent.html">TableComponent</A>
133: <DD>
134: <DT><A HREF="ResultWindow.html#exportQueryToHTML(java.lang.String)"><B>exportQueryToHTML(String)</B></A> -
135: Method in class <A HREF="ResultWindow.html">ResultWindow</A>
136: <DD>exports the current results to HTML
137: <DT><A HREF="TableComponent.html#exportToHTML()"><B>exportToHTML()</B></A> -
138: Method in class <A HREF="TableComponent.html">TableComponent</A>
139: <DD>exports the current data in this tablecomponent to HTML
140: </DL>
141: <HR>
142: <A NAME="_F_"><!-- --></A><H2>
143: <B>F</B></H2>
144: <DL>
145: <DT><A HREF="FM.html"><B>FM</B></A> - class <A HREF="FM.html">FM</A>.<DD><br>
146: FileMaker Test (JDBC Database Driver Test)
147: Main class :
148: contains the main Frame, all event handlers etc
149: <br>
150: The Database access is made over DBBean class
151: all other classes are just for the visualization of the data<DT><A HREF="FM.html#FM()"><B>FM()</B></A> -
152: Constructor for class <A HREF="FM.html">FM</A>
153: <DD>tries to connect to database specified in url-Variable.
154: initializes all GUI components, then fails throws an exception
155: </DL>
156: <HR>
157: <A NAME="_G_"><!-- --></A><H2>
158: <B>G</B></H2>
159: <DL>
160: <DT><A HREF="DBBean.html#getColumnNames()"><B>getColumnNames()</B></A> -
161: Method in class <A HREF="DBBean.html">DBBean</A>
162: <DD>
163: <DT><A HREF="DBFront.html#getColumnNames()"><B>getColumnNames()</B></A> -
164: Method in class <A HREF="DBFront.html">DBFront</A>
165: <DD>
166: <DT><A HREF="DBBean.html#getConnection()"><B>getConnection()</B></A> -
167: Method in class <A HREF="DBBean.html">DBBean</A>
168: <DD>returns the Connection if null creates a new one from the url property.
169: <DT><A HREF="DBBean.html#getLayoutNames(java.lang.String)"><B>getLayoutNames(String)</B></A> -
170: Method in class <A HREF="DBBean.html">DBBean</A>
171: <DD>returns a Vector containing the layoutNames for the specified Table
172: if the database supports this otherwise Vector containing an empty String
173: <DT><A HREF="TableComponent.html#getMaxHeaderWidth()"><B>getMaxHeaderWidth()</B></A> -
174: Method in class <A HREF="TableComponent.html">TableComponent</A>
175: <DD>
176: <DT><A HREF="DBBean.html#getMaxHits()"><B>getMaxHits()</B></A> -
177: Method in class <A HREF="DBBean.html">DBBean</A>
178: <DD>gets the maximum number of hits
179: <DT><A HREF="DBBean.html#getNextRow()"><B>getNextRow()</B></A> -
180: Method in class <A HREF="DBBean.html">DBBean</A>
181: <DD>
182: <DT><A HREF="DBFront.html#getNextRow()"><B>getNextRow()</B></A> -
183: Method in class <A HREF="DBFront.html">DBFront</A>
184: <DD>
185: <DT><A HREF="DBFront.html#getQueryData()"><B>getQueryData()</B></A> -
186: Method in class <A HREF="DBFront.html">DBFront</A>
187: <DD>
188: <DT><A HREF="DBBean.html#getQueryData(java.lang.String)"><B>getQueryData(String)</B></A> -
189: Method in class <A HREF="DBBean.html">DBBean</A>
190: <DD>Returns the result for select * from table
191: with maxHits = 500 default value
192: <DT><A HREF="DBBean.html#getQueryData(java.lang.String, int)"><B>getQueryData(String, int)</B></A> -
193: Method in class <A HREF="DBBean.html">DBBean</A>
194: <DD>Returns the result of the query
195: or an Vector array of Vectors containing error messages
196: <DT><A HREF="DBBean.html#getTableNames()"><B>getTableNames()</B></A> -
197: Method in class <A HREF="DBBean.html">DBBean</A>
198: <DD>returns a Vector containing the Tablenames or an error message in the Vector
199: </DL>
200: <HR>
201: <A NAME="_M_"><!-- --></A><H2>
202: <B>M</B></H2>
203: <DL>
204: <DT><A HREF="FM.html#main(java.lang.String[])"><B>main(String[])</B></A> -
205: Static method in class <A HREF="FM.html">FM</A>
206: <DD>
207: <DT><A HREF="DBBean.html#makeQuery(java.lang.String, int)"><B>makeQuery(String, int)</B></A> -
208: Method in class <A HREF="DBBean.html">DBBean</A>
209: <DD>makes the database Query
210: with the numberOfHits as maximum
211: <DT><A HREF="DBBean.html#maxHits"><B>maxHits</B></A> -
212: Variable in class <A HREF="DBBean.html">DBBean</A>
213: <DD>
214: </DL>
215: <HR>
216: <A NAME="_O_"><!-- --></A><H2>
217: <B>O</B></H2>
218: <DL>
219: <DT><A HREF="FM.html#openLog()"><B>openLog()</B></A> -
220: Static method in class <A HREF="FM.html">FM</A>
221: <DD>open the log file (index.html)
222: </DL>
223: <HR>
224: <A NAME="_Q_"><!-- --></A><H2>
225: <B>Q</B></H2>
226: <DL>
227: <DT><A HREF="DBFront.html#query()"><B>query()</B></A> -
228: Method in class <A HREF="DBFront.html">DBFront</A>
229: <DD>
230: <DT><A HREF="DBFront.html#query(java.lang.String)"><B>query(String)</B></A> -
231: Method in class <A HREF="DBFront.html">DBFront</A>
232: <DD>
233: <DT><A HREF="DBFront.html#query(java.lang.String, java.lang.String)"><B>query(String, String)</B></A> -
234: Method in class <A HREF="DBFront.html">DBFront</A>
235: <DD>
236: </DL>
237: <HR>
238: <A NAME="_R_"><!-- --></A><H2>
239: <B>R</B></H2>
240: <DL>
241: <DT><A HREF="ResultWindow.html"><B>ResultWindow</B></A> - class <A HREF="ResultWindow.html">ResultWindow</A>.<DD>ResultWindow - used to display the results of the query<DT><A HREF="ResultWindow.html#ResultWindow(javax.swing.JFrame)"><B>ResultWindow(JFrame)</B></A> -
242: Constructor for class <A HREF="ResultWindow.html">ResultWindow</A>
243: <DD>Constructs the result Window with the JFrame argument as parent
244: </DL>
245: <HR>
246: <A NAME="_S_"><!-- --></A><H2>
247: <B>S</B></H2>
248: <DL>
249: <DT><A HREF="DBBean.html#setConnection(java.lang.String)"><B>setConnection(String)</B></A> -
250: Method in class <A HREF="DBBean.html">DBBean</A>
251: <DD>sets the connection of this DBBean to the database specified in the url
252: property
253: <DT><A HREF="DBFront.html#setConnection(java.lang.String)"><B>setConnection(String)</B></A> -
254: Method in class <A HREF="DBFront.html">DBFront</A>
255: <DD>
256: <DT><A HREF="DBBean.html#setConnection(java.lang.String, java.lang.String, java.lang.String)"><B>setConnection(String, String, String)</B></A> -
257: Method in class <A HREF="DBBean.html">DBBean</A>
258: <DD>sets the connection of this DBBean to the database specified in the url
259: and the url,user and passwd property of this DBBean instance
260: <DT><A HREF="DBFront.html#setConnection(java.lang.String, java.lang.String, java.lang.String)"><B>setConnection(String, String, String)</B></A> -
261: Method in class <A HREF="DBFront.html">DBFront</A>
262: <DD>
263: <DT><A HREF="TableComponent.html#setData(java.lang.Object[][])"><B>setData(Object[][])</B></A> -
264: Method in class <A HREF="TableComponent.html">TableComponent</A>
265: <DD>Fills the table with the array of Objects
266: <DT><A HREF="TableComponent.html#setEnabled(boolean)"><B>setEnabled(boolean)</B></A> -
267: Method in class <A HREF="TableComponent.html">TableComponent</A>
268: <DD>
269: <DT><A HREF="DBBean.html#setMaxHits(int)"><B>setMaxHits(int)</B></A> -
270: Method in class <A HREF="DBBean.html">DBBean</A>
271: <DD>sets the maximum number of hits
272: <DT><A HREF="DBBean.html#setPasswd(java.lang.String)"><B>setPasswd(String)</B></A> -
273: Method in class <A HREF="DBBean.html">DBBean</A>
274: <DD>sets the database passwd
275: <DT><A HREF="DBFront.html#setPasswd(java.lang.String)"><B>setPasswd(String)</B></A> -
276: Method in class <A HREF="DBFront.html">DBFront</A>
277: <DD>
278: <DT><A HREF="DBFront.html#setQuery(java.lang.String)"><B>setQuery(String)</B></A> -
279: Method in class <A HREF="DBFront.html">DBFront</A>
280: <DD>
281: <DT><A HREF="DBBean.html#setURL(java.lang.String)"><B>setURL(String)</B></A> -
282: Method in class <A HREF="DBBean.html">DBBean</A>
283: <DD>just sets the connection URL
284: <DT><A HREF="DBFront.html#setURL(java.lang.String)"><B>setURL(String)</B></A> -
285: Method in class <A HREF="DBFront.html">DBFront</A>
286: <DD>
287: <DT><A HREF="DBFront.html#setUrlAndQuery(java.lang.String, java.lang.String)"><B>setUrlAndQuery(String, String)</B></A> -
288: Method in class <A HREF="DBFront.html">DBFront</A>
289: <DD>
290: <DT><A HREF="DBBean.html#setUser(java.lang.String)"><B>setUser(String)</B></A> -
291: Method in class <A HREF="DBBean.html">DBBean</A>
292: <DD>sets the database user
293: <DT><A HREF="DBFront.html#setUser(java.lang.String)"><B>setUser(String)</B></A> -
294: Method in class <A HREF="DBFront.html">DBFront</A>
295: <DD>
296: <DT><A HREF="DBBean.html#setUserAndPasswd(java.lang.String, java.lang.String)"><B>setUserAndPasswd(String, String)</B></A> -
297: Method in class <A HREF="DBBean.html">DBBean</A>
298: <DD>sets the database user and passwd
299: <DT><A HREF="DBFront.html#setUserAndPasswd(java.lang.String, java.lang.String)"><B>setUserAndPasswd(String, String)</B></A> -
300: Method in class <A HREF="DBFront.html">DBFront</A>
301: <DD>
302: <DT><A HREF="TableComponent.html#sizeToFit(int, int)"><B>sizeToFit(int, int)</B></A> -
303: Method in class <A HREF="TableComponent.html">TableComponent</A>
304: <DD>
305: </DL>
306: <HR>
307: <A NAME="_T_"><!-- --></A><H2>
308: <B>T</B></H2>
309: <DL>
310: <DT><A HREF="FM.html#tableChanged(javax.swing.event.TableModelEvent)"><B>tableChanged(TableModelEvent)</B></A> -
311: Method in class <A HREF="FM.html">FM</A>
312: <DD>invoked then the user changes the table or the tableModel changes
313: <DT><A HREF="TableComponent.html#tableChanged(javax.swing.event.TableModelEvent)"><B>tableChanged(TableModelEvent)</B></A> -
314: Method in class <A HREF="TableComponent.html">TableComponent</A>
315: <DD>
316: <DT><A HREF="TableComponent.html"><B>TableComponent</B></A> - class <A HREF="TableComponent.html">TableComponent</A>.<DD>Table component<DT><A HREF="TableComponent.html#TableComponent()"><B>TableComponent()</B></A> -
317: Constructor for class <A HREF="TableComponent.html">TableComponent</A>
318: <DD>Constructs an empty table with default header and dummy data
319: <DT><A HREF="DBBean.html#TestDB(java.sql.DatabaseMetaData)"><B>TestDB(DatabaseMetaData)</B></A> -
320: Method in class <A HREF="DBBean.html">DBBean</A>
321: <DD>Test the database drivers features given by the DatabaseMetaData object
322: <DT><A HREF="FM.html#testQuery(java.lang.String)"><B>testQuery(String)</B></A> -
323: Method in class <A HREF="FM.html">FM</A>
324: <DD>Test the specified Query and display the result
325: </DL>
326: <HR>
327: <A NAME="_U_"><!-- --></A><H2>
328: <B>U</B></H2>
329: <DL>
330: <DT><A HREF="ResultWindow.html#updateResult(java.util.Vector, java.util.Vector)"><B>updateResult(Vector, Vector)</B></A> -
331: Method in class <A HREF="ResultWindow.html">ResultWindow</A>
332: <DD>Fills the table component of this window with new data
333: </DL>
334: <HR>
335: <A NAME="_W_"><!-- --></A><H2>
336: <B>W</B></H2>
337: <DL>
338: <DT><A HREF="ResultWindow.html#writeResult()"><B>writeResult()</B></A> -
339: Method in class <A HREF="ResultWindow.html">ResultWindow</A>
340: <DD>Actual write the result to a file( in HTML)
341: </DL>
342: <HR>
343: <A HREF="#_A_">A</A> <A HREF="#_C_">C</A> <A HREF="#_D_">D</A> <A HREF="#_E_">E</A> <A HREF="#_F_">F</A> <A HREF="#_G_">G</A> <A HREF="#_M_">M</A> <A HREF="#_O_">O</A> <A HREF="#_Q_">Q</A> <A HREF="#_R_">R</A> <A HREF="#_S_">S</A> <A HREF="#_T_">T</A> <A HREF="#_U_">U</A> <A HREF="#_W_">W</A>
344: <!-- ========== START OF NAVBAR ========== -->
345: <A NAME="navbar_bottom"><!-- --></A>
346: <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0">
347: <TR>
348: <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
349: <A NAME="navbar_bottom_firstrow"><!-- --></A>
350: <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3">
351: <TR ALIGN="center" VALIGN="top">
352: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <FONT CLASS="NavBarFont1">Class</FONT> </TD>
353: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="overview-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
354: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
355: <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Index</B></FONT> </TD>
356: <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
357: </TR>
358: </TABLE>
359: </TD>
360: <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
361: </EM>
362: </TD>
363: </TR>
364:
365: <TR>
366: <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
367: PREV
368: NEXT</FONT></TD>
369: <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
370: <A HREF="index.html" TARGET="_top"><B>FRAMES</B></A>
371: <A HREF="index-all.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD>
372: </TR>
373: </TABLE>
374: <!-- =========== END OF NAVBAR =========== -->
375:
376: <HR>
377:
378: </BODY>
379: </HTML>
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>