Using Java to connect to local host

[gerrybytes]

Hi all,

I created a Java application which allows me to send information to my mysql database using the jdbc connector via a JFrame. However when i modified the file to be a JApplet the info will not sent and i cannot connect to the database? Any particular reason for this?
I need it to be a JApplet so i can add it to a browser window.

private void save ()
{
Connection conn = null;
 
try
{
Statement stmt;
String userName = "root";
String password = "PASSWORD";
String url = "jdbc:mysql://localhost:3306/DATABASE";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url, userName, password);
System.out.println ("Database connection established");
 
//Get a statement object
stmt = conn.createStatement();
 
stmt.executeUpdate(    "INSERT INTO TABLE(Info i know to put in) VALUES('Values i know to put in')");
}
catch (Exception e)
{
System.err.println ("Cannot connect to database server");
  }
finally
    {if (conn != null)
          {try
               {conn.close ();                
System.out.println ("Database connection terminated");
    }
                catch (Exception e) { /* ignore close errors*/  }
     }
   }
}
 

As i said above it works as a JFrame but not as a JApplet. Any help would be great.

Thanks G.

[nomad]

Hi all,

I created a Java application which allows me to send information to my mysql database using the jdbc connector via a JFrame. However when i modified the file to be a JApplet the info will not sent and i cannot connect to the database? Any particular reason for this?
I need it to be a JApplet so i can add it to a browser window.

private void save ()
{
Connection conn = null;
 
try
{
Statement stmt;
String userName = "root";
String password = "PASSWORD";
String url = "jdbc:mysql://localhost:3306/DATABASE";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url, userName, password);
System.out.println ("Database connection established");
 
//Get a statement object
stmt = conn.createStatement();
 
stmt.executeUpdate(    "INSERT INTO TABLE(Info i know to put in) VALUES('Values i know to put in')");
}
catch (Exception e)
{
System.err.println ("Cannot connect to database server");
  }
finally
    {if (conn != null)
          {try
               {conn.close ();                
System.out.println ("Database connection terminated");
    }
                catch (Exception e) { /* ignore close errors*/  }
     }
   }
}
 

As i said above it works as a JFrame but not as a JApplet. Any help would be great.

Thanks G.

do a google search on this one JApplet and Database. You will find a couple solutions that will help you. One is called Signed

nomad

[gerrybytes]

Hi Nomad,

I know about signing applets. I've done this ok and i get no error messages returned.

Could it be, because i'm connecting directly to the local host or should i use the ip address?

G

[ajos]

Hi Nomad,

I know about signing applets. I've done this ok and i get no error messages returned.

Could it be, because i'm connecting directly to the local host or should i use the ip address?

G

How about printing the stacktrace instead of leaving it empty.ip is not required here. check the mysql docs to connect to a java application/applet.