Dovrei cancellare un record di un database e uso
public void delete(String user,int id_news)
{
Connetti();
PreparedStatement delete_news;
try
{
delete_news=conn.prepareStatement("DELETE FROM TOSEND WHERE TOSEND.User=? AND TOSEND.Id_news=?");
delete_news.setString(1,user);
delete_news.setInt(2,id_news);
ResultSet rs=delete_news.executeQuery();
} catch (SQLException e)
{e.printStackTrace();
System.out.println("errore eliminazione record news.");
chiudi();
}
}
ma mi genera sempre l'eccezione:
No ResultSet was produced
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQue ry(JdbcOdbcPreparedStatement.java:97)
at GestoreDB.delete(GestoreDB.java:63)
at Receive.run(Receive.java:80)
anche se alla fine il record lo cancella...