【计算机外文翻译】Design and Implementation of Bank Smart Counter System Based on SSM Framework-外文翻译

Design and Implementation of Bank Smart Counter System Based on SSM Framework
2022 The 7th International Conference on Computer and Communication Systems

Jianyu Song
University of Chinese Academy of Sciences Shenyang Institute of Computing Technology,University of Chinese
Academy of Sciences
Shenyang , China
email: 897423163@qq.com
Bo Yu
Shenyang Institute of Computing Technology,University of Chinese Academy of Sciences
Shenyang , China
email: yubo@sict.ac.cn

Abstract—Due to the extensive banking operations, When handling different types of business, Bank tellers need to log in to different systems for business processing, The system interaction interface and business process have their own characteristics, Lead in a long business processing time, Poor experience level, From the perspective of the system development, A long development cycle exists, The characteristics of high capacity requirements for developers, Considering the above problems, In the context of the decreasing number of traditional self-service machines year by year, A city commercial bank proposed a bank intelligent counter system developed based on the idea of components, The system is developed through front-end display components, process components, message components, Implement the flexible development of the software, At the same time, it can meet the compatible access requirements of different brands of hardware terminals, Save money on software development costs and hardware procurement costs for banks, At the same time, it improves the user experience.

Keywords—smart counter system; SSM framework; Oracle; J2EE; B/S structure
I.INTRODUCTION
This paper with a city commercial bank intelligent counter project as the background, combined with the bank business process procedural, standardized characteristics, in order to further improve the business efficiency, in the existing counter non-cash business demand analysis, combined with the current single function and high cost, most to the self-service channels, reduce the business processing time, improve service satisfaction.Compared with state-owned banks, urban commercial banks are small in scale, are relatively weak in information technology, and are extremely sensitive to the input and output of information technology[1].How to bring advanced financial technology concepts into the bank operation of limited capital investment is a question worth thinking about, This paper proposes a component-based software development method to build this system, Personalize different services through configuration, Use the process jump to read each link of the business transaction process from the process configuration successively, Complete a full transaction processing, Beautiful system interface design, Easy to operate,Overall, based on the SSM framework design, Using the B/S structure, Implement the client interface with the Bootstrap framework[2], Using the Oracle database, Requirements analysis and design of the system by using the UML unified modeling language[3], Using layered design ideas, Using the component technology to reduce the coupling between the modules, Strong scalability, It provides great convenience for developing new features.
II.DEMAND ANALYSIS
The bank’s smart counter system is a process reengineering of non-cash business with high counter processing frequency. The system must meet the following requirements :
1)Sharing and use of data resources, this system is used for customers to handle banking business , and is an integral part of the bank’s peripheral system. The data interaction interface of the system should be unified with different business systems to ensure that customers can be accurately obtained in the process of business processing. Identity information, electronic business credentials, transaction data statistics and other business information.
2)The interface is beautiful and the layout is reasonable. It is necessary to provide a simple and convenient business display interface for tellers and customers.
3)System users are divided into three categories : customers , voucher administrators, and auditors. Customers can only browse the client interface for business processing, auditors are responsible for reviewing business processing information, and voucher administrators are responsible for managing self-service machine vouchers.
4)Functional scalability
This system adopts the idea of modular design. On the basis of satisfying the business functions such as bank card account opening and transfer, it is also necessary to consider the difficulty of system transformation when adding new functions .
III.TECHNICAL SOLUTIONS
A.Technology Roadmap
After the research and analysis of the framework, database, programming language, etc, comprehensive development costs, technical difficulty factors, the system is based on the Spring+SpringMVC+MyBatis framework JavaEE platform, Spring framework through IoC features, the dependency between objects to Spring control, convenient decoupling, simplify development difficulty, through Spring AoP features, repeat module, achieve transactions, logs, Control of the permissions.SpringMVC is a lightweight web framework using MVC design ideas, which seamlessly connects with Spring. SpringMVC separates the roles of controllers, model objects, dispatchers, and handler objects, making the system expansion more flexible.Mybatis framework adopts xml file configuration for database operation, which avoids tedious database connection configuration, avoids writing a large number of SQL statements, uncoupling sql and code, provides mapping tags, supports the mapping of object and database orm field relationship, supports object relationship mapping tags, supports the formation of object relationship, provides xml tags, and supports dynamic sql.The front-end of the system adopts Bootstrap framework, a front-end development framework based on HTML, CSS, JavaScript development, which provides HTML and CSS specifications, written by dynamic CSS language Less, fully open source, code writing specification, and easy to maintain.The consistent use of RESTful style interface for communication at the front and back end can make developers only focus on the development of front end or back end. Based on the above technical analysis, clear system requirements analysis and on the basis of realizing a bank intelligent counter system based on SSM framework is feasible.

