dbc.cs

来自「实现ＡＴＭ模拟」· CS 代码 · 共 127 行

//张波
//版权所有，请勿模仿

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

namespace server.数据访问层
{
	/// <summary>
	/// DBC 的摘要说明。
	/// </summary>
	public class DBC
	{
		//public static string ConnectionString = "server = .; uid = sa; database = bank";//连接字符串
		public static string ConnectionString ="workstation id=DEEPIN-88AEA418;integrated security=SSPI;data source=.;database=Bank";
		public static SqlConnection conn;
		public static SqlCommand comm;
		public static void GetConnection()
		{
			conn = new SqlConnection(ConnectionString);
		}

		//执行查询语句，返回一个结果集DataSet
		public static DataSet ExecuteQuery(string sql)
		{
			try
			{
				DataSet ds = new DataSet();
				GetConnection();
				SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
				adapter.Fill(ds);
				return ds;
			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.Message);
				return null;
			}
		}

		//执行查询语句，返回一个bool型
		//验证查询的信息是否存在
		public static bool ExecuteCommand(string sql)
		{
			try
			{
				GetConnection();
			
				comm=new SqlCommand(sql,conn);
				conn.Open();
				SqlDataReader reader=comm.ExecuteReader();
				if(reader.Read())
				{
					return true;
				}
				else
				{
					return false;
				}
			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.Message);
				return false;
			}
			finally
			{
				conn.Close();
			}
		}
		//执行增删改语句，返回bool型
		//修改数据信息
		public static bool ExecuteUpdate(string sql)
		{
			try
			{
				GetConnection();
				comm = new SqlCommand(sql,conn);
				conn.Open();
				int i = comm.ExecuteNonQuery();
			
				if(i>0)
				{
					return true;
				}
				else
				{
					return false;
				}
			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.Message);
				return false;
			}
			finally
			{
				conn.Close();
			}
		}

		//执行查询语句，查询出第一行的第一列
		public static object ExecuteScaler(string sql)
		{
			try
			{
				GetConnection();
				SqlCommand comm = new SqlCommand(sql,conn);
				conn.Open();
				object i = comm.ExecuteScalar();

				return i;
			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.Message);
				return null;
			}
			finally
			{
				conn.Close();
			}
		}
	}
}