blocks|key|195699|text|如何使用execute()方法实现该结果。|type|blockquote|depth|inlineStyleRanges|entityRanges|data|195700|不能。只有当结果有一个true时，它才会返回ResultSet。如果插入有问题，该方法将引发异常。来自文档|unstyled|offset|length|style|CODE|195701|布尔执行(String)抛出SQLException
返回：
如果第一个结果是对象，则为true；如果为更新计数，则为false或没有结果
抛出：
SQLException+-如果发生数据库访问错误，则在关闭语句上调用此方法，在PreparedStatement或CallableStatement上调用该方法。
SQLTimeoutException+-当驱动程序确定超过了setQueryTimeout方法指定的超时值，并且至少试图取消当前运行的语句时|BOLD|195702|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#execute%2528java.lang.String%2529^0|0|B|4|M|9|1F|2|0|0|13|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@$E|V|F|W|G|H]|$E|X|F|Y|G|H]]|9|@$E|Z|F|10|1|11]]|A|$]]|$1|I|3|J|5|6|7|12|8|@$E|13|F|14|G|K]]|9|@]|A|$]]|$1|L|3|-4|5|D|7|15|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

<blockquote>
How can I achieve that result using execute() method.
</blockquote>
You can't. It will only return <code>true</code> if the result has a <code>ResultSet</code>. If there is a problem with your insertion, the method will throw an exception. From the <a href="http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#execute%28java.lang.String%29" rel="noreferrer">documentation</a>:
<blockquote>
boolean execute(String sql) throws SQLException
Returns:
true if the first result is a ResultSet object; false if it is an update count or there are no results
Throws:
SQLException - if a database access error occurs, this method is called on a closed Statement, the method is called on a PreparedStatement or CallableStatement
SQLTimeoutException - when the driver has determined that the timeout value that was specified by the setQueryTimeout method has been exceeded and has at least attempted to cancel the currently running Statement
</blockquote>

blocks|key|195665|text|尝试在executeUpdate()上使用Statement方法。它应该返回一个int，指示行数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|195666|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#executeUpdate(java.lang.String)^0|L|9|3|F|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

Try using <a href="http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#executeUpdate(java.lang.String)" rel="nofollow">executeUpdate()</a> method on the <code>Statement</code>. It should return you a int indicating the number of rows.

blocks|key|1241179|text|如果第一个结果是Statement.ececute()对象，则返回ResultSet；如果是更新计数或没有结果，则返回false。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1241180|您可以使用|1241181|int+executeUpdate(String+sql)|blockquote|BOLD|1241182|返回|1241183|1)+SQL数据操作语言(DML)语句的行计数或
2)+0对于不返回任何内容的SQL语句|1241184|文档|1241185|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html^0|8|J|0|0|0|T|0|0|0|0|2|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|12|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|13|8|@$9|14|A|15|B|K]]|D|@]|E|$]]|$1|L|3|M|5|6|7|16|8|@]|D|@]|E|$]]|$1|N|3|O|5|J|7|17|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|18|8|@]|D|@$9|19|A|1A|1|1B]]|E|$]]|$1|R|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]]|S|$T|$5|U|V|W|E|$X|Y]]]]

<code>Statement.ececute()</code> will return true if the first result is a ResultSet object, false if it is an update count or there are no results

You can use

<blockquote>
 int executeUpdate(String sql)
</blockquote>

returns

<blockquote>
 1) the row count for SQL Data Manipulation Language (DML) statements
 or
 
 2) 0 for SQL statements that return nothing
</blockquote>

<a href="http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html" rel="nofollow">Docs</a>

blocks|key|2538898|text|如果它不是select查询，则不能。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2538899|医生就是这么说的|2538900|Returns:++
true+if+the+first+result+is+a+ResultSet+object;+false+if+it+is+an+update+count+or+there+are+no+results`.|code-block|syntax|javascript|2538901|当您提供select查询时，而不是在insert或update时，您将得到一个结果集，如果出现这种类型的查询，您将得到false。|2538902|现在，为了确保它是否成功运行，我想使用e+Exceptions将对您有所帮助。|offset|length|style|CODE|2538903|使用executeUpdate()会给出行数，所以您可以使用它来预测。|2538904|entityMap^0|0|0|0|0|L|A|0|2|F|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|Y|8|@$M|Z|N|10|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|11|8|@$M|12|N|13|O|P]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

You cant if it is not a select query. 
This is what said in the doc

<pre><code>Returns: 
true if the first result is a ResultSet object; false if it is an update count or there are no results`.
</code></pre>

You will get a result set when you give a select query not when insert or update, you will get false always in case of these type of query . 
Now to make it sure if its run successfully or not i guess working with e <code>Exceptions</code> will help you 

Using <code>executeUpdate()</code> will give you the row count so you can use that to predict.

blocks|key|2538934|text|您正在执行insert语句，如果有一个结果集具有从execute语句返回的值，则会有一个结果。检查文件|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2538935|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#execute(java.lang.String)^0|1B|4|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You are doing an insert statement, If there is an resultset that has values returning from the execute statement there will be a result. <a href="http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#execute(java.lang.String)" rel="nofollow">Check the documentation</a>

I have Statement object called stmt, Connection object conn.

<pre><code>stmt = conn.createStatement();
boolean b = stmt.execute("INSERT INTO employee VALUES('E001', 'Smith')")
</code></pre>

But this always produce false. I want true if above query executed successfully and false if the query fails executing. How can I achieve that result using execute() method.

how to get true or false using execute() in Java Statement

33 天实现自己的 AI 进化论？发文瓜分机械键盘、耳机等万元奖池！点击参加活动：<a href="https://cloud.tencent.com/developer/article/2503022" target="_blank">https://cloud.tencent.com/developer/article/2503022</a> 
 <img src="https://qcloudimg.tencent-cloud.cn/raw/01543e0407db10898a7ee9f420794432.jpg"/>

技术创作特训营有奖征文

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云AI代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

文章&问答评论现已支持表情

我有语句对象，称为stmt，Connection object conn。stmt = conn.createStatement();boolean b = stmt.execute("INSERT INTO employee VALUES('E001', 'Smith')")但这总是产生假。如果上述查询成功执行，则需要true，如果查询执行失败，则需要false。如何使用execute()方法实

问如何在Java语句中使用execute()获得真或假
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Java语句中使用execute()获得真或假EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Java语句中使用execute()获得真或假
EN