基于JSP技术的学生网上选课系统的设计与实现_毕业设计论文

基于JSP的学生学籍管理系统—计算机毕业设计(论文) 毕业设计(论文)题目基于JSP的学生学籍管理系统学生学籍管理系统基于JSP的学生学籍管理系统摘要随着信息技术在管理上越来越深入而广泛的应用，管理信息系统的实施在技术上已逐步成熟。

管理信息系统是一个不断发展的新型学科，任何一个单位要生存要发展，要高效率地把内部活动有机地组织起来，就必须建立与自身特点相适应的管理信息系统。

本文采用JSP和MS SQL-Server等软件为开发工具，以Windows XP(或Windows 2000)为开发平台，设计出一个学籍管理信息系统，对学生的信息、课程、成绩进行统一管理，便于查询、修改和删除。

涉及到的主要内容有:体系结构规划、设计平台的搭建以及系统的设计。

主要实现的功能模块有管理系统的功能介绍子系统、新生入学子系统、学生成绩管理子系统、在校学生管理子系统、离校学生管理子系统、各种信息查询子系统以及系统维护子系统。

该系统功能完善，可使高校的学籍管理系统从纯手工中解脱出来，实现高校学籍管理系统自动化、规范化、合理化、科学化，其实用性强，用户界面友好，有助于加快高校的信息传递和智能建设，并为高校整体实现信息化管理体系作好铺垫。

关键字:学生学籍管理; B/S;JSP;SQL SERVER 2000;JDBC-ODBC;I学生学籍管理系统Based on JSP student records management systemAbstractAlong with information technology in management more and more thorough and widespread application, the management information system the implementation to be gradually mature in the technology. The management information system is the new discipline which unceasingly develops, any unit must survive and develop, wants the high efficiency organically to organize the internal activity, must establish the management information system which adapts with own characteristic.This article uses JSP and MS SQL-Server and so on is the development kit, (or Windows 2,000) as develops the platform take Windows XP, designs a school register management information system, to student's information, the curriculum, the result carries on the unification management, is advantageous for the inquiry, the revision and the deletion. Involves the main content includes: The system structure plan, designs the platform to build as well as the system design. The main realization function module has the management system management system the function to introduce the subsystem, the new born matriculation subsystem, the student result management subsystem, manages the subsystem in the school student, manages the subsystem, each kind of information inquiry subsystem as well as the system maintenance subsystem to the school student.This system function perfect, may cause the universities the school register management system to extricate from the pure handwork, realization universities school register management system automation,standardization, rationalization, scientific style, its usability strong, the user contact surface is friendly, is helpful to speeds up the universities the information transmission and the intelligent construction, and finishes the upholstery for the universities whole realization information management system.Keywords: Student school records management ;B/S; JSP; SQL SERVER 2000; JDBC-ODBCII学生学籍管理系统目录摘要 ..................................................................... ........................................................................ . (I)ABSTRACT ............................................................... ........................................................................ ......II 引言 ..................................................................... ........................................................................ ............ 5 第一章绪论 ..................................................................... . (6)1.1选题背景和意义 ............................................................................................................................ 6 1.3系统开发技术 ..................................................................... ........................................................... 7 1.3.1 B/S 体系结构 ..................................................................... ......................................................... 7 1.3.2 SQL SERVER2000 ................................................................... ..................................................... 8 1.3.3 JSP技术 ..................................................................... ............................................................... 9 1.3.4 ODBC数据访问接口 ..................................................................... ........................................... 9 1.3.5 JDBC数据访问接口 ..................................................................... ............................................ 10 1.3.6JAVASCRIPT ............................................................. . (10)第二章系统设计 ..................................................................... ............................................................. 122.1需求分析 ..................................................................... .. (12)2.1.1运行环境 ..................................................................... .............................................................. 12 2.2系统总体设计 ..................................................................... ......................................................... 12 2.2.1 系统目标设计 ..................................................................... ...................................................... 12 2.2.2 系统设计思想 ..................................................................... ...................................................... 13 2.2.3 系统功能描述 ..................................................................... ...................................................... 13 2.2.4系统用例图 ..................................................................... .......................................................... 15 2.2.5系统UML活动图 ..................................................................... ................................................ 17 第三章数据库设计 ..................................................................... ......................................................... 19 3.1总体表设计 .................................................................................................................................. 19 3.2 数据库表的结构 ..................................................................... ..................................................... 19 3.3 实体及ER图 ..................................................................... ......................................................... 25 3.3.1 登录管理 ..................................................................... ............................................................. 25 3.3.2实体的ER图 ..................................................................... ....................................................... 25 3.4 数据库表的关系图 ..................................................................... ................................................. 27 3.5 数据库表的视图 ..................................................................... ..................................................... 28 第四章系统具体实现 ..................................................................... ..................................................... 29 4.1 关键应用 ..................................................................... . (29)4.1.1数据库连接 ............................................................................................................................... 29 4.2 登录管理 ..................................................................... ................................................................ 32 4.3 菜单界面 ..................................................................... ................................................................ 33 4.4 系统管理 ..................................................................... . (34)4.4.1学生信息显示页面 ..................................................................... ............................................... 34 4.4.2学生信息修改页面 ..................................................................... ............................................... 37 4.4.3添加学生信息页面 ..................................................................... ............................................... 37 4.4.4成绩查看页面 ..................................................................... ...................................................... 38 4.5课程管理 ..................................................................... .. (39)4.5.1选修课表显示 ..................................................................... ...................................................... 39 4.5.2选课情况页面 ..................................................................... (40)3学生学籍管理系统4.6 学生管理页面 ..................................................................... ........................................................ 41 4.6.1学籍维护页面 ..................................................................... ...................................................... 42 4.6.2成绩查看页面 ..................................................................... ...................................................... 44 4.6.3学生选修课表页面 ..................................................................... ............................................... 44 4.6.4所选的课程 ..................................................................... .......................................................... 45 4.6.5修改个人密码 ..................................................................... ...................................................... 46 第五章全文总结 ..................................................................... ............................................................. 47 致谢 ............................................................................................................................................. ...... 49 参考文献:..................................................................... .......................................................................494学生学籍管理系统引言进入二十一世纪，计算机技术迅速向着网络化、集成化方向发展。

