With SQL, you would use a single UPDATE command.
使用SQL,您将使用单个update命令。
You may have noticed that Listing 6 never executes the PreparedStatement that you constructed for the SQL UPDATE command.
您可能已经注意到清单6从未执行您为SQL UPDATE 命令构造的PreparedStatement。
He opens a command line window, connects to the SAMPLE database and unsuccessfully tries to update the employee salaries in the employee table. He issues the following SQL statements.
他打开一个命令行窗口,连接到SAMPLE数据库,并尝试更新employee表中的雇员工资(当然这样的尝试会遭到失败)。
Next, you construct an SQL command to update the target row by using an SQL update statement, with a WHERE CURRENT OF clause.
接下来,构造SQL命令来更新目标行,方法为使用带有WHERECURRENTOF子句的SQL update语句。
There are several ways to do this, but usually it consists of building a custom SQL command to be used as an update statement for the EMPLOYEE table.
有多种方法可完成该工作,但通常都包含构建一个定制的SQL命令,作为update语句用于EMPLOYEE表。
Listing 8 shows how to extract the customerid from the XML and use it to create an update SQL command for the database.
清单8演示如何从XML中提取出customerid并用它创建更新数据库的sql语句。
Listing 8 shows how to extract the customerid from the XML and use it to create an update SQL command for the database.
清单8演示如何从XML中提取出customerid并用它创建更新数据库的sql语句。
应用推荐