I am trying to do an Insert, Update and Delete on a table in MS Access. Everything works fine

for a SELECT statement. But when doing the other three operations, I don't seem to get any

errors, but the actions are not reflected on to the DB. Please help...

THe INSERT statement is as follows:

PreparedStatement ps = con.prepareStatement("INSERT INTO Student VALUES (?, ?, ?, ?, ?,      

?, ?, ?)");

    ps.setInt(1,1);

    ps.setString(2,"ish");

    ps.setInt(3,100);

    ps.setInt(4,100);

    ps.setInt(5,100);

    ps.setInt(6,300);

        ps.setInt(7,100);

    ps.setString(8,"A"); 

    ps.executeUpdate();

Also may I know why PreparedStatement is used except for SELECT statement...