cdatabase.cs

医院系统管理

using System;
using System.Data;
using System.Data.SqlClient;

namespace Hospital_Manage
{
	/// <summary>
	/// CDataBase 的摘要说明。
	/// </summary>
	public class CDataBase
	{
		public CDataBase()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		protected static string connectionString="server=(local);database=hospital;uid=sa;pwd=;";

		#region 执行带参数的SQL语句
		/// <summary>
		/// 执行SQL语句，返回影响的记录数
		/// </summary>
		/// <param name="SQLString">SQL语句</param>
		/// <returns>影响的记录数</returns>
		public static int ExecuteSql(string SQLString)
		{
			SqlConnection objSqlConnection=new SqlConnection(connectionString);
			SqlCommand objCommand=new SqlCommand(SQLString,objSqlConnection);
			try
			{
				objSqlConnection.Open();
				return objCommand.ExecuteNonQuery();
			}
			catch(SqlException ex)
			{
				throw new Exception(ex.Message);
			}
			finally
			{
				objSqlConnection.Close();
			}
		}
		#endregion
	}
}