CN1949216A - Information searching method - Google Patents
Information searching method Download PDFInfo
- Publication number
- CN1949216A CN1949216A CNA2006101279597A CN200610127959A CN1949216A CN 1949216 A CN1949216 A CN 1949216A CN A2006101279597 A CNA2006101279597 A CN A2006101279597A CN 200610127959 A CN200610127959 A CN 200610127959A CN 1949216 A CN1949216 A CN 1949216A
- Authority
- CN
- China
- Prior art keywords
- data
- information
- database
- function
- file
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses information search method based that user terminal is connected with data base by wireless transmission mode, which is connected with internet. It includes the following steps: data updating, information search, information logging in includes information amending, deleting, and adding, uploading file, admitting file used to admit ordered file to current computer internal memory, map to computer screen, or store in current data base. Search method returns different result according to the different modules and types. User terminal can download and renew information from remote data base at random. Meanwhile, the information of the user terminal can feed back the remote data base, and renew data according to different contents which can realize user terminal and data base connecting and interaction, lay importance foundation for executing dynamic management.
Description
Technical field
The present invention relates to a kind of querying method, particularly a kind of information query method that in the commodity on-site law-enforcing, uses.
Background technology
In the enforcing law of law enforcement agency of district administration, the still traditional method that generally adopts at present, for example on-the-spot in law enforcement, the article of finding, whether legal registration is arranged, whether belong to circular and look into false scope, be difficult at that time judge, though, sometimes, have computing machine during law enforcement, but because the information in the computing machine is fix information substantially, of a great variety at present commodity, update the frequent epoch, the various information of the quality of its commodity is difficult in law enforcement agency and grasps, and at present, mainly has following problem:
1, inspection is when cracking down on counterfeit goods, and the law enfrocement official judges with memory mostly by rule of thumb, and limited because of man memory, a large amount of professional knowledge and information all can't be in time, utilization accurately and effectively.
2, various places supervisory and management department and information are not connected, and information issue face is narrow, and issuing time also lags behind, and the technical checking achievement is idle, causes quality information not make full use of.
When 3, the law enfrocement official goes out to handle a case, data such as laws and regulations, commercial standards, management counterpart can not in time be inquired about, work efficiency is low.
4, operation applying unit circulation of commodities amount above county level is big, checks that workload is loaded down with trivial details greatly, needs a large amount of manpowers of cost and time, and it is bigger to look into false difficulty.
5, higher level supervisory and management department is difficult to grasp to the supervision situation of grass-roots supervision administrative authority, the rural area commodity is checked coverage rate and management counterpart's situation is difficult to understand.
6, the administrative supervision relevant statistics amount of enforcing the law is big, and workload is big, and efficient is low.
Above problem is the ubiquitous problems of present administrative law-enforcement departments, and different departments are its merchandise news difference of loading, the method unanimity.Therefore demand developing the employed a kind of snap information querying method of the present law-enforcing ranks of a kind of adaptation urgently, improve administrative law enforcement efficient, can be widely used in all administrative law-enforcement departments.
Summary of the invention
The objective of the invention is to, not smooth to overcome in the present enforcing law existing information by a kind of information query method is provided, the problem that law enforcement efficiency is low.
The present invention adopts following technological means to realize:
A kind of information query method connects database based on user terminal with wireless transmission method, and database is connected with Internet; Comprise: the Data Update step: selecteed file in the above-mentioned database is read to internal memory, by circulation with resolve it is stored in the corresponding system data form, can delete legacy data in the time of storage;
Information inquiry step: adopt the ODBC data to connect the bridge bridge, after the condition of having obtained inquiry, call character string and inquire qualified recording storage in internal memory, shine upon by internal storage data on the present user interface of form final body that turns back in this system;
Information typing step: comprise information correction, information deletion, information interpolation; Information correction wherein: use the ODBC data to connect bridge, selection by the user saves as user input data with corresponding data in the local data base, for the function that obtains sequence number obtains the function that the sequence number of wanting amendment record is revised data, revise the record of regulation sequence number, and direct and data association, the result who revises will directly be saved to database, and cover original information;
Information deletion: use the ODBC data to connect bridge, the selection by the user is with corresponding data deletion in the local data base, and this function is irreversible, the method that uses is for obtaining the function of recording mechanism, obtain the sequence number of wanting deletion record, the function of deletion record, the record of deletion regulation sequence number; Information in the delete database, this deletion is irrelevant with internal memory;
Information is added: the data of interpolation come from the information of user's input, use the ODBC data to connect bridge, at first obtain after the user data, be buffered in the internal memory, be stored in the functional based method that is used to add record in the database in the interpolation process then by data verification;
The upload file step: local data is uploaded to database, and the data that will obtain local data base connect data transmission to the central server database by network then to internal memory earlier;
Import the file step: orderly file is directed into the current computer internal memory, map to computer screen, or be saved to current database, with selecting good data, with xls .txt, .xml, .csv, the ..dbf form is stored in the calculator memory automatically by the form of this document, arranges and temporarily leaves in the DataWindow data-carrier store that has set according to the Format Series Lines of data in the file.
Aforesaid Data Update step is manually to upgrade; Its method is: select to download the distinctive file layout Prs formatted file of PowerBuilder database from database; Resolution file, obtain the file logging clauses and subclauses; Existing clauses and subclauses of deletion and content; Keep up-to-date data; The end data exchange; Deletion legacy data in the time of storage; Data after the exchange are back to database; Any mistake wherein takes place in above process, returns again and selects Prs formatted file step.
Aforesaid Data Update step is an online updating; By SQL SERVER 2005 databases of a Microsoft of OLEDB remote data base connection, judge the title and the corresponding table of upgrading module; Obtain data to the local computer core buffer by calling the function that obtains table; Call the function of return data and replace local ACCESS database data; Call more the function of new data and finish upgrading, the deletion legacy data is filled to the available data form to latest data, and the data after will upgrading simultaneously send to database; Connect when obtaining data to the local computer core buffer or replace local ACCESS database data and occur when wrong, disconnecting.
Aforesaid information inquiry step is; Adopt the method for ODBC data bridge, after the condition of having obtained inquiry, call character string query function setfilter (string) and inquire qualified recording storage in internal memory, shine upon on the present user interface of form final body that turns back in this system by internal storage data at local data base LeechdomManage.
Aforesaid information inquiry mode is decided according to type of module, and querying method can return different results with different types according to different modules.
The content of aforesaid information inquiry is; Law-enforcing supervision information, basic unit look into false information, registration is looked into false information, circulated a notice of to look into false information, other information responsible.
Aforesaid Data Update comprises: Chinese Pharmacopoeia, quality publish information, medicine log-on message, laws and regulations information, illegal responsibility information.
Aforesaid query steps is by the medicine log-on message table table in the local LeechdomManage database of ODBC connected reference, this table storage medicine log-on message, use distinctive DataWindow data window in the PowerBuilder database language during connection, directly all content stores in the medicine log-on message table table are mapped in the form of software in internal memory then successively.
Aforesaid information inquiry comprises further that also registration is looked into false and circular is looked into vacation: wherein registering the step of looking into vacation is: the Excel form that imports prescribed form; Selection is looked into and is clicked registration after the false mode and look into vacation; The form data of importing is obtained in circulation; Decompose the Word message that obtains; Between word, insert the inquiry asterisk wildcard " % " of Access approval, and in the log-on message table inquiry this table information, as do not have this information and then be stored in interim form, then return circulation if any this information and obtain the form data step of importing, and enter next law enforcement program.
Wherein circular is looked into false step and is: import the information such as title of certain commodity, select to look into and click circular after the false mode and look into false and vacation is looked in registration, circulate to obtain the form data of importing; Decompose the Word message that obtains; Between word, insert the inquiry asterisk wildcard " % " of Access approval, and inquire about this information at quality communique information table, then be stored in interim form if any this information, as do not have this information then to return circulation to obtain the form data step of importing, and enter next law enforcement program.
Aforesaid information typing step, the information stores of typing sends to database with data simultaneously in the calculator memory of client terminal, and this database is back to internal memory with the result, and the result is mapped to the display of client terminal.
Aforesaid information typing step, the information stores of typing sends to database with data simultaneously in the calculator memory of client terminal, and this database is back to internal memory with the result, and the result is mapped to the display of client terminal.
The present invention compared with prior art has following remarkable advantages and beneficial effect:
A kind of information query method of the present invention, administrative for convenience inspection is handled a case, the realization fast query is cracked down on counterfeit goods, increase work efficiency, master routine is to use database higher level lanquage PowerBuilder, this method forms a kind of new method with new computer program and processor, software cryptography instrument and the ingenious combination of computer network central database.Various functions can isolated operation, also can combined running; The basis that this method realizes is that client terminal links to each other with remote data base, remote data base links to each other with the internet, client terminal can be at any time from the up-to-date information of remote data base down loading updating, simultaneously, the information of client terminal feeds back to remote data base again, decompose through the filtration of database and to carry out the change of data, realized being connected and interaction of client terminal and database, provide important basis law enforcement realization dynamic management according to different catalogues.
Description of drawings
Fig. 1 is the schematic flow sheet of information query method of the present invention;
Fig. 2 is the synoptic diagram of information query method data update module of the present invention;
Fig. 3 is the synoptic diagram of information query method data query module of the present invention;
The schematic flow sheet that Fig. 4 manually upgrades for information query method of the present invention;
Fig. 5 is the schematic flow sheet of information query method online updating of the present invention;
Fig. 6 is the schematic flow sheet of information query method information of the present invention typing;
Fig. 7 looks into false schematic flow sheet for information query method registration of the present invention;
Fig. 8 looks into false schematic flow sheet for information query method circular of the present invention.
Embodiment
Below in conjunction with accompanying drawing specific embodiments of the invention are illustrated:
Below for relating to the explanation of the relevant noun of the present invention and the using method of this function:
1, ODBC:(Open Database Connectivity), promptly open database is interconnected.ODBC is based on SQL (Structured Query Language), and its standard as accessing database.This interface provides mutual operability to greatest extent: an application program can be passed through one group of data base management system (DBMS) that general code access is different.And native system is to connect the data source of local ACCESS database as program by ODBC.
2, between ODBC layer and application program, ADO is " application program " that is positioned on the OLEDB to OLEDB:OLEDB (object linking and embedding database), and ADO calls and is sent to OLEDB earlier, and then transfers to ODBC and handle.
3, LeechdomManage: database is the Access database among the famous office automation product Office of famous software Microsoft company, this database advantage is in the operating system more than the system Windows2000 that Microsoft company produces, do not need to install Office system identification database and can use it automatically.Advantages such as this database belongs to antecedent in toy data base then, has computing fast, and volume is little, and memory space is big are the data source of software so this software adopts the ACCESS database.
4, Chinese Pharmacopoeia: be used to show Chinese all kinds of standard medicinal material information, comprising Chinese medicine, Western medicine, Chinese patent drug etc.The performing step of this function is as follows: show by the Ld_China_Leechdom in the ODBC connected reference LeechdomManage database, the function that returns the pharmacopeia title in the service routine returns pharmacopeia title and content, information all is buffered in the internal memory, is mapped to text filed in the software then.
5, quality is announced inquiry: this function is used to check the quality publish information, by the Ld_artificial table in the local LeechdomManage database of ODBC connected reference, this table storage quality publish information, (a kind of control data window of storing data in the PowerBulider language directly is mapped to all content stores in the Ld_artificial table in the form of software in internal memory then successively to use distinctive DataWindow in the PowerBuilder database language during connection.Also embed query function and manual upgrade function in this function.
6, medicine log-on message: this function is used to check the medicine log-on message, by the medicine log-on message table in the local LeechdomManage database of ODBC connected reference, this table storage medicine log-on message, use distinctive DataWindow data window in the PowerBuilder database language during connection, directly all content stores in the medicine log-on message table are mapped in the form of software in internal memory then successively.Also embed query function and manual upgrade function in this function.
7, inquiry laws and regulations: this function is used to check about laws and regulations concerning the medicine control, by the laws and regulations table in the local LeechdomManage database of ODBC connected reference, this table storage is about laws and regulations concerning the medicine control information, use distinctive DataWindow data window in the PowerBuilder database language during connection, directly all content stores in the laws and regulations table are mapped in the form of software in internal memory then successively.Also embed query function and manual upgrade function in this function, the online upgrading function.
8, inquiry illegal responsibility: this function is used to check the relevant illegal responsibility information about drug control, by the illegal responsibility information table in the local LeechdomManage database of ODBC connected reference, this table storage is about the relevant illegal responsibility information of drug control, use distinctive DataWindow data window in the PowerBuilder database language during connection, directly all content stores in the illegal responsibility information table are mapped in the form of software in internal memory then successively.Also embed query function and manual upgrade function in this function, the online upgrading function.
9, management counterpart information: the effect of this function is the relevant counterpart's of storage a information, counterpart's organization for example, unit address, responsible official's name etc.The performing step of this function has made full use of the advantage of PowerBuilder database language, exchange between fulfillment database data and this software, the advantage of this function is that data access speed is fast, and the functional based method that safety is returned all information returns all relative recordings.The data of this function all come to import to the user.This function also embeds upload function, modify feature, and delete function is added informational function.
10, the typing of law-enforcing supervision information: this function is checked and supervised the result for preservation and is realized, this function breaks through the pattern of conventional manual input checking supervision message, with the input that uses a computer of all information, all input clauses all combine the standard and the convention of the department of checking and supervising, industry personnel situation for example, the medicine equipment situation, medicine is checked situation, these contents are stored in the medicine thing inspection situation summary sheet among the local data base LeechdomManage again respectively, consensus sequence QueryAutomatismId by these several tables links up these tables, can be associated with other data thereby reach data of visit.
11, basic unit looks into vacation: this function realizes for checking no file medicine, this function can go out the medicine true and false by trial inspection by the input medicine information, for example import drug batch number and nomenclature of drug, can be at very short time class return results, whether the result is for being true and false medicine.The mechanism that this function realizes is: with the medicine information of user's input by the ODBC data bridge in local data base LeechdomManage the adulterated drug information table or standard medicine information table in search for, this is recorded as fake and forged medicine so if search out the result at Ld_artificial adulterated drug information table.If in Ld_Login_Leccdom standard medicine information table, search out the result so this medicine for registering medicine.The result who searches out all can be stored in the local computer internal memory temporarily, and maps to the temporary storage table lattice that software interface provides for the user.
Administrative for convenience inspection is handled a case, the realization fast query is cracked down on counterfeit goods, increase work efficiency, master routine is to use database higher level lanquage PowerBuilder, this method forms a kind of new method with new computer program and processor, software cryptography instrument and the ingenious combination of computer network central database.
See also shown in Figure 1ly, be the schematic flow sheet of information query method of the present invention; As can be seen from the figure: 1 is client terminal, and 2 is database, and 3 is the internet that is connected with database.
A kind of information query method comprises:
Data Update step: selecteed file in the above-mentioned database is read to internal memory, by circulation with resolve and it is stored in the corresponding system data form deletion legacy data in the time of storage;
Information inquiry step: adopt the ODBC data to connect the bridge bridge, after the condition of having obtained inquiry, call character string and inquire qualified recording storage in internal memory, shine upon by internal storage data on the present user interface of form final body that turns back in this system;
Information typing step: comprise information correction, information deletion, information interpolation; Wherein:
Information correction: use the ODBC data to connect bridge, selection by the user saves as user input data with corresponding data in the local data base, for the function that obtains sequence number obtains the function that the sequence number of wanting amendment record is revised data, revise the record of regulation sequence number, and
Directly and data association, the result of modification will directly be saved to database, and cover original information;
Information deletion: use the ODBC data to connect bridge, the selection by the user is with corresponding data deletion in the local data base, and this function is irreversible, the method that uses is for obtaining the function of recording mechanism, obtain the sequence number of wanting deletion record, the function of deletion record, the record of deletion regulation sequence number; Information in the delete database, this deletion is irrelevant with internal memory;
Information is added: the data of interpolation come from the information of user's input, use the ODBC data to connect bridge, at first obtain after the user data, be buffered in the internal memory, be stored in the functional based method that is used to add record in the database in the interpolation process then by data verification;
The upload file step: local data is uploaded to database, and the data that will obtain local data base connect data transmission to the central server database by network then to internal memory earlier;
Import the file step: orderly file is directed into the current computer internal memory, map to computer screen, or be saved to current database, with selecting good data, with xls .txt, .xml, .csv, the ..dbf form is stored in the calculator memory automatically by the form of this document, arranges and temporarily leaves in the DataWindow data-carrier store that has set according to the Format Series Lines of data in the file.
See also shown in Figure 2, the synoptic diagram of information query method data update module of the present invention.As can be seen from the figure, this update module 11 comprises: Chinese Pharmacopoeia 111, quality publish information 112, medicine log-on message 113, laws and regulations information 114, illegal responsibility information 115.
See also shown in Figure 3, the synoptic diagram of information query method data query module of the present invention.As can be seen from the figure, this data query module 12 comprises: law-enforcing supervision information 121, basic unit look into false information 122, registration is looked into false information 123, circulated a notice of to look into false information 124, other information responsible 125.
The information inquiry step is; Adopt the method for ODBC data bridge, after the condition of having obtained inquiry, call character string query function setfilter (string) and inquire qualified recording storage in internal memory, shine upon on the present user interface of form final body that turns back in this system by internal storage data at local data base LeechdomManage.
The information inquiry mode is decided according to type of module, and querying method can return different results with different types according to different modules.
See also shown in Figure 4, the schematic flow sheet that information query method of the present invention manually upgrades.
Manually upgrade to one of characteristics of this software, manually the method for upgrading is: from the file of server site download and upgrade, this upgrade file is the distinctive file layout PRS formatted file 1101 of PowerBuilder database, and this document form is a statement form, the storage literal.Have only this software can read the content of this file, because character arranging in this document and literal storage mode conform to this software, for example the title in the file in download is ld_title, the title of these software storage data also is ld_title, software searches out corresponding clauses and subclauses 1102 by the character mapping of internal memory in the swap data, exchanges successively.File in download finishes, in the corresponding function of software, select manually upgrading, the dialog box of a select File will be pointed out by system, choose after the downloaded files by dialog box, this system can read to internal memory with the content in the file automatically, by circulation and parsing all Word messages are stored in the corresponding system data form then, keep up-to-date data 1104.Can delete legacy data 1103 in the time of storage, thereby end data exchange 1105, data after will exchanging simultaneously are sent to database 2, in the process of the original clauses and subclauses of deletion and content 1103, maintenance latest data 1104 and end data exchange 1105, any mistake wherein takes place, and this program will be returned 1101 and select PRS.
See also shown in Figure 5ly, be the schematic flow sheet of information query method online updating of the present invention.As can be seen from the figure,
Online upgrading provides the mechanism of a network data exchange for software.Having under the situation of network, software connects the effect that reaches a data exchange by OLEDB remote data base 2.What system database 1121 adopted is that SQL SERVER 2005 these databases that famous software Microsoft company produces are large database, provides the remote data base exchange message, mass storage data, the function of fast resolving data.The user is having under the situation that network connects and central server is open and can exchange upgrading local data information by network data.
At first pass through the position of URL location database, connect by the OLEDB data, shown in 1121, local computer and remote data base 2 are coupled together, judge the title and the corresponding table 1122 of upgrading module,, the content of calling obtained upgrade to local computer core buffer 1123 by calling the function that obtains table, call the function of return data and replace local ACCESS database data 1124, call the more function of new data, finish data 1125, with the data return data storehouse 2 after the upgrading.Wherein, when obtaining the function that upgrades to local computer core buffer 1123 and call return data and replacing local ACCESS database data 1124, mistake occurs and will disconnect connection 1126.To delete legacy data then, latest data will be filled to the available data form.
By operating with upper type, the form of storage Chinese Pharmacopoeia is Ld_China_Leechdom in for example local LeechdomManage database, the user is this software when the Chinese Pharmacopoeia space of a whole page is selected online upgrading, can judge the content of the content choice remote data base of the space of a whole page, the form of storage Chinese Pharmacopoeia is Ld_China_Leechdom_System in the remote data base, this moment, software searched out this form automatically by code, connect and the judgement local computer that finishes will be stored in data in the local internal memory earlier temporarily, storage finishes to disconnect and connects, to delete legacy data then, latest data will be filled to the available data form:
See also Fig. 1 and shown in Figure 6, be the schematic flow sheet of information query method information of the present invention typing.As can be seen from the figure, the information typing comprises: information correction, information deletion, information are added.The information 13 of information typing sends to local computer internal memory 131, information is sent to database 2 again, and database 2 turns back to internal memory 131 with information, simultaneously, its information mapping is arrived display 15; Wherein:
Information correction: use the ODBC data to connect bridge, selection by the user saves as user input data with corresponding data in the local data base, for the function that obtains sequence number obtains the function that the sequence number of wanting amendment record is revised data, revise the record of regulation sequence number, and direct and data association, the result who revises will directly be saved to database, and cover original information;
Information deletion: use the ODBC data to connect bridge, the selection by the user is with corresponding data deletion in the local data base, and this function is irreversible, the method that uses is for obtaining the function of recording mechanism, obtain the sequence number of wanting deletion record, the function of deletion record, the record of deletion regulation sequence number; Information in the delete database, this deletion is irrelevant with internal memory;
Information is added: this function is used for interpolation information, and the data of interpolation come from the information of user's input.The mechanism that this function realizes connects bridge for using the ODBC data, at first obtains after the user data, is buffered in the internal memory by data verification, is stored in the database then.Use inserintodata (string) (being used to add the function of record) method in the interpolation process.
Below, on the basis of Data Update, look into false method of operating by the specific embodiment explanation.
See also shown in Figure 7, for false schematic flow sheet is looked in information query method of the present invention registration.
This function realizes for inspection has the file medicine information, this function can be checked medicine information in batches, checks the true and false of medicine according to importing fileinfo, and preserves check result automatically, this function under the good situation of computing power and the time allow, in theory can endless identification medicine information:
Begin registration and look into false 1231, at first import the Excel form 1232 of prescribed form, selection is looked into and is clicked registration after the false mode and look into false 1233, circulation is obtained and is imported non-form data 1234, decompose the Word message 1235 that obtains, between word, insert the inquiry asterisk wildcard " % " of Access approval, in registration table, inquire about this information 1237 simultaneously, judged whether this information 1238, if do not have this information with this information stores at interim form 1230, if this information is arranged, turn back to circulation and obtain the non-form data 1234 of importing, enter next law enforcement program 1239 simultaneously.
See also shown in Figure 8, for information query method of the present invention circular is looked into false schematic flow sheet.
Circular is looked into false flow process; This function realizes that for inspection has the file medicine information this function can be checked medicine information in batches, checks the true and false of medicine according to importing fileinfo, and preserves check result automatically, checks to endless batch inspection medicine information from independent medicine.It is the office automation function that realization is badly in need of in a medicine supervision department.And this function improves a lot on the text query in identification, and it is false machine-processed identical that the using method of this function and registration are looked into, and no longer is described in detail at this.
Utilize said method, can also be uploaded to database, relating in the existing local data base that obtains, will be referred to transfer to central database by the network connection then to internal memory to this locality is related to.
Import the file step: orderly file is directed into the current computer internal memory, map to computer screen, or be saved to current database, with selecting good data, with xls .txt, .xml, .csv, the ..dbf form is stored in the calculator memory automatically by the form of this document, arranges and temporarily leaves in the DataWindow data-carrier store that has set according to the Format Series Lines of data in the file.
It should be noted that at last: above embodiment is only in order to the explanation the present invention of the law enforcement aspect of medicine and unrestricted technical scheme described in the invention; This method is applicable to any other merchandise news inquiry and enforcing law.Therefore, although this instructions has been described in detail the present invention with reference to each above-mentioned embodiment,, those of ordinary skill in the art should be appreciated that still and can make amendment or be equal to replacement the present invention; And all do not break away from the technical scheme and the improvement thereof of the spirit and scope of invention, and it all should be encompassed in the middle of the claim scope of the present invention.
Claims (10)
1, a kind of information query method connects database based on user terminal with wireless transmission method, and database is connected with Internet; It is characterized in that: comprising:
Data Update step: selecteed file in the above-mentioned database is read to internal memory, by circulation with resolve and it is stored in the corresponding system data form deletion legacy data in the time of storage;
Information inquiry step: adopt the ODBC data to connect the bridge bridge, after the condition of having obtained inquiry, call character string and inquire qualified recording storage in internal memory, shine upon by internal storage data on the present user interface of form final body that turns back in this system;
Information typing step: comprise information correction, information deletion, information interpolation; Wherein:
Information correction: use the ODBC data to connect bridge, selection by the user saves as user input data with corresponding data in the local data base, for the function that obtains sequence number obtains the function that the sequence number of wanting amendment record is revised data, revise the record of regulation sequence number, and
Directly and data association, the result of modification will directly be saved to database, and cover original information;
Information deletion: use the ODBC data to connect bridge, the selection by the user is with corresponding data deletion in the local data base, and this function is irreversible, the method that uses is for obtaining the function of recording mechanism, obtain the sequence number of wanting deletion record, the function of deletion record, the record of deletion regulation sequence number; Information in the delete database, this deletion is irrelevant with internal memory;
Information is added: the data of interpolation come from the information of user's input, use the ODBC data to connect bridge, at first obtain after the user data, be buffered in the internal memory, be stored in the functional based method that is used to add record in the database in the interpolation process then by data verification;
The upload file step: local data is uploaded to database, and the data that will obtain local data base connect data transmission to the central server database by network then to internal memory earlier;
Import the file step: orderly file is directed into the current computer internal memory, map to computer screen, or be saved to current database, with selecting good data, with xls .txt, .xml, .csv, the ..dbf form is stored in the calculator memory automatically by the form of this document, arranges and temporarily leaves in the DataWindow data-carrier store that has set according to the Format Series Lines of data in the file.
2, information query method according to claim 1 is characterized in that: described Data Update step is for manually upgrading;
Its method is: select to download the distinctive file layout Prs formatted file of PowerBuilder database from database; Resolution file, obtain the file logging clauses and subclauses; Existing clauses and subclauses of deletion and content; Keep up-to-date data; The end data exchange; Deletion legacy data in the time of storage; Data after the exchange are back to database; Any mistake wherein takes place in above process, returns again and selects Prs formatted file step.
3, information query method according to claim 1 is characterized in that: described Data Update step is an online updating;
Its method is: by SQL SERVER 2005 databases of a Microsoft of OLEDB remote data base connection, judge the title and the corresponding table of upgrading module; Obtain data to the local computer core buffer by calling the function that obtains table; Call the function of return data and replace local ACCESS database data; Call more the function of new data and finish upgrading, the deletion legacy data is filled to the available data form to latest data, and the data after will upgrading simultaneously send to database; Connect when obtaining data to the local computer core buffer or replace local ACCESS database data and occur when wrong, disconnecting.
4, information query method according to claim 1 is characterized in that: described information inquiry step is; Adopt the method for ODBC data bridge, after the condition of having obtained inquiry, call character string query function setfilter (string) and inquire qualified recording storage in internal memory, shine upon on the present user interface of form final body that turns back in this system by internal storage data at local data base LeechdomManage.
5, information query method according to claim 4 is characterized in that: described information inquiry mode is decided according to type of module, and querying method can return different results with different types according to different modules.
6, information query method according to claim 1 is characterized in that: the content of described information inquiry comprises; Law-enforcing supervision information, basic unit look into false information, registration is looked into false information, circulated a notice of to look into false information, other information responsible.
7, information query method according to claim 1 is characterized in that: described Data Update comprises: Chinese Pharmacopoeia, quality publish information, medicine log-on message, laws and regulations information, illegal responsibility information.
8, information query method according to claim 6 is characterized in that: described query steps; By the medicine log-on message table table in the local LeechdomManage database of ODBC connected reference, this table storage medicine log-on message, use distinctive DataWindow data window in the PowerBuilder database language during connection, directly all content stores in the medicine log-on message table table are mapped in the form of software in internal memory then successively.
9, information query method according to claim 1 is characterized in that: described information inquiry comprises further that also registration is looked into false and circular is looked into vacation: wherein registering the step of looking into vacation is: the Excel form that imports prescribed form; Selection is looked into and is clicked registration after the false mode and look into vacation; The form data of importing is obtained in circulation; Decompose the Word message that obtains; Between word, insert the inquiry asterisk wildcard " % " of Access approval, and in the log-on message table this table information of inquiry, as do not have this information and then be stored in interim form, then return circulation if any this information and obtain the form data step of importing, and
Enter next law enforcement program.
Wherein circular is looked into false step and is: import the information such as title of certain commodity, select to look into and click circular after the false mode and look into false and vacation is looked in registration, circulate to obtain the form data of importing; Decompose the Word message that obtains; Between word, insert the inquiry asterisk wildcard " % " of Access approval, and inquire about this information, then be stored in interim form, as do not have this information then to return circulation to obtain the form data step of importing if any this information at quality communique information table, and
Enter next law enforcement program.
10, information query method according to claim 1, it is characterized in that: described information typing step, the information stores of typing is in the calculator memory of client terminal, simultaneously data are sent to database, this database is back to internal memory with the result, and the result is mapped to the display of client terminal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2006101279597A CN1949216A (en) | 2006-09-05 | 2006-09-05 | Information searching method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2006101279597A CN1949216A (en) | 2006-09-05 | 2006-09-05 | Information searching method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1949216A true CN1949216A (en) | 2007-04-18 |
Family
ID=38018734
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2006101279597A Pending CN1949216A (en) | 2006-09-05 | 2006-09-05 | Information searching method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1949216A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916290A (en) * | 2010-08-18 | 2010-12-15 | 中兴通讯股份有限公司 | Managing method of internal memory database and device |
| CN102467562A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件（中国）有限公司 | Computer document input method and system |
| CN102499758A (en) * | 2011-10-18 | 2012-06-20 | 浙江大学 | Physiological information network tracking method and system |
| CN102916985A (en) * | 2011-08-02 | 2013-02-06 | 天津中启创科技有限公司 | Method for operating data acquisition and management system |
| CN103995898A (en) * | 2014-06-06 | 2014-08-20 | 北京易谱耐特科技有限公司 | Method and device for obtaining product specification information |
| CN104573104A (en) * | 2015-01-30 | 2015-04-29 | 杭州云灵科技有限公司 | Information entering method and information entering system |
| CN104866571A (en) * | 2015-05-22 | 2015-08-26 | 国云科技股份有限公司 | Method for implementing sequence in SQL Server |
| CN104866481A (en) * | 2014-02-21 | 2015-08-26 | 广东产品质量监督检验研究院 | Product monitoring-sampling-bill printing software system |
| CN108241758A (en) * | 2018-03-21 | 2018-07-03 | 广州华多网络科技有限公司 | Data query method and relevant device |
-
2006
- 2006-09-05 CN CNA2006101279597A patent/CN1949216A/en active Pending
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916290A (en) * | 2010-08-18 | 2010-12-15 | 中兴通讯股份有限公司 | Managing method of internal memory database and device |
| CN101916290B (en) * | 2010-08-18 | 2014-12-10 | 中兴通讯股份有限公司 | Managing method of internal memory database and device |
| CN102467562A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件（中国）有限公司 | Computer document input method and system |
| CN102916985A (en) * | 2011-08-02 | 2013-02-06 | 天津中启创科技有限公司 | Method for operating data acquisition and management system |
| CN102499758A (en) * | 2011-10-18 | 2012-06-20 | 浙江大学 | Physiological information network tracking method and system |
| CN104866481A (en) * | 2014-02-21 | 2015-08-26 | 广东产品质量监督检验研究院 | Product monitoring-sampling-bill printing software system |
| CN103995898A (en) * | 2014-06-06 | 2014-08-20 | 北京易谱耐特科技有限公司 | Method and device for obtaining product specification information |
| CN103995898B (en) * | 2014-06-06 | 2017-05-24 | 北京易谱精灵电子商务有限公司 | Method and device for obtaining product specification information |
| CN104573104A (en) * | 2015-01-30 | 2015-04-29 | 杭州云灵科技有限公司 | Information entering method and information entering system |
| CN104866571A (en) * | 2015-05-22 | 2015-08-26 | 国云科技股份有限公司 | Method for implementing sequence in SQL Server |
| CN108241758A (en) * | 2018-03-21 | 2018-07-03 | 广州华多网络科技有限公司 | Data query method and relevant device |
| CN108241758B (en) * | 2018-03-21 | 2021-05-11 | 广州华多网络科技有限公司 | Data query method and related equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1949216A (en) | Information searching method | |
| US20120089612A1 (en) | Flexible fully integrated real-time document indexing | |
| CN1761962A (en) | Real-time aggregation of unstructured data into structured data for SQL processing by a relational database engine | |
| US7406477B2 (en) | Database system with methodology for automated determination and selection of optimal indexes | |
| US10417611B2 (en) | Methods and systems for providing multiple column custom indexes in a multi-tenant database environment | |
| US20070192374A1 (en) | Virtual repository management to provide functionality | |
| US20110296397A1 (en) | Systems and methods for generating cached representations of host package inventories in remote package repositories | |
| US20140337287A1 (en) | Virtual repository management | |
| US7860857B2 (en) | Digital data processing apparatus and methods for improving plant performance | |
| CN101040280A (en) | Metadata management | |
| CN1685312A (en) | Registry driven interoperability and exchange of documents | |
| KR20060045622A (en) | Extraction, transformation and loading designer module of a computerized financial system | |
| CN101067814A (en) | Mapping conversion method between data access level Xml format data and relational data | |
| CN1755683A (en) | Contextual action publishing | |
| CN1609859A (en) | Search result clustering method | |
| CN1705945A (en) | Global query correlation attributes | |
| CN101079124A (en) | Method for converting enterprise information to electronic media and sequencing according to trade | |
| WO2011145922A1 (en) | Method and system for compiling a unique sample code for specific web content | |
| CN1716249A (en) | System and method for delayed fetching of designated members of a user defined type | |
| CN1877583A (en) | Accessing identification index system and accessing identification index library generation method | |
| CN1932816A (en) | Full text search system based on ciphertext | |
| CN1673972A (en) | Dynamic monitoring system and method for data base list update | |
| CN1561496A (en) | An efficient index structure to access hierarchical data in a relational database system | |
| CN1848851A (en) | Computer and method for establishing light weight catalog access data protocol exchange format fragment | |
| CN102117318A (en) | Data processing method of enterprise informatization system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |