智能计算机与应用
智能計算機與應用
지능계산궤여응용
Computer Study
2014年
4期
9-12,16
,共5页
周建餠%罗辛%史有群%宋汉征
週建餠%囉辛%史有群%宋漢徵
주건병%라신%사유군%송한정
电商系统%Spring 框架%MVC%数据库设计%分页显示
電商繫統%Spring 框架%MVC%數據庫設計%分頁顯示
전상계통%Spring 광가%MVC%수거고설계%분혈현시
E -commerce System%Spring Framework%MVC%Database Design%Pagination Display
在电子商务系统中,由于用户查询条件的宽泛性,可能会出现大量符合条件的查询结果。为了快速响应用户查询,在数据库设计和访问过程中,除了建立合理的索引机制以外,必须对查询结果进行分页处理。在传统 Spring MVC 框架基础上,增加了Bo 层,其主要作用为参数封装,并从数据库的生成、业务逻辑的配置、Dao 层、Service 层、Controller 层、Bo 层、Jsp 层等多个层次优化数据访问过程。通过实验分析,对比传统分页方法,在平均响应时间上具有明显优势,且依托良好的层次结构,具有可移植性强的优点。
在電子商務繫統中,由于用戶查詢條件的寬汎性,可能會齣現大量符閤條件的查詢結果。為瞭快速響應用戶查詢,在數據庫設計和訪問過程中,除瞭建立閤理的索引機製以外,必鬚對查詢結果進行分頁處理。在傳統 Spring MVC 框架基礎上,增加瞭Bo 層,其主要作用為參數封裝,併從數據庫的生成、業務邏輯的配置、Dao 層、Service 層、Controller 層、Bo 層、Jsp 層等多箇層次優化數據訪問過程。通過實驗分析,對比傳統分頁方法,在平均響應時間上具有明顯優勢,且依託良好的層次結構,具有可移植性彊的優點。
재전자상무계통중,유우용호사순조건적관범성,가능회출현대량부합조건적사순결과。위료쾌속향응용호사순,재수거고설계화방문과정중,제료건립합리적색인궤제이외,필수대사순결과진행분혈처리。재전통 Spring MVC 광가기출상,증가료Bo 층,기주요작용위삼수봉장,병종수거고적생성、업무라집적배치、Dao 층、Service 층、Controller 층、Bo 층、Jsp 층등다개층차우화수거방문과정。통과실험분석,대비전통분혈방법,재평균향응시간상구유명현우세,차의탁량호적층차결구,구유가이식성강적우점。
In current e -commerce systems,due to the broadness of user query,database queries often get a large number of eligible query results.For the purpose of quickly respond to user queries,during the process of database design and ac-cess,in addition to a reasonable indexing mechanism,the query results display must be paged display.With improved Spring MVC framework,the Bo -layer is added between JSP -layer and Controller -layer,whose main role is as a param-eter package.Also,from database generating,business logic configuration,Dao -layer design,Service -layer design, Controller -layer design,Bo -layer design,Jsp -layer design and so on,the paper optimizes data access process.After that ,through experimental analysis,compared with traditional paging method,this method has obvious advantages in the aspects such as average response time,a clear frame hierarchy and good portability.