NullPointerException with stmt.executeUpdate

[Anonymous]

Hello,
Wondering why I get a NullPointerException when executing:
stmt.executeUpdate("INSERT INTO PEOPLE (PRI,LOGIN_TYPE) VALUES ('2123','234')");
The complete code is:

import java.sql.*;
import tis.*;
public class trash {
  public static void main(String args []){
    Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           con = DriverManager.getConnection
                      ("jdbc  [img]http://www.javaranch.com/ubb/redface.gif[/img]dbc:tg", "uh", "pass");
           stmt.executeUpdate("INSERT INTO PEOPLE 
                      (PRI,LOGIN_TYPE) VALUES ('2123','234')");
        } catch  (java.lang.ClassNotFoundException e) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
        } catch (SQLException e) {
            System.err.print("SQL exception: ");
            System.err.println(e.getMessage());
        } finally {
            // Always close the database connection.
            try {
if (con != null) {
                   con.close();
                }
            } catch (SQLException ignored) { }
        }
    }
}

[This message has been edited by Yoo-Jin, Lee (edited July 07, 2000).]

[Milind Kulkarni]

Hi Lee,
Insert the following line -
Statement stmt = con.createStatement ();
before
stmt.executeUpdate("INSERT INTO PEOPLE (PRI,LOGIN_TYPE) VALUES ('2123','234')");

Also change the above line as follows:
int i = stmt.executeUpdate("INSERT INTO PEOPLE (PRI,LOGIN_TYPE) VALUES ('2123','234')");

Hope this helps !!
Regards,
Milind

[This message has been edited by Milind Kulkarni (edited July 07, 2000).]