.net mysql sqlhelper_C# SqlHelper

public static string strConn = @"Data Source=" + @"F:\资料文档\20190227\CAD\0625AnPin\CadDLLcl\Data\Cad_try0626.db";public static string Sql =String.Empty;///

///执行SQL语句，返回影响的记录数///

/// SQL语句

/// 影响的记录数

public static int ExecuteSql(stringSQLString)

{using (SQLiteConnection connection = newSQLiteConnection(strConn))

{//事务

using (SQLiteTransaction singleTrans =connection.BeginTransaction(IsolationLevel.ReadCommitted))

{using (SQLiteCommand cmd = newSQLiteCommand(SQLString, connection))

{try{

connection.Open();

cmd.Transaction=singleTrans;int rows =cmd.ExecuteNonQuery();

singleTrans.Commit();returnrows;

}catch(System.Data.SqlClient.SqlException e)

{

connection.Close();

singleTrans.Rollback();throwe;

}

}

}

}

}///

///执行查询语句，返回DataTable///

/// 查询语句 param >

/// < returns >DataSet returns >

public static DataTable Query(stringSQLString)

{using (SQLiteConnection connection = newSQLiteConnection(strConn))

{

DataSet ds= newDataSet();try{

connection.Open();

SQLiteDataAdapter command= newSQLiteDataAdapter(SQLString, connection);

command.Fill(ds,"ds");return ds.Tables[0];

}catch(Exception ex)

{

connection.Close();throwex;

}

}

}///

///执行存储过程，返回影响的记录数///

/// SQL语句

/// 影响的记录数

public static int ExecuteProc(stringprocName, SQLiteParameter[] coll)

{using (SQLiteConnection connection = newSQLiteConnection(strConn))

{//事务

using (SQLiteTransaction singleTrans =connection.BeginTransaction(IsolationLevel.ReadCommitted))

{using (SQLiteCommand cmd = newSQLiteCommand(connection))

{try{

connection.Open();for (int i = 0; i < coll.Length; i++)

{

cmd.Parameters.Add(coll[i]);

}

cmd.CommandType=CommandType.StoredProcedure;

cmd.CommandText=procName;

cmd.Transaction=singleTrans;int rows =cmd.ExecuteNonQuery();

singleTrans.Commit();returnrows;

}catch(System.Data.SqlClient.SqlException e)

{

connection.Close();

singleTrans.Rollback();throwe;

}

}

}

}

}///

///执行带参数的SQL语句，返回影响的记录数///

/// SQL语句

/// 影响的记录数

public static int ExecuteSqlPar(stringsqlPar, SQLiteParameter[] coll)

{using (SQLiteConnection connection = newSQLiteConnection(strConn))

{//事务

using (SQLiteTransaction singleTrans =connection.BeginTransaction(IsolationLevel.ReadCommitted))

{using (SQLiteCommand cmd = newSQLiteCommand(connection))

{try{

connection.Open();for (int i = 0; i < coll.Length; i++)

{

cmd.Parameters.Add(coll[i]);

}

cmd.CommandType=CommandType.Text;

cmd.CommandText=sqlPar;

cmd.Transaction=singleTrans;int rows =cmd.ExecuteNonQuery();

singleTrans.Commit();returnrows;

}catch(System.Data.SqlClient.SqlException e)

{

connection.Close();

singleTrans.Rollback();throwe;

}

}

}

}

}

Sqlite