blocks|key|1382073|text|在执行DML语句时，应该使用executeUpdate/execute，而不是executeQuery。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1382074|以下是一个简短的比较：|1382075|​|1382076|📷|atomic|1382077|1382078|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/c4c93e900231c713035c061133d50793.png|imageAlt^0|E|D|S|7|13|C|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|14|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|15|8|@]|D|@$9|16|A|17|1|18]]|E|$]]|$1|M|3|I|5|6|7|19|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|O|$P|$5|Q|R|S|E|$T|U|V|-4]]]]

When executing DML statement , you should use <code>executeUpdate</code>/<code>execute</code> rather than <code>executeQuery</code>.

Here is a brief comparison :

<a href="https://i.stack.imgur.com/V6fjm.png" rel="noreferrer"><img src="https://i.stack.imgur.com/V6fjm.png" alt="executeQueryVSexecuteUpdateVSexecute"></a>

blocks|key|1382231|text|如果您使用的是spring+boot，只需添加一个@Modifying注释即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1382232|@Modifying
@Query
(value+=+"UPDATE+user+SET+middleName+=+'Mudd'+WHERE+id+=+1",+nativeQuery+=+true)
void+updateMiddleName();|code-block|syntax|javascript|1382233|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you're using spring boot, just add an @Modifying annotation. 

<pre><code>@Modifying
@Query
(value = "UPDATE user SET middleName = 'Mudd' WHERE id = 1", nativeQuery = true)
void updateMiddleName();
</code></pre>

blocks|key|1381974|text|使用executeUpdate()发出数据操作语句。executeQuery()仅用于SELECT查询(即返回结果集的查询)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1381975|entityMap^0|2|F|Q|E|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Use <code>executeUpdate()</code> to issue data manipulation statements. <code>executeQuery()</code> is only meant for SELECT queries (i.e. queries that return a result set).

blocks|key|1167025|text|这就是executeUpdate的作用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1167026|这里是一个非常简短的区别总结：http://www.coderanch.com/t/301594/JDBC/java/Difference-between-execute-executeQuery-executeUpdate|1167027|entityMap|0|LINK|mutability|MUTABLE|url|http://www.coderanch.com/t/301594/JDBC/java/Difference-between-execute-executeQuery-executeUpdate^0|3|D|0|F|2P|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@$9|T|A|U|1|V]]|E|$]]|$1|H|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

That's what <code>executeUpdate</code> is for.

Here's a very brief summary of the difference: <a href="http://www.coderanch.com/t/301594/JDBC/java/Difference-between-execute-executeQuery-executeUpdate" rel="noreferrer">http://www.coderanch.com/t/301594/JDBC/java/Difference-between-execute-executeQuery-executeUpdate</a>

blocks|key|1167281|text|下面的代码适用于我:我使用INSERT设置值，使用SELECT获得该值的LAST_INSERT_ID()；我使用java+NetBeans+8.1、MySql和java.JDBC.driver|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1167282|++++++++++++++++try+{

++++++++String+Query+=+"INSERT+INTO+`stock`(`stock`,+`min_stock`,+++
++++++++++++++++`id_stock`)+VALUES+("

++++++++++++++++%2B+"\""+%2B+p.get_Stock().getStock()+%2B+"\",+"
++++++++++++++++%2B+"\""+%2B+p.get_Stock().getStockMinimo()+%2B+"\","
++++++++++++++++%2B+""+%2B+"null"+%2B+")";

++++++++Statement+st+=+miConexion.createStatement();
++++++++st.executeUpdate(Query);

++++++++java.sql.ResultSet+rs;
++++++++rs+=+st.executeQuery("Select+LAST_INSERT_ID()+from+stock+limit+1");++++++++++++++++
++++++++rs.next();+//para+posicionar+el+puntero+en+la+primer+fila
++++++++ultimo_id+=+rs.getInt("LAST_INSERT_ID()");
++++++++}+catch+(SqlException+ex)+{+ex.printTrace;}|code-block|syntax|javascript|1167283|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This code works for me: I set values whit an INSERT and get the LAST_INSERT_ID() of this value whit a SELECT; I use java NetBeans 8.1, MySql and java.JDBC.driver 

<pre><code> try {

 String Query = "INSERT INTO `stock`(`stock`, `min_stock`, 
 `id_stock`) VALUES ("

 + "\"" + p.get_Stock().getStock() + "\", "
 + "\"" + p.get_Stock().getStockMinimo() + "\","
 + "" + "null" + ")";

 Statement st = miConexion.createStatement();
 st.executeUpdate(Query);

 java.sql.ResultSet rs;
 rs = st.executeQuery("Select LAST_INSERT_ID() from stock limit 1"); 
 rs.next(); //para posicionar el puntero en la primer fila
 ultimo_id = rs.getInt("LAST_INSERT_ID()");
 } catch (SqlException ex) { ex.printTrace;}
