資源簡介
使用C# SQL 完成 的一個模擬圖書管理的實例,作為初步開發的學習案例,實例使用了SQL 數據庫Book,數據庫腳本再DB文件夾下,執行即可。實例有登陸、借書、還書等模快,及相關的數據庫執行
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using??System.Data.SqlClient;
using?System.Windows.Forms;
namespace?Wingtech.BooksManage
{
????static?class?baseFunction
????{
????????public?static?string?SqlConnectionString?=?“server=.;database=Book;uid=sa;pwd=test“;
????????public?static?string?UserName?=?““;
????????public?static?bool?QueryBySql(string?sql)
????????{
????????????using?(SqlConnection?sqlConnection?=?new?SqlConnection(SqlConnectionString))
????????????{
????????????????try
????????????????{
????????????????????sqlConnection.Open();
????????????????????SqlCommand?command?=?new?SqlCommand(sql?sqlConnection);
????????????????????if?((int)command.ExecuteScalar()?>?
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????40??2018-11-24?16:03??Wingtech.BooksManage\.git\COMMIT_EDITMSG
?????文件????????734??2018-11-24?16:03??Wingtech.BooksManage\.git\config
?????文件?????????73??2018-11-24?16:03??Wingtech.BooksManage\.git\desc
?????文件?????????23??2018-11-24?16:03??Wingtech.BooksManage\.git\HEAD
?????文件????????478??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\applypatch-msg.sample
?????文件????????896??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\commit-msg.sample
?????文件????????189??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\post-update.sample
?????文件????????424??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\pre-applypatch.sample
?????文件???????1642??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\pre-commit.sample
?????文件???????1348??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\pre-push.sample
?????文件???????4898??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\pre-reba
?????文件????????544??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\pre-receive.sample
?????文件???????1239??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\prepare-commit-msg.sample
?????文件???????3610??2018-11-24?16:03??Wingtech.BooksManage\.git\hooks\update.sample
?????文件???????4562??2018-11-24?16:03??Wingtech.BooksManage\.git\index
?????文件????????240??2018-11-24?16:03??Wingtech.BooksManage\.git\info\exclude
?????文件????????203??2018-11-24?16:03??Wingtech.BooksManage\.git\logs\HEAD
?????文件????????203??2018-11-24?16:03??Wingtech.BooksManage\.git\logs\refs\heads\master
?????文件????????150??2018-11-24?16:04??Wingtech.BooksManage\.git\ms-persist.xm
?????文件???????1359??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件????????795??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件????????832??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件???????1223??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件???????1306??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件???????1665??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件???????1329??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件????????751??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件???????1119??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件????????494??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
?????文件????????339??2018-11-24?16:03??Wingtech.BooksManage\.git\ob
............此處省略203個文件信息
評論
共有 條評論