JSP学生选课系统-课程设计JSP学生选课系统052 1. 一、实训目的计算机应用实训是计算机科学与技术专业重要的实践性教学课程，安排在毕业前最后一学期进行。

通过本次应用实训，使学生对结合学习过的知识，对软件开发过程进一步理解，并掌握按照软件工程的思想，进行程序开发设计的过程，同时培养学生严谨、科学的工作作风，为今后从事计算机工作打下必要的基础。

通过本次实训，使学生掌握程序设计中需求分析、概要设计、详细设计的方法和过程，并通过实际学习，利用Eclipse3+MyEclipse6+JDK6开发环境，实现基于JSP环境下采用Model1模式程序的编制。

2. 二、设计题目编号题目备注1 图书管理系统2 人事管理系统3 教材管理系统4 学生管理系统5 工资管理系统6 库存管理系统7 IC卡管理系统8 科技文献管理系统3. 三、分组原则原则上每组人数不超过5人，在班级内部采用自愿组合的形式，但班级内部两个不同小组不允许选择同一题目。

4. 四、实训要求1、认真听讲。

2、遵守实训时间安排。

3、按时上机，认真练习。

4、认真书写实训报告。

时间安排表：序实习内容总天数讲课操作机动备注号1 布置题目，查找资料 1 0.3 0.72 需求分析与设计3 2 13 数据库设计及答辩 1 0.5 0.54 JSP程序设计 8 4 45 报告撰写 1 0.1 0.96 成绩评定及答辩 1 0.1 0.9合计（天数） 15 7 81. 六、成绩评定成绩包括出勤纪律、分析设计、程序编制和实训报告4个部分。

由实训指导教师科学评定成绩，各项成绩按比例累加得到实训总成绩。

实训各项占总成绩比例如下：出勤纪律：10％分析设计：20％程序编制：50％实训报告：20％注：其中平时成绩和实训报告具有一票否决权，其一不及格总成绩为不及格。

1、本实训是一门综合程序设计课程，在本实训期间，每一部分内容都是教师先讲解，让学生了解之后再进行练习。

2、本实训注重在规定的时间内完成设计内容，目的在于加强学生的动手能力。

选课系统的分析与实现摘要在传统的手工选课处理过程中，存在着大量繁重而复杂的工作。

选课工作将成为教务管理的一个主要任务,改变原有的人工选课方式,采用网上选课势在必行。