Fig. 1. System overall frame diagram
The system is developed in strict accordance with the layered specifications, which are mainly divided into client layer, presentation layer, business layer, persistence layer, and resource layer . The overall frame diagram of the system is shown in Figure 1. The presentation layer generally refers to the front-end module of the web application, and the UI components are used for display . The business layer is the middle layer of the web application and is implemented based on the SpringMVC framework[4].The SpringMVC framework is equivalent to a combination of a controller and a view dispatcher When the user operates on the page, it can be understood as initiating a request, and the request will be sent Go to the SpringMVC controller, call the corresponding business method, respond to the request, and the view dispatcher returns the result. The Spring[5] framework acts as a container, and many beans loaded in it are entity objects , and the methods of the corresponding classes of these objects are used , which implements logical processing of the business and provides an interface for interacting with the presentation layer and the persistence layer.
The persistence layer implements persistent object operations through MyBatis[6], and uses database and configuration information to provide persistent services for applications. It reads database-related parameters from configuration files, and uses persistent classes and data tables correspondingly.
The resource layer is the database. The logical relationship between entities and entities is determined by analyzing the use case . Through the analysis of ER modeling, the entity set in the smart counter system is determined, and the relationship between the entity set and the entity set is converted into a relationship mode or relationship. Table. The system can realize the function of active-standby switching, has a mature uploading mechanism, and can preserve the data generated by the application in good condition .
B.System Function Design
The bank smart counter system is oriented to bank customers and voucher administrators. Customers click on business buttons such as card opening and transfer, and the application is responsible for interacting with various business systems to complete business processing. After the voucher administrator passes the verification by entering the teller number and password, the voucher can be transferred,The system module design is divided into public function module, local management module, business function module.

Fig. 2. Functional diagram of smart counter system
1)Public function module: including online verification, face recognition, card insertion and verification, card removal, reading protocol, audit authorization, customer information maintenance, and password setting. The functions contained in this module are the public part of different business functions, namely customers When opening a card or transferring money, identity information needs to be verified, and identity verification requires online verification and face recognition.
2)Local management module: including teller management and certificate management, that is, the certificate administrator completes operations such as adding various certificates, clearing the machine, turning over the certificate, shutting down the machine, restarting the machine, and managing the master key. The auditor can log in to modify and enter fingerprints. .
3)Design of business function modules: mainly include bank card opening, contract signing, transfer, mutual transfer between fixed accounts, wealth management, loss reporting and certificate replacement.
a)Bank card opening: The customer opens a bank account with the bank with an ID card. After inserting the ID card, check the validity of the ID card. After passing, check whether there is a type I account in the bank. No type I account can be opened. Type I accounts and Type I accounts can open Type II and III accounts. Type I accounts only support the opening of physical media, and Type II and III accounts support the opening of physical media and virtual media. Customers read the bank card account opening agreement and enter the customer After the account opening is successful, you can choose whether to sign a transaction or not.
b)Fixed term business: Converting from current to fixed term means that the customer holds the bank card of the bank and his identity document and uses the current balance in the bank card account to transfer to the fixed term. The types of fixed deposits include lump sum deposit and call deposit . Interest rate and deposit period select the products that need to be processed. Regular transfer to current period refers to the transaction of withdrawing funds from the regular sub-account in the card to the current account of the bank card.
c)Signing contract: Customers holding the bank card of the Bank can conduct SMS contract and small-amount passwordfree contract. SMS contract supports up to three mobile phone numbers for contracting SMS under the same bank card account. The starting point of the transfer amount is 1 yuan, and the SMS Signing supports the first signing, adding numbers, modifying numbers, and canceling SMS signing.
d)Transfer: The customer holds the bank card of the bank to transfer funds to the bank’s account or the foreign bank’s account. The payment method supports real-time arrival, 2- hour arrival, and the next day’s arrival. The person in charge can be the owner of the bank card account or agent.
e)Wealth management business: According to the requirements of banking regulatory authorities, customers need to go to the counter for audio recording and video recording for the first time to sign a financial management contract. The function design of the wealth management module of the smart counter system includes wealth management purchase, wealth management inquiry, and wealth management withdrawal.
f)Loss reporting and replacement card business: After the customer passes online verification, face recognition and other identification methods with his ID card, the system will query the bank card account under his name according to the ID card number. or unusable bank card for reissuing transactions. For loss reporting and reissuing, it is necessary to transfer the contracted business, available balance and electronic cash balance of the original bank account to the new bank account.
C.Database Design
The system database is implemented using Oracle. Oracle is an enterprise-level large-scale relational database. It uses the MyBatis framework to connect to Oracle and access the data in the data table. MyBatis supports customized SQL, stored procedures and advanced mapping , avoiding almost all JDBC codes and manual operations. To set parameters and obtain result sets , you can use simple XML or annotations to configure and map native information, map interfaces and Java POJOs to records in the database, and follow the system function logic hierarchy and data table according to the banking business logic and data flow direction . Including teller management table, media management table, media distribution details table.

