-
大小: 741KB文件類型: .zip金幣: 2下載: 2 次發(fā)布日期: 2021-10-26
- 語言: 數(shù)據(jù)庫
- 標(biāo)簽: C#??SQl??
資源簡介
1.1 課題研究現(xiàn)狀分析
在各大高校里，實(shí)驗(yàn)設(shè)備各式各樣。在實(shí)驗(yàn)設(shè)備的管理中，如果通過使用計(jì)算機(jī)可以減少大量的手工操作，提高工作效率。實(shí)驗(yàn)設(shè)備管理系統(tǒng)過去采用人工處理方式，由于工作量非常之大，為了提高工作效率，方便管理，因此需要開發(fā)一個(gè)實(shí)驗(yàn)設(shè)備管理系統(tǒng)。
本次課題為：實(shí)驗(yàn)設(shè)備管理系統(tǒng)，它的主要功能是先通過用戶身份驗(yàn)證，然后即可登錄實(shí)驗(yàn)設(shè)備管理系統(tǒng)，然后通過增、刪、查、改操作對實(shí)驗(yàn)設(shè)備信息進(jìn)行管理和維護(hù)。
1.1.1 本領(lǐng)域內(nèi)已開展的研究工作
1．理論研究基礎(chǔ)
（1）后臺以SQL數(shù)據(jù)庫支持。
（2）前臺以 NeatBeans為開發(fā)環(huán)境，實(shí)現(xiàn)學(xué)生基本信息管理的增、刪、查、改操作。
2．技術(shù)層面的支持
（1）系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)應(yīng)采用MVC分層模式。
（2）系統(tǒng)界面采用MDI方式，即用戶登錄后進(jìn)入主窗體，主窗體通過菜單進(jìn)入子窗體。
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?WindowsFormsApplication1
{
????public?partial?class?AddEquipment?:?Form
????{
????????public?AddEquipment（）
????????{
????????????InitializeComponent（）;
????????}
????????private?void?btnAdd_Click（object?sender?EventArgs?e）
????????{
???????????String?connectionStr?=?“Data?Source=‘.‘;?Initial?Catalog=‘Equipment‘;?Integrated?Security=‘true‘“;
????????????SqlConnection?connection?=?new?SqlConnection（connectionStr）;
????????????connection.Open（）;
??????????
????????????SqlCommand?com?=?new?SqlCommand（）;
????????????com.Connection?=?connection;
????????????com.CommandText?=?string.Format（“select?count（*）?from?Equipment?where?EquipmentNO=‘{0}‘“this.txtNO.Text）;
????????????int?count?=?（int）com.ExecuteScalar（）;
????????????if?（count?>?0）
????????????{
????????????????MessageBox.Show（“編號已存在！“）;
????????????}
????????????else
????????????{
????????????????String?sql?=?String.Format（“insert?into?Equipment?“?+?“（EquipmentNO?EquipmentNameKindProducerStateEnterDate）“?+
????????????????“values?（‘{0}‘?‘{1}‘?‘{2}‘?‘{3}‘?‘{4}‘‘{5}‘）“?this.txtNO.Text?this.txtName.Text
????????????????this.comKind.Text?this.txtProducer.Text?this.comState.Text?this.txtDataTime.Text）;
????????????????SqlCommand?command?=?new?SqlCommand（）;
????????????????command.Connection?=?connection;
????????????????command.CommandText?=?sql;
????????????????int?dd?=?command.ExecuteNonQuery（）;
????????????????if?（dd?==?1）
????????????????{
????????????????????MessageBox.Show（“添加成功！“）;
????????????????}
????????????
????????????????String?sql1?=?String.Format（“select?*?from?Equipment?“）;
????????????????SqlCommand?command1?=?new?SqlCommand（sql1?connection）;
????????????????SqlDataReader?reader1?=?command1.ExecuteReader（）;
????????????????this.listView1.Items.Clear（）;
????????????????while?（reader1.Read（））
????????????????{
????????????????????ListViewItem?lvi?=?new?ListViewItem（）;
????????????????????lvi.Text?=?reader1[“EquipmentNO“].ToString（）;
????????????????????lvi.SubItems.Add（reader1[“EquipmentName“].ToString（））;
????????????????????lvi.SubItems.Add（reader1[“Kind“].ToString（））;
????????????????????lvi.SubItems.Add（reader1[“Producer“].ToString（））;
????????????????????lvi.SubItems.Add（reader1[“State“].ToString（））;
????????????????????lvi.SubItems.Add（reader1[“Beizhu“].ToString（））;
????????????????????this.listView1.Items.Add（lvi）;
????????????????}
????????????????reader1.Close（）;
????????????????connection.Close（）;
????????????}
????????
????????}
????????private?void?btnQuit_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;
????????}
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????String?connectionStr?=?“Data?Source= ?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-12-18?11:01??20114052126蘇雪源\
?????目錄???????????0??2013-12-02?19:49??20114052126蘇雪源\WindowsFormsApplication1\
?????目錄???????????0??2013-12-10?14:54??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\
?????文件???????24774??2013-12-07?20:12??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddEquipment.Designer.cs
?????文件???????13234??2013-12-10?17:45??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddEquipment.cs
?????文件????????5817??2013-12-07?20:12??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddEquipment.resx
?????文件????????6774??2013-12-06?15:01??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddType.Designer.cs
?????文件????????3723??2013-12-10?17:04??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddType.cs
?????文件????????5817??2013-12-06?15:01??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddType.resx
?????文件???????16432??2013-12-05?22:07??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddUser.Designer.cs
?????文件????????3900??2013-12-05?22:07??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddUser.cs
?????文件????????5817??2013-12-05?22:07??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\AddUser.resx
?????文件????????6963??2013-12-07?19:56??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\Bumen.Designer.cs
?????文件????????3801??2013-12-10?17:19??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\Bumen.cs
?????文件????????5817??2013-12-07?19:56??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\Bumen.resx
?????文件???????20146??2013-12-10?14:51??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangeManage.Designer.cs
?????文件????????4364??2013-12-10?14:51??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangeManage.cs
?????文件????????6610??2013-12-10?14:51??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangeManage.resx
?????文件????????8233??2013-12-06?10:40??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangePass.Designer.cs
?????文件????????1688??2013-12-06?10:40??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangePass.cs
?????文件????????5817??2013-12-06?10:40??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangePass.resx
?????文件???????19133??2013-12-05?22:08??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangeUser.Designer.cs
?????文件????????3811??2013-12-05?22:08??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangeUser.cs
?????文件????????6438??2013-12-05?22:08??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\ChangeUser.resx
?????文件????????5344??2013-12-06?17:01??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\EquipView.Designer.cs
?????文件????????1709??2013-12-06?17:01??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\EquipView.cs
?????文件????????5817??2013-12-06?17:01??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\EquipView.resx
?????文件???????13402??2013-12-10?15:17??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\Equipment.csproj
?????文件?????????452??2013-12-03?15:32??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\Equipment.csproj.user
?????文件??????151552??2013-12-03?16:07??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\Equipment.sdf
?????文件???????20593??2013-12-03?15:31??20114052126蘇雪源\WindowsFormsApplication1\WindowsFormsApplication1\EquipmentCache.Designer.cs
............此處省略96個(gè)文件信息
- 上一篇：sql解析代碼_bak
- 下一篇：漢語動(dòng)詞詞庫逆序
評論
共有 條評論
川公網(wǎng)安備 51152502000135號