CN106777076B - SQL limited query clause generation method and combinational logic filter - Google Patents
SQL limited query clause generation method and combinational logic filter Download PDFInfo
- Publication number
- CN106777076B CN106777076B CN201611145061.2A CN201611145061A CN106777076B CN 106777076 B CN106777076 B CN 106777076B CN 201611145061 A CN201611145061 A CN 201611145061A CN 106777076 B CN106777076 B CN 106777076B
- Authority
- CN
- China
- Prior art keywords
- filter
- sql
- combinational logic
- parameter values
- parameter
- 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
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000010586 diagram Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method for generating an SQL (structured query language) limited query clause and a combinational logic filter. The method is applied to a combinational logic filter consisting of one or more basic data filters, wherein the basic data filters comprise a GetParameters virtual method for acquiring parameter values and a GetSQL virtual method for acquiring SQL statements. The method calls a GetSQL virtual method to obtain SQL sentences, calls a GetParameters virtual method to obtain parameter values, and logically splices the obtained SQL sentences according to the obtained parameter values. The method calls the GetSQL virtual method to obtain the SQL sentences, calls the GetParameters virtual method to obtain the parameter values, and logically splices the obtained SQL sentences according to the obtained parameter values, so that the execution path of the spliced limited query clauses is excellent and is easy to realize.
Description
Technical Field
The invention relates to the field of distributed computing application, in particular to a method for generating SQL (structured query language) limited query clauses and a combinational logic filter.
Background
SQL (Structured Query Language) is a special-purpose programming Language, a high-level non-procedural programming Language that allows users to work on high-level data structures. The method does not require a user to specify a data storage method and does not require the user to know a specific data storage mode, so that different database systems with completely different underlying structures can use the same structured query language as an interface for data input and management. Meanwhile, SQL sentences can be nested, so that the method has great flexibility and strong functions. Are now widely used to access data and to query, update and manage relational database systems.
At present, there are two methods for generating an SQL query statement:
the first way adopts a character string splicing way, such as: the user interface has inquiry conditions of two fields of NAME and ADDRESS, and the inquiry conditions can be spliced in the program according to several different input states: when the NAME input is not empty, splicing conditions related to the NAME into a query statement; similarly, when the ADDRESS field input is not empty, the conditions associated with ADDRESS are spliced into the query statement.
Although the execution path is better, the programming process is complex, and particularly, when a more complex logic structure exists in the query condition, the complexity is higher;
the second way, which is implemented in an OR way, taking ORACLE as an example, when the user interface has a query condition of two fields, NAME and ADDRESS, a WHERE clause of SQL can be written as: (: NAME IS NULL OR NAME LIKE: NAME) AND (: ADDRESS IS NULL OR ADDRESS LIKE: ADDRESS).
The second approach, although simplifying the program code, makes the execution path very bad, making the index not used effectively.
Disclosure of Invention
Technical problem to be solved
In order to generate a limited query clause simply and optimally, the invention provides a method for generating the SQL limited query clause and a combinational logic filter.
(II) technical scheme
In order to achieve the purpose, the invention adopts the main technical scheme that:
a method of generating a structured query language, SQL, qualified query clause, applied to a combinational logic filter consisting of one or more underlying data filters; the basic data filter comprises a GetParameters virtual method for acquiring parameter values and a GetSQL virtual method for acquiring SQL statements;
the method comprises the following steps:
101, calling a GetSQL virtual method included in the basic data filter to obtain an SQL statement;
102, calling a GetParameters virtual method included in the basic data filter to obtain a parameter value;
and 103, logically splicing the obtained SQL statements according to the obtained parameter values.
Optionally, step 103 specifically includes:
103-1, determining the parameter value of the acquired SQL statement input parameter according to the acquired parameter value;
103-2, logically splicing SQL statements with non-empty parameter values of the input parameters.
Optionally, the combinational logic filter is an and logic filter;
step 103-2 specifically comprises:
AND splicing SQL sentences with non-empty parameter values of the input parameters by using AND symbols.
Optionally the combinational logic filter is an or logic filter;
step 103-2 specifically comprises:
and splicing SQL sentences with non-empty parameter values of the input parameters by using OR symbols.
Optionally, the base data filter is an SQL filter.
In addition, the invention adopts the main technical scheme that:
a combinational logic filter, said combinational logic filter comprised of one or more base data filters;
the basic data filter comprises a GetParameters virtual method for acquiring parameter values and a GetSQL virtual method for acquiring Structured Query Language (SQL) statements;
the combinational logic filter is used for calling a GetSQL virtual method included by the basic data filter to obtain an SQL statement; calling a GetParameters virtual method included in the basic data filter to obtain a parameter value; and logically splicing the obtained SQL sentences according to the obtained parameter values.
Optionally, the combinational logic filter is configured to determine a parameter value of the acquired SQL statement input parameter according to the acquired parameter value; and logically splicing SQL statements with non-empty parameter values of the input parameters.
Optionally, the combinational logic filter is a base class; the subclass of the combinational logic filter is an AND logic filter;
AND the AND logic filter is used for splicing SQL sentences with non-empty parameter values of the input parameters by using AND symbols.
Optionally, the combinational logic filter is a base class; the subclass of the combinational logic filter is an OR logic filter;
and the OR logic filter is used for splicing SQL sentences with non-empty parameter values of the input parameters by using OR symbols.
Optionally, the base data filter is a base class, and the subclass of the base data filter is an SQL filter.
(III) advantageous effects
The invention has the beneficial effects that: and calling a GetSQL virtual method to obtain an SQL statement, calling a GetParameters virtual method to obtain a parameter value, and logically splicing the obtained SQL statement according to the obtained parameter value, wherein the spliced limited query clause has a better execution path and is easy to realize.
Drawings
Fig. 1 is a flowchart of a method for generating an SQL query-defining clause according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a class diagram provided in accordance with an embodiment of the present invention;
fig. 3 is a flowchart of another method for generating an SQL query-defining clause according to an embodiment of the present invention.
Detailed Description
For the purpose of better explaining the present invention and to facilitate understanding, the present invention will be described in detail by way of specific embodiments with reference to the accompanying drawings.
The traditional SQL limited query statement generation method has two methods: the first mode adopts a character string splicing mode. Although the execution path is better, the programming process is complex, and particularly, the complexity is higher when a more complex logic structure exists in the query condition. In the second mode, OR is adopted. The second approach, although simplifying the program code, makes the execution path very bad, making the index not used effectively. The method calls the GetSQL virtual method to obtain the SQL sentences, calls the GetParameters virtual method to obtain the parameter values, and logically splices the obtained SQL sentences according to the obtained parameter values, so that the execution path of the spliced limited query clauses is excellent and is easy to realize.
Referring to fig. 1, the present embodiment provides a method for generating an SQL qualified query clause, which is applied to a combinational logic filter, where the combinational logic filter is composed of one or more basic data filters; the basic data filter comprises a GetParameters virtual method for acquiring parameter values and a GetSQL virtual method for acquiring SQL statements;
the method comprises the following steps:
101, calling a GetSQL virtual method included in the basic data filter to obtain an SQL statement.
And 102, calling a GetParameters virtual method included in the basic data filter to acquire a parameter value.
And 103, logically splicing the obtained SQL statements according to the obtained parameter values.
Optionally, step 103 specifically includes:
103-1, determining the parameter value of the acquired SQL statement input parameter according to the acquired parameter value.
103-2, logically splicing SQL statements with non-empty parameter values of the input parameters.
Optionally, the combinational logic filter is an and logic filter;
step 103-2 specifically comprises:
AND splicing SQL sentences with non-empty parameter values of the input parameters by using AND symbols.
Optionally, the combinational logic filter is an or logic filter;
step 103-2 specifically comprises:
and splicing SQL sentences with non-empty parameter values of the input parameters by using OR symbols.
Optionally, the underlying data filter is an SQL filter.
The invention has the beneficial effects that: and calling a GetSQL virtual method to obtain an SQL statement, calling a GetParameters virtual method to obtain a parameter value, and logically splicing the obtained SQL statement according to the obtained parameter value, wherein the spliced limited query clause has a better execution path and is easy to realize.
The method for generating the SQL restriction query clause provided by the invention is applied to the class structure shown in figure 2, wherein the class structure comprises
1. A combinational logic filter (composeticiicfilter) is a base class of all logic filters, which has a set attribute named ChildDataFilters, indicating that the combinational logic filter is composed of a plurality of basic data filters (basedatafilters).
(1) And the AndLogicFilter is an AND logic filter, is a subclass of the ComositeLogicFilter, and is used for realizing the splicing of the subclass of each basic data filter with the mode.
(2) The OrLogicFilter is an OR logic filter, is a subclass of the ComositeLogicFilter, and is used for realizing the splicing of the subclasses of all the basic data filters with the mode.
2. BaseDataFilter, is the base class of all data filters. The method comprises the following two virtual methods which are realized by each subclass of BaseDataFilter:
(1) GetParameters virtual method for obtaining all parameters of the data filter.
(2) And the GetSQL virtual method is used for acquiring the SQL statement.
The subclasses of BaseDataFilter are SQL filters (SqlFilter) and ComositeLogicFilter.
● for the GetParameters virtual method, it returns ParameterName in SqlFilter. The result of all GetParameters of ChildDataFilters connected in parallel is returned in the ComositeLogicFilter;
● for the GetSQL virtual method, it returns SQL properties (attributes) in SqlFilter. AND returning in AndLogicalFilter is the result of splicing the returned values of GetSQL method with AND symbols, wherein all input parameters in ChildDataFilters are not null. In OrLogicalFilter, the returned value of the method is the result of splicing the returned values of all GetSQL methods with null input parameters in ChildDataFilters by OR symbols.
In addition, the SqlFilter contains a filter clause and has a ParameterName to identify the parameter name, which corresponds to the parameter name in parameterValues in GetSQL, and if the ParameterName is not found in the parameterValues, the SqlFilter is considered not to be contained in the final SQL.
Based on the class diagram shown in fig. 2, a process of executing the method for generating the SQL qualified query clause by the composetierelogicfilter, which is a subclass of the composetierelogicfilter, is described again as an example, and refer to fig. 3.
301, OrLogicFilter calls the GetSQL virtual method included in SqlFilter to obtain the SQL statement.
302, OrLogicFilter calls the GetParameters virtual method included in the SqlFilter to obtain the parameter value.
303, the OrLogicFilter determines the parameter value of the input parameter of the obtained SQL statement according to the obtained parameter value, and splices the SQL statement with the OR symbol, wherein the parameter value of the input parameter is not empty.
Next, based on the class diagram shown in fig. 2, a process of executing a method for generating an SQL restricted query clause by the subclass andlogic filter of the CompositeLogicFilter will be described again as an example.
If the following configuration is present:
then, when the NAME parameter has a value and ADDRESS is empty, the final generating query limit clause is:
NAME LIKE:NAME
when the NAME parameter is null and ADDRESS has a value, the final generating WHERE clause is:
ADDRESS LIKE:ADDRESS
when both NAME and ADDRESS have values, the final WHERE clause is generated:
(NAME LIKE:NAME)AND(ADDRESS LIKE:ADDRESS)
in the method provided by the embodiment, all the filters involved have two common methods: the method comprises the steps of obtaining a parameter list, obtaining parameters in a data filter, and obtaining a final WHERE clause according to the value of an input parameter. The SQL WHERE clause for executing path optimization can be spliced by the method provided by the embodiment.
The method provided by the embodiment calls a GetSQL virtual method to obtain an SQL statement, calls a GetParameters virtual method to obtain a parameter value, and logically splices the obtained SQL statement according to the obtained parameter value, so that the execution path of the spliced limited query clause is excellent and is simple to implement.
Based on the same inventive concept, the invention also provides a combined logic filter, which consists of one or more basic data filters;
the basic data filter comprises a GetParameters virtual method for acquiring parameter values and a GetSQL virtual method for acquiring Structured Query Language (SQL) statements;
the combined logic filter is used for calling a GetSQL virtual method included by the basic data filter to obtain an SQL statement; calling a GetParameters virtual method included in a basic data filter to obtain a parameter value; and logically splicing the obtained SQL sentences according to the obtained parameter values.
Optionally, the combinational logic filter is configured to determine a parameter value of the acquired SQL statement input parameter according to the acquired parameter value; and logically splicing SQL statements with non-empty parameter values of the input parameters.
Optionally, the combinational logic filter is a base class; the subclass of combinational logic filters is AND logic filters;
AND the AND logic filter is used for splicing SQL sentences with non-empty parameter values of the input parameters by using AND symbols.
Optionally, the combinational logic filter is a base class; the subclass of the combinational logic filter is an OR logic filter;
OR the logic filter is used for splicing SQL sentences of which the parameter values of the input parameters are not null by using OR symbols.
Optionally, the base data filter is a base class, the subclass of the base data filter is an SQL filter, and the subclass of the base data filter is a combinational logic filter.
The combinational logic filter provided in this embodiment invokes a GetSQL virtual method to obtain SQL statements, invokes a GetParameters virtual method to obtain parameter values, and logically splices the obtained SQL statements according to the obtained parameter values, so that the execution path of the spliced restricted query clauses is superior and is simple to implement.
Claims (7)
1. A method for generating a structured query language, SQL, restricted query clause, applied to a combinational logic filter, characterized in that the combinational logic filter consists of one or more basic data filters; the basic data filter comprises a GetParameters virtual method for acquiring parameter values and a GetSQL virtual method for acquiring SQL statements;
the method comprises the following steps:
101, calling a GetSQL virtual method included in the basic data filter to obtain an SQL statement;
102, calling a GetParameters virtual method included in the basic data filter to obtain a parameter value;
103, logically splicing the obtained SQL statements according to the obtained parameter values;
step 103 specifically comprises:
103-1, determining the parameter value of the acquired SQL statement input parameter according to the acquired parameter value;
103-2, logically splicing SQL sentences with non-empty parameter values of the input parameters;
wherein the basic data filter is an SQL filter, the SQL filter includes a filter clause, and the filter clause includes a ParameterName identification parameter name, the parameter name corresponds to a parameter name in parameterValues in the GetSQL virtual method, and if the ParameterName is not found in the parameterValues, the SQL filter is considered not to be included in the final SQL statement.
2. The method of claim 1, wherein the combinational logic filter is an and logic filter;
step 103-2 specifically comprises:
AND splicing SQL sentences with non-empty parameter values of the input parameters by using AND symbols.
3. The method of claim 1, wherein the combinational logic filter is an or logic filter;
step 103-2 specifically comprises:
and splicing SQL sentences with non-empty parameter values of the input parameters by using OR symbols.
4. A combinational logic filter, wherein the combinational logic filter is comprised of one or more base data filters;
the basic data filter comprises a GetParameters virtual method for acquiring parameter values and a GetSQL virtual method for acquiring Structured Query Language (SQL) statements;
the combinational logic filter is used for calling a GetSQL virtual method included by the basic data filter to obtain an SQL statement; calling a GetParameters virtual method included in the basic data filter to obtain a parameter value; logically splicing the obtained SQL sentences according to the obtained parameter values;
the logically splicing the obtained SQL statements by the combinational logic filter according to the obtained parameter values comprises the following steps: determining the parameter value of the acquired SQL statement input parameter according to the acquired parameter value; logically splicing SQL sentences with non-empty parameter values of the input parameters;
wherein the basic data filter is an SQL filter, the SQL filter includes a filter clause, and the filter clause includes a ParameterName identification parameter name, the parameter name corresponds to a parameter name in parameterValues in the GetSQL virtual method, and if the ParameterName is not found in the parameterValues, the SQL filter is considered not to be included in the final SQL statement.
5. The combinational logic filter according to claim 4, wherein the combinational logic filter is a base class; the subclass of the combinational logic filter is an AND logic filter;
AND the AND logic filter is used for splicing SQL sentences with non-empty parameter values of the input parameters by using AND symbols.
6. The combinational logic filter according to claim 4, wherein the combinational logic filter is a base class; the subclass of the combinational logic filter is an OR logic filter;
and the OR logic filter is used for splicing SQL sentences with non-empty parameter values of the input parameters by using OR symbols.
7. The combinational logic filter according to any of claims 4-6, wherein the base data filter is a base class, the subclass of the base data filter is a SQL filter, and the subclass of the base data filter is the combinational logic filter.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611145061.2A CN106777076B (en) | 2016-12-13 | 2016-12-13 | SQL limited query clause generation method and combinational logic filter |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611145061.2A CN106777076B (en) | 2016-12-13 | 2016-12-13 | SQL limited query clause generation method and combinational logic filter |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106777076A CN106777076A (en) | 2017-05-31 |
| CN106777076B true CN106777076B (en) | 2020-05-05 |
Family
ID=58880766
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611145061.2A Active CN106777076B (en) | 2016-12-13 | 2016-12-13 | SQL limited query clause generation method and combinational logic filter |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106777076B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222110A (en) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | Data processing device and method |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN103902606A (en) * | 2012-12-28 | 2014-07-02 | 腾讯科技（深圳）有限公司 | Data processing method and system of database |
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
-
2016
- 2016-12-13 CN CN201611145061.2A patent/CN106777076B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222110A (en) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | Data processing device and method |
| CN103902606A (en) * | 2012-12-28 | 2014-07-02 | 腾讯科技（深圳）有限公司 | Data processing method and system of database |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106777076A (en) | 2017-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9317557B2 (en) | Answering relational database queries using graph exploration | |
| CN102254029B (en) | View-based data access system and method | |
| CN110704398A (en) | Database migration method and device from MySQL to Oracle and computer equipment | |
| Afrati et al. | Transitive closure and recursive datalog implemented on clusters | |
| US10977224B2 (en) | Dynamic modeling of data in relational databases | |
| CN106407303A (en) | Data storage method and apparatus, and data query method and apparatus | |
| US20230075655A1 (en) | Systems and methods for context-independent database search paths | |
| US9740713B1 (en) | Dynamic modeling of data in relational databases | |
| US11893026B2 (en) | Advanced multiprovider optimization | |
| US10726006B2 (en) | Query optimization using propagated data distinctness | |
| US20200320216A1 (en) | Systems and methods for determining database permissions | |
| CN107102995B (en) | Method and device for determining SQL execution plan | |
| WO2019015364A1 (en) | Method and device for executing structured query language (sql) instruction | |
| CN110110108B (en) | Data importing method and device of graph database | |
| US10831784B2 (en) | Integration of relational calculation views into a relational engine | |
| US20240256613A1 (en) | Data processing method and apparatus, readable storage medium, and electronic device | |
| CN111475511A (en) | Data storage method, data access method, data storage device, data access device and data access equipment based on tree structure | |
| CN103678396A (en) | Data backup method and device based on data models | |
| CN106777076B (en) | SQL limited query clause generation method and combinational logic filter | |
| Feng et al. | Transforming UML class diagram into cassandra data model with annotations | |
| CN114490724B (en) | Method and device for processing database query statement | |
| CN114817512B (en) | Question-answer reasoning method and device | |
| CN106991116A (en) | The optimization method and device of database executive plan | |
| CN107463618A (en) | A kind of index creation method and apparatus | |
| US20130110853A1 (en) | Sql constructs ported to non-sql domains |
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 | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20210119 Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee after: SHENZHEN JINFU TECHNOLOGY Co.,Ltd. Patentee after: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Address before: 528200 area 4, 3rd floor, building 5, area a, Hantian science and Technology City, No.17, Guicheng Shenhai Road, Nanhai District, Foshan City, Guangdong Province Patentee before: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20170531 Assignee: Guangdong Yaoda Financial Leasing Co.,Ltd. Assignor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Contract record no.: X2021980004499 Denomination of invention: A method of generating SQL restricted query clause and combinational logic filter Granted publication date: 20200505 License type: Exclusive License Record date: 20210608 |
|
| EE01 | Entry into force of recordation of patent licensing contract | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A method of generating SQL restricted query clause and combinational logic filter Effective date of registration: 20210609 Granted publication date: 20200505 Pledgee: Guangdong Yaoda Financial Leasing Co.,Ltd. Pledgor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Registration number: Y2021980004556 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PC01 | Cancellation of the registration of the contract for pledge of patent right |
Granted publication date: 20200505 Pledgee: Guangdong Yaoda Financial Leasing Co.,Ltd. Pledgor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Registration number: Y2021980004556 |
|
| PC01 | Cancellation of the registration of the contract for pledge of patent right | ||
| EC01 | Cancellation of recordation of patent licensing contract |
Assignee: Guangdong Yaoda Financial Leasing Co.,Ltd. Assignor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Contract record no.: X2021980004499 Date of cancellation: 20240809 |
|
| EC01 | Cancellation of recordation of patent licensing contract |