c# 配置文件连接mysql_C#连接数据库_使用读取配置文件的方式

1 usingSystem;2 usingSystem.Collections.Generic;3 usingSystem.Configuration;4 usingSystem.Data.SqlClient;5 usingSystem.Linq;6 usingSystem.Text;7 usingSystem.Threading.Tasks;8 usingSystem.Data;9

10 namespaceStudents.DAL11 {12 public classDBHelper13 {14 public static readonly string conn = ConfigurationManager.ConnectionStrings["ClassRoomConnectionString"].ToString();15 public static SqlConnection connection = newSqlConnection(DBHelper.conn);16

17 ///

18 ///增删改数据19 ///

20 ///

21 ///

22 public static int ExecuteNonQuery(stringsql, SqlParameter[] par)23 {24 try

25 {26 connection.Open(); //打开数据库连接

27 SqlCommand comm = newSqlCommand(sql, connection);28 //comm.CommandType = System.Data.CommandType.StoredProcedure;

29 comm.Parameters.AddRange(par);30 returncomm.ExecuteNonQuery();31 }32 catch

33 {34 throw;35 }36 finally

37 {38 connection.Close();39 }40 }41 ///

42 ///增删改数据43 ///

44 ///

45 ///

46 public static int ExecuteNonQuery(string sql, SqlParameter[] par, stringsql2, SqlParameter[] par2)47 {48 connection.Open(); //打开数据库连接

49 SqlTransaction tra =connection.BeginTransaction();50 try

51 {52 SqlCommand comm = newSqlCommand(sql, connection);53 SqlCommand comm2 = newSqlCommand(sql2, connection);54 comm.Parameters.AddRange(par);55 comm2.Parameters.AddRange(par2);56 comm.Transaction =tra;57 comm2.Transaction =tra;58 int num1 =comm.ExecuteNonQuery();59 int num2 =comm2.ExecuteNonQuery();60 int num = comm.ExecuteNonQuery() +comm2.ExecuteNonQuery();61 tra.Commit();62 returnnum;63 }64 catch

65 {66 tra.Rollback();67 throw;68 }69 finally

70 {71 connection.Close();72 }73 }74 ///

75 ///查询数据76 ///

77 ///

78 ///

79 public static SqlDataReader ExecuteReader(stringsql, SqlParameter[] par)80 {81 try

82 {83 connection.Open(); //打开数据库连接

84 SqlCommand comm = newSqlCommand(sql, connection);85 //comm.CommandType = System.Data.CommandType.StoredProcedure;

86 comm.Parameters.AddRange(par);87 returncomm.ExecuteReader(CommandBehavior.CloseConnection);88 }89 catch

90 {91 throw;92 }93 }94 ///

95 ///查询数据96 ///

97 ///

98 ///

99 public static SqlDataReader ExecuteReader(stringsql)100 {101 try

102 {103 connection.Open(); //打开数据库连接

104 SqlCommand comm = newSqlCommand(sql, connection);105 returncomm.ExecuteReader(CommandBehavior.CloseConnection);106 }107 catch

108 {109 throw;110 }111 }112 ///

113 ///返回单个值114 ///

115 ///

116 ///

117 public static object ExecuteScalar(stringsql, SqlParameter[] par)118 {119 try

120 {121 connection.Open(); //打开数据库连接

122 SqlCommand comm = newSqlCommand(sql, connection);123 //comm.CommandType = System.Data.CommandType.StoredProcedure;

124 comm.Parameters.AddRange(par);125 returncomm.ExecuteScalar();126 }127 catch

128 {129 throw;130 }131 finally

132 {133 connection.Close();134 }135 }136 }137 }