【正文】 結(jié)構(gòu)，使用 JSP 編程、利用 SQLServer2020建立數(shù)據(jù)庫、采用 HTML， JavaScript等編程技術(shù)。 The result inquiry module mainly carries on the increase, the deletion, the input result to the required course, as well as the student carries on function and inquiry result and so on. 目 錄 摘 要 ................................................................................................................................I Abstract......................................................................................................................... II 引 言 ............................................................................................................................... 2 第一章 緒論 ................................................................................................................... 3 選題的背景和意義 .............................................................................................. 3 國內(nèi)外研究現(xiàn)狀及發(fā)展趨勢 ................................................................................ 3 本課題研究內(nèi)容 .................................................................................................. 3 本課題研究的目標(biāo)及主要特色 ............................................................................. 4 第二章 系統(tǒng)設(shè)計使用技術(shù)介紹 ....................................................................................... 5 JSP（ Java Server Pages）和 Java Bean 技術(shù)介紹 .................................................... 5 JSP 概述 ..................................................................................................... 5 JSP工作原理 ........................................................................................... 5 JavaBean技術(shù)介紹 ................................................................................... 5 B/S體系結(jié)構(gòu)介紹 ................................................................................................ 6 JavaScrit技術(shù)介紹 ........................................................................................... 7 SQL Server 2020 數(shù)據(jù)庫 ................................................................................... 7 數(shù)據(jù)庫介紹 .............................................................................................. 7 ODBC數(shù)據(jù)訪問接口 .................................................................................. 8 JDBC數(shù)據(jù) 訪問接口 .................................................................................. 8 第三章 系統(tǒng)設(shè)計 .......................................................................................................... 10 需求分析 .......................................................................................................... 10 運行環(huán)境 ................................................................................................. 10 系統(tǒng)總體設(shè)計 ................................................................................................... 10 系統(tǒng)目標(biāo)設(shè)計 ........................................................................................ 10 系統(tǒng)設(shè)計思想 ........................................................................................ 10 系統(tǒng)功能描述 ........................................................................................ 11 系統(tǒng)用例圖 ............................................................................................ 13 系統(tǒng) UML活動圖 ..................................................................................... 14 第四章 數(shù)據(jù)庫設(shè)計 ...................................................................................................... 15 總體表設(shè)計 ...................................................................................................... 15 數(shù)據(jù)庫表的結(jié)構(gòu) ............................................................................................... 15 實體及 ER圖 .................................................................................................... 17 實體介紹 ............................................................................................... 17 實體的 ER圖以及各實體之間聯(lián)系的 ER圖 .............................................. 17 數(shù)據(jù)庫表的關(guān)系圖 ............................................................................................ 20 數(shù)據(jù)庫表的視圖 ............................................................................................... 21 數(shù)據(jù)庫連接 ...................................................................................................... 21 第五章 系統(tǒng)具體實現(xiàn) ................................................................................................... 24 登入界面 .......................................................................................................... 24 學(xué)生界面 .......................................................................................................... 26 學(xué)生界面功能實現(xiàn) ............................................................................................ 27 查看公告頁面 ........................................................................................ 27 學(xué)生修改密碼頁面 ................................................................................. 27 學(xué)生學(xué)籍維護頁面 ................................................................................. 29 成績查詢 ............................................................................................... 31 查看學(xué)修課表并進行選修 ....................................................................... 31 管理員界面 ...................................................................................................... 33 管理員界面功能實現(xiàn) ........................................................................................ 34 查看學(xué)生基本信息 ................................................................................. 34 添加新學(xué)生和選修課 .............................................................................. 36 查看學(xué)修課表和必修課表 ....................................................................... 37 查看學(xué)生選課情況和學(xué)生成績 ................................................................ 38 添加必修課表和學(xué)生成績 ......................................