范例
学院名称论文提交日期
本 科 毕 业 论 文 农业信息技术学习网站的开发 周朋友 200730010428 指导教师 刘丽五 教授 宋凤 老师 农学院 专业名称 农学（信息技术方向） 论文答辩日期 ?
摘 要
我国作为最大的发展中国家和传统的农业大国，农业信息技术有着巨大的应用空间和广阔的发展前景。华南农业大学农学院为了适应我国--特别是改革开放的广东农业发展的需要，提出基于现代农业的专业改革，在农学专业下设四个方向，其中之一农业信息技术方向。该方向建于20xx年，是一个将现代信息技术与农业科学相结合的新专业方向。经过几年的实践，该专业方向表现出广阔的发展前景。在网络技术飞速发展的时代，建立农业信息技术学习网站、整合本专业方向的相关资源，以提供本专业方向的学生交流学习和分享经验是十分必要的。
本文根据农学（农业信息技术方向）专业的需要，以现有的专业材料为基础，通过JSP、MySQL、Struts和Tomcat等软件，开发农业信息技术学习网站。该网站主要由“关于农信”、“相关资讯”、“课程资源”和“讨论区”等模块组成，实现了如下五个方面主要功能：一是本专业的介绍，包括专业简介、师资和优秀毕业生；二是相关资讯的浏览，包括新闻和文章；三是课程资源的下载和评论；四是师生讨论区；五是管理员管理。这些功能已通过测试，均能正常实现，内容丰富且方便浏览。本网站按照网站的通用开发流程，先通过与农学（农业信息技术方向）专业的同学详细交流，确定网站的主要功能，然后用HTML+CSS设计前台界面，接着编码实现后台管理，最后进行程序测试。将网站的前台样式和表现分开设计，后台则采用Java技术实现，并提供了将来出现新需求时的扩展接口。本网站以蓝色作为基调，表示农业信息技术方向具有希望、具有发展前景。网站的访问方式为：http://202.116.160.176/NongXin/
关键词 网站 JSP MySQL Struts Tomcat
Developing Learning Website for the Agriculture Information Technology
Zhou Xueyou
（College of Agriculture, South China Agricultural University, Guangzhou, 510642, China）
Abstract: China is the biggest developing and traditional agricultural country, where the
information technology in agriculture grows very fast. In order to meet the great need of it, the Agriculture College of SCAU took out a Modern-Agriculture-based way to reform, and divided its Major of Agriculture into four directions. The Major of Agriculture Information Technology is one of them. Built at 2001, the Major of Agriculture Information Technology is a modern information technology and agricultural science combined major, which grows very fast these years and now needs a online platform to offer its students to quickly get its resource and a place to share and communicate.
In this study, with JSP, MySQL, Struts and Tomcat, the author developed a website, which contains four menus that respectively named “About the Major”, “News”, “Resource” and “Forum” for the Major of Agricultural Information Technology to achieve the following five functions. Firstly, introduction of the major, including a simple sumary of the major and introduction of the teacher team and outstanding students. Secondly, relative news and articles. Three, a place to offer free resource downloading and comments. Fourly, a forum for the teachers and students to discuss. At last, features for administrator. All functions above were tested and are now running online fluently. Based on Java and XHTML+CSS, this website can be easily expanded in the future. The background color of this site is blue, which is the symbol of the hope and glory blueprint for the Major of Agriculture Information Technology. You can visit the website at http://202.116.160.176/NongXin/.
Key words: Website JSP MySQL Struts Tomcat
目 录
1 前言 ·········································································································································· 1 2 材料与方法 ······························································································································ 1
2.1 材料 ······································································································································· 1
2.2 方法 ······································································································································· 1
2.2.1 需求分析 ···························································································································· 1
2.2.2 用户界面设计及开发 ········································································································ 1
2.2.3 MySQL数据库设计 ·········································································································· 1
2.2.4 采用Java开发JavaBean程序 ························································································· 1
2.2.5 采用JSP开发前台程序 ·································································· 错误！未定义书签。
2.2.6 采用Struts 2开发网站管理程序 ···················································· 错误！未定义书签。 3 结果 ·········································································································································· 2
3.1 程序测试 ······························································································································· 2
3.1.1 用户访问网站 ·················································································· 错误！未定义书签。
3.1.2 管理员管理 ························································································································ 2
3.2 用户测试及评估 ··················································································································· 2
3.3 后台评估 ······························································································································· 2 4 讨论 ·········································································································································· 2 参考文献 ···································································································· 错误！未定义书签。 附录 ············································································································ 错误！未定义书签。 致谢 ············································································································ 错误！未定义书签。
1 前言
我国作为最大的发展中国家和传统的农业大国，农业信息技术有着巨大的应用空间和广阔的发展前景。华南农业大学农学院为了适应我国--特别是改革开放的广东农业发展的需要，提出基于现代农业的专业改革，在农学专业下设四个方向，其中之一农业信。。。。。。。。。。。。。。。。。。。。。。优秀毕业生；其二是相关资讯的浏览，包括新闻和文章；其三课程资源的下载和评论；其四是师生讨论区；其五是管理员管理（马如等，1990；Feng, et al, 2001）。
2 材料与方法
2.1 材料 2.2 方法 2.2.1 需求分析
2.2.2 用户界面设计及开发
根据主要用户年轻化的特点，本例在配色方案和导航设计两方面以活泼为主，添加了一些传统网站少用的元素如灯箱效果和交互动画来增强用户体验。 2.2.3 MySQL数据库设计
新建数据库数据表及字段见表1。
表1 高秆野生稻群体主要农艺性状分析
性状 株高(cm) 穗数 实粒 空粒
2.2.4 采用Java开发JavaBean程序
JSP（Java Server Pages）可以使用成熟的JavaBean组件来实现复杂的业务功能。本例采用如下9个类，使用JDBC（Java Data Base Connectivity,java数据库连接）与数据库交互，实现数据的持久化（Java代码见附录）。通过JDBC编程接口，用Java程序设计语言编写的应用程序能够执行SQL（Structured Query Language,结构化查询语言）语句、检
1
最小值 1.73 3 2 260
最大值 平均值±标准误 3.26 24 3160 2100
2.23+0.00167 8.48+0.0181 178+1.582 855+1.9206
偏度 1.172 1.393
峰度 0.564 2.484
变异系数 0.153 0.438 2.992 0.459
5.903 43.768 1.016
0.745
索结果、在友好的的用户界面中显示数据，并且可以将所做的改动传回到数据库[2]。 3 结果
3.1 程序测试
3.1.1 管理员管理
图1 本例的前台配色方案
3.1.1 管理员支持
3.2 用户测试及评估
3.3 后台评估
4 讨论
本站后台用Java技术实现，具有良好的安全性（王武等，1999）。网站的安全性问题在于如何保护网站数据不被泄露、损坏、窃取或篡改。本网站通过实现一个过滤器防止未登录用户进入网站后台管理相关页面。。。。。。。。。。。。网站的用户密码经过MD5加密，对用户个人数据有很好的保护。网站采用MySQL实现数据库，每周定期进行三次备份，以防服务器发生严重故障导致系统重装时无法恢复数据。
2
参 考 文 献
傅立国. 野生水稻种属，中国植物红皮书（第一册），北京：科学出版社, 1992, 314-316. 吕川根，邹江石．水稻亚种间亲和性的研究进展．江苏农业学报，2000，16(1)：50－56. 梁国华，严长杰，裔传灯等．水稻广亲和性遗传的再研究．遗传学报，2001，28：447?457. 欧阳学智，李宝健．籼粳杂种F1雌性败育的某些超微结构特征．两系法杂交水稻研究论
文集．北京：中国农业出版社，1992，290-293.
宋翔．水稻籼粳亚种间杂种不育机理的研究．武汉，华中农业大学博士学位论文，2005 Aris-Brosou S, Yang Z. Effects of models of rate evolution on estimation of divergence dates
with special reference to the metazoan 18S ribosomal RNA phylogeny. Syst Biol, 2002, 51: 703-714.
Ikehashi H, Araki H. Genetics of F1 sterility in remote crosses of rice. Rice Genetics, ed IRRI
(IRRI, Manila), 1986: 119-130.
Ikehashi H, Wan J. Differentiation of alleles at seven loci for hybrid sterility in cultivated rice
(Oryza sativa L.). In: Rice genetics: Proceedings of the international rice genetics symposium, 16-20 October 1995, IRRI, Manila. 1996. pp 404–408.
Nei M, Kumar S. 2000. Molecular evolution and phylogenetics. London, Oxford University Press.
3
附 录
基因序列：
1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T NJ11 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T 02428 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T SXW006 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T YLW004 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T YLW006 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T IRW496 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T IRW501 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T IRW644 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T DXW051 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T DXW062 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T CHW001 1 A T C A A C C C A T T T C C T T T C C T A C G T T T G A C T G C C T G C C T G C C C C T G A G C A A G C A A G A A A G A A A G A A A G A A G G G A T T A A A T T GZW032
致 谢
本文是由刘丽五教授和宋凤老师指导下完成的。
2010届毕业生潘浩文师兄等给予帮助。感谢同学们在我完成论文的过程中给予我的无私的帮助。
最后，谨向评阅本论文的各位老师表示敬意和感谢
4