CN104318377A - Sports goods marketing information management system - Google Patents

Sports goods marketing information management system Download PDF

Info

Publication number
CN104318377A
CN104318377A CN201410562648.8A CN201410562648A CN104318377A CN 104318377 A CN104318377 A CN 104318377A CN 201410562648 A CN201410562648 A CN 201410562648A CN 104318377 A CN104318377 A CN 104318377A
Authority
CN
China
Prior art keywords
module
order
management system
information
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201410562648.8A
Other languages
Chinese (zh)
Inventor
张晓丹
宁志高
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenyang University of Chemical Technology
Original Assignee
Shenyang University of Chemical Technology
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenyang University of Chemical Technology filed Critical Shenyang University of Chemical Technology
Priority to CN201410562648.8A priority Critical patent/CN104318377A/en
Publication of CN104318377A publication Critical patent/CN104318377A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063—Operations research, analysis or management
    • G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • G06Q30/0601—Electronic shopping [e-shopping]

Landscapes

  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Accounting & Taxation (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Finance (AREA)
  • Theoretical Computer Science (AREA)
  • Development Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Educational Administration (AREA)
  • Game Theory and Decision Science (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a sports goods marketing information management system, and relates to a computer management system. The sports goods marketing information management system comprises a foreground user module and a background user module which are arranged under a Browser/ Server network mode, wherein the foreground user module comprises a member registration module, a shopping cart module, an order inquiry module and a goods browsing module, the background user module comprises a notice management module, a goods management module, an order management module, a member management module and a user management module, data flows of all the above modules are defined through a data dictionary, the data flows, data elements, data storage, data processing and external items of all the above modules are described through the data dictionary, corresponding database information tables are established, and the database information tables are linked with a database through JDBC (java database connectivity). The sports goods marketing information management system can use modern scientific and technological resources well, improves use rate of an enterprise at all points, reduces manual workloads, prevents error and a large amount of waste of manpower and material resources, and effectively saves management costs.

Description

A kind of sports goods Marketing Information Management System
Technical field
The present invention relates to a kind of computer management system, specifically a kind of sports goods Marketing Information Management System.
Background technology
Shopping online is an e-commerce platform.Here, consumer stays indoors a series of consumption information such as the merchandise news just can browsed in each supermarket, sales field, chain store, discounting commodity and advertising campaign.Consumer can find the commodity that oneself needs easily, picture and character introduction, and so, consumer will buy oneself requirement very easily, can also buy the commodity that consumer locality does not have to sell; E-Bank payment is safer with regard to present situation, and it can reduce the stolen stolen possibility of fund, and because online shopping mall can save the rent of a lot of shop front, this just saves a fund for businessman.For businessman, shopping online is the strong means of one of publicity corporate image, is a kind of mode of Cheap highly effective.Its advantage is apparent, release news have in time, feature accurately, both pictures and texts are excellent, refreshes in time.Any Xindeng commodity and sales promotion, advertising message can be presented in face of consumer in the very first time.Can realize timely interaction between consumer and businessman, the up-to-date demand in market can be recognized by businessman.In whole market economy, this novel shopping mode can in the larger context, more aspect realizes resource distribution with higher efficiency.
Along with the fast development of ecommerce, it is closely bound up with the life of people, and no matter you are the occupation being engaged in which aspect, seems the shadow of ecommerce.Before not having ecommerce, people are still with face-to-face shopping mode, and this shopping mode is subject to the impact of other patterns a lot, such as weather, the factors one such as geography, and takies people's a lot of time.
At present, aim at the sale of sports goods and the information management system designed there is not been reported.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of sports goods Marketing Information Management System, and this system is for not yet occurring in prior art aiming at the sale of sports goods and the deficiency of the information management system designed provides a kind of sports goods Marketing Information Management System.
For solving the problems of the technologies described above, the technical solution used in the present invention is:
Sports goods Marketing Information Management System of the present invention, foreground line module and management staff's module are set under Brower/Server network schemer, wherein foreground line module comprises member registration module, shopping cart module, order inquiries module and goods browse module, management staff's module comprises bulletin administration module, item management module, order management module, member management module and user management module, is defined by the data flow of data dictionary to above-mentioned each module; Describe the data stream of above-mentioned each module by data dictionary, data element, data store, processing, external entries, set up Administrator Info's table, the large category information table of notice information table, merchandise news table, member registration information table, commodity, sequence information table, commodity group information table and shopping cart information table, use JDBC linked database.
The log-on message of described member registration module record member in online sporting goods shop, data comprise user name, password, name, age, occupation, mailbox.
The details of described shopping cart module recording user shopping, data comprise numbering, order number, article number, valency, quantity.
In described order inquiries module, member checks the sequence information oneself submitted to, and whether inquiry order is treated.
The notice information of described bulletin management module records website, keeper can add, deletes or revise bulletin, and data comprise numbering, title, content, issuing time.
The relevant information of described item management module record web site commodity, keeper can add, delete commodity and merchandise classification, and data comprise goods number, classification, trade name, producer, brief introduction, shelf life, present price, special price, picture.
The information of the order produced after described order management module record member does shopping, keeper processes the order that client submits to, deliver according to order information, or order is deleted, whether data comprise numbering, order number, user name, name, address, phone, Payment Methods, method of shipment, remarks, deliver, creation-time.
The information of described user management module record website management staff, data comprise numbering, user name, password, name.
Application the present invention will carry out the registration of new user before shopping, can login system after succeeding in registration; Authentication password correctly laggard enter website homepage carry out choosing of sports goods; After the commodity chosen are put into shopping cart, cashier can be gone to fill in consignee's information and confirm, form untreated order; User-pay after service provider acknowledges receipt of, service provider delivers; When user receives goods, delete this order, complete a shopping process.
The present invention has following beneficial effect and advantage:
1. the present invention first take full advantage of JSP program development with should have on dirigibility, can modify to program function at any time, secondly, the background function of keeper is very powerful, Classification Management has been carried out to commodity, can inquire the pouplarity of commodity fast, thus effectively adjust marketing plan, this sample system is also provided with very large marketable value.
2. present system better can utilize modern scientific and technological resources, improves the utilization factor in every respect of enterprise, reduces artificial workload, avoids makeing mistakes and the waste of a large amount of man power and materials, has effectively saved handling cost.
Accompanying drawing explanation
Fig. 1 is foreground system function structure chart in present system;
Fig. 2 is management staff's function structure chart in present system;
Fig. 3 is present system program flow diagram;
Fig. 4 is present system front desk service process flow diagram;
Fig. 5 is present system Batch Processing process flow diagram.
Embodiment
Below in conjunction with Figure of description, the present invention is further elaborated.
As shown in Figure 1, 2, sports goods Marketing Information Management System of the present invention, foreground line module and management staff's module are set under Brower/Server network schemer, wherein foreground line module comprises member registration module, shopping cart module, order inquiries module and goods browse module, management staff's module comprises bulletin administration module, item management module, order management module, member management module and user management module, is defined by the data flow of data dictionary to above-mentioned each module; Describe the data stream of above-mentioned each module by data dictionary, data element, data store, processing, external entries, set up Administrator Info (tb_manager) table, notice information (tb_affiche) table, merchandise news (tb_goods) table, member registration information (tb_member) table, the large category information of commodity (tb_bigType) table, sequence information (tb_order) table, the little category information of commodity (tb_smallType) table and shopping cart information (tb_orderDetail) table, use JDBC linked database.
The function that online sporting goods shop will realize is very many, and most important is exactly that the shopping of keeper to the management realization of commodity and user realizes; This wherein just comprises: keeper is to the interpolation of commodity, and price is revised, the inquiry of order, the amendment etc. of type of merchandize.
As shown in Figure 4,5, present system front desk service process flow diagram and Batch Processing process flow diagram is respectively.
In structured analysis, the effect of data dictionary all can be explained in any uncomprehending exercise question of data in data dictionary.In data flow diagram each element through determining to put together, the specification of common construction system.
It is below the explanation that each module data is stored.
The data of table 3.1 membership information store
The data of table 3.4 merchandise classification information store
Foreground line module mainly comprises user's registration, and order inquiries, adds shopping cart, these main modular of goods browse.User becomes the member in store by " user's registration ", therefore obtains the authority buying commodity; The state of the commodity that you buy can be found after " order inquiries " member Website login; " shopping cart " is that these details buying commodity of member describe.
The major function of management staff's module realizes the maintenance and management in this store, as interpolation, the deletion of classification; The interpolation of commodity, inquiry, the management such as deletion; The inquiry of order, deletes, management etc.
The present embodiment being described below database table:
Table 4.1 Administrator Info (tb_manager) shows
Field name Type Length Major key Allow empty Explanation of field
id int 4 Be No Sequence number
account varchar 50 ? Be User name
password varchar 51 ? Be Password
name varchar 50 ? Be Real Name
sign bit 1 ? Be Whether log in
Table 4.2 notice information (tb_affiche) is shown
Field name Type Length Major key Allow empty Explanation of field
id int 4 Be No Numbering
name varchar 51 ? Be Customs Assigned Number
content text 16 ? Be Payment Methods
issueTime smalldatetie 4 ? Be Account number
Table 4.3 merchandise news (tb_goods) is shown
Field name Type Length Major key Allow empty Explanation of field
id int 4 Be No Goods number
bigId int 4 ? Be Large class numbering
smallId int 4 ? Be Group is numbered
goodsName varchar 50 ? Be Trade name
goodsFrom varchar 51 ? Be Manufacturer
introduce text 16 ? Be Descriptive labelling
creaTime smalldatetime 4 ? Be Issuing time
nowPrice money 8 ? Be Commodity present price
freePrice money 8 ? Be Commodity special price
number int 5 ? Be Buy number of times
pirture varchar 50 ? Be Picture
mark bit 1 ? Be Whether special price
Table 4.4 member registration information (tb_member) is shown
Field name Type Length Major key Allow empty Explanation of field
id int 4 Be No Sequence number
name varchar 50 ? Be User name
password varchar 50 ? Be Password
reallyName varchar 10 ? Be Real Name
age int 4 ? Be Age
profession varchar 50 ? Be Occupation
email varchar 50 ? Be E-mail address
question varchar 50 ? Be Security Question
result varchar 51 ? Be Answer
The large category information of table 4.5 commodity (tb_bigType) is shown
Field name Type Length Major key Allow empty Explanation of field
Id int 4 Be No Class number
bigName varchar 51 ? Be Item name
creatime smalldatetime 4 ? Be Creation-time
Table 4.6 sequence information (tb_order) is shown
Field name Type Length Major key Allow empty Explanation of field
id int 4 ? No Sequence number
number varchar 51 Be No Order number
name varchar 50 ? Be User name
reallyName varchar 50 ? Be Name
address varchar 50 ? Be Address
tel varchar 50 ? Be Phone
setMoney varchar 50 ? Be Payment Methods
post varchar 51 ? Be Method of shipment
bz text 16 ? Be Remarks
sign bit 1 ? Be Whether shipped
creaTime smalldatetime 4 ? Be Order the time
The little category information of table 4.7 commodity (tb_smallType) is shown
Field name Type Length Major key Allow empty Explanation of field
Id int 4 Be No Group is numbered
bigId Int 4 ? No Affiliated large class numbering
smallName varchar 51 ? Be Group title
creaTime smalldatetime 4 ? Be Creation-time
Table 4.8 shopping cart information (tb_orderDetail) is shown
Field name Type Length Major key Allow empty Explanation of field
Id int 4 Be No Sequence number
orderNumber varchar 51 ? Be Order number
goodsId Int 4 ? Be Article number
price Float 8 ? Be Commodity price
number int 4 ? Be Quantity purchase
As shown in Figure 3, be the program flow diagram of present system.
The registration of new user will be carried out before shopping, can login system after succeeding in registration; Authentication password correctly laggard enter website homepage carry out choosing of sports goods; After the commodity chosen are put into shopping cart, cashier can be gone to fill in consignee's information and confirm, form untreated order; User-pay after service provider acknowledges receipt of, service provider delivers; When user receives goods, delete this order, complete a shopping process.
Sale Management Platform is mainly for sports enthusiast with the direct dealing between businessman, and sales management information newly defines traditional circulation pattern, decreases intermediate link.Mainly comprise foreground to user's exhibiting product, different classes of member handles the inquiry of all kinds of business and product information.The operation on backstage comprises the management of Administrator Info, has the additions and deletions of product information to change and looks into, the management of membership information.This system can help consumer better to find oneself proud product, and businessman can also be made better to have managed the commodity of oneself sale, and stock up, the supply of material, the Integrated service of sale, decreases manpower, material resources, financial resources.

Claims (9)

1. a sports goods Marketing Information Management System, it is characterized in that: foreground line module and management staff's module are set under Brower/Server network schemer, wherein foreground line module comprises member registration module, shopping cart module, order inquiries module and goods browse module, management staff's module comprises bulletin administration module, item management module, order management module, member management module and user management module, is defined by the data flow of data dictionary to above-mentioned each module; Describe the data stream of above-mentioned each module by data dictionary, data element, data store, processing, external entries, set up Administrator Info's table, the large category information table of notice information table, merchandise news table, member registration information table, commodity, sequence information table, commodity group information table and shopping cart information table, use JDBC linked database.
2., by sports goods Marketing Information Management System according to claim 1, it is characterized in that: the log-on message of described member registration module record member in online sporting goods shop, data comprise user name, password, name, age, occupation, mailbox.
3. by sports goods Marketing Information Management System according to claim 1, it is characterized in that: the details of described shopping cart module recording user shopping, data comprise numbering, order number, article number, valency, quantity.
4. by sports goods Marketing Information Management System according to claim 1, it is characterized in that: in described order inquiries module, member checks the sequence information oneself submitted to, whether inquiry order is treated.
5., by sports goods Marketing Information Management System according to claim 1, it is characterized in that: the notice information of described bulletin management module records website, keeper can add, deletes or revise bulletin, and data comprise numbering, title, content, issuing time.
6. by sports goods Marketing Information Management System according to claim 1, it is characterized in that: the relevant information of described item management module record web site commodity, keeper can add, delete commodity and merchandise classification, and data comprise goods number, classification, trade name, producer, brief introduction, shelf life, present price, special price, picture.
7. by sports goods Marketing Information Management System according to claim 1, it is characterized in that: the information of the order produced after described order management module record member does shopping, keeper processes the order that client submits to, deliver according to order information, or order is deleted, whether data comprise numbering, order number, user name, name, address, phone, Payment Methods, method of shipment, remarks, deliver, creation-time.
8., by sports goods Marketing Information Management System according to claim 1, it is characterized in that: the information of described user management module record website management staff, data comprise numbering, user name, password, name.
9., by sports goods Marketing Information Management System according to claim 1, it is characterized in that: the registration that new user will be carried out before shopping, can login system after succeeding in registration; Authentication password correctly laggard enter website homepage carry out choosing of sports goods; After the commodity chosen are put into shopping cart, cashier can be gone to fill in consignee's information and confirm, form untreated order; User-pay after service provider acknowledges receipt of, service provider delivers; When user receives goods, delete this order, complete a shopping process.
CN201410562648.8A 2014-10-22 2014-10-22 Sports goods marketing information management system Pending CN104318377A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410562648.8A CN104318377A (en) 2014-10-22 2014-10-22 Sports goods marketing information management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410562648.8A CN104318377A (en) 2014-10-22 2014-10-22 Sports goods marketing information management system

Publications (1)

Publication Number Publication Date
CN104318377A true CN104318377A (en) 2015-01-28

Family

ID=52373605

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410562648.8A Pending CN104318377A (en) 2014-10-22 2014-10-22 Sports goods marketing information management system

Country Status (1)

Country Link
CN (1) CN104318377A (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105069625A (en) * 2015-07-16 2015-11-18 沈阳化工大学 Enterprise electronic mall system
CN105550831A (en) * 2016-02-15 2016-05-04 重庆昇鑫科技有限公司 Intelligent mall business management system based on internet of things
CN106651192A (en) * 2016-12-29 2017-05-10 深圳市赛亿科技开发有限公司 Background management system of network marketing platform
CN107967612A (en) * 2017-12-28 2018-04-27 湖南机械之家信息科技有限公司 Market service platform system after engineering machinery
CN108959536A (en) * 2018-06-29 2018-12-07 嘉兴玖轩电子商务有限公司 A kind of database design for e-commerce system
CN109325688A (en) * 2018-09-19 2019-02-12 深圳市朗耀电子商务有限公司 A kind of jewellery sales record system
WO2019157944A1 (en) * 2018-02-13 2019-08-22 北京京东尚科信息技术有限公司 Item information processing method, system and device, and computer-readable storage medium
CN110399360A (en) * 2019-07-26 2019-11-01 北京明略软件系统有限公司 The setting method and device of dictionary table, storage medium, electronic device
CN111476620A (en) * 2019-01-24 2020-07-31 上海杰弟文化传播有限公司 Method for realizing business of clothing electronic commerce system

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103870970A (en) * 2014-03-25 2014-06-18 沈阳化工大学 Campus goods-selling online-shop system
CN103886466A (en) * 2014-03-21 2014-06-25 沈阳化工大学 Online mall system
CN103903152A (en) * 2014-03-27 2014-07-02 沈阳化工大学 Online shopping center system
CN103903175A (en) * 2014-03-21 2014-07-02 沈阳化工大学 Electronic commerce shopping system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103886466A (en) * 2014-03-21 2014-06-25 沈阳化工大学 Online mall system
CN103903175A (en) * 2014-03-21 2014-07-02 沈阳化工大学 Electronic commerce shopping system
CN103870970A (en) * 2014-03-25 2014-06-18 沈阳化工大学 Campus goods-selling online-shop system
CN103903152A (en) * 2014-03-27 2014-07-02 沈阳化工大学 Online shopping center system

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105069625A (en) * 2015-07-16 2015-11-18 沈阳化工大学 Enterprise electronic mall system
CN105550831A (en) * 2016-02-15 2016-05-04 重庆昇鑫科技有限公司 Intelligent mall business management system based on internet of things
CN106651192A (en) * 2016-12-29 2017-05-10 深圳市赛亿科技开发有限公司 Background management system of network marketing platform
CN107967612A (en) * 2017-12-28 2018-04-27 湖南机械之家信息科技有限公司 Market service platform system after engineering machinery
WO2019157944A1 (en) * 2018-02-13 2019-08-22 北京京东尚科信息技术有限公司 Item information processing method, system and device, and computer-readable storage medium
CN108959536A (en) * 2018-06-29 2018-12-07 嘉兴玖轩电子商务有限公司 A kind of database design for e-commerce system
CN109325688A (en) * 2018-09-19 2019-02-12 深圳市朗耀电子商务有限公司 A kind of jewellery sales record system
CN111476620A (en) * 2019-01-24 2020-07-31 上海杰弟文化传播有限公司 Method for realizing business of clothing electronic commerce system
CN110399360A (en) * 2019-07-26 2019-11-01 北京明略软件系统有限公司 The setting method and device of dictionary table, storage medium, electronic device

Similar Documents

Publication Publication Date Title
CN104318377A (en) Sports goods marketing information management system
CN103903175A (en) Electronic commerce shopping system
CN109784669A (en) Based on the mating cloud manufacturing service system with resource-sharing business of industrial collaboration
CN103903152A (en) Online shopping center system
CN105243577A (en) E-commerce platform for agricultural products
CN104268778A (en) Integrated on-line trading and extension service system for cultural and creative products
CN107292683A (en) Wechat distributes merchant processing systems and its method
CN104574103A (en) Electronic service platform with automatic demand screening function
CN107301556A (en) The data-sharing systems and its control method of a kind of multi-brand
CN106204215A (en) A kind of online Books Marketing system
CN104299087A (en) Online shopping mall system
Revinova E-commerce in BRICS: similarities and differences
CN104318382A (en) E-commerce information management system
CN104318380A (en) Recording and video company sale system
CN104574142A (en) Method for establishing electronic service platform with automatic demand screening function
CN105046549A (en) Special local product online sales information management system
CN107437128A (en) One kind is based on wechat mobile terminal distribution platform system
CN107403327A (en) Mobile differential pin store processing system and its method
CN108256952A (en) Store processing system is distributed on the net in a kind of mobile multiple terminals
CN107730344A (en) A kind of manufacturing industry supply-chain management system based on Internet of Things
Ahammed et al. Big data analysis for e-trading system
KR101151720B1 (en) Merchandise management system using social commerce
Kyrychenko et al. The Role of Infocommunication Technologies in International Tourism Industry Development
Abbas International Usage Of Internet In E-Business And E-Tourism
Hiep et al. The state of e-commerce industry after Covid-19 pandemic and some development policies

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20150128

RJ01 Rejection of invention patent application after publication