本文通过分析传统人工选课的缺点及基于校园网的网上选课系统的优点，提出了基于B/S模式网上选课系统的基本设计思想，简要介绍了B/S结构模式以及JSP技术，详细介绍了系统的功能设计,数据库设计与数据库连接池的配置方法，以及系统的具体实现方法，并在试运行的基础上对系统的进一步完善提出了改进方案。

经过多次运行测试,本系统能够满足学生选课、教师录入成绩、管理员录入基本信息与成绩管理等各方面的需求。

关键词网上选课系统;B/S模式；JSP；数据库ABSTRACT In the traditional way of courses selecting process ,themanagement job needs many men to work on。

It is heavy and complicated .Because selecting courses has become important part of school management ， it is very necessary to replace the old inefficient way with the modern way based on Internet.This paper gives the basic design idea of the B/S—based online courses selecting system by analyzing the shortcoming of manual process of course selection and the excellence of online courses selecting system which base on campus—web 。

本科生毕业设计（论文）外文翻译毕业设计（论文）题目：基于JSP的高校选排课系统的设计与实现外文题目：Overview of JSP Technology译文题目：JSP技术概述学院：软件学院专业：软件工程学生姓名：学生班级：软件工程1102班学生学号：指导教师：Overview of JSP TechnologyAutor: Zambon Giulio/ Sekler MichaelSource: Springer-Verlag New York Inc1.Benefits of JSPJSP pages are translated into servlets. So, fundamentally, any task JSP pages can perform could also be accomplished by servlets. However, this underlying equivalence does not mean that servlets and JSP pages are equally appropriate in all scenarios. The issue is not the power of the technology, it is the convenience, productivity, and maintainability of one or the other. After all, anything you can do on a particular computer platform in the Java programming language you could also do in assembly language. But it still matters which you choose.JSP provides the following benefits over servlets alone: It is easier to write and maintain the HTML. Your static code is ordinary HTML: no extra backslashes, no double quotes, and no lurking Java syntax.You can use standard Web-site development tools. Even HTML tools that know nothing about JSP can be used because they simply ignore the JSP tags.You can divide up your development team. The Java programmers can work on the dynamic code. The Web developers can concentrate on the presentation layer. On large projects, this division is very important. Depending on the size of your team and the complexity of your project, you can enforce a weaker or stronger separation between the static HTML and the dynamic content.Now, this discussion is not to say that you should stop using servlets and use only JSP instead. By no means. Almost all projects will use both. For some requests in your project, you will use servlets. For others, you will use JSP. For still others, you will combine them with the MVC architecture . You want the appropriate tool for the job, and servlets, by themselves, do not complete your toolkit.2. Advantages of JSP Over Competing TechnologiesA number of years ago, Marty was invited to attend a small 20-person industry roundtable discussion on software technology. Sitting in the seat next to Marty was James Gosling, inventor of the Java programming language. Sitting several seats away was a high-level manager from a very large software company in Redmond, Washington. During the discussion, the moderator brought up the subject of Jini, which at that time was a new Java technology. The moderator asked the manager what he thought of it, and the manager responded that it was too early to tell, but that it seemed to be an excellent idea. He went on to say that they would keep an eye on it, and if it seemed to be catching on, they would follow his company's usual "embrace and extend" strategy. At this point, Gosling lightheartedly interjected "You mean disgrace and distend."Now, the grievance that Gosling was airing was that he felt that this company would take technology from other companies and suborn it for their own purposes. But guess what? The shoe is on the other foot here. The Java community did not invent the idea of designing pages as a mixture of static HTML and dynamic code marked with special tags. For example, ColdFusion did it years earlier. Even ASP (a product from the very software company of the aforementioned manager) popularized this approach before JSP came along and decided to jump on the bandwagon. In fact, JSP not only adopted the general idea, it even used many of the same special tags as ASP did..So, the question becomes: why use JSP instead of one of these other technologies? Our first response is that we are not arguing that everyone should. Several of those other technologies are quite good and are reasonable options in some situations. In other situations, however, JSP is clearly better. Here are a few of the reasons.2.1Versus .NET and Active Server Pages (ASP)NET is well-designed technology from Microsoft. is the part that directly competes with servlets and JSP. The advantages of JSP are two fold.First, JSP is portable to multiple operating systems and Web servers; you aren't locked into deploying on Windows and IIS. Although the core .NET platform runs on a few non-Windows platforms, the ASP part does not. You cannot expect to deploy serious applications on multiple servers and operating systems. For some applications, this difference does not matter. Forothers, it matters greatly.Second, for some applications the choice of the underlying language matters greatly. For example, although .NET's C# language is very well designed and is similar to Java, fewer programmers are familiar with either the core C# syntax or the many auxiliary libraries. In addition, many developers still use the original version of ASP. With this version, JSP has a clear advantage for the dynamic code. With JSP, the dynamic part is written in Java, not VBScript or another ASP-specific language, so JSP is more powerful and better suited to complex applications that require reusable components.You could make the same argument when comparing JSP to the previous version of ColdFusion; with JSP you can use Java for the "real code" and are not tied to a particular server product. However, the current release of ColdFusion is within the context of a J2EE server, allowing developers to easily mix ColdFusion and servlet/JSP code.2.2 Versus PHPPHP (a recursive acronym for "PHP: Hypertext Preprocessor") is a free, open-source, HTML-embedded scripting language that is somewhat similar to both ASP and JSP. One advantage of JSP is that the dynamic part is written in Java, which already has an extensive API for networking, database access, distributed objects, and the like, whereas PHP requires learning an entirely new, less widely used language. A second advantage is that JSP is much more widely supported by tool and server vendors than is PHP.2.3 Versus Pure ServletsJSP doesn't provide any capabilities that couldn't, in principle, be accomplished with servlets. In fact, JSP documents are automatically translated into servlets behind the scenes. But it is more convenient to write (and to modify!) regular HTML than to use a zillion println statements to generate the HTML. Plus, by separating the presentation from the content, you can put different people on different tasks: your Web page design experts can build the HTML by using familiar tools and either leave places for your servlet programmers to insert the dynamic content or invoke the dynamic content indirectly by means of XML tags.Does this mean that you can just learn JSP and forget about servlets? Absolutely not! JSPdevelopers need to know servlets for four reasons:JSP pages get translated into servlets. You can't understand how JSP works without understanding servlets.JSP consists of static HTML, special-purpose JSP tags, and Java code. What kind of Java code? Servlet code! You can't write that code if you don't understand servlet programming.Some tasks are better accomplished by servlets than by JSP. JSP is good at generating pages that consist of large sections of fairly well structured HTML or other character data. Servlets are better for generating binary data, building pages with highly variable structure, and performing tasks (such as redirection) that involve little or no output.Some tasks are better accomplished by a combination of servlets and JSP than by either servlets or JSP alone.2.4 ersus JavaScriptJavaScript, which is completely distinct from the Java programming language, is normally used to dynamically generate HTML on the client, building parts of the Web page as the browser loads the document. This is a useful capability and does not normally overlap with the capabilities of JSP (which runs only on the server). JSP pages still include SCRIPT tags for JavaScript, just as normal HTML pages do. In fact, JSP can even be used to dynamically generate the JavaScript that will be sent to the client. So, JavaScript is not a competing technology; it is a complementary one.It is also possible to use JavaScript on the server, most notably on Sun ONE (formerly iPlanet), IIS, and BroadVision servers. However, Java is more powerful, flexible, reliable, and portable.3. Misconceptions About JSPForgetting JSP Is Server-Side Technology,Here are some typical questions Marty has received (most of them repeatedly).Our server is running JDK 1.4. So, how do I put a Swing component in a JSP page?How do I put an image into a JSP page? I do not know the proper Java I/O commands to read image files.Since Tomcat does not support JavaScript,how do I make images that are highlighted when the user moves the mouse over them?Our clients use older browsers that do not understand JSP. What should we do?When our clients use "View Source" in a browser, how can I prevent them from seeing the JSP tags?All of these questions are based upon the assumption that browsers know something about the server-side process. But they do not. Thus:For putting applets with Swing components into Web pages, what matters is the browser's Java version—the server's version is irrelevant. If the browser supports the Java 2 platform, you use the normal APPLET (or Java plug-in) tag and would do so even if you were using non-Java technology on the server.You do not need Java I/O to read image files; you just put the image in the directory for Web resources (i.e., two levels up from WEB-INF/classes) and output a normal IMG tag.You create images that change under the mouse by using client-side JavaScript, referenced with the SCRIPT tag; this does not change just because the server is using JSP.Browsers do not "support" JSP at all—they merely see the output of the JSP page. So, make sure your JSP outputs HTML compatible with the browser, just as you would do with static HTML pages.And, of course you need not do anything to prevent clients from seeing JSP tags; those tags are processed on the server and are not part of the output that is sent to the client.Confusing Translation Time with Request Time,A JSP page is converted into a servlet. The servlet is compiled, loaded into the server's memory, initialized, and executed. But which step happens when? To answer that question, remember two points: The JSP page is translated into a servlet and compiled only the first time it is accessed after having been modified.Loading into memory, initialization, and execution follow the normal rules for servlets.The most frequently misunderstood entries are highlighted. When referring to the table, note that servlets resulting from JSP pages use the _jspService method (called for both GET and POST requests), not doGet or doPost. Also, for initialization, they use the jspInit method, not the init method.JSP page translated into servlet Servlet compiled Servlet loaded into server's memory jspInit called _jspService called.JSP技术概述作者:赞邦.朱利奥/赛克勒.迈克尔出处: 施普林格出版社（纽约公司）1.JSP的好处JSP页面最终会转换成服务程序。

