保密工作领导责任制-小学语文试题

范例




本科毕业论文



农业信息技术学习网站的开发







学院名称
论文提交日期



农学院

年 月 日
专业名称

农学（信息技术方向）
论文答辩日期

年 月 日

摘 要
我国作为最大的发展中国家和传统的农业大国，农业信息技术有着巨大 的应用空间
和广阔的发展前景。华南农业大学农学院为了适应我国--特别是改革开放的广东农业发展的需要，提出基于现代农业的专业改革，在农学专业下设四个方向，其中之一农业信
息技术方向。 该方向建于2001年，是一个将现代信息技术与农业科学相结合的新专业方

向。经过几 年的实践，该专业方向表现出广阔的发展前景。在网络技术飞速发展的时代，
建立农业信息技术学习网站 、整合本专业方向的相关资源，以提供本专业方向的学生交
流学习和分享经验是十分必要的。
本文根据农学（农业信息技术方向）专业的需要，以现有的专业材料为基础，通过
JSP、MySQL、 Struts和Tomcat等软件，开发农业信息技术学习网站。该网站主要由“关
于农信”、“相关 资讯”、“课程资源”和“讨论区”等模块组成，实现了如下五个方
面主要功能：一是本专业的介绍，包 括专业简介、师资和优秀毕业生；二是相关资讯的
浏览，包括新闻和文章；三是课程资源的下载和评论； 四是师生讨论区；五是管理员管
理。这些功能已通过测试，均能正常实现，内容丰富且方便浏览。本网站 按照网站的通
用开发流程，先通过与农学（农业信息技术方向）专业的同学详细交流，确定网站的主要功能，然后用HTML+CSS设计前台界面，接着编码实现后台管理，最后进行程序测试。
将网 站的前台样式和表现分开设计，后台则采用Java技术实现，并提供了将来出现新需
求时的扩展接口。 本网站以蓝色作为基调，表示农业信息技术方向具有希望、具有发展
前景。网站的访问方式为：http :202.116.160.176NongXin

关键词： 网站 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.176NongXin.

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 Connectivi ty,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

索结果、在友好的的用户界面中显示数据，并且可以将所做的改动传回到数据库。
3 结果
3.1 程序测试
3.1.1 管理员管理

图1 本例的前台配色方案
3.1.1 管理员支持
3.2 用户测试及评估
3.3 后台评估
4 讨论
本站后台用Java技术实现，具有良好的安全性（王武等，1999）。网站的安全性问题在于如何保护网站数据不被泄露、损坏、窃取或篡改。本网站通过实现一个过滤器防止
未登录用户进 入网站后台管理相关页面。。。。。。。。。。。。网站的用户密码经过MD5加密，
对用户个人数据有 很好的保护。网站采用MySQL实现数据库，每周定期进行三次备份，
以防服务器发生严重故障导致系 统重装时无法恢复数据。















2

参 考 文 献
傅立国. 野生水稻种属，中国植物红皮书（第一册）[M]，北京：科学出版社, 1992：314-316.

吕川根，邹江石．水稻亚种间亲和性的研究进展[J]．江苏农业学报，2000，16(1)：50< br>－56.
梁国华，严长杰，裔传灯等．水稻广亲和性遗传的再研究[J]．遗传学报，2001 ，28：447−457.
欧阳学智，李宝健．籼粳杂种F
1
雌性败育的某些超微结 构特征[A]．两系法杂交水稻研
究论文集[C]．北京：中国农业出版社，1992：290-293 .
宋翔．水稻籼粳亚种间杂种不育机理的研究[D]．武汉，华中农业大学博士学位论文，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[J]. Syst Biol, 2002,
51: 703-714.
Ikehashi H, Araki H. Genetics of F
1
sterility in remote crosses of rice. Rice Genetics[M], 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[C], 16-20 October 1995, IRRI, Manila. 1996. pp 404–408.
Nei M, Kumar S. 2000. Molecular evolution and phylogenetics[M]. 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