Whenever I try either to insert new record of update existing record in the database it produces NoResultSet-Produce error but it makes effect in database. How to resolve this problem. The code I have used is as below:
Code:
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:MarksheetDB", " ", "222222"); Statement st = con.createStatement(); String sql="update valueTable set field1='value1', field2='value2' where ID = 1"; ResultSet rs = st.executeQuery(sql); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); }
Comment