事务处理和非事务处理方法代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】事务处理和非事务处理方法

作者:汶纡 / 发布于2014/11/18/ 380


	String connectionString = ConfigurationManager.ConnectionStrings["DB_Constr"].ToString();
	SqlConnection conn = null;
	SqlTransaction trans = null;
	try {
	 conn = new SqlConnection(connectionString);
	 if (conn.State != ConnectionState.Open) conn.Open();
	 //开启事务，可以指定事无级别。默认为提交才可以查询
	 trans = conn.BeginTransaction();
	 //save(conn, trans);
	 DbUtils.commit(trans);
	} catch (Exception ex) {
	 DbUtils.rollback(trans);
	 ClientScript.RegisterStartupScript(this.GetType(), "错误提示", "<script>alert('" + StringUtil.toJsStr(ex.Message) + "');</script>");
	} finally {
	 DbUtils.closeQuietly(conn, trans);
	}
	
	
	String connectionString = ConfigurationManager.ConnectionStrings["DB_Constr"].ToString();
	SqlConnection conn = null;
	try {
	 conn = new SqlConnection(connectionString);
	 if (conn.State != ConnectionState.Open) conn.Open();
	
	
	
	} catch (Exception ex) {
	 ScriptManager.RegisterStartupScript(this, this.GetType(), "mess", "<script>alert('"+StringUtil.toJsStr(ex.Message)+"')</script>", false);
	} finally {
	 DbUtils.closeQuietly(conn);
	}

	

	

	using System;
	using System.Collections.Generic;
	using System.Text;
	
	namespace Tools{
	 public sealed class StringUtil {
	
	 public static bool isEmpty(String str) {
	 if (str == null) return true;
	 if (str.Length == 0) return true;
	 if (str == String.Empty) return true;
	 return false;
	 }
	 public static bool isNotEmpty(String str) {
	 return !isEmpty(str);
	 }
	
	 public static String toJsStr(String str) {
	 str = str.Replace("'", "\\'");
	 str = str.Replace("\r", "");
	 str = str.Replace("\n", "\\n");
	 return str;
	 }
	
	 public static void Main() {
	 Console.Write(isNotEmpty(null));
	 Console.Read();
	 }
	
	 }
	}

	

	using System;
	using System.Collections.Generic;
	using System.Text;
	using System.Data.SqlClient;
	using System.Data;
	
	namespace Tools{
	 public class DbUtils {
	 public static SqlConnection getConnection(string connectstr) {
	 SqlConnection conn = new SqlConnection(connectstr);
	 if (conn.State != ConnectionState.Open) {
	 conn.Open();
	 }
	 return conn;
	 }
	
	
	 public static void closeQuietly(SqlConnection conn) {
	 try {
	 close(conn);
	 } catch { }
	 }
	
	 public static void closeQuietly(SqlTransaction trans) {
	 try {
	 close(trans);
	 } catch { }
	 }
	
	 public static void close(SqlConnection conn) {
	 if (conn != null) {
	 conn.Close();
	 conn.Dispose();
	 }
	 }
	 public static void close(SqlTransaction trans) {
	 if (trans != null) {
	 trans.Dispose();
	 }
	 }
	 public static void closeQuietly(SqlConnection conn, SqlTransaction trans) {
	 closeQuietly(trans);
	 closeQuietly(conn);
	 }
	
	 public static void commit(SqlTransaction trans) {
	 try {
	 if(trans!=null) trans.Commit();
	 } catch{ }
	 }
	
	 public static void rollback(SqlTransaction trans) {
	 try {
	 if (trans != null) trans.Rollback();
	 } catch { }
	 }
	 }
	}

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　事务处理　　非事务处理　

同语言下

可能有用的

汶纡贡献的其它代码(55)