CN110781186B - Method for realizing software interface read-write data table - Google Patents
Method for realizing software interface read-write data table Download PDFInfo
- Publication number
- CN110781186B CN110781186B CN201910986049.1A CN201910986049A CN110781186B CN 110781186 B CN110781186 B CN 110781186B CN 201910986049 A CN201910986049 A CN 201910986049A CN 110781186 B CN110781186 B CN 110781186B
- Authority
- CN
- China
- Prior art keywords
- database
- control
- field
- data
- controls
- 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.)
- Active
Links
Images
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- 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
Abstract
The invention relates to a method for realizing the reading and writing of a database by a software interface, which comprises the steps of firstly arranging the interface according to the existing database, and then obtaining all field names and field type lists of a specified database table; assigning a label control by adopting a polling mode according to the acquired field name list and the label attribute, traversing the field content control, and assigning the control according to the control type and the row and column number; when a display record command is obtained, displaying a certain line of data obtained through database statements in a control polling mode; and when the storage command is obtained, updating or creating the database, judging whether the database is updated or created repeatedly according to the index, generating a data statement by adopting a control polling mode, and writing the data into the database. The invention realizes the conversion from the database to the interface by adopting the method of defining the control attribute association database, overcomes the complexity of the conventional interface design, and can supplement the class library function to realize the expansion according to the special requirements of the user.
Description
Technical Field
The invention relates to a method for realizing a software interface read-write database. Belongs to the technical field of software engineering.
Background
The database is a set of information sets with structural characteristics, and is convenient for people to manage or retrieve organized and structured data. The database can maintain a large amount of data, quickly search the needed data, save a large amount of manpower and facilitate real-time updating, so the method has wide application in various industries. Common databases include ACCESS, SQLSever, ORACLE and the like, programmers can design the databases by using various development languages, and in the conventional interface design, all fields in a certain table in the database are displayed in an interface, including field names and data of a certain row, the field names are generally represented by label controls, and the label controls are required to be defined by the control names and control attributes; for data corresponding to the field names, a text box control, a drop-down box control, a date control, an image control, and the like need to be used for editing or displaying, and the control names and control attributes need to be defined for the controls. It can be seen that this design can also be tolerated for small non-relational databases, but the interface design is very time consuming when there are many fields in a table and a control needs to call up data about another table.
Disclosure of Invention
The technical problem to be solved by the present invention is to provide a low-consumption compact feed network with compact structure, light weight and high reliability, which can realize a broadband with any tap distance in a very small space.
The technical scheme adopted by the invention for solving the problems is as follows: a method for realizing reading and writing of a database by a software interface comprises the steps of firstly arranging an interface according to the existing database, orderly placing label controls and field content controls in a container control, regularly defining Tag attributes of the controls in the container, then obtaining all field names and field type lists of a specified database table, assigning values to the label controls by the field names, and processing data when the field types are used for displaying or submitting data; assigning the label control in a polling mode according to the acquired field name list and the Tag attribute of the label control, traversing the field content control, judging the type of the control, obtaining the column number and the row number of the data table according to the Tag attribute of the control, and assigning the control according to the type and the column number and the row number of the control; when a display record command is obtained, analyzing Tag attributes of all controls in the container control and displaying the Tag attributes in association with the data table by adopting a control polling mode to obtain a certain line of data through database statements; and when a storage command is obtained, updating or creating the database, judging whether the database is updated or created repeatedly by the index, analyzing Tag attributes of all controls in the container control and associating the Tag attributes with the data table to generate data statements by adopting a control polling mode, and writing the data into the database.
Preferably, when the interface is arranged, firstly, a container control is placed on the interface, label controls are placed in the container control in order according to field definitions of a certain table of the database, and corresponding field content controls are placed according to field types corresponding to the label controls; after the controls are adjusted, defining Tag attributes of all the controls in a format of XXT-BB-CC, wherein XX represents a field serial number of a database table, the necessary definition exists, the range is 01-99, and the field definition of the database table can be met; t is an abbreviation of field data type, is not necessarily defined, and is only required to be defined when the type conversion is required; BB is a database table name needing to be associated, is not necessarily defined, and is only required to be defined when association is needed; the CC is a database table field name needing to be associated, is not necessarily defined, and is only required to be associated.
Preferably, the method includes performing a loop for the string processing function with the separator, specifically including performing a loop according to the length of the string, assigning the string before the separator to the variable if the character is the separator, exiting the loop to obtain the variable, and performing a loop according to the length of the string, assigning the string after the separator to the variable if the character is the separator, exiting the loop, and returning the variable.
Preferably, before the field content control is assigned, traversing the field content control of the interface, judging that the control is of a drop-down box control type, judging that Tag attributes of the control have database association, obtaining a table name and a field name by using a character string processing module to obtain a data set object, and temporarily storing the value of the drop-down box control according to the information content of the data set object so as to be used when the field content control is assigned.
Preferably, when the storage command is obtained, processing is performed according to two modes of modification and addition according to the existence of the field content, records with the field content equal to the specified field are found for modification during modification, all database fields are respectively assigned according to a mode of traversing the control by the device during addition, and then the database is inserted.
Compared with the prior art, the invention has the advantages that:
1) the method of the invention overcomes the complexity of the conventional interface design, the conventional database software design generally provides display and operation for a certain table in the database by using one interface, a designer sets the Text attribute representation for the field name in the table by using the label control, and the label control of the invention can automatically read the field name of the table for display; when displaying certain row of data in the table, assigning values to the interface control statements according to the data types by adopting corresponding field names, if the field names have 100, assigning values can be completed by at least 100 statements, and the invention can be completed by one statement; when data writing operation is performed, generally, each field is assigned according to the control content and the corresponding field name, if the field names are 100, assignment can be completed by at least 100 statements, and the invention can be completed by one statement.
2) The method designed by the invention can supplement the class library function to realize extension according to the special requirements of the user.
Drawings
FIG. 1 is a software design interface of an embodiment of the present invention.
FIG. 2 is a software running interface of the example of FIG. 1.
FIG. 3 is a software display data logging interface of the example of FIG. 1.
FIG. 4 is a software submission data interface of the example of FIG. 1.
Detailed Description
The invention is described in further detail below with reference to the accompanying examples.
As shown in fig. 1, in the implementation method for reading and writing the SQL database by the software interface in this embodiment, the function is to implement interface design and database operation by associating the database table with the interface control, and the specific process is as follows:
1 arranging the interface
Placing a container control, such as a Panel control, in an interface, and sequentially placing Label controls for displaying field names of tables according to field definitions of a certain table in a database; selecting and placing a corresponding textBox TextBox control according to the field type definition corresponding to the label control, wherein the TextBox control is used for displaying the character string type, the floating point type and the integer field content in the table; the Combobox selection box control is used for displaying the content of other relevant fields needing to be associated; the DateTimePicker date control is used for displaying the time type data in the table; a PictureBox image control for displaying the picture type data; a CheckBox selection box control for displaying boolean type data, among other types of controls.
After the controls are adjusted, defining Tag attributes of all the controls in a format of XXT-BB-CC, wherein XX represents a field serial number of a database table, the necessary definition exists, the range is 01-99, and the field definition of the database table can be met; t is an abbreviation of field data type, is not necessarily defined, and is only required to be defined when the type conversion is required; BB is a database table name needing to be associated, is not necessarily defined, and is only required to be defined when association is needed; the CC is a database table field name needing to be associated, is not necessarily defined, and is only required to be defined when the association is needed, for example, the Label control is only defined as '01', and the Combox control is correspondingly defined as '06V-cultural degree'.
2. Design class implementation association
Designing a self-defining class which comprises SQL database processing functions, character string processing functions, polling display functions, data submission functions and auxiliary functions such as type conversion functions. The method specifically comprises the following steps:
1) the database connection function public static SqlConnection getcon (), which is a database entry function, must pass through to access the database. Connecting the SqlConnection object with a specified database according to SQL statements, returning the information of the SqlConnection object, wherein the SqlConnection object has the functions of connecting the specified database and returning the SqlConnection object information, and the specific flow is as follows: connecting the SqlConnection function with a specified database, and returning to the SqlConnection class; opening a specified database by using an open function; the entire function returns the SqlConnection object information.
2) The database shutdown function public static void con _ close (), which is a database export function, must pass through to disconnect a connected database. The SQL sentence is used for closing the designated database and releasing the resources, the function of the SQL sentence is to close the connected database, and the specific flow is as follows: and if the database is judged to be in the connection state, closing operation is carried out, and the space is released.
3) A read data table information function public static SqlDataReader getcom (string SQLstr) is a function for reading related table information of a database, an input is an SQL statement, a specified SQL statement is executed, and an SqlDataReader object is returned, wherein the function of the SqlDataReader object information of a certain table of a specified database is obtained, and the specific flow is as follows: and opening the connection with the database, creating a SqlCommand object, inputting an SQL specified command, and returning the information of the SqlDataReader object after the execution.
4) Executing SQLCommand function public static SqlDataReader getcom (string SQLstr), which is a function for executing SQL commands, inputs SQL statements and executes the SQL statements, the function of the SQL statements is to execute the SQL commands, and the specific flow is as follows: and opening the connection with the database, creating an SqlCommand object for executing the SQL statement, releasing the space, and disconnecting the connection.
5) Creating a DataSet object function public static DataSet getDataSet (string SQLstr, string tableName), which is a DataSet data set creating function, inputting a SQL statement and a table name of a database, obtaining a data set DataSet through the SQL statement and the table name, wherein the DataSet has the function of obtaining a DataSet of a certain table of the database, and the specific process is as follows: opening the connection with the database, creating a SqlDataAdap object, acquiring the information of the specified data table, creating a DataSet object, adding the data table information into the DataSet object through a Fill () method of the SqlDataAdap object, closing the connection of the database, and returning to the DataSet object.
6) Taking a public static string [ ] GetTableFieldNaAMELList (string TableName) of all field name functions of a specified table, which is a function for obtaining the field name of a certain table in a database, inputting the name of a certain table in the database, obtaining the names of all fields of the table through the table name, outputting the names as a name list, wherein the function is to obtain the field name to be assigned to an interface label space, and the specific flow is as follows: and executing the SQL name sentence to generate a SqlDataReader object to obtain the sequence number of the SqlDataReader, initializing the list, circularly generating the name list, returning the list, and closing the connection of the database.
7) Taking a function public static string [ ] GetTableFieldtTypeList (string TableName) of all field types of a specified table, wherein the function is a function for obtaining the field type of a certain table in a database, inputting the function as the name of the certain table in the database, obtaining the types of all fields of the table through the table name, outputting the table as a type list, and the function of the function is to obtain the type elements needing to be converted with the display type of an interface control, and the specific flow is as follows: executing SQL (structured query language) name sentences to generate SqlDataReader objects, obtaining the sequence number of the SqlDataReader, initializing the list, circularly generating a type list, returning the list, and closing the connection of the database.
8) Obtaining a type abbreviation function public static string GetType _ ab _ str (String Str), which is a function for abbreviating a complete type, inputting a full name character string of the type, and outputting a type character string for all field abbreviations of a table, such as "datetime" for type abbreviation "D"; the function is an abbreviation type to facilitate programming, and the specific flow is as follows: using switch statement processing judgment, the return abbreviation type is defined.
9) A String processing function for obtaining a String public static String GetSeq _ Pre _ Str (String Str, String seq) before a delimiter of a String, which is a processing function with a fixed delimiter String, inputs a delimiter between a String to be processed and the String, outputs a String on the left side of the first delimiter of the String, and is used for processing a Tag attribute of a control to obtain useful information, for example, the String _ Pre _ Str ("1, 2, 3", ",") is input to obtain "1", and the function of the String before the delimiter is obtained, the specific flow is as follows: and circulating according to the length of the character string, if the character is a separator, assigning the character string before the separator to a variable, exiting the circulation and returning to the variable.
10) Obtaining a character String public static String GetNext _ Pre _ Str (String Str, String seq) after a separator of a character String, which is a processing function for a character String with a fixed separator, inputting a separator between a character String to be processed and the character String, outputting a character String on the right side of the first separator of the character String, and processing a Tag attribute of a control to obtain useful information, for example, inputting GetNext _ Pre _ Str ("1, 2, 3", ",") to obtain "2, 3", and the function of obtaining the character String after the separator is specifically as follows: and circulating according to the length of the character string, if the character is a separator, assigning the character string behind the separator to a variable, exiting circulation and returning to the variable.
11) Setting a Label Control attribute function public static void set Label Text (Control. Control Collection ctc, string [ ] st) in a container, inputting the Label Control attribute function into a container Control class and a field name list, assigning the Label Control Text attribute in the container by adopting a polling mode according to the field name list, and assigning the fields of a database to the Label Control, wherein the specific process is as follows: and traversing the control in the container, judging that the control is of the Label type, and obtaining the field name of the field list according to the integer value of the Label tag attribute.
11) Setting a value function public static void set Combo xText (Control. Control Collection ctc, string str) of a combox filled in a container for data needing database association, wherein the value function public static void set Combo xText is a function for adding a drop-down box Control, the input of the function is a container Control class and a table name/field name character string, the table name/field name is obtained by a character string processing function and assigns values to items attributes of the Combo box Control, the function is to assign contents with database association to the Combo box Control for convenient writing operation, and the specific flow is as follows: traversing the control in the container, judging that the control is of ComboBox type,
judging that tag attributes of the ComboBox control are associated with a database, using 9) and 10) functions to obtain a table name and a field name to obtain a DataSet object, and adding the Items attributes of the ComboBox control according to the information content of the DataSet object.
12) Setting a related display Control value function public static void SetControlText (Control. ControlCollection ctc, string SQLstr, string tableName, int N) in a container, wherein the function is a function for assigning the related function in an interface container, is input as a container Control class, an SQL command statement, a database table name and a record number, responds to display the data content corresponding to the record number on an interface, and has the function of assigning the interface Control to a certain record in a certain table of the database according to the type, and the specific flow is as follows: and traversing the controls in the container, judging the types of the controls, obtaining the column numbers and the N line numbers of the data table according to the tag attributes, and assigning the controls according to the types and the column numbers of the controls.
13) Clearing a related display Control value function public static void clean Control text (Control. Control collection ctc) in the container, wherein the function is a function for clearing Control content, the input is a container Control class, the related Control content is cleared by a method for traversing the Control in the container, the function is to clear the Control content, and the specific flow is as follows: and traversing the controls in the container, judging the types of the controls, and clearing the display contents of the controls according to the types.
14) Converting a picture into a byte array function public static void Read _ image (PictureBox my image), which is to convert picture information into a binary function, input the binary function as the image of a pictebox control, convert the called picture so as to be convenient for storage in a database, and convert the picture format into the database storable information, wherein the specific flow is as follows: and selecting pictures through the browsing frame to generate a file stream, and writing the file stream into the byte array.
15) Storing the pictures into a database function public static void SaveImage (string SQLstr, string str, byte [ ] p), which is to store binary picture information into the database function, input as SQL command, @ Photoid characters and byte arrays, and store the byte arrays obtained from Read _ Image into the table fields of the specified database, wherein the function is to store the pictures into the database according to the bytes, and the specific flow is as follows: and generating an SQL command through the StringBuilder object, establishing an SqlCommand class, executing a byte data storage instruction, and closing the database.
16) Submitting a data function public static void Part _ SaveClass (Control. Control Collection Contr, string TableName, string KeyStr, string KeyWord), writing interface Control content into a database function, inputting the interface Control content into a container Control class, field content and a specified field, writing Control values in the container into a database in an updating or newly-built mode according to indexes, wherein the function of the database is to write the content of the interface Control after being changed into the database, and the specific flow is as follows: and processing according to two modes of modification and addition according to the existence of the field content, finding records with the same field content and specified field for modification during modification, respectively assigning values to all database fields according to a mode of traversing controls by a device during addition, and then inserting.
3. Main program calling class realizing display and submission
In the initialization of the main interface, a GetTableFielddName List function and a GetTableFielddTypeList function are called to obtain a field name and a field type list of a database table, the field name is used for assigning values to a Label control, and the field type is used for carrying out data processing when data are displayed or submitted; calling a SetLabelText function to assign values to the Text attributes of the Label controls, wherein the value is the content of the XX of the Tag attribute at the position of the field name list, calling a SetComboxText function to assign values to the Combobox controls needing to be associated with other table field contents, traversing all data of the Tag attributes with the data table name of BB and the field name of CC, and assigning the values to the items attributes of the Combobox controls; when a display record command is obtained, calling a SetControlText function to carry out assignment display on related controls in the container, and displaying a certain line of data obtained through an SQL statement in a control polling mode; when a storage command is obtained, calling a Part _ SaveClass function to update or create the database, judging whether the database is updated or created repeatedly according to whether the index is repeated, generating an SQL statement by adopting a control polling mode, and writing data into the database.
Example (c):
1 database design
An SQL database is designed and named as CS, and 9 tables are designed and respectively represent basic information (main tables) of employees, department categories, wage categories, ethnic categories, cultural degrees, political appearances, job title categories, employee categories and job categories, as shown in FIG. 2.
The employee basic information form includes the following fields: [ worker number ], [ worker name ], [ nationality ], [ birth year ], [ age ], [ cultural degree ], [ marital status ], [ sex ], [ political aspect ], [ identity number ], [ work time ], [ work age ], [ worker type ], [ job type ], [ work type ], [ wage type ], [ department type ], [ job type ], [ phone number ], [ graduation school ], [ major repair speciality ], [ graduation time ], [ family address ], [ personal photograph ], [ province ], [ city ], [ month wage ], [ bank account ], [ contract start date ], [ contract end date ], [ contract year limit ], and 24 fields. Wherein [ national ] field content is taken from a national category table, [ degree of culture ] field content is taken from a degree of culture table, [ political face ] field content is taken from a political face table, [ staff type ] field content is taken from a staff category table, [ salary type ] field content is taken from a salary category table, [ department type ] field content is taken from a department category table, [ staff type ] field content is taken from a staff category table; the [ year of birth ], [ work time ], [ graduation time ], [ contract start date ], [ contract end date ] field type is date type, the [ marital situation ] field type is boolean type, the [ age ], [ work age ], [ contract age ] field type is integer type, the [ personal photo ] field type is picture, and the others are character string types.
2. Interface layout
The interface layout is designed according to the content of the basic information of the employee, as shown in fig. 3.
3. Program execution
As shown in fig. 4.
In addition to the above embodiments, the present invention also includes other embodiments, and any technical solutions formed by equivalent transformation or equivalent replacement should fall within the scope of the claims of the present invention.
Claims (5)
1. A method for realizing a software interface read-write database is characterized by comprising the following steps: firstly, according to an existing database arrangement interface, orderly placing label controls and field content controls in a container control, regularly defining Tag attributes of the controls in the container, then obtaining a list of all field names and field types of a specified database table, wherein the field names are used for assigning values to the label controls, and the field types are used for carrying out data processing when displaying or submitting data; assigning the label control in a polling mode according to the acquired field name list and the Tag attribute of the label control, traversing the field content control, judging the type of the control, obtaining the column number and the row number of the data table according to the Tag attribute of the control, and assigning the control according to the type and the column number and the row number of the control; when a display record command is obtained, analyzing Tag attributes of all controls in the container control and displaying the Tag attributes in association with the data table by adopting a control polling mode to obtain a certain line of data through database statements; and when a storage command is obtained, updating or creating the database, judging whether the database is updated or created repeatedly by the index, analyzing Tag attributes of all controls in the container control and associating the Tag attributes with the data table to generate data statements by adopting a control polling mode, and writing the data into the database.
2. The method for implementing the software interface read-write database according to claim 1, wherein: when an interface is arranged, firstly, a container control is placed on the interface, label controls are placed in the container control in order according to field definitions of a certain table of a database, and corresponding field content controls are placed according to field types corresponding to the label controls; after the controls are adjusted, defining Tag attributes of all the controls in a format of XXT-BB-CC, wherein XX represents a field serial number of a database table, the necessary definition exists, the range is 01-99, and the field definition of the database table can be met; t is an abbreviation of field data type, is not necessarily defined, and is only required to be defined when the type conversion is required; BB is a database table name needing to be associated, is not necessarily defined, and is only required to be defined when association is needed; the CC is a database table field name needing to be associated, is not necessarily defined, and is only required to be associated.
3. The method for implementing the software interface read-write database according to claim 1, wherein: the method comprises the steps of aiming at the character string processing function with the separator, specifically, circulating according to the length of the character string, if the character is the separator, assigning the character string before the separator to the variable, exiting the circulation to obtain the variable, circulating according to the length of the character string, if the character is the separator, assigning the character string after the separator to the variable, exiting the circulation and returning the variable.
4. The method for implementing the software interface read-write database according to claim 1, wherein: before the field content control is assigned, traversing the field content control of the interface, judging that the control is a drop-down box control type, judging that the Tag attribute of the control has database association, obtaining a table name and a field name by using a character string processing module to obtain a data set object, and temporarily storing the value of the drop-down box control according to the information content of the data set object so as to be used when the field content control is assigned.
5. The method for implementing the software interface read-write database according to claim 1, wherein: and when the storage command is obtained, processing according to two modes of modification and addition according to the existence of the field content, finding out records with the field content equal to the specified field for modification during modification, respectively assigning values to all database fields according to a mode of traversing the control by a device during addition, and then inserting the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910986049.1A CN110781186B (en) | 2019-10-17 | 2019-10-17 | Method for realizing software interface read-write data table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910986049.1A CN110781186B (en) | 2019-10-17 | 2019-10-17 | Method for realizing software interface read-write data table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110781186A CN110781186A (en) | 2020-02-11 |
| CN110781186B true CN110781186B (en) | 2022-04-15 |
Family
ID=69385779
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910986049.1A Active CN110781186B (en) | 2019-10-17 | 2019-10-17 | Method for realizing software interface read-write data table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110781186B (en) |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7251822B2 (en) * | 2003-10-23 | 2007-07-31 | Microsoft Corporation | System and methods providing enhanced security model |
| CA2690251A1 (en) * | 2007-06-10 | 2008-12-18 | Shopplex.Com Corporation | System and method for managing and updating data from a number of sources for a project |
| CN102467534A (en) * | 2010-11-12 | 2012-05-23 | 上海宝信软件股份有限公司 | Display method and display device for multi-field database |
| CN103970662B (en) * | 2014-05-22 | 2017-09-29 | 于秀山 | A kind of gui software input border value-acquiring method and system |
| CN105160023B (en) * | 2015-09-30 | 2018-07-10 | 深圳市巧捷万端云计算有限公司 | Graphics data inquiry processing method based on Cloud Server |
| CN106779576B (en) * | 2016-11-11 | 2020-10-09 | 浪潮通用软件有限公司 | Configuration method of service field |
| CN108154569B (en) * | 2017-12-27 | 2021-02-12 | 广州奥格智能科技有限公司 | Patrol acquisition method based on object modeling configuration |
| CN110134725A (en) * | 2019-05-22 | 2019-08-16 | 山东浪潮通软信息科技有限公司 | A kind of method and system of dynamic queries extended field |
-
2019
- 2019-10-17 CN CN201910986049.1A patent/CN110781186B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN110781186A (en) | 2020-02-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11816100B2 (en) | Dynamically materialized views for sheets based data | |
| US11755606B2 (en) | Dynamically updated data sheets using row links | |
| US6327593B1 (en) | Automated system and method for capturing and managing user knowledge within a search system | |
| US6374252B1 (en) | Modeling of object-oriented database structures, translation to relational database structures, and dynamic searches thereon | |
| US6240422B1 (en) | Object to relational database mapping infrastructure in a customer care and billing system | |
| US6556986B2 (en) | Database management method of invoking a function retrieving index type definition, cataloging particular index which has not yet been supported by a database system | |
| US6356913B1 (en) | Generic (database-independent) and dynamically-modifiable schema | |
| KR20060045622A (en) | Extraction, transformation and loading designer module of a computerized financial system | |
| US6915303B2 (en) | Code generator system for digital libraries | |
| US20110246535A1 (en) | Apparatus and Method for Constructing Data Applications in an Unstructured Data Environment | |
| US20080228782A1 (en) | Apparatus, Method, and Computer Program Product for Creating Hierarchical Dictionary | |
| US6513072B1 (en) | Method for associating data bearing objects with user interface objects | |
| CN110134681B (en) | Data storage and query method and device, computer equipment and storage medium | |
| US7685155B2 (en) | System and method of providing and utilizing an object schema to facilitate mapping between disparate domains | |
| US6820268B2 (en) | Method for associating data bearing objects with user interface objects | |
| CN108228762B (en) | Method and system for configuring master database universal templates | |
| CN113934786A (en) | Implementation method for constructing unified ETL | |
| CN110781186B (en) | Method for realizing software interface read-write data table | |
| Prywes | Man-computer problem solving with multilist | |
| Yannakoudakis | The architectural logic of database systems | |
| CN112181996B (en) | Unified data access middleware method and system for relational database | |
| US20030140194A1 (en) | Data management system and computer program | |
| Putzer | Data structures and data-base systems used in high energy physics: Modelling and implementation | |
| JP2005202612A (en) | Data base generation program preparing apparatus | |
| JP2022097358A (en) | On-line report creation system having query binding function |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |