Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

Java ODBC

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?

Name: Anonymous 2011-04-04 0:10

Bumping, because let's face it, the 2 threads above this are utter spam shit.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List