基于JSP-OTP技术选课系统的设计与实现
邓万友
【期刊名称】《科学技术与工程》
【年(卷),期】2010(010)003
【摘要】以学分制下选课制的基础理论为前提,分析了JDBC、JSP等Web数据库开发技术及OTP等网络安全性技术;阐述了基于网络环境选课系统的设计思想、工作原理和运行机制;构建了平均分布概率算法,进行资源优化,利用虚拟"购物筐"思想、事故处理和一次性口令系统实现了网络化的最优选修课程管理系统.通过多次试验
表明该系统运行稳定、速度快且效率较高、自适应性较强,完全符合学分制管理体
制对选课系统的要求.
【总页数】5页(P807-811)
【作者】邓万友
【作者单位】大庆石油学院教务处,大庆,163318
【正文语种】中文
【中图分类】TP393.2
【相关文献】
1.基于JSP技术网上选课系统的设计与实现 [J], 柳亚琴
2.基于 Web Service 开发技术的网上选课系统的设计与实现 [J], 赵坤灿;周绍景;
王俊英
3.基于ASP技术的网上选课系统的设计与实现 [J], 任民丰
4.基于Struts+Hibernate技术的网上选课系统设计与实现 [J], 贾兰兰;王秀义
5.基于工作流技术的学生选课系统的设计与实现 [J], 曹风华
因版权原因，仅展示原文概要，查看原文内容请购买。