Fig. 3. Entity class relationship diagram of smart counter system
IV.SYSTEM IMPLEMENTATION
A.Presentation Layer Implementation
The function of the display layer is to display the page, collect user requests, process processes, use Flex framework to achieve flexible layout, and then combine HTML[7], CSS, JSP technology to realize the front-end page display of business function modules such as bank card issuing, contract signing and transfer.
As shown in Figure 4, after the customer clicks the frontend page business button, the browser sends a request, which is captured and forwarded by the front-end controller DispatherServlet. The forwarded path is to match the content in the corresponding processor mapper @RequestMapping according to the request URL . The matching content It is implemented through xml configuration . After the matching is successful, the corresponding method is executed. The method has a return value. According to the return value of the method, the corresponding result view is found with the help of the view parser, the result view is rendered, and the browser is responded.

Fig. 4. SSM Framework Flowchart
For example, after the system starts the service, the main interface includes advertisement image display and business function buttons. The credential administrator enters the local management module by clicking the row mark in the upper left corner, and the customer selects the business to be handled by clicking the corresponding business function button. The client application accesses the application server through the browser to obtain the overall background image and advertisement animation of the system, configures the nodes through the flexview. Domain, node OutputBOx can be set multiple, each corresponding to a display component. Node Buttons configuration jump link, configuration instructions are as follows:

B.Business Layer Implementation
The business layer is mainly for the controller to execute the corresponding command, call the relevant processing class, realize the business logic, the business function accesses the controller corresponding to the page through the interface, and the controller calls the specific business method, the main task of the Spring framework It is to create business layer interface and implementation class and persistence layer interface and implementation class. In the action directory, configure the processing class mapped by a specific business, process specific business logic, and realize business operations. In the Spring framework, the core processing class rtl.control.action.ParamActionSupport is the parent class of the transaction processing class. It uses template methods internally to achieve high reuse and high expansion, and complete event push. The transaction processing class saves the parameter data in the page request object to the transaction internal object IModel. .The transaction processing class inherits the parent class to obtain the page request parameters, obtains the transaction processing parameters from the IModel by overloading the execute() interface method, and calls the system components to complete the transaction processing. The transaction processing includes data encryption, request message assembly, and transmission. , remote interface invocation, parsing and processing of response messages, etc., and finally save the data obtained from transaction processing to the page request object, whose attribute is currentResults. For example, the transaction code for bank card details query is shown as follows:

C.Persistence Layer Implementation
The persistence layer is implemented by the Mybatis framework. Mybatis is an open source framework that simplifies and implements the Java data persistence layer. It abstracts a lot of JDBC redundant code and provides easy-touse api and database interaction. In Java applications, data The work involved in the persistence [9] layer includes: generating the required Java objects from the data queried from the database; persisting the data in the Java objects to the data through SQL. MyBatis automates SQL by abstracting the underlying JDBC code The result set generates Java objects, and the process of persisting the data of Java objects in the database makes the use of SQL easy and provides other features to simplify the implementation of persistence logic, and support complex SQL result set data mapping to nested Object graph structure, supports one-to-one and one-to-many result set and Java object mapping, and supports constructing dynamic SQL statements based on input data. Compared with Hibernate’s elimination of SQL, MyBatis does not shield SQL. The advantage of not shielding SQL is that , you can specify SQL rules by yourself, without Hibernate automatically generating rules, which can define SQL more accurately, thereby optimizing performance, and more in line with the requirements of mobile Internet high concurrency, big data, high performance, and high response. Mybatis will be executed through xml. The various statements are configured, and the final executed sql statement is generated by mapping the java object and the sql in the statement. Finally, the mybatis framework executes the sql and maps the result into a java object and returns it. Mybatis performs the process of JDBC accessing the database. Encapsulation simplifies the JDBC code and solves the trouble of JDBC encapsulating the result set as a Java object.
For example, the function code to detect whether the bank card is an unsuccessfully issued voucher in the card box is as follows:

V.APPLICATION SCENARIOS
A.System Deployment
The system adopts the Weblogic deployment scheme, which deploys the system in Weblogic to update and replace the versions, and directly modify and replace the relevant files in the application deployment directory.The system has the ability of dual-active attributes and load balancing, can realize the function of switching main and standby, can realize the stable interaction with other systems, has a mature upload mechanism, and can save the data generated by the application intact. The system deployment mode is shown in Figure 5.
This system uses Redis as a cache server, can realize Session sharing, Web server uses F5 load balancing[8], through the traffic allocation algorithm to master the flexible use of multiple middleware application servers, while with firewall, distributed denial-of-service attacks and other security functions.

Fig. 5. System data flow diagram
B.System Performance Analysis
The system performance test selection transactions in line with frequent calls, large space database table, occupy the maximum storage space or other resources, the disk, permanent memory data excessive access transactions, to sum up the test selection test business for query balance, mainly involves: transaction message processing ability, database concurrent processing ability, log processing, page jump response ability, process processing.
This test uses LoadRunner 11 Chinese version as a performance test and analysis tool to pressure the system through LoadRunner virtual users (Vuser), and monitor the test indicators and collect indicator information during the test execution.
1)Concurrent test
Concurrency testing by instantaneous compression, instantaneous exit and gradual compression, The steps are as follows:
a)Instant compression tool to simulate 50 users to submit service request and accept the return result. After operation, all users exit and gradually pressure the tool to simulate 50 users by increasing 2 users every 10 seconds for 5 minutes and 2 users every 10 seconds. Record the average response time, pass transaction number, transaction accuracy, application server utilization, memory usage and other parameters.
b)Change the number of concurrent users to 100 and repeat the above test process.
c)Gradually increase the number of concurrent users.
d)When the increase of the number of users occurs, the Transations per Second upward trend slows down or even decreases; the CPU / memory reaches the limit or the system remains unresponsive within the specified time.

Fig. 6. Concurrency test record
2) Stability test
Using the script and scenario setting of business simulation load test, the stability test of the system is 1*2 hours, recording the average response time of each service, service accuracy, server CPU utilization, memory usage and other parameters, to check whether the server is down time and the transaction accuracy is less than 95%.With 150 users concurrent and running for 2 hours, 1 error caused by timeout occurred, but no transaction failed, the transaction correctness reached 100%, and the average response time of the transaction was about 3.4 seconds.

Fig. 7. Stability test results
a)Normal test: the same transaction is run 200 times, with an average response time of about 0.26 seconds.
b)Peak test: the maximum peak period can support 165 concurrent users, the application system response is normal, the performance parameters of server and database are normal, and the response time of flat transactions is about 2.516 seconds.
c)Stability test: simulate 150 concurrent users for 2 consecutive hours. Without transaction failure, the transaction correctness reaches 100%, and the average response time of the transaction is about 3.4 seconds.
d)Limit / recovery test: simulate the processing of card issuing system in extreme cases such as network instability during peak operation. Limit the server bandwidth to 64Kbps and 150 concurrent users, the test tool reports-56992 and-27791, but the server does not stop responding, and the application system can recover by itself.
2)Test conclusion
Comprehensive above tests: in the current environment, the deployment of 165 terminals, access to the server is stable and reliable, the system indicators can meet the requirements, if the bank has to deploy more than 165 terminals recommended to increase server memory or optimize server configuration.
VI.CONCLUSION AND OUTLOOK
This paper designs and implements a bank smart counter system based on the SSM framework. The overall use of the MVC layered design idea, the process reengineering of the personal non-cash business at the counter, combined with the actual needs of the business, realizes the bank card Open, transfer, wealth management, signing and other functions, the public process and interface can realize the reuse of components, which effectively improves the development efficiency. The system has a short development cycle and low cost, and has achieved good results under the limited capital investment of city commercial banks. After the system is put into operation, the operation is stable, the operation is simple, and the user experience is good. At present, this system is mainly aimed at the hardware equipment of a single manufacturer. With the continuous development of business, this system will become a unified smart counter business platform, adapting to different Branded hardware devices.
REFERENCES
[1] He Shiya . Design and implementation of multi-functional self-service card issuance system in Urumqi [ Master’s Thesis ]. Dalian : Dalian University of Technology , 2016 .
[2] Wang Qin. Design and Implementation of College Portal Website based on Bootstrap Technology [J]. Journal of Natural Science of Harbin Normal University, 2017,33 (03): 43-48.
[3] P. Rajarajeswari, D. Vasumathi, and A. Ramamohanreddy, “Applying UML Modeling Techniques for Architecture View of Electronic Commerce System,” Vol. 7, No. 1, pp. 39-42, February, 2016.
[4] Xu Shuye, Lv Lijun. Design and implementation of mobile web-based experimental class reservation system . Experimental Science and Technology. 2017,15 (6) :145-150
[5] Wu Guanxue . Based on SpringMVC hotel management system [ Master’s thesis ]. Changchun : Jilin University , 2018 .
[6] Li Chunsheng, Li Zhaoxia , Liu Tao , Hu Yanan . Design and Research of Scientific Research Office Management System Based on SSM . Computer Technology and Development. 2021, 31 ( 12 ) : 148-154 .
[7] Wang Jia, Gao Yinchun, ginger antler. Online course selection platform based on F5 load balancing technology [J]. Computer system application, 2017,26 (06): 108-111.
[8] Sun Wenyue.Design and implementation of the fire maintenance APP based on html5 [Master’s thesis].Xi’an: Xidian University, 2020.

