110,529
社区成员
发帖
与我相关
我的任务
分享
//连接数据库字符串
string connStr = "User Id=" + userName + ";Host=" + host + ";Database=" + dataBase + ";password=" + passWord + "";
MySqlConnection conn = new MySqlConnection(connStr);
using (MySqlConnection conn = MyConn.GetConnection())
{
try
{
conn.Open();
Trans = conn.BeginTransaction();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.Transaction = Trans;
cmd.CommandText = "select * from table";
cmd.ExecuteNonQuery();
//事务提交
Trans.Commit();
}
catch (DbException e)
{
//事务回滚
if (Trans != null)
Trans.Rollback();
}
finally
{
conn.Close();
}
}