学习笔记:关于" No ResultSet was produced"

statement提供方法executeUpdate做insert,delete,update操作，返回值为int;
executeQuery执行静态的sql查询语句，返回值为ResultSet

for example:

Statement stmt = conn.createStatement();
String sqlDelete = "delete from t_message where messageid='"+ids+"'";
stmt.executeQuery(sqlDelete);

以上代码会出现" No ResultSet was produced"的错误;

所以,executeQuery()是执行Select语句的,而executeUpdate则用于执行 insert,delete,update语句.