I have the written the following code:
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
public class ProjTest extends JApplet implements ActionListener
{
JButton btOK;
Connection con;
Statement stat;
String url = "jdbc
dbc
rojTest";
String data = "Insert into Emp_Details " +
"Values('Patrick', 'Mugabe', 'E231', 'Programmer')";
public void init()
{
Container cp = getContentPane();
cp.setLayout(new FlowLayout());
btOK = new JButton("Click");
cp.add(btOK);
btOK.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception ex)
{
getAppletContext().showStatus("Error on connection" +
ex.getMessage());
}
try
{
Connection con = DriverManager.getConnection(url, "", "");
stat = con.createStatement();
stat.executeUpdate(data);
}
catch(SQLException conex)
{
showStatus("Error reported " + conex.getMessage());
}
catch(Exception exc)
{
showStatus("check for data errors"); }
}
}
When I click the button (btOK) to insert data into my database, I am getting the following error:
Error reported No suitable driver.
Please help me on how I can overcome this error.