基于SSM框架的银行智能柜台系统的设计与实现
2022年第七届计算机和通信系统国际会议

宋建宇
中国科学院大学沈阳中国大学计算技术学院
科学院
沈阳，中国
电子邮件： 897423163@qq.com
于波
中国科学院大学沈阳计算技术研究所
沈阳，中国
电子邮件： yubo@sict.ac.cn

摘要：由于银行业务广泛，在处理不同类型的业务时，银行柜员需要登录不同的系统进行业务处理，系统交互接口和业务流程有自己的特点，导致业务处理时间长，经验水平差，从系统开发的角度来看，开发周期长，开发人员高容量需求的特点，考虑到上述问题，在传统自助机数量逐年减少的情况下，城市商业银行提出了银行智能柜台系统开发基于组件，系统开发通过前端显示组件，过程组件、消息组件，实现软件的灵活开发，同时，它可以满足兼容的访问需求的不同品牌的硬件终端，为银行节省了软件开发成本和硬件采购成本，同时也改善了用户体验。

关键字——智能计数器系统、SSM框架、Oracle、J2EE、B/S结构
I.介绍
本文以城市商业银行智能柜台项目为背景，结合银行业务流程程序、标准化特点，为进一步提高业务效率，在现有的柜台非现金业务需求分析中，结合目前的单一功能和成本高，最针对自助渠道，减少业务处理时间，提高服务满意度。与国有银行相比，城市商业银行规模较小，信息技术相对较弱，对信息技术[1]的投入和输出极为敏感。如何将先进的金融技术概念引入有限资本投资的银行运营是一个值得思考的问题，本文提出一个基于组件的软件开发方法来构建这个系统，通过配置个性化不同的服务，使用流程跳转读取每个环节的业务交易流程从流程配置，完成完整的事务处理，美丽的系统界面设计，易于操作，总体而言，基于SSM框架设计，使用B/S结构，使用引导框架[2]实现客户端接口，使用Oracle数据库，使用UML统一建模语言[3]对系统进行需求分析和设计，使用分层设计思想，利用组件技术减少了模块之间的耦合，具有较强的可伸缩性，为开发新特性提供了很大的便利。
II.需求分析
银行的智能计数系统是柜台处理频率高的非现金业务的流程再造。该系统必须满足以下要求：
1)该系统是数据资源的共享和利用，用于客户处理银行业务，是银行外围系统的一个组成部分。系统的数据交互接口应与不同的业务系统进行统一，以确保在业务处理过程中能够准确地获得客户。身份信息、电子业务凭证、交易数据统计等业务信息。
2)界面美观，布局合理。有必要为柜员和客户提供一个简单、方便的业务显示界面。
3)系统用户可分为三类：客户、凭证管理员和审计人员。客户只能浏览客户端界面进行业务处理，审核员负责审核业务处理信息，凭证管理员负责自助机凭证的管理。
4)功能可伸缩性
该系统采用了模块化设计的思想。在满足银行卡开户、转账等业务功能的基础上，在增加新功能时也需要考虑系统转换的难度。
III.技术解决方案
A.技术路线图
经过研究分析框架、数据库、编程语言等、综合开发成本、技术难度因素，系统基于弹簧+弹簧MVC+MyBatis框架JavaEE平台，弹簧框架通过IoC功能，对象之间依赖弹簧控制，方便解耦，简化开发难度，通过弹簧AoP功能，重复模块，实现事务、日志、控制权限等。SpringMVC是一个使用MVC设计理念的轻量级web框架，它与Spring无缝连接。SpringMVC将控制器、模型对象、调度程序和处理程序对象的角色分开，使系统扩展更加灵活。Mybatis框架采用xml文件配置数据库操作，避免了繁琐的数据库连接配置，避免编写大量SQL语句，解耦SQL和代码，提供映射标签，支持对象和数据库orm字段关系，支持对象关系映射标签，支持对象关系的形成，提供xml标签，支持动态SQL。系统的前端采用了Bootstrap框架，这是一个基于HTML、CSS、JavaScript开发的前端开发框架，提供HTML和CSS规范，使用动态CSS语言编写，完全开放源代码，代码编写规范，易于维护。在前端和后端持续使用RESTful风格的通信界面来进行通信，这使得开发人员只关注前端或后端的开发。基于以上技术分析，明确系统的需求分析，在实现基于SSM框架的银行智能柜台系统的基础上是可行的。

