Name: Anonymous 2011-04-03 23:00
package homework3;
import java.sql.*;
import javax.swing.JOptionPane;
public class hw3_2 {
public static void main(String args[])
{
//Variables for database insert set by JOptionpane data input
String course = JOptionPane.showInputDialog(null, "Course ID:");
String desc = JOptionPane.showInputDialog(null, "Description:");
String cred = JOptionPane.showInputDialog(null, "Credits:");
int credits = Integer.parseInt(cred);
//DB Connection
String url = "jdbc:odbc:registrar";
Connection con;
Statement stat;
String insert;
insert = "INSERT INTO courses VALUES ('" + course + "','" + desc + "','" + credits + "');";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try
{
con = DriverManager.getConnection(url, "", "");
stat = con.createStatement();
ResultSet rs = stat.executeQuery(insert);
System.out.println("Data successfully added to Courses table.");
stat.close();
con.close();
}
catch (SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
}
}
}The insert query works as intended, however I'm getting "SQLException: General error" from the 2nd catch - what error is it catching?