For inserting to DB you can’t use stmt.executeQuery method, you must use stmt.executeUpdate( sqlStatment ).Meanwhile you must commit any changes in Oracle ,you can do it with stmt.executeUpdate( “commit” ) or you can set auto commit to true. You can do it with this instruction conn.setAutoCommit(true).please check its syntax.



I hope this can help you, let me know if you have any problem.

thank you very much for your help. I did it by your
instruction. there is an Incompatible types error with
this phrase:

rset=stmt.executeUpdate("insert into kairegistration
values ('"+studentid+"','"+coursenumber+"')");

I have slightly modified your code example (see the attachment) ->
ie. the update/insert returns an INT, not a ResultSet.
The error you are reffering to (incompatible types) could be related
to how your 'kairegistration' table fields look like. In your INSERT
statement all data are inserted as String. If the DB field type is a
NUMBER (for example), you have to add your argument as a number as
well (therefore without the quotation marks around).
So check out the definition of your DB table and try the modified
example again.

the modified code lines:

1. stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
2. try {
StringBuffer sql = new StringBuffer();
String sqlString = "";
sql.append("insert into kairegistration values ('");
sql.append(studentid);
sql.append("','");
sql.append(coursenumber);
sql.append("')");
sqlString = sql.toString();

int resultDB = stmt.executeUpdate(sqlString);
}