CN106570119A - Device for quickly obtaining product information and method for obtaining product information - Google Patents
Device for quickly obtaining product information and method for obtaining product information Download PDFInfo
- Publication number
- CN106570119A CN106570119A CN201610947448.3A CN201610947448A CN106570119A CN 106570119 A CN106570119 A CN 106570119A CN 201610947448 A CN201610947448 A CN 201610947448A CN 106570119 A CN106570119 A CN 106570119A
- Authority
- CN
- China
- Prior art keywords
- database
- product
- product information
- information
- test
- 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
- 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
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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/24—Querying
-
- 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/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Toxicology (AREA)
- Artificial Intelligence (AREA)
- Computer Vision & Pattern Recognition (AREA)
- General Health & Medical Sciences (AREA)
- Electromagnetism (AREA)
- Health & Medical Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses a device for quickly obtaining product information and a method for obtaining the product information. The device comprises multiple computers provided with code scanners and a database server, wherein the multiple computers provided with the code scanners are connected with the database server through an internet; and the database server is provided with a production database and a test database. The device for quickly obtaining the product information and the method for obtaining the product information are associated with the databases, and a user can inquire and acquire specific information of producing and testing a product from the associated databases only by entering a product batch number through the code scanners, so that the error probability of product information input is reduced, manual input of the user is greatly reduced and the operation process of the user is simplified.
Description
Technical field
The invention belongs to chip switch technical field, more particularly to a kind of device and its acquisition of quick obtaining product information
The method of product information.
Background technology
At present, in production management field, user needs to be manually entered product information to computer, for product information
Record is checked.With increasing for product information, it is manually entered and not only increases work load, is also easily caused wrong input.
Information input is quickly completed for convenience, product information is made bar code by many companies, by code reader to letter
The scanning of breath, completes product information typing.Although the method solves be manually entered loaded down with trivial details, alleviates work load, but by
It is excessive in bar number of codes, still can not completely avoid the mistake input that code mistake processed or barcode scanning are brought the problems such as dislocation.
The content of the invention
Goal of the invention：For the deficiencies in the prior art, it is an object of the invention to provide a kind of quick obtaining product
The device of information, it is adaptable to information query, substantially reduce the number being manually entered and operating process for user.The present invention's is another
One purpose is to provide a kind of obtaining product information method of the device of above-mentioned quick obtaining product information.
Technical scheme：In order to realize foregoing invention purpose, the technical solution used in the present invention is as follows：
A kind of device for quick obtaining product information, including multiple computers and database server for installing code reader,
The computer for installing code reader is connected by internet with database server；Production number is set on described database server
According to storehouse and test database.
Described database server is PC or industrial computer.
The database that described database server is used is SQL Server or MySQL database.
Described Production database, the batch information of record product, including product type, name of product and batch number
Amount, has just generated and has recorded when product is prepared and completed.
Described test database, the test information of record product, including test software programs and test hardware device,
Just generate when product test is completed and recorded.
The obtaining product information method of the device of described quick obtaining product information, comprises the steps of：
1）Computer is scanned by code reader, typing product batches numbering；
2）According to the product batches numbering for obtaining, the database of association is inquired about；
3）By the presentation of information of inquiry in computer user interface.
Beneficial effect：Compared with prior art, device of quick obtaining product information of the invention and products thereof information
Acquisition methods, with database association, user only need to be numbered by code reader typing product batches, you can from the database of association
Inquiry obtains the specifying information of the production and test, so as to reduce the error probability of product information input, also subtracts in a large number
Lack being manually entered for user, and simplify the operating process of user.
Description of the drawings
Fig. 1 is the structural representation of the device of quick obtaining product information.
Specific embodiment
With reference to concrete accompanying drawing, the present invention is described further.
The core concept of method of the quick obtaining product information of the present invention is：User only need to be scanned by code reader, record
Enter product batches numbering, then number the inquiry from the database of association by product batches and obtain the production with test
Specifying information, is easy to the record to product information or examination.
As shown in figure 1, the device of the quick obtaining product information of the present invention, including multiple computers for installing code reader with
And database server.Wherein, computer is connected with database server by internet, and database server includes production number
According to storehouse and test database.Database server is PC or industrial computer, and the database that database server is used is SQL
Server or MySQL or other databases.
Production database, the batch information of essential record product, including product type, name of product and batch size etc.
Product batches information, has just generated and has recorded when product is prepared and completed.
Test database, the test information of essential record product, including test software programs and test hardware device etc.
Product test information, has just generated when product test is completed and has recorded.
The method of the quick obtaining product information, comprises the steps of：
1）Computer is scanned by code reader, typing product batches numbering；
2）According to the product batches numbering for obtaining, the database of association is inquired about；
3）By the presentation of information of inquiry in computer user interface；
The present invention is mainly suitable for information query, substantially reduce the number being manually entered and operating process for user.
Claims (6)
1. a kind of device for quick obtaining product information, it is characterised in that computers including multiple installation code readers and
Database server, the computer for installing code reader is connected by internet with database server；Take in described database
Production database and test database are set on business device.
2. the device of quick obtaining product information according to claim 1, it is characterised in that described database server
For PC or industrial computer.
3. the device of quick obtaining product information according to claim 1, it is characterised in that described database service
The database that device is used is SQL Server or MySQL database.
4. the device of quick obtaining product information according to claim 1, it is characterised in that described Production database,
The batch information of record product, including product type, name of product and batch size, it is just raw when product preparation is completed
Into and record.
5. the device of quick obtaining product information according to claim 1, it is characterised in that described test database,
The test information of record product, including test software programs and test hardware device, it is just raw when product test is completed
Into and record.
6. the obtaining product information method of the device of the quick obtaining product information described in claim 1, it is characterised in that include
Following steps：
1）Computer is scanned by code reader, typing product batches numbering；
2）According to the product batches numbering for obtaining, the database of association is inquired about；
3）By the presentation of information of inquiry in computer user interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610947448.3A CN106570119A (en) | 2016-10-26 | 2016-10-26 | Device for quickly obtaining product information and method for obtaining product information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610947448.3A CN106570119A (en) | 2016-10-26 | 2016-10-26 | Device for quickly obtaining product information and method for obtaining product information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106570119A true CN106570119A (en) | 2017-04-19 |
Family
ID=58534941
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610947448.3A Pending CN106570119A (en) | 2016-10-26 | 2016-10-26 | Device for quickly obtaining product information and method for obtaining product information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106570119A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108240838A (en) * | 2017-11-10 | 2018-07-03 | 精华电子(苏州)有限公司 | A kind of on-line detecting system and method |
| CN111866097A (en) * | 2020-07-03 | 2020-10-30 | 熊猫智慧水务有限公司 | Intelligent device-based scanned data aggregation method |
| CN112526317A (en) * | 2020-11-13 | 2021-03-19 | 上海华岭集成电路技术股份有限公司 | Integrated circuit test data recording method |
| CN113626660A (en) * | 2021-08-16 | 2021-11-09 | 深圳市康立生物医疗有限公司 | Identification method, system and equipment of test card associated with immune information |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030187848A1 (en) * | 2002-04-02 | 2003-10-02 | Hovhannes Ghukasyan | Method and apparatus for restricting access to a database according to user permissions |
| CN103955835A (en) * | 2014-04-22 | 2014-07-30 | 广州宽度信息技术有限公司 | Method and system for live fowl source tracing anti-fake management |
| CN105678362A (en) * | 2016-03-09 | 2016-06-15 | 上海道之科技有限公司 | Traceability method of power module |
-
2016
- 2016-10-26 CN CN201610947448.3A patent/CN106570119A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030187848A1 (en) * | 2002-04-02 | 2003-10-02 | Hovhannes Ghukasyan | Method and apparatus for restricting access to a database according to user permissions |
| CN103955835A (en) * | 2014-04-22 | 2014-07-30 | 广州宽度信息技术有限公司 | Method and system for live fowl source tracing anti-fake management |
| CN105678362A (en) * | 2016-03-09 | 2016-06-15 | 上海道之科技有限公司 | Traceability method of power module |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108240838A (en) * | 2017-11-10 | 2018-07-03 | 精华电子(苏州)有限公司 | A kind of on-line detecting system and method |
| CN111866097A (en) * | 2020-07-03 | 2020-10-30 | 熊猫智慧水务有限公司 | Intelligent device-based scanned data aggregation method |
| CN112526317A (en) * | 2020-11-13 | 2021-03-19 | 上海华岭集成电路技术股份有限公司 | Integrated circuit test data recording method |
| CN113626660A (en) * | 2021-08-16 | 2021-11-09 | 深圳市康立生物医疗有限公司 | Identification method, system and equipment of test card associated with immune information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106570119A (en) | Device for quickly obtaining product information and method for obtaining product information | |
| EP3343411A1 (en) | Sql auditing method and apparatus, server and storage device | |
| CN111966868B (en) | Data management method based on identification analysis and related equipment | |
| CN102810135A (en) | Auxiliary processing system for drug prescription | |
| CN105095034A (en) | Product test equipment and testing method based on same | |
| CN103544624A (en) | Self-service after-sales service system and method | |
| CN204360423U (en) | A kind of milk product Quick Response Code traceability system | |
| CN112667697A (en) | Method and device for acquiring real estate information by combining RPA and AI | |
| CN111274548A (en) | Method and device for determining open source software license compliance | |
| CN111370132A (en) | Electronic file analysis method and device, computer equipment and storage medium | |
| CN110196849B (en) | System and method for realizing user portrait construction processing based on big data management technology | |
| CN104680111A (en) | Image type high-speed bar code scanning method | |
| CN113094418A (en) | Business processing method and system based on enterprise WeChat and computer equipment | |
| CN110995466B (en) | Multi-format log unified processing method and system under security situation awareness system | |
| CN112735571A (en) | Medical health data uploading management platform | |
| CN105335894A (en) | System for querying process information in production process | |
| CN106650850A (en) | Bar code scanning equipment configuration method and configuration system based on webpage end | |
| CN114912866A (en) | Information association method, device, equipment and storage medium | |
| CN103793540A (en) | Handheld data acquisition terminal | |
| CN102968728A (en) | Method for querying commodity standard conformity based on bar code scanning terminal | |
| TWI554758B (en) | A rapid-test system | |
| CN203414999U (en) | Fax-based clinical test data acquisition system | |
| CN114066488A (en) | Product anti-counterfeiting tracing identification equipment and method based on industrial Internet | |
| CN110888676B (en) | Shortcut key processing method and device | |
| CN110807034A (en) | Generating method and generating device of traceable data and readable storage medium |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20191120 Address after: 212000 Zhenjiang city Jiangsu province area Dingmao latitude four Road No. 36 Applicant after: JIANGSU ACETEC SEMICO-NDUCTOR CO., LTD. Address before: 211800, No. 15, No. 29, step road, Pukou Economic Development Zone, Nanjing, Jiangsu Applicant before: Jiangsu Aike core semiconductor Co. Ltd. |