</code></pre>

blocks|key|1167401|text|@Modifying
@Transactional
@Query(value+=+"delete+from+cart_item+where+cart_cart_id=:cart",+nativeQuery+=+true)
public+void+deleteByCart(@Param("cart")+int+cart);+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1167402|别忘了在@query前添加@Modifying和@跨国公司。这对我很管用。|unstyled|1167403|要在JPA中使用原生查询来删除带有某些条件的记录，上面提到的注释很重要。|1167404|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre class="lang-java prettyprint-override"><code>@Modifying
@Transactional
@Query(value = "delete from cart_item where cart_cart_id=:cart", nativeQuery = true)
public void deleteByCart(@Param("cart") int cart); 
</code></pre>

Do not forget to add @Modifying and @Transnational before @query. it works for me.

To delete the record with some condition using native query with JPA the above mentioned annotations are important.

blocks|key|1167057|text|executeQuery()返回一个ResultSet。我不太熟悉Java/MySQL，但是要创建索引，您可能需要一个executeUpdate()。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1167058|entityMap^0|0|E|I|9|1N|F|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

<code>executeQuery()</code> returns a <code>ResultSet</code>. I'm not as familiar with Java/MySQL, but to create indexes you probably want a <code>executeUpdate()</code>.

blocks|key|1382295|text|Connection+conn+=+DriverManager.getConnection("jdbc:mysql://localhost:3306/java_swing_db",+"root",+"root");

Statement+smt+=+conn.createStatement();

String+sql+=+"SELECT+*+FROM+`users`+WHERE+`email`+=+"+%2B+email+%2B+"+AND+`password`+=+"+%2B+password+%2B+"+LIMIT+1;";

String+registerSql+=+"INSERT+INTO+`users`(`email`,+`password`,+`name`)+VALUES+('"+%2B+email+%2B+"','"+%2B+password+%2B+"','"+%2B+name+%2B+"')";

System.out.println("SQL:+"+%2B+registerSql);
++++++++++++
int+result+=+smt.executeUpdate(registerSql);
System.out.println("Result:+"+%2B+result);

if+(result+==+0)+{
+++JOptionPane.showMessageDialog(this,+"This+is+alredy+exist");
}+else+{
++JOptionPane.showMessageDialog(this,+"Welcome,+Your+account+is+sucessfully+created");
++App.isLogin+=+true;
++this.dispose();
++new+HomeFrame().show();
}
conn.close();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1382296|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Connection conn = DriverManager.getConnection(&quot;jdbc:mysql://localhost:3306/java_swing_db&quot;, &quot;root&quot;, &quot;root&quot;);

Statement smt = conn.createStatement();

String sql = &quot;SELECT * FROM `users` WHERE `email` = &quot; + email + &quot; AND `password` = &quot; + password + &quot; LIMIT 1;&quot;;

String registerSql = &quot;INSERT INTO `users`(`email`, `password`, `name`) VALUES ('&quot; + email + &quot;','&quot; + password + &quot;','&quot; + name + &quot;')&quot;;

System.out.println(&quot;SQL: &quot; + registerSql);
 
int result = smt.executeUpdate(registerSql);
System.out.println(&quot;Result: &quot; + result);

if (result == 0) {
 JOptionPane.showMessageDialog(this, &quot;This is alredy exist&quot;);
} else {
 JOptionPane.showMessageDialog(this, &quot;Welcome, Your account is sucessfully created&quot;);
 App.isLogin = true;
 this.dispose();
 new HomeFrame().show();
}
conn.close();
</code></pre>

blocks|key|1167113|text|除了圆括号中的executeUpdate()之外，还必须添加一个变量才能使用SQL语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1167114|例如：|1167115|PreparedStatement+pst+=++connection.prepareStatement(sql);
int+numRowsChanged+=+pst.executeUpdate(sql);|code-block|syntax|javascript|1167116|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Besides executeUpdate() on the parentheses, you must also add a variable to use an SQL statement.

For example:

<pre><code>PreparedStatement pst = connection.prepareStatement(sql);
int numRowsChanged = pst.executeUpdate(sql);
</code></pre>

In MySQL I have two tables, <code>tableA</code> and <code>tableB</code>. I am trying to execute two queries:

<pre><code>executeQuery(query1) 
executeQuery(query2)
</code></pre>

But I get the following error:

<pre><code>can not issue data manipulation statements with executeQuery().
</code></pre>

What does this mean?

Cannot issue data manipulation statements with executeQuery()

在MySQL中，我有两个表：tableA和tableB。我正在尝试执行两个查询：executeQuery(query1) executeQuery(query2)但我得到以下错误：can not issue data manipulation statements with executeQuery().这是什么意思？

问无法使用executeQuery()发出数据操作语句
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法使用executeQuery()发出数据操作语句EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法使用executeQuery()发出数据操作语句
EN