I've found code for DB Connectivity in
Java Apps but I haven't found any
Applet specific ones. Are there any special DB related additions I must include in applet code for it to work?
I ask this because I'm trying to connect to a mysql db from an applet and my applet will print only as far as "Attempting a connection..." and then will not print out any of the SQL table. My code looks like this:
import java.sql.*;
import java.applet.Applet;
import java.awt.*;
public class DBConnectApplet1 extends Applet {
public void paint(Graphics g) {
//try to load
JDBC driver
g.drawString("Attempting to load driver...",0,0);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
g.drawString("Driver Found",100,0);
}
catch(ClassNotFoundException ee) {
ee.printStackTrace();
g.drawString("Driver Not Found",100,0);
}
//attempt to establish connection with database
String url = "jdbc:mysql://localhost/thedew";
String user = "guest";
String password = "";
Connection con = null;
// open connection
try {
g.drawString("Attempting a connection...",0,50);
con = DriverManager.getConnection(url, user, password);
g.drawString("Connection Established",100,50);
}
catch(SQLException e) {
e.printStackTrace();
g.drawString("Connection Failed",100,50);
}
//issue SQL statements...
Anyone have ideas about why this is so. I've read that replacing localhost with your ip address works but it didn't seem to make a difference with me. Thanks.