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