91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

后臺數據庫 設計公交安全管理系統(tǒng)，推薦使用SQL Server，其它DBMS亦可。 數據庫的有關語義如下： 公交公司有若干個車隊，每個車隊下有若干條線路； 公交公司有若干輛汽車，每輛車屬于一條線路； 每個車隊有一名隊長，他只有管理工作，不開車； 每條線路有若干名司機，其中有一名路隊長，除開車外，還承擔管理工作；每名司機只在一條線路上開車； 司機開車時會產生違章，包含：闖紅燈、未禮讓斑馬線、壓線、違章停車等； 隊長、路隊長負責將司機的違章信息輸入到系統(tǒng)，包含：司機、車輛、車隊、線路、站點、時間、違章等。 前臺程序 開發(fā)一個公交安全管理系統(tǒng)來對數據庫進行訪問，可以使用C、Java等集成開發(fā)環(huán)境。 系統(tǒng)實現功能如下： 錄入司機基本信息，如工號、姓名、性別等； 錄入汽車基本信息，如車牌號、座數等； 錄入司機的違章信息； 查詢某個車隊下的司機基本信息； 查詢某名司機在某個時間段的違章詳細信息； 查詢某個車隊在某個時間段的違章統(tǒng)計信息，如：2次闖紅燈、4次未禮讓斑馬線等。 東西說的都很清楚，自己下載下來參考。

資源截圖

代碼片段和文件信息 

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

namespace?WindowsFormsApp2
{
????public?partial?class?Form1?:?Form
????{

????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????//驗證登錄
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????
????????????//采集數據
????????????string?loginid?=?textloginid.Text.Trim（）;
????????????string?loginpwd?=?textloginpwd.Text.Trim（）;
????????????string?sf?=?comboBox1.SelectedItem.ToString（）;

????????????//驗證登錄
????????????string?constr?=?“Data?Source=LARRY6799;Initial?Catalog=bus1;Integrated?Security=True“;
????????????using?（SqlConnection?con?=?new?SqlConnection（constr））
????????????{
????????????????if?（sf.Equals（“車隊長“）||?sf.Equals（“路隊長“））
????????????????{
????????????????????string?sql;
????????????????????if?（sf.Equals（“車隊長“））{
?????????????????????????sql?=?string.Format（“select?count（*）?from?cdz?where?cheduizhang?=?‘{0}‘?and?loginpwd?=?‘{1}‘“?loginid?loginpwd）;
????????????????????}
????????????????????else{
?????????????????????????sql?=?string.Format（“select?count（*）?from?xlz?where?luduizhang?=?‘{0}‘?and?loginpwd?=?‘{1}‘“?loginid?loginpwd）;
????????????????????}
????????????????????
????????????????????using?（SqlCommand?cmd?=?new?SqlCommand（sql?con））
????????????????????{
????????????????????????con.Open（）;
????????????????????????int?count?=?（int）cmd.ExecuteScalar（）;
????????????????????????if?（count?>?0）
????????????????????????{
????????????????????????????Form2?fmain?=?new?Form2（this.textloginid.Text）;
????????????????????????????fmain.Show（）;
????????????????????????????this.Dispose（false）;
????????????????????????}
????????????????????????else
????????????????????????{
????????????????????????????MessageBox.Show（“登錄失敗，請重新輸入用戶名和密碼！“）;
????????????????????????}
????????????????????}
????????????????}???????????

????????????????else?if?（sf.Equals（“司機“））
????????????????{
????????????????????string?sql?=?string.Format（“select?count（*）?from?sj?where?siji?=?‘{0}‘?and?loginpwd?=?‘{1}‘“?loginid?loginpwd）;
????????????????????using?（SqlCommand?cmd?=?new?SqlCommand（sql?con））
????????????????????{
????????????????????????con.Open（）;
????????????????????????int?count?=?（int）cmd.ExecuteScalar（）;
????????????????????????if?（count?>?0）
????????????????????????{
????????????????????????????Formsiji?fsj?=?new?Formsiji（this.textloginid.Text）;
????????????????????????????fsj.Show（）;
????????????????????????????this.Dispose（false）;
????????????????????????}
????????????????????????else
????????????????????????{
????????????????????????????MessageBox.Show（“登錄失敗，請重新輸入用戶名和密碼！“）;
????????????????????????}

????????????????????}
????????????????}
????????????????else
?????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-23?14:53??16030110032_張瑞\
?????文件????????1411??2018-11-23?14:52??16030110032_張瑞\view.txt
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\DesignTimeBuild\
?????文件?????????200??2018-10-24?18:12??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\DesignTimeBuild\.dtbcache
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\
?????文件??????173568??2018-11-14?21:08??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\.suo
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\Server\
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\Server\sqlite3\
?????文件???????????0??2018-10-20?20:37??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\Server\sqlite3\db.lock
?????文件??????786432??2018-11-04?22:20??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\Server\sqlite3\storage.ide
?????文件???????32768??2018-11-14?20:47??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\Server\sqlite3\storage.ide-shm
?????文件?????4136512??2018-11-05?23:53??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\.vs\WindowsFormsApp2\v15\Server\sqlite3\storage.ide-wal
?????目錄???????????0??2018-11-23?14:05??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\
?????文件?????????189??2018-10-20?20:37??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\App.config
?????文件????????6403??2018-11-04?02:33??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form1.Designer.cs
?????文件????????3562??2018-11-04?10:04??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form1.cs
?????文件????????5817??2018-11-04?02:33??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form1.resx
?????文件????????8224??2018-10-24?16:55??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form2.Designer.cs
?????文件????????2240??2018-11-04?21:00??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form2.cs
?????文件????????5817??2018-10-24?16:55??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form2.resx
?????文件????????8632??2018-11-04?22:22??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form3.Designer.cs
?????文件????????4048??2018-11-04?22:23??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form3.cs
?????文件????????5817??2018-11-04?22:22??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form3.resx
?????文件????????7223??2018-11-04?14:09??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form4.Designer.cs
?????文件????????3297??2018-11-04?14:13??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form4.cs
?????文件????????5817??2018-11-04?14:09??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form4.resx
?????文件????????9130??2018-11-04?22:43??16030110032_張瑞\前臺程序C#\WindowsFormsApp2\WindowsFormsApp2\Form5.Designer.cs
............此處省略344個文件信息

評論

共有 條評論

相關資源