The Design And Implementation Of Commodity Spot Trading Management System For Tianjin Port Market

Traditional commodity spot transactions is easy to cause the customer data, product data, or other important data missing, and artificial management is easy to cause the error handling and repeat. With the development of information technology, In order to achieve high efficiency and long-term functioning of commodity spot transaction management, Tianjin port market sets up a commodity spot transaction management system based on information technology, which will realize the spot trading of promptness and convenience.The system uses B/S structure, JAVA language, SSH framework based on MVC design pattern. The MVC design pattern divides the system into three layers:the Web layer, service layer and physical layer. The Web layer manages users’ requests and responses, builds up the model objects in the view and performs UI validation. The Web layer is supported and implemented by the Struts. The service layer, implemented by Spring, processes the application of business logic and business check, manages dependencies between business objects, joins the flexibility between Web layer and physical layer, so that they do not communicate directly with each other. The service layer manages the realization from the business layer to the Web layer. The physical layer is supported and implemented by Hibernate, which adopts the advanced object relational mapping framework. The system uses the JDBC technology to encapsulate data. The system adopts Microsoft SQL Server 2014.The system realizes the functions including:the system management functions which consists of value table management, user management, role management and authority management. The trade setting management functions is made up of basic management, product management and member management. Among them, the basic management includes traded setting, time setting, the deposit rate setting, warehouse management and settlement management. The warehouse management consists of the add warehouse and the query warehouse. The settlement line management achieves the add and query clearing line. The commodity management includes product model setting, forward contract and spot contract setting. The member management realizes the function that adds and modifies the member and member seats, adds, modifies and deletes the customers. The Settlement management includes discrepancy gold management and warehouse management. The transaction management consists of spot transaction, forward transactions and customer inquiries. The spot trading function implements the spot, the spot cancellations and spot transaction. The forward transactions achieve forward orders and forward withdrawals. The customer inquiry function refers to financial inquiry. The query statistics function realizes the transaction query, member funds query and statement query. The trade enquiry includes order query and transaction inquiry.The system provides a good technical support for the commodity spot transaction management and development of Tianjin port after it puts into use, which makes Commodity spot transactions more convenient and fast.