图1。系统整体框架图
系统严格按照分层规范进行开发，主要分为客户端层、表示层、业务层、持久性层和资源层。系统的整体机框图如图1所示。表示层一般是指web应用程序的前端模块，而UI组件用于显示。业务层是web应用程序的中间层，它是基于SpringMVC框架[4]实现的。SpringMVC框架相当于控制器和视图调度器的组合。当用户在页面上操作时，可以理解为发起请求，请求将被发送到SpringMVC控制器，调用相应的业务方法，响应请求，然后视图调度器返回结果。Spring[5]框架充当一个容器，其中加载的许多bean都是实体对象，并使用了这些对象的相应类的方法，它实现了业务的逻辑处理，并提供了一个与表示层和持久性层交互的接口。
持久性层通过MyBatis[6]实现持久性对象操作，并使用数据库和配置信息为应用程序提供持久性服务。它从配置文件中读取与数据库相关的参数，并相应地使用持久性类和数据表。
资源层是数据库。通过分析用例的逻辑关系来确定实体之间的逻辑关系。通过对ER建模的分析，确定了智能计数器系统中的实体集，并将实体集与实体集之间的关系转换为一种关系模式或关系。表该系统可以实现主备交换功能，具有成熟的上传机制，能够将应用程序生成的数据保持在良好的状态。
B.系统功能设计
银行智能柜台系统是面向银行客户和代金券管理人员的。客户点击开卡、转账等业务按钮，应用程序负责与各种业务系统进行交互，完成业务处理。凭证管理员通过输入柜员号码和密码通过验证后，可将凭证转账，系统模块设计分为公共功能模块、本地管理模块、业务功能模块。

图2。智能柜台系统功能图
1)公共功能模块：包括在线验证、人脸识别、插卡与验证、除卡、读取协议、审计授权、客户信息维护、密码设置等。本模块所包含的功能是不同业务功能的公共部分，即客户在刷卡或转账时，身份信息需要验证，身份验证需要在线验证和人脸识别。
2)本地管理模块：包括柜员管理和证书管理，即证书管理员完成添加各种证书、清理机器、移交证书、关闭机器、重新启动机器、管理主密钥等操作。审核员可以登录以修改和输入指纹. .
3)业务功能模块的设计：主要包括银行卡开立、合同签订、转账、固定账户间相互转账、财富管理、亏损报告、证书更换等。
a)银行卡开户：客户用身份证在该银行开立了一个银行账户。插入身份证后，检查身份证的有效性。通过后，检查银行里是否有I类账户。无法打开I型帐户。I类账户和I类账户可以开设II类和III类账户。I类账户只支持打开物理媒体，II类和III类账户支持打开物理媒体和虚拟媒体。客户阅读银行卡开户协议并进入客户开户成功后，您可以选择是否签署交易协议。
b)固定期限业务：当期转为固定期限是指客户持有银行银行卡及其身份证明，将银行卡账户的活期余额转入固定期限。固定性存款的类型包括一次性存款和定期存款。利率和存款期选择需要加工的产品。当期定期转账是指从银行卡的常规子账户中提取资金到银行卡的经常账户的交易。
c)签订合同：持有银行银行卡的客户可以签订短信合同和小额免密码合同。短信合同支持最多三个手机号码的合同短信下的同一银行卡帐户。转账金额的起点为1元，短信签名支持第一次签名、加号码、修改号码、取消短信签名。
d)转账：客户持有银行的银行卡，将资金转账到银行账户或外国银行账户。支付方式支持实时到达、2小时到达、第二天到达。负责人可以是银行卡账户的所有者或代理人。
e)理财业务：根据银行监管机构的要求，客户需要第一次到柜台进行录音、录像，签订财务管理合同。智能柜台系统的财富管理模块的功能设计包括财富管理购买、财富管理查询、财富管理提取等。
f)丢失报告和更换卡业务：客户使用其身份证通过在线验证、面部识别等识别方式后，系统将根据身份证号查询其名下的银行卡账户。或无法使用的用于补发交易的银行卡。亏损报亏损、再发，需要将合同业务、可用余额和电子现金余额转入新银行账户。
C.数据库设计
系统数据库使用Oracle实现的。Oracle是一个企业级的大型关系数据库。它使用MyBatis框架连接到Oracle并访问数据表中的数据。MyBatis支持定制的SQL、存储过程和高级映射，避免了几乎所有的JDBC代码和手动操作。要设置参数和获取结果集，可以使用简单的XML或注释将本机信息、将接口和Java POJOs映射到数据库中的记录，并根据银行业务逻辑和数据流方向遵循系统功能逻辑层次结构和数据表。包括柜员管理表、媒体管理表、媒体分发明细表。

