dbaccess.cs

一个很简单的考试系统。实用性很强啊！数据库在里面

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace bizdb
{
	/// <summary>
	/// dbAccess 的摘要说明。
	/// </summary>
	public class dbAccess
	{
		private static string sql_cnt = "Server = .; DataBase = easter; User ID = sa; Password = sa";
		private SqlConnection openSqlcnt = new SqlConnection( sql_cnt );

//		private static string sql_cnt = "Server = 192.168.0.1; DataBase = examdb; User ID = sa; Password = jiuhao.com";
//		private SqlConnection openSqlcnt = new SqlConnection( sql_cnt );

		//private OperateDb operDb = new OperateDb();  ///实例化operateDb类

		/// <summary>
		/// 以下是数据库查询用的字符串
		public static string sel_Yxfx = "select sub_no, sub_name from subject";      ///查找学科五大类的名字及No
		public static string subName = Convert.ToString( "sub_name" );
		public static string subNo = Convert.ToString( "sub_no" );
		public static string tab_Subject = Convert.ToString( "subject" );

		public static string sel_Zyk = "select spe_no, sub_no, spe_name from speciality";               ///查找专业的名称及No，
		public static string speName = Convert.ToString( "spe_name" );                    
		public static string speNo = Convert.ToString( "spe_no" );
		public static string tab_Spec = Convert.ToString( "speciality" );

		public static string sel_Kls = "select cou_no, spe_no from knowledgeSystem";    ///查找课程与专业关系表的相对应No
		public static string tab_Kls = "knowledgeSystem";
		public static string couNo = "cou_no";

		public static string sel_Cour = "select cou_no, cou_name from Course";           ///查找课程的名称及No
		public static string couName = "cou_name";
		public static string tab_Cour = "Course";

		public dbAccess()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
	
		public static string conn;
		public string connStr
		{
			set
			{
				conn=value;
			}
			get
			{
				return conn;
			}
		}

		/// <summary>
		/// 以下是陆海峰同志编写的学员选课程序所用到的数据库连接操作的方法( 包括上面的SqlCon 和SQL语句 )

		public void openDb()
		{
			openSqlcnt.Open();
		}

		public void closeDb()
		{
			openSqlcnt.Close();
		}

		private SqlCommand databaseCmd( string cmdText ,SqlCommand cmdOpen )
		{
			cmdOpen.Connection = openSqlcnt;
			cmdOpen.CommandText = cmdText;
			return cmdOpen;
		}

		public SqlDataReader dataReader( string text )
		{
			SqlCommand openCmd = new SqlCommand();
			openCmd = databaseCmd( text ,openCmd);
			SqlDataReader dtReader;
			dtReader = openCmd.ExecuteReader();
			return dtReader;
		}

		///以上这些是与数据库连接的操作
		///以下是与数据库有关的操作的方法
		
		public void dtRead( ref Dataset_xyxk dataSet, string sqlWord, string dtsTabName, string dtsFirCol, string dtsSendCol )
		{                                         ///+1次重载的方法，五个参数,无Where子句的向DataSet中的所需表中添加数据的方法
            openDb();

            SqlDataReader dataRd = dataReader( sqlWord );

			while ( dataRd.Read() )
			{
				DataRow dtRow = dataSet.Tables[dtsTabName].NewRow();
				dtRow[dtsFirCol] = dataRd[dtsFirCol].ToString();
				dtRow[dtsSendCol] = dataRd[dtsSendCol].ToString();
				dataSet.Tables[dtsTabName].Rows.Add(dtRow);	
			}
				dataRd.Close();
				closeDb();
		}

		public void dtRead( ref Dataset_xyxk dataSet, string sqlWord, string dtsTabName, string dtsFirCol, 
			string dtsSendCol, string dtsThrCol )
		{                                          ///+2次重载的方法，六个参数,无Where子句的向DataSet中的所需表中添加数据的方法
			openDb();

            SqlDataReader dataRd = dataReader( sqlWord );

			while ( dataRd.Read() )
			{
				DataRow dtRow = dataSet.Tables[dtsTabName].NewRow();
				dtRow[dtsFirCol]= dataRd[dtsFirCol].ToString();
				dtRow[dtsSendCol]= dataRd[dtsSendCol].ToString();
				dtRow[dtsThrCol] = dataRd[dtsThrCol].ToString();
				dataSet.Tables[dtsTabName].Rows.Add(dtRow);	
			}

            dataRd.Close();
            closeDb();

		}

		
	}
	
}