辽宁高速公路收费系统
(IMG 子系统)
毕业设计论文
单 位：____________________
指导教师：____________________
姓 名：____________________
时 间：____________________
论文专用纸
摘 要
辽宁高速收费系统解决了在高速公路收费业务中由于采用传统方法和手
段所出现的难于处理的各种问题，并把管理对象转到信息对象的信息管理系
统，把高速公路收费管理工作推向新的高度。
图像审批系统是高速公路收费管理信息系统的一部分，主要是在分中心
对收费站传回来的图像进行审核。在分中心，当审核人员认为某个捕捉到的
图像有问题，可以进行批注，上报给中心。同时中心审批过的图像也可以及
时的通知分中心。在审批图像的同时，可以明确的得知这些图像产生的时间 、
地点、人员、当时的付款方式，收费员输入的车型等信息。此外在中心和分
中心，也可以根据时间、地点等条件进行查询，以获得当时收费站的图像。
从而达到事后监督审核稽查的作用。
本系统使用当前流行 web 应用程序开发技术 jsp 开发，面向中型站点，
采用了 jsp+javaBean 的架构，以 Apache+Tomcat 为运行环境，在本地
机上实现了 B/S 结构的 web 应用程序。
该系统包括黑车牌照管理、图像审批类型维护、图像审批处理、图像审
批查询和图像审批统计报表五个模块。
关键词 辽宁高速收费系统，图像审批系统，图像审批
Abstract
2
论文专用纸
The charging system of Liaoning speedway oered a
resolution for the intractability problems occurred in speedway
business aairs because of the using of traditional means. She
transformed the management objects to information objects, and
pushed the management of speedway charging to a new high
degree.
Images checking system is a sub-system of the speedway
charging management information system. Its main function is
examining images caught and passed by toll station. In sub-center
station, when the checkers doubt some image, they can annotate
with comments and report to center. In the meanwhile, images in
center station also can be checked and then report to sub-center
station. When we check images, we also can get the messages
about the originate time, address, operator, methods of payment,
car type of these images etc.. In addition, both in center station
and sub-center station, we can query images by time or address,
so that we do supervise and examine.
This system ,which was developed by using the prevail web
technical JSP ,faced to medium-sized web site, adopted the JSP +
javaBean struts, with the run environment Apache + Tomcat, had
accomplished a web application using B/S structure.
Five modules made up this shopping system. They are lawless
license management, the checking type of images maintain,
checking images, query checked images, images checked
statistical statement.
Keywords the charging system of Liaoning speedway，images
checking
system，images checking，lawless license
目 录
前 言.....................................................................................................................................................6
第一章 可行性分析和系统设计.........................................................................................................7
1.1 背景——智能交通系统（ITS）..............................................................................................8
1.2 项目开发价值分析....................................................................................................................8
1.3 技术可行性分析........................................................................................................................9
3
论文专用纸
1.3.1
开发技术——
JSP...............................................................................................................9
1.3.2 JSP
应用程序处理过程
(
如下页图
1
。
1)...........................................................................9
1.3.3
开发架构方案——
jsp+javaBean.......................................................................................9
1.3.4
开发环境方案——
Apache+Tomcat.................................................................................11
1.3.5
数据库连接技术——
JDBC
技术
.....................................................................................13
1.3.6
数据库方案——
Oracle....................................................................................................14
1.4 系统实现方案设计..................................................................................................................14
第二章 总体设计...............................................................................................................................15
2.1 系统组成..................................................................................................................................15
2.2 程序模块图..............................................................................................................................16
2.3 数据库表结构..........................................................................................................................17
2.3.1
黑名单表
O_BLACK_PLATE...........................................................................................17
2.3.2
常量表
S_SVC_CONST.....................................................................................................17
2.3.3
图像参数表
O_IMAGE.....................................................................................................17
2.3.4
表
P_MOP_TAB................................................................................................................19
2.3.5
表
P_OBSE........................................................................................................................20
2.3.6
表
P_FILE_HEADER........................................................................................................20
2.3.7
表
P_CENTER_SUBCENTER_LIST.................................................................................21
2.3.7
表
P_VPLAZE_LIST..........................................................................................................21
2.3.8
表
P_NET_NO...................................................................................................................22
2.3.9
表
P_VEHI_CLAS.............................................................................................................22
2.3.10
表
P_LANE_TYPE...........................................................................................................23
第三章 详细设计和功能说明...........................................................................................................23
3.1 黑车牌照管理..........................................................................................................................25
3.1.1
功能描述
...........................................................................................................................25
3.1.2
业务流程图
.......................................................................................................................25
3.1.3
用户画面
...........................................................................................................................25
3.1.4
业务描述
...........................................................................................................................27
3.1.5
数据库操作
.......................................................................................................................28
3.1.6
测试点
...............................................................................................................................29
3.2 图像审批类型维护..................................................................................................................29
3.2.1
功能描述
...........................................................................................................................29
3.2.2
业务流程图
.......................................................................................................................29
3.2.3
用户画面
...........................................................................................................................30
3.2.4
业务描述
...........................................................................................................................31
4
论文专用纸
3.2.5
数据库操作
.......................................................................................................................32
3.2.6
测试点
...............................................................................................................................32
3.3 图像审批处理..........................................................................................................................33
3.3.1
功能描述
...........................................................................................................................33
3.3.2
业务流程图
.......................................................................................................................33
3.3.3
用户画面
...........................................................................................................................33
3.3.4
业务描述
...........................................................................................................................36
3.3.5
数据库操作
.......................................................................................................................39
3.3.6
测试点
...............................................................................................................................39
3.4 图像审批查询..........................................................................................................................40
3.4.1
功能描述
...........................................................................................................................40
3.4.2
业务流程图
.......................................................................................................................40
3.4.3
用户画面
...........................................................................................................................41
3.4.4
业务描述
...........................................................................................................................44
3.4.5
数据库操作
.......................................................................................................................46
3.4.6
测试点
...............................................................................................................................46
3.5 图像审批统计报表..................................................................................................................48
3.5.1
功能描述
...........................................................................................................................48
3.5.2
业务流程图
.......................................................................................................................48
3.5.3
用户画面
...........................................................................................................................48
3.5.4
业务描述
...........................................................................................................................51
3.5.5
数据库操作
.......................................................................................................................53
3.5.6
测试点
...............................................................................................................................53
结束语.................................................................................................................................................55
致 谢...................................................................................................................................................56
附 录 1 JAVA DATABASE CONNECTIVITY (JDBC).................................................................56
附 录 2 用 JDBC 连接数据库............................................................................................................70
附 录 3 部分程序代码........................................................................................................................80
参考文献...........................................................................................................................................116
5