图3。智能计数器系统的实体类关系图
IV.系统实现
A.演示文稿图层的实现
显示层的功能是显示页面，收集用户请求，处理流程，使用Flex框架来实现灵活的布局，然后结合HTML[7]、CSS、JSP技术，实现银行卡发卡、合同签订、转账等业务功能模块的前端页面显示。
如图4所示，客户点击首页业务按钮后，浏览器发送一个请求，该请求由前端控制器捕获并转发。转发的路径是根据请求URL匹配对应的处理器映射器@请求映射中的内容。匹配的内容它是通过xml配置来实现的。匹配成功后，将执行相应的方法。该方法有一个返回值。根据该方法的返回值，通过视图解析器找到相应的结果视图，呈现结果视图，并响应浏览器。

图4。SSM框架流程图
例如，在系统启动服务后，主界面包括广告图像显示和业务功能按钮。凭据管理员点击左上角的行标记进入本地管理模块，客户点击相应的业务功能按钮选择要处理的业务。客户端应用程序通过浏览器访问应用程序服务器，获得系统的整体背景图像和广告动画，并通过柔性视图配置节点。域，节点输出框可以设置为多个，每个对应一个显示组件。节点按钮配置跳转链接，配置说明如下：

B.业务层实施
业务层主要是让控制器执行相应的命令，调用相关的处理类，实现业务逻辑，业务功能通过接口访问页面对应的控制器，控制器调用特定的业务方法，Spring框架的主要任务是创建业务层接口和实现类、持久层接口和实现类。在操作目录中，配置由特定业务映射的处理类、流程特定的业务逻辑，并实现业务操作。在Spring框架中，核心处理类rtl.control.action。参数支持是事务处理类的父类。它在内部使用模板方法来实现高重用性和高扩展性，并完成事件推送。事务处理类将页面请求对象中的参数数据保存到事务内部对象IModel中。事务处理类继承父类来获取页面请求参数，通过超载执行（）接口方法从IModel获取事务处理参数，并调用系统组件来完成事务处理。事务处理包括数据加密、请求消息程序集和传输。远程接口调用、解析和处理响应消息等，最后将从事务处理中获得的数据保存到页面请求对象，其属性为当前结果。例如，银行卡明细查询的交易代码如下：.

C.持久性层实现
持久性层由Mybatiis框架实现。Mybatis是一个开源框架，它简化并实现了Java数据持久性层。它抽象了大量的JDBC冗余代码，并提供了易于计算的api和数据库交互。在Java应用程序中，数据持久性[9]层所涉及的工作包括：从从数据库中查询到的数据中生成所需的Java对象；通过SQL将Java对象中的数据持久化到数据中。MyBatis通过抽象自动化SQL底层JDBC代码结果集生成Java对象，和数据库中Java对象的过程使使用SQL容易和提供其他特性来简化持久性逻辑的实现，并支持复杂的SQL结果集数据映射到嵌套对象图结构，支持一对一和一对多的结果集和Java对象映射，并支持基于输入数据构建动态SQL语句。与冬眠蛋白消除的SQL相比，MyBatis并不能屏蔽SQL。不屏蔽SQL的优点是，您可以自己指定SQL规则，无需hibernete自动生成规则，可以更准确地定义SQL，从而优化性能，更符合移动互联网高并发、大数据、高性能、高响应的要求。mybatiis将通过xml执行。我们配置了各种语句，最终执行的sql语句是通过映射语句中的java对象和语句中的sql来生成的。最后，mybatis框架执行sql并将结果映射到java对象并返回它。Mybatiis执行JDBC访问数据库的过程。封装简化了JDBC代码，并解决了JDBC将结果集封装为Java对象的问题。
例如，在卡箱中检测银行卡是否为未成功发放的凭证的功能代码如下：

V.应用程序场景
A.系统部署
系统采用Weblogic部署方案，在Weblogic中部署系统进行更新和替换版本，并直接修改和替换应用程序部署目录中的相关文件。该系统具有双主动属性和负载平衡的能力，能够实现主待机的切换功能，能够实现与其他系统的稳定交互，具有成熟的上传机制，并可以完整地保存应用程序生成的数据。系统部署模式如图5所示。
该系统采用Redis作为缓存服务器，可实现会话共享，Web服务器使用F5负载均衡[8]，通过流量分配算法掌握多个中间件应用服务器的灵活使用，同时采用防火墙、分布式拒绝服务攻击等安全功能。

