【導(dǎo)讀】計(jì)時(shí)取得的成果。本人知道，除文中已經(jīng)標(biāo)明引用的內(nèi)容外，本畢業(yè)設(shè)計(jì)。說明書不包含任何其他個(gè)人或集體已經(jīng)發(fā)表或撰寫過的研究成果。的研究做出貢獻(xiàn)的個(gè)人或集體，均已在文中以明確方式標(biāo)明。識(shí)到本聲明的法律后果由本人承擔(dān)。此外，通過軟件可以保存和分析大量的歷史數(shù)據(jù)，能夠?yàn)楣ぷ魇业囊恍Q策的制定。和實(shí)施提供數(shù)據(jù)支持從而提供強(qiáng)有力的幫助。的工具和SQLServer2020這一后臺(tái)的開發(fā)系統(tǒng)的工具。具體實(shí)現(xiàn)的一些目標(biāo)如下:系。息的管理，使系統(tǒng)更加完善；連接excel，人員信息、入庫信息的結(jié)果可以保存其中，

　　

【正文】 用編程實(shí)例教程》，北京：北京希望電子出版社，2020 年， P103—129。 [5] 曹軍生編著《 SQL Server 2020 實(shí)用教程》，北京：北京理工大學(xué)出版社， 2020 年，P16。 [6] 張逸編著《軟件設(shè)計(jì)精要與模式 第二版 》，北京：電子工業(yè)出版社， 2020 年， P15。 [7] 王晟，馬里杰等編著《 SQL Server 數(shù)據(jù)庫開發(fā)經(jīng)典案例解析》，北京：清華大學(xué)出版社， 2020 年， P21。 [8] 何玉潔編著《數(shù)據(jù)庫設(shè)計(jì)》，北京：機(jī)械工業(yè)出版社， 2020 年， P38。 [9] 薩師煊、王珊編著《數(shù)據(jù)庫系統(tǒng)概論》，北京：高等教育出版社， 2020 年， P42。 [10] 溫昱編著《軟件架構(gòu)設(shè)計(jì)》，北京，電子工業(yè)出版社， 2020 年， P53。 [11]Kim, .“ WebBased Speaking Test Development Using Visual Basic . Multimedia Assisted Language Learning” , 2020. 9(2), p. 7798. [12] Alan B.“ Learning SQLO39。Reilly Series[M]” ,O39。Reilly Media, Inc, 2020. [13]Clare C.“ Beginning SQL Queries: From Novice to ProfessionalApress Series[M]” ,Apress, 2020. [14] Andy O.“ Robert Sheldon. SQL: a beginner39。s guide BEGINNER39。S GUIDE[M]” ,McGrawHill Professional, 2020. [15] Chris F.“ SQL: Visual QuickStart Guide Visual Quickstart Guide Series[M]” , Peachpit Press, 2020. 27 英文翻譯資料 Data Environment And Designer In the VB application, in addition to using data objects and data control to access the database, you can also use the data environment (Data Environment) to access the database. Data environment is VB new features, it uses a graphical way to connect to the database, in a data environments can create multiple connections for connecting to different databases, each connection can create multiple mands, which can create multiple data sources so that you can only create a data environment in the case of different databases for different tables, views, stored procedures or queries visit. The same as ADO control, you can write code to support data access. In addition, VB to provide convenient and practical reporting capabilities, by using Report Designer and data environment, basic without writing code, you can easily use the mouse to drag the shortcut to create data reports, design data report can also preview and directly to the printer to print. Data Environment: Data environment is a hierarchical data source. Each data environment can contain a number of connection (Connection), by establishing a different connection to connect to a different database. Each connection contains a number of mands (Command), and each mand can also contain Serveral submands. Each mand corresponds to the database not only a table, a view or a stored procedure, but also can query designer to create queries. The hierarchical structure of the data environment, users can easily create a hierarchical set of records. For each mand, you can also add statistics to group or operation. Data Environment designer provides an interactive design environment. At design time, you can set the connection and mand objects for the value of the event by writing code to respond ADO, execute mands, create a hierarchical structure, you can also drag the Data Environment object to the form or report to create data bound controls. As can be directly generated by dragging the databound controls, which create data in the data environment and data report form is very convenient. VB in the data environment is the most powerful, most convenient to use a data objects with the ADO control or bind the controls, and data environment can also be binding, but bound controls and data environment, in addition to set the DataSource and DataField properties, but also with the control is bound to set the order, that is, The data used by the members (DataMember property). Data Report: Data Report Designer VB to provide a report designer, and VB in the data source object can provide with the use of the mouse drag operation, you can easily create plex reports. Data Report Designer created reports can be printed directly, you can also export the report to HTML or text file. 28 Data Report is a database application, a very important part. Data were recorded and maintenance work is pleted, often need to generate various forms of data reports. The main function of the database is to store data and provide data, the data is the role of statements retrieved from the database data to a certain format, printed or displayed. For example, payroll reports, sales reports, classroom transcripts, transcripts and so on. Works in the VB menu, select Add Data Report mand in the current project to add a data report. In addition, the system automatically create a data project to create a data report (DataReport) object and added to the project. Created the first data report design object s default name DataReportl. In the project window, doubleclick the DataReportl, open the Data Report Designer window contains a page header, detail area and a page footer, which is when the Report Designer to create default display state, in addition, it also includes the report header / report footer, group header / packet footnote. 摘自： 網(wǎng)站 29 數(shù)據(jù)環(huán) 境與設(shè)計(jì)者 在 VB 應(yīng)用程序中 ,除了使用數(shù)據(jù)對(duì)象和數(shù)據(jù)控制訪問數(shù)據(jù)庫 ,您還可以使用數(shù)據(jù)環(huán)境 (數(shù)據(jù)環(huán)境 )來訪問數(shù)據(jù)庫。數(shù)據(jù)環(huán)境是 VB 的新功能 ,它使用一個(gè)圖形化的方式連接到數(shù)據(jù)庫 ,數(shù)據(jù)環(huán)境中可以創(chuàng)建多個(gè)連接不同的數(shù)據(jù)庫連接 ,每個(gè)連接可以創(chuàng)建多個(gè)命令 ,它可以創(chuàng)建多個(gè)數(shù)據(jù)源 ,這樣你只能創(chuàng)建一個(gè)數(shù)據(jù)環(huán)境的不同數(shù)據(jù)庫表、視圖、存儲(chǔ)過程或查詢?cè)L問。 ADO 控件一樣 ,您可以編寫代碼來支持?jǐn)?shù)據(jù)訪問。 此外 ,VB 提供方便實(shí)用的報(bào)告功能 ,通過使用報(bào)表設(shè)計(jì)器和數(shù)據(jù)環(huán)境 ,基本沒有寫代碼 ,您可以用鼠標(biāo)拖動(dòng)快捷方式創(chuàng)建數(shù)據(jù)報(bào) 告 ,設(shè)計(jì)數(shù)據(jù)報(bào)告也可以直接預(yù)覽和打印到打印機(jī)。 數(shù)據(jù)環(huán)境 :數(shù)據(jù)環(huán)境是一種層次化的數(shù)據(jù)來源。每個(gè)數(shù)據(jù)環(huán)境中可以包含大量的連接 (連接 ),通過建立不同的連接連接到一個(gè)不同的數(shù)據(jù)庫 ,每個(gè)連接包含許多命令 (命令 ),和每個(gè)命令也可以包含多個(gè) submands。不僅每個(gè)命令對(duì)應(yīng)數(shù)據(jù)庫表、視圖或存儲(chǔ)過程 ,也可以查詢?cè)O(shè)計(jì)器來創(chuàng)建查詢。層次結(jié)構(gòu)數(shù)據(jù)的環(huán)境中 ,用戶可以很容易地創(chuàng)建一套分層的記錄。對(duì)于每一個(gè)命令 ,您還可以添加統(tǒng)計(jì)組或操作 . 數(shù)據(jù)環(huán)境設(shè)計(jì)器提供了一個(gè)交互式設(shè)計(jì)環(huán)境 ,在設(shè)計(jì)時(shí) ,您可以設(shè)置連接和命令對(duì)象價(jià)值的事件通 過編寫代碼來響應(yīng) ADO,執(zhí)行命令 ,創(chuàng)建一個(gè)層次結(jié)構(gòu) ,還可以拖動(dòng)數(shù)據(jù)環(huán)境對(duì)象的形式或報(bào)告創(chuàng)建數(shù)據(jù)綁定控件。 可以直接通過拖動(dòng)生成數(shù)據(jù)綁定控件 ,創(chuàng)建數(shù)據(jù)的數(shù)據(jù)環(huán)境和數(shù)據(jù)報(bào)表形式十分便利。 VB 的數(shù)據(jù)環(huán)境是最強(qiáng)大的 ,最方便的使用與 ADO 數(shù)據(jù) 對(duì)象控制或綁定的控件和數(shù)據(jù)環(huán)境也可以綁定 ,但是數(shù)據(jù)綁定控件和數(shù)據(jù)環(huán)境中 ,除了設(shè)置數(shù)據(jù)源和DataField 屬性外 ,還設(shè)置了控件綁定到的順序 ,也就是說 ,使用的數(shù)據(jù)成員 (數(shù)據(jù)成員屬性 )。數(shù)據(jù)報(bào)告 :數(shù)據(jù)報(bào)告設(shè)計(jì)器 VB 提供一個(gè)報(bào)告設(shè)計(jì)器 ,和 VB 的數(shù)據(jù)源 對(duì)象可以使用鼠標(biāo)拖動(dòng)操作 ,您可以很容易地創(chuàng)建復(fù)雜的報(bào)告?？梢灾苯哟蛴?shù)據(jù)報(bào)表設(shè)計(jì)器創(chuàng)建報(bào)告 ,你也可以報(bào)告導(dǎo)出到 HTML 或文本文件。數(shù)據(jù)報(bào)告是一個(gè)數(shù)據(jù)庫應(yīng)用程序中 ,一個(gè)非常重要的部分。數(shù)據(jù)記錄和維護(hù)工作完成后 ,通常需要生成各種形式的數(shù)據(jù)報(bào)告。 數(shù)據(jù)庫的主要功能是存儲(chǔ)數(shù)據(jù)并提供數(shù)據(jù) ,數(shù)據(jù)的角色是語句從數(shù)據(jù)庫中檢索到的數(shù)據(jù)在一定格式 ,打印或顯示出來。例如 ,工資報(bào)告 ,銷售報(bào)告 ,課