c#连接oracle数据库时执行更新操作无效?
代码如下
public int Update1()
{
OracleConnection conn = new OracleConnection(@"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.18.11.222)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));User Id=system;Password=manager");
conn.Open();
string sql = "update system.users set name='www',pwd='bbb' where id=1";
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
int result = cmd.ExecuteNonQuery();
conn.Close();
return result;
}
返回值影响行数为零行,我的数据库里确实存在id=1的记录