图5。系统数据流程图
B.系统性能分析
系统性能测试选择事务符合频繁调用、大空间数据库表，占用最大存储空间或其他资源、磁盘、永久内存数据过度访问事务，总结测试选择测试业务进行查询平衡，主要包括：事务消息处理能力、数据库并发处理能力、日志处理能力、页面跳转响应能力、过程处理能力。
本测试采用加载运行者11中文版作为性能测试和分析工具，通过加载运行者虚拟用户（Vuser）对系统施加压力，并在测试执行过程中监控测试指标，收集指标信息。
1)同时测试
通过瞬时压缩、瞬时退出和渐进压缩进行并发测试，步骤如下：
a)即时压缩工具，模拟50个用户提交服务请求并接受返回结果。操作后，所有用户都退出，并逐渐对工具施加压力，以模拟50个用户，每10秒增加2个用户，持续5分钟，每10秒增加2个用户。记录平均响应时间、传递事务号、事务精度、应用服务器利用率、内存利用率等参数。
b)将并发用户数更改为100个，并重复上述测试过程。
c)逐步增加并发用户的数量。
d)当用户数量增加时，每秒传输上升的趋势减慢甚至减少；CPU /内存达到限制或系统在指定的时间内仍然无响应。

图6。并发性测试记录
2)稳定性试验
使用业务模拟负载测试的脚本和场景设置，系统的稳定性测试为1*2小时，记录每个服务的平均响应时间、服务精度、服务器CPU利用率、内存使用率等参数，检查服务器是否停机时间，事务精度是否小于95%。150个用户并发运行2小时，出现1次超时错误，但没有事务失败，事务正确性达到100%，事务的平均响应时间约为3.4秒。

图7。稳定性试验结果
a)正常测试：同一事务运行200次，平均响应时间约为0.26秒。
b)峰值测试：最大峰值周期可支持165个并发用户，应用系统响应正常，服务器和数据库的性能参数正常，平面事务的响应时间约为2.516秒。
c)稳定性测试：连续模拟150个并发用户2个小时。没有事务失败，事务正确性达到100%，事务的平均响应时间约为3.4秒。
d)限制/恢复测试：模拟峰值运行时网络不稳定等极端情况下发卡系统的处理。将服务器带宽限制在64Kbps和150个并发用户以内，测试工具报告了-56992和-27791，但服务器不会停止响应，应用程序系统可以自行恢复。
2)试验结论
综合以上测试：在当前环境下，部署165个终端，访问服务器稳定可靠，系统指标可以满足要求，如果银行必须部署超过165个终端，建议增加服务器内存或优化服务器配置。
VI.结论与展望
本文设计并实现了一种基于SSM框架的银行智能计数器系统。全面运用MVC分层设计理念，对柜台个人非现金业务的流程再造，结合业务的实际需求，实现银行卡开放、转账、理财、签名等功能，公共流程和接口可以实现组件的重用，有效提高了开发效率。该系统开发周期短，成本低，在城市商业银行有限的资本投资下取得了良好的效果。系统投入运行后，运行稳定，操作简单，用户体验良好。目前，该系统主要是针对单一厂家的硬件设备。随着业务的不断发展，该系统将成为一个统一的智能柜台业务平台，适应不同的品牌硬件设备。
参考文献
[1] He Shiya。乌鲁木齐[硕士论文]多功能自助卡发卡系统的设计与实现大连：大连理工大学，2016年。.
[2]王秦。基于自助自助技术的高校门户网站的设计与实现。《哈尔滨师范大学自然科学学报》，2017,33（03）： 43-48。
[3] P.拉贾拉杰斯瓦里，D。瓦苏马提和A。“电子商务系统建筑景观中UML建模技术的应用”，第7卷，No. 1，第3页。2016年2月39-42日。
[4]徐淑，吕立军。基于移动网络的实验类预约系统的设计与实现。实验科学与技术。2017,15 (6) :145-150
[5]吴冠雪。基于SpringMVC酒店管理系统[硕士论文]长春：吉林大学，2018年。.
[6]李真，李兆霞，刘涛，胡延安。基于SSM的科研办公室管理系统的设计与研究。计算机技术与开发。2021, 31 (12) : 148-154 .
[7]王佳，高银春，姜黄色的鹿角。基于F5负载平衡技术的在线课程选择平台[J]。计算机系统应用程序，2017年，26（06）：108-111。
[8]孙文悦。基于html5[硕士论文]的消防维护APP的设计与实现。西安：西安电子科技大学，2020年。