sql2=" UPDATE sigining_contract SET accumulated_amount='%d',accumulated_pay='%d',discount=(contract_amount-'%d') where contract_origin='%s'"%(JT,PT,PT,str(name)) 心有猛虎,细嗅蔷薇
...
--SELECT stuid FROM dbo.BZList WHERE AreaOrganID=-1 AND AreaPointCode=-1 AND DeptOrganID=-1
SELECT bzid,stuid, BZKTypeID, BZKTypeName, BZDate, BZData, BZRemark, PointCode FROM dbo.BZList WHERE ...
以下示例将展示如何使用Spring jdbc执行更新数据库表的记录，这里演示如何更新student表中指定条件的记录。
语法：
String updateQuery = "update Student set age = ? where id = ?";
jdbcTemplateObject.update(u...
