OracleConnection oracleConnection = new OracleConnection(jbdcConnectionString);oracleConnection.Open();string updateSql = "update tco_msg_send set send_flag = 1 where send_content = '針對tset”事件'";OracleCommand updateCmd = new OracleCommand(updateSql, oracleConnection);int i = updateCmd.ExecuteNonQuery();if (i > 0){sb.Append("更新狀態:rownum為" + id + "的消息狀態已更新\r\n\r\n");}else{sb.Append("更新狀態:rownum為" + id + "的消息狀態未更新或已不存在\r\n\r\n");}oracleConnection.Close();
在調用方法updateCmd.ExecuteNonQuery()執行更新語句時不報錯誤也不執行
森林海
2018-08-08 11:14:28