中南民族大学毕业论文(设计）学院：计算机科学学院专业：计算机科学与技术年级:2010 题目:毕业设计选题系统设计与实现学生姓名：学号: 指导教师姓名: 刘赛职称：副教授2014年5月中南民族大学本科毕业论文（设计)原创性声明本人郑重声明：所呈交的论文是本人在导师的指导下独立进行研究所取得的研究成果.除了文中特别加以标注引用的内容外，本论文不包含任何其他个人或集体已经发表或撰写的成果作品。

本人完全意识到本声明的法律后果由本人承担.作者签名：年月日目录摘要 (1)关键词 (1)Abstract (1)Key words (1)1 引言 (2)1。

1 JSP简介 (2)1.2 My eclipse简介 (2)1.3 Mysql简介。

.。

.。

.。

.。

...。

.。

.。

.。

..。

.。

...。

.。

.。

....。

.。

..。

..。

.。

.。

...。

..。

.。

.。

..。

.。

.。

..。

.。

..。

.。

.。

...。

.。

.。

..。

.22 系统分析 (2)2.1 需求分析 (2)2.2 可行性分析 (3)3 系统设计 (3)3.1 系统功能结构。

...。

.。

..。

.。

.。

.。

.。

........。

..........。

....。

..。

.。

..。

..。

....。

..。

.。

..。

. .。

..。

..。

..。

...。

..。

..。

.。

.。

33。

2 设计目标 (3)3。

3 开发及运行环境 (4)3。

4 数据库设计 (4)4 系统总体架构 (5)4。

1 系统页面具体结果显示 (5)4.2 类的分布 (8)5 系统主要功能模块设计 (9)5。

1 登录模块设计 (9)5.1.1 用户层。

..。

...。

...。

.。

.。

...。

.。

.。

.。

.。

.。

..。

...。

..。

....。

.。

...。

.。

.。

...。

..。

.。

.。

.。

.。

..。

.。

.。

........。

..。

105。

1.2 数据层的方法 (12)5。

1。

3 实体映射层的方法 (13)6 学生模块具体实现 (15)6。