<p><span style=""><span style="font-size: 9pt;">对于事务隔离级别总结一下就是:</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></span></p>
<p><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></p>
<p style=""><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"><span style="">1,<span style='font: 7pt "Times New Roman";'> </span></span></span><span style="font-size: 9pt;"><span style="">读未提交(</span></span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">read uncommitted</span><span style=""><span style="font-size: 9pt;">),读的时候,允许其他事物写</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></span></p>
<p style=""><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"><span style="">2,<span style='font: 7pt "Times New Roman";'> </span></span></span><span style="font-size: 9pt;"><span style="">授权读取(</span></span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">Read Committed</span><span style=""><span style="font-size: 9pt;">),读的时候,不允许其他事务写,但可以读</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></span></p>
<p style=""><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"><span style="">3,<span style='font: 7pt "Times New Roman";'> </span></span></span><span style="font-size: 9pt;"><span style="">可重复读取(</span></span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">Repeatable Read</span><span style=""><span style="font-size: 9pt;">),读的时候,其他事务可以读,写得时候,其他事务不能读。有可能会出现幻读,比如在读取过程中,有另外的数据插入</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span lang="EN-US"><span style="font-family: Times New Roman;">4</span></span><span style="">,</span></span><span style="">序列化(</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">Serializable</span><span style="">):所有事物串行执行。</span></p>
<p><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></p>
<p style=""><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"><span style="">1,<span style='font: 7pt "Times New Roman";'> </span></span></span><span style="font-size: 9pt;"><span style="">读未提交(</span></span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">read uncommitted</span><span style=""><span style="font-size: 9pt;">),读的时候,允许其他事物写</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></span></p>
<p style=""><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"><span style="">2,<span style='font: 7pt "Times New Roman";'> </span></span></span><span style="font-size: 9pt;"><span style="">授权读取(</span></span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">Read Committed</span><span style=""><span style="font-size: 9pt;">),读的时候,不允许其他事务写,但可以读</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></span></p>
<p style=""><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"><span style="">3,<span style='font: 7pt "Times New Roman";'> </span></span></span><span style="font-size: 9pt;"><span style="">可重复读取(</span></span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">Repeatable Read</span><span style=""><span style="font-size: 9pt;">),读的时候,其他事务可以读,写得时候,其他事务不能读。有可能会出现幻读,比如在读取过程中,有另外的数据插入</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US"></span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span lang="EN-US"><span style="font-family: Times New Roman;">4</span></span><span style="">,</span></span><span style="">序列化(</span><span style="font-size: 9pt; font-family: Verdana;" lang="EN-US">Serializable</span><span style="">):所有事物串行执行。</span></p>