using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?System.Collections;

namespace?StudentManagement
{
????
}

public?class?DBHelper
{
????//SHOO:定義全局變量
????public?static?string?strLoginName?=?““;?//登錄用戶名
????public?static?string?conStr?=?“Server=127.0.0.1;User?ID=sa;Pwd=0077;Database=StudentManagement“;?//庫連接腳本
????public?static?string?strRowValue?=?““;?//獲取行中某值
????public?static?DataTable?dt;

????//SHOO:庫操作_cmd執行并返回結果
????public?static?bool?ExecuteSql（string?sql）
????{
????????bool?ReturnResult?=?false;
????????SqlConnection?conn?=?new?SqlConnection（conStr）;
????????if?（conn.State?==?ConnectionState.Closed）
????????????conn.Open（）;
????????SqlCommand?cmd?=?new?SqlCommand（sql?conn）;
????????int?result?=?cmd.ExecuteNonQuery（）;?//執行cmd返回結果
????????conn.Close（）;

????????if?（result?>?0）
????????????ReturnResult?=?true;
????????return?ReturnResult;
????}

????//SHOO:庫操作_cmd執行結果給ds
????public?static?DataTable?GetDataTable（string?sql）
????{
????????DataSet?ds?=?new?DataSet（）;
????????SqlConnection?conn?=?new?SqlConnection（conStr）;
????????if?（conn.State?==?ConnectionState.Closed）
????????????conn.Open（）;
????????SqlDataAdapter?da?=?new?SqlDataAdapter（sql?conn）;
????????da.Fill（ds）;?//執行cmd將結果集填充給DataSet
????????conn.Close（）;
????????return?ds.Tables[0];?//返回DataSet的第1張表
????}




????//數據庫連接對象
????private?static?SqlConnection?conn?=?null;

????//初始化數據庫連接
????private?static?void?InitConnection（）
????{
????????//如果連接對象不存在，則創建連接
????????if?（conn?==?null）
????????????conn?=?new?SqlConnection（conStr）;
????????//如果連接對象關閉，則打開連接
????????if?（conn.State?==?ConnectionState.Closed）
????????????conn.Open（）;
????????//如果連接中斷，則重啟連接
????????if?（conn.State?==?ConnectionState.Broken）
????????{
????????????conn.Close（）;
????????????conn.Open（）;
????????}
????}

????//查詢，獲取DataReader
????public?static?SqlDataReader?GetDataReader（string?sqlstr）
????{
????????InitConnection（）;
????????SqlCommand?cmd?=?new?SqlCommand（sqlstr?conn）;
????????return?cmd.ExecuteReader（CommandBehavior.CloseConnection）;
????}

????////查詢，獲取DataTable
????//public?static?DataTable?GetDataTable（string?sqlstr）
????//{
????//????InitConnection（）;
????//????DataTable?table?=?new?DataTable（）;
????//????SqlDataAdapter?dap?=?new?SqlDataAdapter（sqlstr?conn）;
????//????dap.Fill（table）;
????//????conn.Close（）;
????//????return?table;
????//}

????//增刪改
????public?static?bool?ExecuteNonQuery（string?sqlstr）
????{
????????InitConnection（）;
????????SqlCommand?cmd?=?new?SqlCommand（sqlstr?conn）;
????????int?result?=?cmd.ExecuteNonQuery（）;
????????conn.Close（）;
????????return?result?>?0;
????}

????//執行集合函數
????public?static?object?ExecuteScalar（string?sqlstr）
????{
????????InitConnection（）;
????????SqlCommand?cmd?=?new?SqlCommand（sqlstr?conn）;
????????object?result?=?cmd.ExecuteScalar（）;
????????conn.Close（）;
?????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????1858048??2019-12-31?10:33??StudentManagementDB.BAK
?????目錄???????????0??2019-12-31?09:49??StudentManagement\
?????文件?????????525??2019-12-31?09:06??StudentManagement\App.config
?????文件????????3304??2019-12-30?21:16??StudentManagement\DBHelp.cs
?????文件????????3132??2019-12-29?23:39??StudentManagement\FormAbout.Designer.cs
?????文件?????????373??2019-12-29?23:39??StudentManagement\FormAbout.cs
?????文件????????5817??2019-12-29?23:39??StudentManagement\FormAbout.resx
?????文件????????9351??2019-12-29?23:39??StudentManagement\FormConfig.Designer.cs
?????文件????????1725??2019-12-29?23:39??StudentManagement\FormConfig.cs
?????文件????????5817??2019-12-29?23:39??StudentManagement\FormConfig.resx
?????文件????????8588??2019-12-29?23:40??StudentManagement\FormCourse.Designer.cs
?????文件????????2309??2019-12-29?23:40??StudentManagement\FormCourse.cs
?????文件????????5817??2019-12-29?23:40??StudentManagement\FormCourse.resx
?????文件????????8601??2019-12-29?23:40??StudentManagement\FormCourseEdit.Designer.cs
?????文件????????2317??2019-12-29?23:40??StudentManagement\FormCourseEdit.cs
?????文件????????5817??2019-12-29?23:40??StudentManagement\FormCourseEdit.resx
?????文件???????13376??2019-12-30?14:40??StudentManagement\FormLogin.Designer.cs
?????文件????????2897??2019-12-30?14:40??StudentManagement\FormLogin.cs
?????文件????????9817??2019-12-30?14:40??StudentManagement\FormLogin.resx
?????文件??????114158??2019-12-31?10:24??StudentManagement\FormMain.Designer.cs
?????文件???????22396??2019-12-31?10:24??StudentManagement\FormMain.cs
?????文件???????16190??2019-12-31?10:24??StudentManagement\FormMain.resx
?????文件????????5555??2019-12-29?23:58??StudentManagement\FormMajor.Designer.cs
?????文件????????2045??2019-12-29?23:58??StudentManagement\FormMajor.cs
?????文件????????5817??2019-12-29?23:58??StudentManagement\FormMajor.resx
?????文件????????5853??2019-12-29?23:58??StudentManagement\FormMajorEdit.Designer.cs
?????文件????????1721??2019-12-29?23:58??StudentManagement\FormMajorEdit.cs
?????文件????????9817??2019-12-29?23:58??StudentManagement\FormMajorEdit.resx
?????文件????????5902??2019-12-30?00:34??StudentManagement\FormPwd.Designer.cs
?????文件????????2629??2019-12-30?10:26??StudentManagement\FormPwd.cs
?????文件????????5817??2019-12-30?00:34??StudentManagement\FormPwd.resx
............此處省略84個文件信息