?? database.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.ComponentModel;
namespace 圖書館管理系統
{
/// <summary>
/// DataBase 的摘要說明。
/// </summary>
public class DataBase : IDisposable
{
private SqlConnection sqlConn;
public static string sConn = "Persist Security Info=False;Integrated Security=SSPI;database=libbook;server=localhost;Connect Timeout=30";
public DataBase()
{
//
// TODO: 在此處添加構造函數邏輯
//
}
public void Dispose()
{
Dispose( true );
GC.SuppressFinalize( true );
}
protected void Dispose( bool disposing )
{
if ( !disposing )
{
return;
}
if ( sqlConn != null )
{
sqlConn.Dispose();
sqlConn = null;
}
}
public void Open()
{
if ( sqlConn == null )
{
sqlConn = new SqlConnection( sConn );
sqlConn.Open();
}
}
public void Close()
{
if ( sqlConn != null )
{
sqlConn.Close();
}
}
public DataView RunSelectSQL( string sSQLString )
{
this.Open();
DataSet SqlDS = new DataSet();
SqlDataAdapter SqlDA = new SqlDataAdapter( sSQLString, this.sqlConn );
SqlDA.Fill( SqlDS );
return SqlDS.Tables[ 0 ].DefaultView;
}
public void RunDelOrInsSQL( string sSQLString )
{
this.Open();
SqlCommand SqlComm = new SqlCommand( sSQLString, this.sqlConn );
SqlComm.ExecuteNonQuery();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -