目 录
中文摘要 I
英文摘要 II
1 引言 1
2 智能交通系统介绍 2
2.1 智能交通系统(ITS)概述 2
2.2智能交通管理系统的应用现状及发展趋势 3
3 开发方法、技术、工具 4
3.1 系统的开发方法 4
3.2 开发技术 4
3.2.1动态网页技术简介 4
3.2.2 JSP技术简介 4
3.3开发工具 5
3.3.1网页制作工具Deamweaver MX2004 6
3.3.2 SQL 6
3.3.3 Eclipse 7
4 需求分析 10
4.1 设计目标 10
4.2 智能道路交通信息系统描述 10
4.2.1 功能模块简单描述 10
4.3 系统的数据流程分析 12
4.3.1 数据流程分析概述 12
4.4.2 数据流程图 12
5 数据库系统及设计 17
5.1 数据库的引入 17
5.2 数据库E-R模型 18
5.3 数据库表结构设计 19
5.4 数据库的完整性和安全性 25
5.4.1 数据库的完整性 25
5.4.2 数据库的安全性 25
6 系统主要功能模块的设计与实现 26
6.1 系统设计概述 26
6.1.1 系统设计的原则与内容 26
6.1.2 系统设计的基本方法 26
6.2 系统主要功能模块结构设计 27
6.2.1 系统主要功能模块结构 27
6.2.2 用户管理子系统 27
6.2.3 用户组管理子系统 28
6.2.4 违章信息录入子系统 29
6.2.5 违章信息公告子系统 32
6.2.6 违章处罚子系统 32
6.2.7 信息统计子系统 33
6.3系统重要的程序实现简介 36
6.3.1 数据库的连接实现 36
6.3.2 违章图片存储方式 37
7 系统测试 38
7.1 软件测试的目的和原则 38
7.2 系统测试 39
7.2.1 JSP的中文乱码问题 39
7.2.2 表单和表格打印问题 39
7.2.3 数据库时间字段以及页面中的时间显示问题 39
7.3 软件运行与安装 40
7.3.1 J2EE应用程序的构建与部署 40
7.3.2 具体运行过程 40
8 结论 41
9 致谢 43
参考文献 44
6 系统主要功能模块的设计与实现
6.1 系统设计概述
6.1.1 系统设计的原则与内容
系统设计阶段的主要目的是，在系统分析提出的反映用户需求的逻辑方案的基础上，科学合理地将逻辑方案转换成可以实施的物理（技术）方案。即根据系统分析说明书中的系统逻辑模型，综合考虑各种约束，利用一切可用的技术手段和方法，进行各种具体设计，确定新系统的实施方案，解决“系统怎么做”的问题。系统设计阶段的主要任务是：在科学合理的设计系统总体模型的基础上，尽可能提高系统的运行效率、可变性、可靠性、可控性和工作质量。充分利用并合理投入各类可以利用的人、财、物资源，使之获得较高的综合效率。[3]
系统设计包括总体结构设计和具体物理模型设计。总体结构设计主要指在系统分析的基础上，对整个系统的划分、机器设备配置=数据的存储规律以及整个系统实现设计等方面的合理安排。
系统设计的优劣会直接影响到整个系统设计的质量和所获得的经济效益。因此，为了使设计的系统能最大限度地满足用户的需求，在系统设计中应遵循这样一些基本原则：简单性、系统性、灵活性、可靠性和经济性。[7]
6.1.2 系统设计的基本方法
目前常见的系统设计方法主要有Jackson法、Parnas法和结构化设计方法(SD)等。其中，Jackson法是面向数据结构的设计方法，其核心是按输入输出以及内部存储信息的数据进行设计，把数据结构的描述变换为对程序结构的描述；Parnas方法与主张程序结构要充分反映数据结构的Jackson方法完全相反，Parnas方法主张将可能会发生变化的数据结构隐藏在一个模块的内部，使其它模块与这个因素无关，也就是说，在设计模块时，将某个因素屏蔽在某个模块内部，这个因素的不断变化不至于传播到所在模块的边界之外，即以信息屏蔽为原则建立模块结构：SD方法是通过将结构化编程技术(SP)的思想移植到整个程序系统的模块结构设计领域而形成的。SD方法自诞生以来，一直显示其强大的生命力，被计算机界认为是60年代末期软件领域研究的最大成果之一，是目前模块结构设计中历史最久、使用最广的一种方法。
SD方法的主题思想是将一个程序系统设计成由有层次关系的、相对独立的、单一 功能的诸模块组成的结构，即一方面满足模块间联系弱，模块内联系强的要求，另一方面诸模块之间具有简单的层次结构关系。在这种层次型的模块结构中，模块之间的调用关系非常明确与简单，每个模块可以单独地被理解、编写、调试、查错与修改，一个模块的错误不易向其它模块扩散。理论分析与实践经验都证明，这种层次型的模块结构具有较高的正确性、可靠性、可理解性和可维护性，它适用于任何软件系统的模块结构设计。因此，本系统开发设计中选用SD方法进行系统设计。
6.2 系统主要功能模块结构设计
6.2.1 系统主要功能模块结构
智能道路交通信息管理系统的设计方法主要采用结构化系统的设计方法，其主要特点是：模块结构相对独立、功能单一；模块内部联系大；模块之间联系小；采用模块结构图的描述方式。
本系统根据功能结构来划分为多个子系统模块，主要的功能模块有用户管理、权限管理、违章信息录入、违章信息公告、违章处罚、违章信息统计以及系统的设置部分——包括了：支队管理、大队管理、违章行为、违章地点、车辆类型、处罚地点等子模块。接下来分别介绍几个重要的模块的设计。
6.2.2 用户管理子系统
用户管理子系统仅供管理员级的用户使用，它包括增加用户和查询用户信息两个模块：
①增加用户：填写用户信息，设定用户所属的组，添加用户设定密码。
<%@page contentType="application/msword;charset=gb2312" language="java" import="com.db.*,com.WZXinXi.*,com.ChuFaResult.*,java.lang.*,java.util.*,java.sql.*"%>
<%
request.setCharacterEncoding("gb2312");
%>
<%
String quhua=request.getParameter("quhua");
String bianhao = request.getParameter("bianhao");
String xingming = request.getParameter("xingming");
String part = request.getParameter("part");
String danwei = request.getParameter("danwei");
String sehngfen = request.getParameter("sehngfen");
String carid = request.getParameter("carid");
String cartype = request.getParameter("cartype");
String year1 = request.getParameter("year1");
String mouth1 = request.getParameter("mouth1");
String date1 = request.getParameter("date1");
String hour1 = request.getParameter("hour1");
String min1 = request.getParameter("min1");
//out.print(min1);
String miao = request.getParameter("miao");
out.print(miao);
String caraction = request.getParameter("caraction");
String actionid = request.getParameter("actionid");
String tiaoli = request.getParameter("tiaoli");
String tiaoli1 = request.getParameter("tiaoli1");
String tiao= request.getParameter("tiao");
String kuan = request.getParameter("kuan");
String xian = request.getParameter("xian");
String fajin = request.getParameter("fajin");
String fangshi = request.getParameter("fangshi");
String bank = request.getParameter("bank");
String lilu = request.getParameter("lilu");
String fuyi = request.getParameter("fuyi");
String addr = request.getParameter("addr");
String police = request.getParameter("police");
String year2 = request.getParameter("year2");
String mouth2 = request.getParameter("mouth2");
String date2 = request.getParameter("date2");
ChuFaResult add=new ChuFaResult();
add.setWspace(quhua);
add.setId(bianhao);
add.setName(xingming);
add.setPart(part);
add.setAddr(danwei);
add.setSid(sehngfen);
add.setCarid(carid);
add.setCarType(cartype);
String shijian = year1+"-"+mouth1+"-"+date1+" "+hour1+":"+min1+":"+miao ;
add.setShijian(shijian);
add.setCaraction(caraction);
add.setActionid(actionid);
float fj=Float.parseFloat(fajin);
add.setFajing(fj);
add.setChuaddr(addr);
add.setPerson(police);
String chusj = year2+"-"+mouth2+"-"+date2;
add.setChushijian(chusj);
Connection conall = DBConection.getConnect();
ChuFaResultBean addsave = new ChuFaResultBean(conall);
WZXinXiBean update = new WZXinXiBean(conall);
try{
addsave.add(add);
update.updateWZXinXi2(carid,shijian);
%>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="./test.files/filelist.xml">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>aaa</o:Author>
<o:LastAuthor>aaa</o:LastAuthor>
<o:Revision>38</o:Revision>
<o:TotalTime>57</o:TotalTime>
<o:Created>2006-05-18T12:47:00Z</o:Created>
<o:LastSaved>2006-05-22T09:10:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>53</o:Words>
<o:Characters>307</o:Characters>
<o:Company>cqu</o:Company>
<o:Lines>2</o:Lines>
<o:Paragraphs>1</o:Paragraphs>
<o:CharactersWithSpaces>377</o:CharactersWithSpaces>
<o:Version>9.2812</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:PunctuationKerning/>
<w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing>
<w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery>
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
<w:Compatibility>
<w:SpaceForUL/>
<w:BalanceSingleByteDoubleByteWidth/>
<w:DoNotLeaveBackslashAlone/>
<w:ULTrailSpace/>
<w:DoNotExpandShiftReturn/>
<w:AdjustLineHeightInTable/>
<w:UseFELayout/>
</w:Compatibility>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:宋体;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@宋体";
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
mso-pagination:none;
font-size:10.5pt;
mso-bidi-font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:宋体;
mso-font-kerning:1.0pt;}
p.MsoBodyText, li.MsoBodyText, div.MsoBodyText
{margin:0cm;
margin-bottom:.0001pt;
text-align:center;
mso-pagination:none;
font-size:10.5pt;
mso-bidi-font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:宋体;
mso-font-kerning:1.0pt;}
/* Page Definitions */
@page
{mso-page-border-surround-header:no;
mso-page-border-surround-footer:no;}
@page Section1
{size:10.0cm 269.35pt;
margin:72.0pt 89.85pt 72.0pt 89.85pt;
mso-header-margin:42.55pt;
mso-footer-margin:49.6pt;
mso-paper-source:0;
layout-grid:15.6pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body bgcolor="#CCCCCC" style='tab-interval:21.0pt;text-justify-trim:punctuation' lang=ZH-CN>
<div class=Section1 style='layout-grid:15.6pt'>
<p class=MsoBodyText style='text-align:justify;text-justify:inter-ideograph;
text-indent:42.0pt;mso-char-indent-count:4.0;mso-char-indent-size:10.5pt;
mso-char-indent-size:10.5pt'><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>公共交通管理违章处罚决定书</span></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>行政区划：</span><span lang=EN-US><span
style="mso-spacerun:
yes"> </span><span
style="mso-spacerun: yes"> </span><font color="#0000FF"><%=quhua%></font><span style='mso-tab-count:1'>
</span></span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>编号：</span><span lang=EN-US><span style="mso-spacerun:
yes"> </span></span><font color="#0000FF"><%=bianhao%></font></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>被处罚人姓名：</span><span lang=EN-US><span
style="mso-spacerun: yes"> </span><span
style="mso-spacerun: yes"> </span><font color="#0000FF"><%=xingming%></font><span style="mso-spacerun:
yes"> </span><span style='mso-tab-count:1'> </span></span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>发证机关：</span><font color="#0000FF"><%=part%></font> </p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>单位地址：</span><span lang=EN-US><span
style="mso-spacerun:
yes"> </span><span
style="mso-spacerun: yes"> </span></span><font color="#0000FF"><%=danwei%></font></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>驾驶证或身份证号码：</span> <span
style="mso-spacerun: yes"> </span><font color="#0000FF"><%=sehngfen%></font></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>车牌号码：</span><span lang=EN-US><span
style="mso-spacerun:
yes"> </span><span
style="mso-spacerun: yes"> </span><font color="#0000FF"><%=carid%></font><span style="mso-spacerun:
yes"> </span><span style='mso-tab-count:
1'> </span></span><span style='font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>车辆类型：</span><font color="#0000FF"><%=cartype%></font>
</p>
<p class=MsoNormal style='text-indent:21.0pt'><span style='font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>鉴于</span>
<span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=year1%></font>年</span> <span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'><font color="#0000FF"><%=mouth1%></font>月</span> <span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=date1%></font>日</span> <span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'><font color="#0000FF"><%=hour1%></font>时</span> <span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=min1%></font>分</span> <span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'><font color="#0000FF"><%=caraction%></font>（违章行为）</span></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>违章代码</span> <span style='font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'><font color="#0000FF"><%=actionid%></font>，根据</span><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:42.0pt;mso-char-indent-count:4.0;
mso-char-indent-size:10.5pt;mso-char-indent-size:10.5pt'><span lang=EN-US><span
style="mso-spacerun: yes"> </span></span><span style='font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>中华人民共和国道路交通管理条例</span>
<span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:42.0pt;mso-char-indent-count:4.0;
mso-char-indent-size:10.5pt;mso-char-indent-size:10.5pt'><span lang=EN-US><span
style="mso-spacerun: yes"> </span><span style="mso-spacerun:
yes"> </span><font color="#0000FF"><%=tiaoli%></font><span style="mso-spacerun: yes">
</span><o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:42.0pt;mso-char-indent-count:4.0;
mso-char-indent-size:10.5pt;mso-char-indent-size:10.5pt'><span lang=EN-US><span
style="mso-spacerun: yes"> </span><span style="mso-spacerun:
yes"> </span><font color="#0000FF"><%=tiaoli1%></font><span style="mso-spacerun: yes">
</span></span></p>
<p class=MsoNormal><span lang=EN-US><span style="mso-spacerun:
yes"> </span></span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>第</span> <span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=tiao%></font>条第</span> <span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'><font color="#0000FF"><%=kuan%></font>款第</span> <span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=xian%></font>项之规定。决定给予罚款</span> <span style='font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'><%=fajin%>元的罚款。</span><span
lang=EN-US><o:p></o:p></span></p>
<%
if(fangshi.equals("0"))
{
%>
<p class=MsoNormal><span lang=EN-US><span style="mso-spacerun:
yes"> </span></span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>现金缴纳</span><span
lang=EN-US><span style="mso-spacerun: yes"> </span><o:p></o:p></span></p>
<%
}else{
%>
<p class=MsoNormal><span lang=EN-US><span style="mso-spacerun:
yes"> </span></span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>自本决定起</span><span
lang=EN-US>15</span><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>日内到</span> <span style='font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'><font color="#0000FF"><%=bank%></font>银行缴纳。逾期不缴纳的，每日按罚款金额的</span>
<span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=lilu%></font>加处罚款。</span></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>无正当理由，超期</span><span lang=EN-US>3</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>个月不缴纳，撤销驾驶证</span><span lang=EN-US><o:p></o:p></span></p>
<%
}
%>
<p class=MsoNormal><span lang=EN-US><span style="mso-spacerun:
yes"> </span></span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>如不服从本决定，可在</span><span
lang=EN-US>30</span><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>日内向</span> <font color="#0000FF"><%=fuyi%></font><span
style="mso-spacerun: yes"> </span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>申请行政复议或在</span><span
lang=EN-US>3</span><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>个月内</span></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>向人民法院提出诉讼</span></p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>处罚地点：</span> <span lang=EN-US><font color="#0000FF"><%=addr%></font><span
style='mso-tab-count:2'> </span></span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>值勤民警：</span><font color="#0000FF"><%=police%></font> </p>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>违章处罚决定书填写时间：</span> <span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=year2%></font>年</span> <span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'><font color="#0000FF"><%=mouth2%></font>月</span> <span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'><font color="#0000FF"><%=date2%></font>日</span></p>
</div>
</body>
</html>
<%
}catch(Exception e)
{
out.print(e.getMessage()+"\n数据库保存失败！！！请检查数据！！！！");
}
%>
716
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
