using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.SqlClient;
using?System.Windows.Forms;

namespace?Library
{
????class?DBConn
????{
????????public?static?SqlConnection?GetConnection（）
????????{
????????????string?debugpath?=?Application.StartupPath;
????????????string?binpath?=?debugpath.Substring（0?debugpath.LastIndexOf（“\\“））;
????????????string?path?=?binpath.Substring（0?binpath.LastIndexOf（“\\“））;
????????????//連接字符串
????????????string?constr?=?@“Data?Source=（LocalDB）\MSSQLLocalDB;?AttachDbFilename=“?+?path?+?“\\Library_.mdf;?Integrated?Security?=?True“;
????????????//創(chuàng)建連接
????????????SqlConnection?con?=?new?SqlConnection（constr）;
????????????return?con;
????????}

????????public?static?int?InsertUpdateDelete（string?cmdText）
????????{
????????????SqlConnection?con?=?DBConn.GetConnection（）;
????????????int?count?=?0;
????????????con.Open（）;
????????????if?（con.State?==?ConnectionState.Open）
????????????{
????????????????SqlCommand?cmd?=?new?SqlCommand（cmdText?con）;
????????????????count?=?cmd.ExecuteNonQuery（）;
????????????????con.Close（）;
????????????}
????????????return?count;
????????}

????????public?static?DataTable?GetTable（string?cmdText）
????????{
????????????SqlConnection?con?=?DBConn.GetConnection（）;
????????????SqlCommand?cmd?=?new?SqlCommand（cmdText?con）;
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（cmd）;
????????????DataSet?ds?=?new?DataSet（）;
????????????sda.Fill（ds?“st“）;
????????????return?ds.Tables[“st“];
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2019-06-29?09:27??C#--圖書(shū)管理系統(tǒng)\
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\.vs\
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\.vs\Library\
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\
?????文件??????124416??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\.suo
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\Server\
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\Server\sqlite3\
?????文件???????????0??2019-06-06?10:00??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\Server\sqlite3\db.lock
?????文件??????749568??2019-06-20?11:18??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\Server\sqlite3\storage.ide
?????文件???????32768??2019-06-29?09:13??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\Server\sqlite3\storage.ide-shm
?????文件?????4140632??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\.vs\Library\v15\Server\sqlite3\storage.ide-wal
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\Library\
?????文件????????1119??2019-06-06?10:00??C#--圖書(shū)管理系統(tǒng)\Library.sln
?????文件?????????189??2019-06-06?10:00??C#--圖書(shū)管理系統(tǒng)\Library\App.config
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\Library\bin\
?????目錄???????????0??2019-06-29?09:26??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\
?????文件??????516096??2006-08-18?11:50??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\IrisSkin2.dll
?????文件?????1319424??2019-06-29?09:20??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\Library.exe
?????文件?????????189??2019-06-06?10:00??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\Library.exe.config
?????文件??????237056??2019-06-29?09:20??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\Library.pdb
?????文件?????8388608??2019-06-29?09:20??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\Library_.mdf
?????文件?????8388608??2019-06-29?09:20??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\Library__log.ldf
?????文件???????12477??2010-04-04?21:03??C#--圖書(shū)管理系統(tǒng)\Library\bin\Debug\Midsummer.ssk
?????目錄???????????0??2019-06-06?10:04??C#--圖書(shū)管理系統(tǒng)\Library\bin\Release\
?????文件????????1654??2019-06-20?10:05??C#--圖書(shū)管理系統(tǒng)\Library\DBConn.cs
?????文件?????????977??2019-06-21?10:22??C#--圖書(shū)管理系統(tǒng)\Library\Form10UserReg.cs
?????文件???????12440??2019-06-20?09:15??C#--圖書(shū)管理系統(tǒng)\Library\Form10UserReg.Designer.cs
?????文件????????5817??2019-06-21?10:22??C#--圖書(shū)管理系統(tǒng)\Library\Form10UserReg.resx
?????文件????????2856??2019-06-13?21:56??C#--圖書(shū)管理系統(tǒng)\Library\Form11UserLook.cs
?????文件????????9531??2019-06-13?21:57??C#--圖書(shū)管理系統(tǒng)\Library\Form11UserLook.Designer.cs
?????文件????????5817??2019-06-13?21:56??C#--圖書(shū)管理系統(tǒng)\Library\Form11UserLook.resx
............此處省略121個(gè)文件信息