生活随笔
收集整理的這篇文章主要介紹了
基于JavaWeb的汽车销售管理系统
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
目 錄
摘 要 1
Abstract 2
一、 系統開發平臺 4
二、數據庫規劃 5
2.1 任務陳述 5
2.2 任務目標 6
三、系統定義 7
3.1 系統邊界 7
3.2 用戶視圖 7
四、需求分析 9
4.1 用戶需求說明 9
4.1.1 數據需求 9
4.1.2 事務需求 9
4.2 系統需求說明 10
五、數據庫邏輯設計 12
5.1 ER圖 12
5.2 數據字典 12
5.3 關系表 13
六、 數據庫物理設計 16
6.1索引 16
6.2視圖 16
6.3安全機制 16
6.4其他 17
七、 應用程序設計 18
7.1功能模塊 18
7.2界面設計 18
7.3事務設計： 24
八、測試和運行 44
8.1基礎信息的查詢/修改/刪除： 44
8.2車輛或配件采購的提交和相關查詢： 48
8.3車輛預訂/銷售的添加和相關查詢： 54
九、總結 67
9.1系統優點： 67
9.2系統不足： 67
9.3個人感想： 67
參考文獻 69
四、需求分析
4.1 用戶需求說明
4.1.1 數據需求
實體集：
車輛信息（合格證號，車牌號，品牌，車型，含稅成本，顏色，
狀態）
用戶信息（身份證號碼，姓名，性別，電話，住址）
汽車配件（配件編號，配件名，生產成本，售價）
員工信息（身份證號碼，姓名，性別，電話，地址，類別）
倉庫信息（倉庫編號，倉庫名，倉庫容量，管理員身份證號）
供應商信息（供應商編號，供應商名稱，供應商電話，供應商地址）
聯系集：
車輛銷售/預訂（合格證號，用戶ID，員工ID，方式‘銷售’or‘預訂’，付款金額，時間）
車輛/配件采購（合格證號/配件編號，員工ID，供應商編號，采購時間，采購金額）
車輛附加配件（合格證號，配件編號，員工ID，費用，時間，服務類型）
車輛/配件存儲（合格證號/配件編號，倉庫編號）
4.1.2 事務需求
數據錄入：
車輛銷售/預訂信息錄入、用戶信息錄入、員工信息錄入、倉庫信息錄入、員工采購（車輛/配件）信息錄入、供應商信息錄入
數據更新/修改；
客戶、員工、倉庫、供應商信息的修改和更新、客戶預訂車輛信息的結算、刪除，客戶預訂失效信息的更新、庫存車輛的轉移。
數據查詢：
客戶、員工、倉庫、供應商信息的查詢、客戶購車信息以及預訂信息的查詢、客戶維修保養加裝信息的查詢、財務收入/支出查詢、庫存車輛/配件信息的查詢，車輛/配件采購單的查詢。
4.2 系統需求說明
性能要求：
軟件應能保證系統運行穩定，避免系統崩潰；
軟件必須保證有足夠的數據精度，不影響正常業務；
查詢某條記錄的時間小于3秒。
更新/修改某條記錄的時間少于4秒。
對數據進行有效性驗證的時間少于1秒。（對任何輸入都要進行有效性檢查，對部分錯誤產生報錯信息）
生成報表的時間少于5秒。
操作要求：
擁有良好的交互界面，操作簡單的同時保證一定的安全性；
對某些特定需求產生相應的輸出供用戶打印（發票開具）；
不同種類的用戶擁有不同的權限，絕對禁止越權級操作；（權限越高的用戶，操作流程越嚴密）
數據容量要求：
運行在本軟件系統上的各類數據的最大規模約為40GB（服務器硬盤大小），由于只是一個輕量級的服務器，未來的數據規模的增加會產生不良后果；
事務故障處理說明：
用戶個人設備的硬件故障可能造成本軟件不能運行或不能正常進行輸入/輸出等后果，系統的資源不足及網絡的運輸通道阻塞可能造成本軟件運行效果不佳，上述故障的處理由用戶自行解決。
軟件在運行過程中產生的數據庫錯誤，將由系統自動記入錯誤日志，非網絡傳輸引起的錯誤將由系統管理員或軟件開發者解決。
軟件在運行過程中產生的其他錯誤，將根據情況由軟件開發者或系統管理員協助解決。
數據庫的備份與恢復：
數據庫每周進行一次的完整備份，每天一次差異備份，每半小時一次事務日志備份。數據庫的恢復應該由開發人員或管理人員進行。
主頁代碼如下：
<!DOCTYPE html
>
<html lang
="zh-CN">
<head
><meta http
-equiv
="Content-Type" content
="text/html; charset=utf-8"><title
>汽車4S銷售后臺系統
</title
><link href
="style/authority/main_css.css" rel
="stylesheet" type
="text/css" /><link href
="style/authority/zTreeStyle.css" rel
="stylesheet" type
="text/css"><script type
="text/javascript" src
="scripts/jquery/jquery-1.7.1.js"></script
><script type
="text/javascript" src
="scripts/zTree/jquery.ztree.core-3.2.js"></script
><script type
="text/javascript" src
="scripts/authority/commonAll.js"></script
><script type
="text/javascript">function logout(){if(confirm("您確定要退出本系統嗎？")){window
.location
.href
= "signin.jsp";}}function getDate01(){var time
= new Date();var myYear
= time
.getFullYear();var myMonth
= time
.getMonth()+1;var myDay
= time
.getDate();if(myMonth
< 10){myMonth
= "0" + myMonth
;}document
.getElementById("day_day").innerHTML
= myYear
+ "." + myMonth
+ "." + myDay
;}</script
><script type
="text/javascript">var zTree
;var setting
= {view
: {dblClickExpand
: false,showLine: false,expandSpeed: ($
.browser
.msie
&& parseInt($
.browser
.version
)<=6)?"":"fast"},data: {key
: {name
: "resourceName"},simpleData: {enable
:true,idKey: "resourceID",pIdKey: "parentID",rootPId: ""}},callback: {onClick
: zTreeOnClick
}};var curExpandNode
= null;function beforeExpand(treeId
, treeNode
) {var pNode
= curExpandNode ? curExpandNode
.getParentNode():null;var treeNodeP
= treeNode.parentTId ? treeNode
.getParentNode():null;for(var i
=0, l
=!treeNodeP
? 0:treeNodeP
.children
.length
; i
<l
; i
++ ) {if (treeNode
!== treeNodeP
.children
[i
]) {zTree
.expandNode(treeNodeP
.children
[i
], false);}}while (pNode
) {if (pNode
=== treeNode
) {break;}pNode
= pNode
.getParentNode();}if (!pNode
) {singlePath(treeNode
);}}function singlePath(newNode
) {if (newNode
=== curExpandNode
) return;if (curExpandNode
&& curExpandNode
.open
==true) {if (newNode
.parentTId
=== curExpandNode
.parentTId
) {zTree
.expandNode(curExpandNode
, false);} else {var newParents
= [];while (newNode
) {newNode
= newNode
.getParentNode();if (newNode
=== curExpandNode
) {newParents
= null;break;} else if (newNode
) {newParents
.push(newNode
);}}if (newParents
!=null) {var oldNode
= curExpandNode
;var oldParents
= [];while (oldNode
) {oldNode
= oldNode
.getParentNode();if (oldNode
) {oldParents
.push(oldNode
);}}if (newParents
.length
>0) {for (var i
= Math
.min(newParents
.length
, oldParents
.length
)-1; i
>=0; i
--) {if (newParents
[i
] !== oldParents
[i
]) {zTree
.expandNode(oldParents
[i
], false);break;}}}else {zTree
.expandNode(oldParents
[oldParents
.length
-1], false);}}}}curExpandNode
= newNode
;}function onExpand(event, treeId
, treeNode
) {curExpandNode
= treeNode
;}function zTreeOnClick(event, treeId
, treeNode
) {var zTree
= $
.fn
.zTree
.getZTreeObj("dleft_tab1");zTree
.expandNode(treeNode
, null, null, null, true);if(treeNode
.isParent
){return false;}if(treeNode
.accessPath
=="" || treeNode
.accessPath
=="#"){alert("節點路徑為空或者為'#'哦...");return false;}rightMain(treeNode
.accessPath
);if( treeNode
.isParent
){$
('#here_area'
).html('當前位置：'
+treeNode
.getParentNode().resourceName
+'
 
;> 
;<span style
="color:#1A5CC6">'
+treeNode
.resourceName
+'
</span
>'
);}else{$
('#here_area'
).html('當前位置：系統
 
;> 
;<span style
="color:#1A5CC6">'
+treeNode
.resourceName
+'
</span
>'
);}};function switchTab(tabpage
,tabid
){var oItem
= document
.getElementById(tabpage
).getElementsByTagName("li"); for(var i
=0; i
<oItem
.length
; i
++){var x
= oItem
[i
]; x
.className
= "";}if('left_tab1'
== tabid
){$
(document
).ajaxStart(onStart
).ajaxSuccess(onStop
);loadMenu('YEWUMOKUAI'
, 'dleft_tab1'
);}else if('left_tab2'
== tabid
){$
(document
).ajaxStart(onStart
).ajaxSuccess(onStop
);loadMenu('XITONGMOKUAI'
, 'dleft_tab1'
);}else if('left_tab3'
== tabid
){$
(document
).ajaxStart(onStart
).ajaxSuccess(onStop
);loadMenu('QITAMOKUAI'
, 'dleft_tab1'
);} }$
(document
).ready(function(){$
(document
).ajaxStart(onStart
).ajaxSuccess(onStop
);loadMenu('YEWUMOKUAI'
, "dleft_tab1");if( zTree
){zTree
.expandAll(false);}});function loadMenu(resourceType
, treeObj
){data
= [{"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":2,"resourceName":"系統管理","resourceOrder":0,"resourceType":""},{"accessPath":"staff_list.jsp","checked":false,"delFlag":0,"parentID":2,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":21,"resourceName":"查看員工信息","resourceOrder":0,"resourceType":""},{"accessPath":"staff_edit.jsp","checked":false,"delFlag":0,"parentID":2,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":22,"resourceName":"添加員工信息","resourceOrder":0,"resourceType":""},{"accessPath":"pswd_edit.jsp","checked":false,"delFlag":0,"parentID":2,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":23,"resourceName":"修改密碼","resourceOrder":0,"resourceType":""},{"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":3,"resourceName":"銷售管理","resourceOrder":0,"resourceType":""},{"accessPath":"car_subscribe_list.jsp","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":31,"resourceName":"查看車輛預訂單","resourceOrder":0,"resourceType":""},{"accessPath":"car_subscribe_edit.jsp","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":32,"resourceName":"添加車輛預訂單","resourceOrder":0,"resourceType":""},{"accessPath":"car_sales_list.jsp","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":33,"resourceName":"查看車輛銷售單","resourceOrder":0,"resourceType":""},{"accessPath":"car_sales_edit.jsp","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":34,"resourceName":"添加車輛銷售單","resourceOrder":0,"resourceType":""},{"accessPath":"car_parts_edit.jsp","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":35,"resourceName":"加裝維修保養","resourceOrder":0,"resourceType":""},{"accessPath":"car_parts_list.jsp","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":36,"resourceName":"查看加裝維修保養","resourceOrder":0,"resourceType":""},{"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":4,"resourceName":"庫存管理","resourceOrder":0,"resourceType":""},{"accessPath":"car_storage_list.jsp","checked":false,"delFlag":0,"parentID":4,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":41,"resourceName":"庫存車輛信息","resourceOrder":0,"resourceType":""},{"accessPath":"parts_storage_list.jsp","checked":false,"delFlag":0,"parentID":4,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":42,"resourceName":"庫存配件信息","resourceOrder":0,"resourceType":""},{"accessPath":"storage_list.jsp","checked":false,"delFlag":0,"parentID":4,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":43,"resourceName":"查詢倉庫信息","resourceOrder":0,"resourceType":""},{"accessPath":"storage_edit.jsp","checked":false,"delFlag":0,"parentID":4,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":44,"resourceName":"添加倉庫信息","resourceOrder":0,"resourceType":""},{"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":5,"resourceName":"進貨管理","resourceOrder":0,"resourceType":""},{"accessPath":"car_purchase_list.jsp","checked":false,"delFlag":0,"parentID":5,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":51,"resourceName":"查看汽車采購訂單","resourceOrder":0,"resourceType":""},{"accessPath":"parts_purchase_list.jsp","checked":false,"delFlag":0,"parentID":5,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":52,"resourceName":"查看配件采購訂單","resourceOrder":0,"resourceType":""},{"accessPath":"car_purchase_edit.jsp","checked":false,"delFlag":0,"parentID":5,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":53,"resourceName":"添加汽車采購訂單","resourceOrder":0,"resourceType":""},{"accessPath":"parts_purchase_edit.jsp","checked":false,"delFlag":0,"parentID":5,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":54,"resourceName":"添加采購配件訂單","resourceOrder":0,"resourceType":""},{"accessPath":"supplier_list.jsp","checked":false,"delFlag":0,"parentID":5,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":55,"resourceName":"查看供貨商信息","resourceOrder":0,"resourceType":""},{"accessPath":"supplier_edit.jsp","checked":false,"delFlag":0,"parentID":5,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":56,"resourceName":"添加供貨商信息","resourceOrder":0,"resourceType":""},{"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":6,"resourceName":"財務管理","resourceOrder":0,"resourceType":""},{"accessPath":"ListCharge","checked":false,"delFlag":0,"parentID":6,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":61,"resourceName":"財務支出表","resourceOrder":0,"resourceType":""},{"accessPath":"ListIncome","checked":false,"delFlag":0,"parentID":6,"resourceCode":"","resourceDesc":"","resourceGrade":3,"resourceID":62,"resourceName":"財務收入表","resourceOrder":0,"resourceType":""},{"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":7,"resourceName":"客戶管理","resourceOrder":0,"resourceType":""},{"accessPath":"customer_list.jsp","checked":false,"delFlag":0,"parentID":7,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":71,"resourceName":"查看客戶信息","resourceOrder":0,"resourceType":""},{"accessPath":"customer_edit.jsp","checked":false,"delFlag":0,"parentID":7,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":72,"resourceName":"添加客戶信息","resourceOrder":0,"resourceType":""} ];if(data
!= null){$
.fn
.zTree
.init($
("#"+treeObj
), setting
, data
);zTree
= $
.fn
.zTree
.getZTreeObj(treeObj
);if( zTree
){zTree
.expandAll(false);}}}function onStart(){$
("#ajaxDialog").show();}function onStop(){$
("#ajaxDialog").hide();}</script
>
</head
>
<body onload
="getDate01()"><div id
="top"><div id
="top_logo"><b style
="color:white;font-size:30px;">汽車銷售管理系統
</b
></div
><div id
="top_links"><div id
="top_op"><ul
><li
><img alt
="當前用戶" src
="images/common/user.jpg">：
<li
><p
><%=session
.getAttribute("username") %></p
></li
></li
><li
><img alt
="今天是" src
="images/common/date.jpg">：
<span id
="day_day"></span
></li
></ul
> </div
><div id
="top_close"><a href
="javascript:void(0);" onclick
="logout();" target
="_parent"><img alt
="退出系統" title
="退出系統" src
="images/common/close.jpg" style
="position: relative; top: 10px; left: 25px;"></a
></div
></div
></div
><!-- side menu start
--><div id
="side"><div id
="left_menu"><ul id
="TabPage2" style
="height:200px; margin-top:50px;"><li id
="left_tab1" class="selected" onClick
="javascript:switchTab('TabPage2','left_tab1');" title
="業務模塊"><img alt
="業務模塊" title
="業務模塊" src
="images/common/1_hover.jpg" width
="33" height
="31"></li
></ul
><div id
="nav_show" style
="position:absolute; bottom:0px; padding:10px;"><a href
="javascript:;" id
="show_hide_btn"><img alt
="顯示/隱藏" title
="顯示/隱藏" src
="images/common/nav_hide.png" width
="35" height
="35"></a
></div
></div
><div id
="left_menu_cnt"><div id
="nav_module"><img src
="images/common/module_1.png" width
="210" height
="58"/></div
><div id
="nav_resource"><ul id
="dleft_tab1" class="ztree"></ul
></div
></div
></div
><script type
="text/javascript">$
(function(){$
('#TabPage2 li'
).click(function(){var index
= $
(this).index();$
(this).find('img'
).attr('src'
, 'images
/common
/'
+ (index
+1) +'_hover
.jpg'
);$
(this).css({background
:'#fff'
});$
('#nav_module'
).find('img'
).attr('src'
, 'images
/common
/module_'
+ (index
+1) +'
.png'
);$
('#TabPage2 li'
).each(function(i
, ele
){if( i
!=index
){$
(ele
).find('img'
).attr('src'
, 'images
/common
/'
+ (i
+1) +'
.jpg'
);$
(ele
).css({background
:'#
044599'
});}});switchSysBar(true);});$
("#show_hide_btn").click(function() {switchSysBar();});});function switchSysBar(flag
){var side
= $
('#side'
);var left_menu_cnt
= $
('#left_menu_cnt'
);if( flag
==true ){ left_menu_cnt
.show(500, 'linear'
);side
.css({width
:'280px'
});$
('#top_nav'
).css({width
:'
77%'
, left:'304px'
});$
('#main'
).css({left
:'280px'
});}else{if ( left_menu_cnt
.is(":visible") ) {left_menu_cnt
.hide(10, 'linear'
);side
.css({width
:'60px'
});$
('#top_nav'
).css({width
:'
100%'
, left:'60px'
, 'padding
-left
':'28px'
});$
('#main'
).css({left
:'60px'
});$
("#show_hide_btn").find('img'
).attr('src'
, 'images
/common
/nav_show
.png'
);} else {left_menu_cnt
.show(500, 'linear'
);side
.css({width
:'280px'
});$
('#top_nav'
).css({width
:'
77%'
, left:'304px'
, 'padding
-left
':'0px'
});$
('#main'
).css({left
:'280px'
});$
("#show_hide_btn").find('img'
).attr('src'
, 'images
/common
/nav_hide
.png'
);}}}</script
><!-- side menu start
--><div id
="top_nav"><span id
="here_area">當前位置：系統
 
;> 
;系統介紹
</span
></div
><div id
="main"><iframe name
="right" id
="rightMain" src
="introduce.html" frameborder
="no" scrolling
="auto" width
="100%" height
="100%" allowtransparency
="true"/></div
>
<div style
="display:none"><script src
='http
://v7
.cnzz
.com
/stat
.php
?id
=155540&web_id
=155540' language
='JavaScript' charset
='utf
-8'
></script
></div
>
</body
>
</html
>
總結
以上是生活随笔為你收集整理的基于JavaWeb的汽车销售管理系统的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
