悲观观定SQL Server和Oracle_ORACLE_学习笔记★闵涛★计算机学习电脑编程软硬件技巧


	转至繁体中文版	\| 网站首页 \| 图文教程 \| 资源下载 \| 站长博客 \| 图片素材 \| 武汉seo \| 武汉网站优化 \|

悲观观定SQL Server和Oracle

作者：闵涛文章来源：闵涛的学习笔记点击数：1396 更新时间：2009/4/22 22:03:36

author:wuxiuxiang;
Email:imessage@126.com

using System;
using System.Data;
namespace com.cuc.wu.example
{
   public class class1
   {
  //For SQL Server 需要与Connection相关的一个Transaction的隔离级别为
    //Repeatable Read或Serializable,对于Oracle,在Command中使用select for update即可
       public void LockedSQLDataRow()
       {
           DataSet ds = new DataSet();
           SqlConnection sconn = new SqlConnection("server=localhost;uid=sa;pwd=sa;database=pubs");
           sconn.Open();
           SqlTransaction tx = new sconn.BeginTransaction(IsolationLevel.Serializable);

           SqlCommand cmd = new SqlCommand("select * from authors",conn,tx);
           SqlDataAdapter da = new SqlDataAdapter(cmd);
           da.Fill(ds,"autors");
           //rows locked here

           ds.Tables[0].Rows[1][2]="Free";

           SqlCommandBuilder bld = new SqlCommandBuilder(da);
           da.Update(ds,"authors");
           tx.commit();
           //rows unlocked here
           da.Dispose();
           conn.Close();//ÏÔÊ½ÊÍ·Å×ÊÔ´
       }
       public void LockedORADataRow()
       {
           DataSet ds = new DataSet();
           OleDbConnection oconn = new OleDbConnection("provider=msdaora;data source=ocr11;user id=scott;password=tiger");
           conn.Open();

           OleDbTransaction tx = oconn.BeginTransaction();
           OleDbCommand cmd = new OleDbCommand("select * form emp for update ",conn,tx);

           OleDbDataAdapter da = new OleDbDataAdapter(cmd);
           da.Fill(ds,"emp");