CN110084335A - A kind of both-end commodity information management system based on bar code scanning - Google Patents
A kind of both-end commodity information management system based on bar code scanning Download PDFInfo
- Publication number
- CN110084335A CN110084335A CN201910233194.2A CN201910233194A CN110084335A CN 110084335 A CN110084335 A CN 110084335A CN 201910233194 A CN201910233194 A CN 201910233194A CN 110084335 A CN110084335 A CN 110084335A
- Authority
- CN
- China
- Prior art keywords
- module
- information
- client
- server
- local
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
- G06K17/0029—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device the arrangement being specially adapted for wireless interrogation of grouped or bundled articles tagged with wireless record carriers
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K7/00—Methods or arrangements for sensing record carriers, e.g. for reading patterns
- G06K7/10—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
- G06K7/10544—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum
- G06K7/10821—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum further details of bar or optical code scanning devices
- G06K7/10861—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum further details of bar or optical code scanning devices sensing of data fields affixed to objects or articles, e.g. coded labels
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Electromagnetism (AREA)
- Data Mining & Analysis (AREA)
- Computer Networks & Wireless Communication (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Toxicology (AREA)
- Artificial Intelligence (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to a kind of both-end commodity information management system based on bar code scanning, comprising: with the database side of the client of inquiring information of goods, the server-side being connect with the client and storing data；It is operated on Android system with the client of inquiring information of goods；Client includes: connection server module, local data library module, bar code scanner module, local goods data input module, local goods information inquiry module, merchandise news typing server module, server-side querying commodity information module, local goods information inspection, editor module, local goods information import modul, local goods information export module；The server-side connecting with the client operates on PC；Server-side includes: connection database end module, and adding module checks module；The database side of storing data is using the Navicat premium for being connected to MySQL.Database side includes: memory module, editor module, import modul, export module.
Description
Technical field
The present invention relates to fields of communication technology, more particularly to a kind of both-end commodity information management system based on bar code scanning
System.
Background technique
With the development of science and technology, the competition of market economy is also more and more fierce, cruel.How merchandise news is managed as quotient
The hot issue of family or even enterprises pay attention is one preferably square with the commodity information management system that computer technology is developed
Method.Compared with traditional labor management, commodity information management system saves time, man power and material, saved management at
This, moreover, commodity information management system management merchandise news is more information-based, standardizes, efficient activity.
But computer volume is larger, and it is not readily portable, it is not able to satisfy what merchandise news was put in storage in time in some scenarios
Demand.Replacing computer to carry out commodity information management with the mobile phone of small in volume is the good method for solving this problem.
In view of personal server is not necessarily at any time in the state opened, system is added to client store commodity information
Function, and the function of export local data is added to facilitate local data to be transplanted on server, also corresponding point of query function
For local search and networking inquiry.
Commodity bar code is the important component of merchandise news, but its length is longer, using being manually entered management
Not only operating efficiency is lower for mode, but also it is possible that the situation of data inputting mistake in Input Process, therefore we
System obtains bar code using bar code scanning and is manually entered two kinds of typing forms of bar code, greatly improves commodity letter
Cease the flexibility of management.
Summary of the invention
The problem of for merchandise news is managed in the prior art, now providing one kind, to aim at operating efficiency higher
And it is easy to operate flexible, and the higher both-end commodity information management system based on bar code scanning of accuracy.Technical solution
It is as follows:
A kind of both-end commodity information management system based on bar code scanning, comprising:
It adds and the database of the client of inquiring information of goods, the server-side being connect with the client and storing data
End；
Addition and the client of inquiring information of goods operate on Android system；
Client includes:
Connection server module, local data library module, bar code scanner module, local goods data input module, this
Ground querying commodity information module, merchandise news typing server module, server-side querying commodity information module, local goods letter
Breath check, editor module, local goods information import modul, local goods information export module；
The server-side connecting with the client operates on PC；
Server-side includes:
Database end module is connected, adding module checks module；
The database side of storing data is using the Navicat premium for being connected to MySQL；
Database side includes:
Memory module, editor module, import modul, export module；
It exports for the convenience of the user and is stored in local information of goods information data in client, the export of client local goods information
The import modul of module and database side carries out the transmitting of information between the two with the file format of csv；It is not networking for convenience
In the case of can check the merchandise news in server-side, the local goods information import modul being arranged in client, database side
The export module of design equally carries out information biography between the two with the file format of csv；
The bar code scanner module of client allows user by taking pictures and identifying album picture two ways to obtain
Commodity bar code, user are also an option that the typing form for being manually entered bar code.
Detailed description of the invention
A kind of structural schematic diagram of the both-end commodity information management system based on bar code scanning of Fig. 1；
The structure example of Fig. 2 system client, (a) are the module 1-8 of client, (b) are the editor module of client,
It (c) is the bar code scanner module of client；
The structure example of Fig. 3 server of the system；
The structure example at Fig. 4 system database end；
Each appended drawing reference indicates in description above:
(1) server module is connected；(2) merchandise news typing server module；(3) server-side querying commodity information mould
Block；(4) local goods data input module；(5) local goods information inquiry module；(6) local goods information view block；
(7) local goods information export module；(8) local goods information import modul；(9) local goods information editing module；(10)
Bar code scanner module；(11) adding module；(12) module is checked；(13) module is imported and exported；(14) editor module；
Specific embodiment
Technical scheme is as follows:
As shown in Figure 1, a kind of both-end commodity information management system based on bar code scanning of the present invention includes:
Client, server-side and database side；
The merchandise news of this system management include product name, bar code, commodity details A, commodity details B, commodity details C and
Commodity details D.User can assign details ABCD meaning (such as color, specification, price) according to their needs.
Client operates on Android machine.Because Android system has good open source, and then can provide multiple connect
Mouth integrates different functional modules, and Android system makes user more smooth in operation.
Input server IP address after (module 1), user can be uploaded to server (module 2) new merchandise news or
Merchandise news in query service device (module 3)；When server is inactive or the inconvenient networking of user, it is also an option that
(module 4), inquiring information of goods (module 5) is locally stored.Inquiry operation inputs the product name for needing to inquire by user
What the needs of (or commodity bar code) and user selection were inquired be details A or details B or details C or details D come into
Row inquiry；It is noted that inquiry operation supports fuzzy query, such as inquiry commodity bar code is 112, all quotient in library
Product bar code includes that the commodity (such as " 11211 " and " 11234 ") of " 112 " will all return to user as a result.
The local data library module of client uses SQLite, and SQLite is a small-sized, relationship built in Android
Type, the database for belonging to text-type.
It is exported in client in order to facilitate user and is stored in local information of goods information data, local number is added in client
According to export module (module 7), database side devises import modul (module 13), carries out letter between the two with the file format of csv
The transmitting of breath, it is very convenient.The merchandise news in server-side, client can also be checked under not networking situation for convenience
In be added to data import modul (module 8), database side devises export module (module 13), between the two equally with csv
File format carry out information transmitting, data in server are imported into client, in this way, not opened or client in server
When holding failed cluster, merchandise news also may browse through.
Local goods information view block (module 6) facilitates user intuitively to browse local whole merchandise news, and can
To be edited (module 9), delete operation to them.
Bar code scanner module (module 10) is added in client allows user by taking pictures and identifying album picture
Two ways come obtain commodity bar code (scan product barcode is the important component of merchandise news, length generally compared with
It is long), efficiency of inputting and accuracy rate are improved, user equally can choose the typing form for being manually entered bar code, greatly mention
The high flexibility of commodity information management.
Server-side operates on PC.Its major function is the merchandise news for receiving client and transmitting, and is stored to number
According to library end, the same inquiry request for receiving client and sending returns result to client after database side obtains query result
End.Server-side presents interactive interface in the form of web pages, and it is new that user can upload (module 11) to database side by the interface
Merchandise news, can also intuitively check all merchandise news of (module 12) database side.
Database side is attached to the Navicat premium of MySQL, passes through the visualization interface of Navicat, Yong Huke
Very easily to be edited (module 14), delete operation in library data, can also will be exported in library data or into library
It imports data (module 13), data migration is carried out with this, it is very convenient.
Claims (1)
1. a kind of both-end commodity information management system based on bar code scanning, comprising:
With the database side of the client of inquiring information of goods, the server-side being connect with the client and storing data；
It is operated on Android system with the client of inquiring information of goods；
Client includes:
Connect server module, local data library module, bar code scanner module, local goods data input module, local quotient
Product information inquiry module, merchandise news typing server module, server-side querying commodity information module, local goods information are looked into
It sees, editor module, local goods information import modul, local goods information export module；
The server-side connecting with the client operates on PC；
Server-side includes:
Database end module is connected, adding module checks module；
The database side of storing data is using the Navicat premium for being connected to MySQL；
Database side includes:
Memory module, editor module, import modul, export module；
It exports in client for the convenience of the user and is stored in local information of goods information data, client local goods information export module
With the import modul of database side, the transmitting of information is carried out with the file format of csv between the two；For convenience of under not networking situation
It can check the merchandise news in server-side, the local goods information import modul being arranged in client, database side design
Export module equally carries out information biography between the two with the file format of csv；
The bar code scanner module of client allows user by taking pictures and identifying album picture two ways to obtain commodity
Bar code, user are also an option that the typing form for being manually entered bar code.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910233194.2A CN110084335A (en) | 2019-03-26 | 2019-03-26 | A kind of both-end commodity information management system based on bar code scanning |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910233194.2A CN110084335A (en) | 2019-03-26 | 2019-03-26 | A kind of both-end commodity information management system based on bar code scanning |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110084335A true CN110084335A (en) | 2019-08-02 |
Family
ID=67413655
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910233194.2A Pending CN110084335A (en) | 2019-03-26 | 2019-03-26 | A kind of both-end commodity information management system based on bar code scanning |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110084335A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111860709A (en) * | 2020-06-21 | 2020-10-30 | 深圳华物信联科技有限公司 | Commodity management system and commodity management method |
| CN113887684A (en) * | 2021-09-27 | 2022-01-04 | 青岛普天智能制造股份有限公司 | Code scanning automatic recording system and method for biological sample liquid nitrogen storage |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103067483A (en) * | 2012-12-25 | 2013-04-24 | 广东邮电职业技术学院 | Remote data increment synchronization method and device based on data package |
| CN108369685A (en) * | 2015-07-31 | 2018-08-03 | 微软技术许可有限责任公司 | Utilize the organization directory of local and web search |
| CN108491935A (en) * | 2018-02-06 | 2018-09-04 | 国网浙江省电力公司丽水供电公司 | A kind of customer information visualized O＆M management system and method |
-
2019
- 2019-03-26 CN CN201910233194.2A patent/CN110084335A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103067483A (en) * | 2012-12-25 | 2013-04-24 | 广东邮电职业技术学院 | Remote data increment synchronization method and device based on data package |
| CN108369685A (en) * | 2015-07-31 | 2018-08-03 | 微软技术许可有限责任公司 | Utilize the organization directory of local and web search |
| CN108491935A (en) * | 2018-02-06 | 2018-09-04 | 国网浙江省电力公司丽水供电公司 | A kind of customer information visualized O＆M management system and method |
Non-Patent Citations (1)
| Title |
|---|
| 宫翔: "《基于Android平台仓储管理软件的开发》", 《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111860709A (en) * | 2020-06-21 | 2020-10-30 | 深圳华物信联科技有限公司 | Commodity management system and commodity management method |
| CN111860709B (en) * | 2020-06-21 | 2023-09-22 | 深圳盈达信息科技有限公司 | Commodity management system and commodity management method |
| CN113887684A (en) * | 2021-09-27 | 2022-01-04 | 青岛普天智能制造股份有限公司 | Code scanning automatic recording system and method for biological sample liquid nitrogen storage |
| CN113887684B (en) * | 2021-09-27 | 2023-10-13 | 青岛环球集团有限公司 | Automatic code scanning and recording system and method for liquid nitrogen storage of biological samples |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102339289B (en) | Match identification method for character information and image information, and device thereof | |
| CN102982178B (en) | A kind of image searching method, device and system | |
| CN107067060B (en) | Two-dimensional code RFID label printing system of self-service book cabinet and book borrowing method | |
| CN107958028A (en) | Method, apparatus, storage medium and the terminal of data acquisition | |
| CN102682105B (en) | Utilize mobile terminal identification and obtain the system and method for related web page information | |
| CN112364223B (en) | Digital archive system | |
| CN201111143Y (en) | System for collecting and enquiring commercial product concluded price information | |
| CN101211357A (en) | System and method for collecting internet information by using mobile terminal two-dimension bar-code technology | |
| CN110084335A (en) | A kind of both-end commodity information management system based on bar code scanning | |
| CN103164759A (en) | Intelligent medicine box management system based on radio frequency identification device (RFID) | |
| CN104820932A (en) | Quick commodity retrieval system in massive data and method thereof | |
| CN206788898U (en) | The Quick Response Code RFID label tag print system of self-service book cabinet | |
| US20060173755A1 (en) | Catalog management apparatus, catalog generation method and catalog retrieval method | |
| US20080071553A1 (en) | Generation of Commercial Presentations | |
| CN102624770A (en) | Information extraction method and extraction information network storage management system based on cloud calculation | |
| CN202711309U (en) | Intelligent medicine box management system based on RFID | |
| CN104299150A (en) | Fabric transaction system and method based on mobile client terminals | |
| CN104506597A (en) | Method, device and system for acquiring information of electricity customers | |
| CN108509396A (en) | Pdf document turns method, electronic device and the computer readable storage medium of picture | |
| CN106650850A (en) | Bar code scanning equipment configuration method and configuration system based on webpage end | |
| CN211604177U (en) | Internet of things tracing comprehensive application system integrating radio frequency identification and two-dimensional code technology | |
| CN105868380A (en) | Heterogenous data reading method and electronic equipment | |
| KR102227518B1 (en) | Cloud database coupled collective printing apparatus and method thereof | |
| KR20130023897A (en) | System, terminal, server, method, recording medium and program providing device for providing phonebook service with qr code | |
| CN111160876A (en) | Internet of things identification analysis information input method based on input equipment identity |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190802 |
|
| RJ01 | Rejection of invention patent application after publication |