There is security problem here. The COFFEEBREAK serving
MySQL server sits on a different machine than the WWW server.
See the <A HREF="http://www.intersolv.com/datadirect/shared/wp/wp_dd_jdbc1.html">Deploying Java and JDBC</A> article from DataDirect.
<STRONG>Replace "tecfa" by "tecfa2" in the URL if needed !</STRONG>
.... or just click on the URLs below.
<P>
The source is listed above (or in the <A HREF=""./"">directory</A>):
<UL>
  <LI> 
Simple "query-line" example (will not work for everything):
<pre>
<A HREF="http://tecfa2.unige.ch/guides/java/staf2x/ex/jdbc/coffee-break/simple-query-applet/MySqlQueryLineApplet.html">MySqlQueryLineApplet.html</A>
</pre>
</LI>

  <LI> 
Simple "query-update-lines" example. Allows both queries and updates.
<pre>
<A HREF="http://tecfa2.unige.ch/guides/java/staf2x/ex/jdbc/coffee-break/simple-query-applet/MySqlUpdateLineApplet.html">MySqlUpdateLineApplet.html</A>
</pre>

 </LI>


  <LI> 
Simple "query-update-lines" example with Swing, same as above but much
prettier (needs swing 1.1 installed / or the Netscape/Java plugin).
Needs more work, but the general ideas ought to be more or less ok.
<pre>
<A HREF="http://tecfa2.unige.ch/guides/java/staf2x/ex/jdbc/coffee-break/simple-query-applet/MySqlUpdateSwingApplet.html">MySqlUpdateSwingApplet.html</A>
</pre>

 </LI>

  <LI>Simple "query-update-lines" example with Swing, same as above 
but with a misunderstanding of the potential Abstract Table Model. Well at
least it shows how to add or remove components in a Panel and how to
map a simple 2D array + labels onto a JTable ...
<pre>
<A HREF="http://tecfa2.unige.ch/guides/java/staf2x/ex/jdbc/coffee-break/simple-query-applet/MySqlUpdateSwingApplet01.html">MySqlUpdateSwingApplet01.html</A>
</pre>
</LI>


</UL>
<hr>

<ADDRESS>
  <A NAME="Signature"
     HREF="http://tecfa.unige.ch/tecfa-people/schneider.html">D.K.S.</A>
</ADDRESS>