Here is my code :
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class BirthdayApplet extends JApplet {
Connection conn;
public void init()
{
setLayout(new FlowLayout());
JButton test = new JButton("Click Me!");
testButton happy = new testButton();
test.addActionListener(happy);
add(test);
try
{
// Load the driver
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
// Connect to the database
conn = DriverManager.getConnection("jdbc:mysql://mysql9.ixwebhosting.com/net20_java", "mat2", "yay1");
}
catch (Exception e) {add(new JLabel(e.getMessage()));}
}
public void start()
{
}
public void stop()
{
}
public void destroy()
{
}
private class testButton implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
try {
conn.createStatement().execute("INSERT INTO `people` (`name`, `address`) VALUES ('Start Here', '52 Woot Ave')");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} //Insert a row
}
}
}
I copied all of my class files into a folder as well as the mysql connector files. I wrote up a quick html to test it with this code :
<applet code=BirthdayApplet.class
archive="mysql-connector-java-5.1.7-bin.jar"
width=800 height=600>
</applet>
I've gotten various errors trying to get this to work but with the current configuration it gives me : Communications Link Failure last packet sent to server was 0ms ago.
Project still accesses database without a problem from eclipse and works fine.
Would appreciate any suggestions.
Thank you
This post has been edited by corsen2000: 30 March 2009 - 04:10 PM

Start a new topic
Add Reply




MultiQuote
| 


