CN104461531B - A kind of implementation method of reporting system SQL - Google Patents

A kind of implementation method of reporting system SQL Download PDF

Info

Publication number
CN104461531B
CN104461531B CN201410722935.0A CN201410722935A CN104461531B CN 104461531 B CN104461531 B CN 104461531B CN 201410722935 A CN201410722935 A CN 201410722935A CN 104461531 B CN104461531 B CN 104461531B
Authority
CN
China
Prior art keywords
sql
parameter
associated storage
storage process
name
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.)
Expired - Fee Related
Application number
CN201410722935.0A
Other languages
Chinese (zh)
Other versions
CN104461531A (en
Inventor
聂作先
王平阳
张顺淼
杨海燕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian University of Technology
Original Assignee
Fujian University of Technology
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian University of Technology filed Critical Fujian University of Technology
Priority to CN201410722935.0A priority Critical patent/CN104461531B/en
Publication of CN104461531A publication Critical patent/CN104461531A/en
Application granted granted Critical
Publication of CN104461531B publication Critical patent/CN104461531B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Stored Programmes (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses reporting system SQL implementation method, comprise the following steps:Step 1):SQL and parameter registration;Step 2):SQL associated storage process is created;Step 3):SQL is used in form;Step 4):Recognize the SQL in form;Step 5):Identification variables are with replacing in SQL parameter list;Step 6):Prepare parameter and call SQL associated storage process;Step 7):Perform SQL associated storage process and returning result;Step 8):Receive SQL associated storage process returning result and be applied in form.The technical threshold that the present invention creates SQL is relatively low, the design that reports user only needs to be familiar with storing process can just create SQL, as long as registering the title and parameter information of SQL in designer and submitting and establishment and deployment that associated storage process just completes SQL are created in database.

Description

A kind of implementation method of reporting system SQL
Technical field
The present invention relates to computer software application field, more particularly to a kind of realization side of reporting system SQL Method.
Background technology
SQL function is one of critical function of business report system, and it allows Report Form Design person or reports user Used when form transfer function and business processing logic are packaged as into the form of function for design form, realize code reuse and spy Determine the characteristic demand of application field.
Form is the essential part of enterprise application software, the exploitation of form for convenience, all kinds of form development systems In a number of system function is both provided to complete the function that some are general, such as Mathematical treatment, string processing, date lattice Formula conversion etc..But in actual applications, according to the specific needs of application field, Report Form Design person also need to often use some be The function that does not have in system function, the date format conversion or number format conversion of such as specific format, and with applied business logic Related processing function, these functions are accomplished by Report Form Design person's designed, designed and supply its Reusability into SQL.
In the business report system of current main-stream, the method that design SQL is provided mostly.Microsoft There is provided SQL in crystal report (Crystal Report) system in Visual Studio IDEs Editing machine designs SQL for user, can be published in the warehouse of reporting system and be set with every other after the completion of design Meter person is shared to be used.Crystal report SQL design and issue it is all fairly simple, but need to use VISUAL BASIC or The special programming language of crystal report is write, and has many restrictions to code function, can not be used such as in SQL Form or Database field, this greatly limits the application of SQL.
Profit universe reporting system, outstanding table reporting system and X5 forms platform are all the parsings that WEB forms are developed with JAVA language Engine, therefore, they are required to SQL and developed using JAVA language, and it is configured using also will be according to certain regular right Configuration file enters edlin.For example the flow of one SQL of addition is as follows in profit universe reporting system:
1st, the java classes of SQL are write, are inherited This class of com.runqian.report4.model.expression.Function.
2nd, under the config catalogues of java class.path, customFunctions.properties files are found, and The registration of SQL class and function name is carried out wherein.
3rd, at designer end, by customFunctions.properties files copy to designer web WEB- INF classes under config, by class file copy to designer web WEB-INF under classes, have bag name, phase The Jian Bao paths answered.
4th, in web terminal, by customFunctions.properties files copy to webapps demo WEB- INF classes under config, by class file copy to webapps demo WEB-INF under classes, have bag name, Corresponding Jian Bao paths.
5th, designer is restarted.
6th, SQL is used in designer.
Above-mentioned SQL implementation method advantage is powerful, the volume that JAVA programming languages can be made full use of to provide Cheng Nengli, form translation function and business logic processing function to user are all easier to realize.
Also a kind of implementation of SQL simply can design and apply SQL【1】.It is square herein In case, SQL four-tuple Fun={ SQL name, SQL query statement, input parameter number, output parameter Number } define, the function of function is realized that reports user need to only write this SQL query statement by SQL query statement therein, without Use other programming languages.After above-mentioned SQL four-tuple is all determined, so that it may be submitted to database, for other forms Family is shared to be used.It can be embedded in when using as system function in expression formula.The SQL resolving of this scheme It is as follows:
1st, the identification variables in the expression formula comprising SQL and replacement, all variables all replace with specific value, Prepared for SQL evaluation.
2nd, the SQL in recognition expression formula.
3rd, by the User-Defined Functions function name stored in database, corresponding SQL query statement and parameter are found Number information is compared with the variable number obtained, to verify whether variable-definition number is correct.
4th, the parametric variable in SQL query statement is replaced with the actual parameter value of the SQL in expression formula.
5th, SQL query statement of the previous step after variable replacement is performed, return value, i.e. asking as SQL is obtained Value result replaces its appearance in expression formula.
For profit universe reporting system, the outstanding SQL realization side based on JAVA such as table reporting system and X5 form platforms Method, its major defect is:
The technical threshold for creating SQL is higher.Various reporting systems require user when designing SQL Using the programming language specified and by defined said shank, it is necessary to which the SQL of database manipulation also GPRS SQL is compiled Journey.
The deployment of SQL is complicated, and when SQL is more, workload is big and error-prone.
For with four-tuple Fun={ SQL name, SQL query statement, input parameter number, output parameter number } The SQL scheme of realization, its main deficiency is function limitation, and SQL is performed and result is obtained and all passed through What SQL query statement was realized, it is difficult to realize the SQL function of including service logic rule.In addition it is also efficient low Shortcoming, i.e., perform SQL query statement database server and be required for carrying out syntax check to it every time.
The SQL function of the current each main flow reporting system of comprehensive analysis is realized, it is found that there are the following problems:
The technical threshold for creating SQL is higher.Various reporting systems require user when designing SQL Using the programming language specified and by defined said shank, it is necessary to which the SQL of database manipulation also GPRS SQL is compiled Journey.This means common Report Form Design person and user may need one new programming language and its developing instrument of study to set Count SQL.
The deployment of SQL is complicated.During the SQL deployment of various reporting systems, generally involve The establishment of multiple files and editor, and to put it under specified file path, some reporting systems also need to restarting and set Gauge is to allow SQL to come into force, and process is complicated, and when SQL is more, workload is big and error-prone.
The content of the invention
Present invention aims at provide it is a kind of with relatively low technical threshold and simple deployment way to solve background technology The reporting system SQL implementation method of the technical problem referred to.
The technical scheme that the present invention is provided is:A kind of reporting system SQL implementation method, comprises the following steps:
Step 1):SQL and parameter registration.This step is completed on the function interface of Report Designer.Form is set Meter person need to provide name, the parameter name of number of parameters and each parameter and its description of SQL, then be submitted to system Database can complete enrollment process.Reporting system function is recognized with prefix $, and SQL is recognized with prefix $ $, such as one If individual function shape such as $ FUNC (), are system functions, if shape such as $ $ FUNC (), are SQLs.This increase prefix Function naming method is conducive to distinguishing common parenthesized expression, system function and SQL.
Step 2):SQL associated storage process is created.This step is completed in data base management system.It is all from The function of defined function is all realized by its related storing process.The name of SQL associated storage process is self-defined letter Several words remove prefix and obtained, such as the entitled myFunc () of SQL, then the entitled myFunc of its associated storage process The related definition method of (), this function name and storing process name can be directly from making by oneself when ensure that parsing SQL Adopted function name obtains its associated storage procedure name, without being retrieved from database.All SQL associated storage processes Parameter list using unified form myFunc (inParams, outParam), no matter SQL includes how many parameters, But its associated storage process only includes an input parameter and an output parameter, input parameter is used to transmit to storing process Parameter value, if SQL has multiple parameters, this multiple parameters, which is grouped together, is transferred to input parameter, output parameter For returning to storing process implementing result.Processing logic during SQL associated storage is comprised the following steps:A) connect Input parameter is received, the multiple parameters combined are resolved into single parameter;B type conversion, conversion) are carried out to each parameter Into the data type of needs;C the processing logic of SQL) is performed;D) implementing result is set to output parameter and returned.
Step 3):SQL is used in form.This step is completed in Report Designer.Used certainly in form Defined function is fairly simple, and the form defined in step 1 according to it is used alone or in expression formula.
Step 4):Recognize the SQL in form.This step is parsed in form and completed with creating in engine.In form In expression parsing evaluation process, the prefix naming rule named according to SQL recognizes SQL therein, carried Take out preparation parsing.
Step 5):Identification variables are with replacing in SQL parameter list.This step is parsed with creating engine in form It is middle to complete.In the parameter list for the SQL that step 4 is extracted, possible comprising variable, constant and other functions.This step Including following sub-step:Variable therein and other functions are identified;The actual value of variable in parameter is asked for, in parameter Function calculate and obtain end value;Its appearance in parameter list is replaced with the actual value of parametric variable, with parameter The execution result value of function replaces its appearance in parameter list.By above-mentioned steps, in the parameter list of SQL Only include constant.
Step 6):Prepare parameter and call SQL associated storage process.This step is drawn in form parsing with establishment Hold up middle completion.Comprise the following steps:Prepare the input parameter of SQL associated storage process.By obtained in step 5 Parameter list containing constant removes front and rear bracket, is assigned to input parameter;The output of SQL associated storage process is set Parameter;Remove the prefix $ $ of SQL name, be used as storing process name;Visited using storing process name and parameter setting data storehouse Component is asked, submits storing process to be performed to database server.
Step 7):Perform SQL associated storage process and returning result.This step is in data base management system Realize.
Step 8):Receive SQL associated storage process returning result and be applied in form.This step is in form Parsing is completed with creating in engine.
The beneficial effects of the invention are as follows:
A kind of reporting system SQL processing scheme that the present invention is provided, its core concept is all self-defined letters Number is realized by database store process.Various commercial database management systems both provide the mechanism of design storing process, its In comprising various flow control mechanisms, a large amount of format analysis processing functions, mathematical function and date function etc., while can directly operate SQL statement.After storing process is it is further an advantage that once compile, repeat later without compiling again, execution efficiency compared with Height, and compilation operations will be performed by being submitted to other programming languages before the SQL query statement of Database Systems is performed every time.
Advantages of the present invention includes:(1) technical threshold for creating SQL is relatively low, and reports user only needs to be familiar with depositing The design of storage process can just create SQL, and the method letter of storing process is created in various data base management systems Single, grammer is approached.User is without using other programming tools and programming language.(2) SQL deployment is simple, as long as setting The title and parameter information of SQL are registered in gauge and submits and associated storage process is created in database just Complete the establishment and deployment of SQL.
Brief description of the drawings
When considered in conjunction with the accompanying drawings, by referring to following detailed description, can more completely more fully understand the present invention with And the adjoint advantage of many of which is easily learnt, but accompanying drawing described herein is used for providing a further understanding of the present invention, The part of the present invention is constituted, schematic description and description of the invention is used to explain the present invention, do not constituted to this hair Bright improper restriction, wherein:
Fig. 1 is the overall procedure block diagram of the reporting system SQL implementation method of the present invention;
Fig. 2 is the FB(flow block) of SQL associated storage process internal handling process;
Fig. 3 is identification variables and the FB(flow block) of replacement in SQL parameter list;
Fig. 4 is the FB(flow block) for preparing parameter and calling SQL associated storage process.
Embodiment
In order to facilitate the understanding of the purposes, features and advantages of the present invention, it is below in conjunction with the accompanying drawings and specific real Applying mode, the present invention is further detailed explanation.
Refer to the attached drawing, illustrates the technical side of the present invention with the detailed process of definition and the parsing of a SQL below Case.
It is assumed that needing a SQL to give tacit consent to date format " 08/25/2014 " is converted to Chinese date format, such as " 2014 on August 25, ", with reference to the accompanying drawings 1, following steps will be passed through:ChnDate (today (), ' YYYY MM The DD days moon ') same day date format is turned into Chinese date format.
Step 1):SQL and parameter registration.Registration SQL be $ $ chnDate (oldDate, Format), $ $ chnDate are SQL names, and oldDate is the date to be converted of default form, and format is to expect to turn The form changed into.
Step 2):SQL associated storage process is created.A storing process is created in data base management system, Shape such as chnDate (inParams, outParam), inParams are input parameters, and outParam is output parameter, is character String type.The processing logic of accompanying drawing 2 is realized in storing process chnDate, the old date to using CSV in inParams And two parameter values of desired format resolve into the parameter value of two character string types, and date type and structure class are converted into respectively Type, is then handled it and is set implementing result to output parameter outParam returns.
Step 3):SQL is used in form.Using example such as
$ STRCAT (" date printeds:", $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ')), wherein system letter Number $ STRCAT () are used for two string-concatenations into a character string, and system function $ TDODAY () are used to obtain acquiescence lattice The current date of formula, if current date is " 08/25/2014 ", above-mentioned example will obtain character string " date printed:201 On August 25th, 4 ".The number of parameters of SQL should be identical with what is registered in step 1.
Step 4):Recognize the SQL in form., can be very according to SQL prefix and parenthesis matching relation Readily recognize $ STRCAT (" date printeds:", $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ')) in make by oneself Adopted function $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ').
Step 5):Identification variables are with replacing in SQL parameter list.$ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ') in, its parameter list is " $ TDODAY (), ' YYYY MM months DD day ' ", wherein $ TDODAY () are system letter Number is, it is necessary to evaluation, it is assumed that evaluation obtains result:08/25/2014, $ TDODAY () are replaced in $ $ chnDate ($ TDODAY with it (), ' YYYY MM months DD day ') in appearance, obtain $ $ chnDate (' 08/25/2014 ', ' YYYY MM months DD day ').Extremely This, only includes constant in the parameter list of SQL.
Step 6):Prepare parameter and call SQL associated storage process.Comprise the following steps:1st, SQL The input parameter value of associated storage process is " ' 08/25/2014 ', ' YYYY MM months DD day ' ".2nd, SQL is set to close Join the output parameter of storing process;3rd, the name using chnDate as storing process;4th, using storing process name and parameter setting data Storehouse accesses component, submits storing process to be performed to database server.
Step 7):Perform step 6) in set storing process and returning result, herein returning result be " in 2014 August 25 ".
Step 8):Receiving step 7) in storing process returning result and be applied in form expression formula, i.e., by step 7) return Return result and replace SQL $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ') (" beaten in expression formula $ STRCAT Print the date:", $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ')) in appearance, obtain $ STRCAT (" printing day Phase:", " 2014 on August 25, "), so far, SQL parsing terminates.
The present invention can also have other alternate embodiments, such as:
In step 1) in, the name of SQL can also be without special prefix, then can when Report Engine is parsed Obtain the name list of all system functions and SQL from system database with elder generation, then with the function used in form It is compared.
In step 2) in, the storing process name of SQL association can also be saved in SQL in database , then can be without derived relation between storing process name and its association SQL name in record, its incidence relation can be from SQL is found in the register information in database.Then when calling associated storage process for SQL will first from The storing process name of SQL association is obtained in database.In addition, the processing logic of SQL can also use number Realized according to the User Defined SQL function in the system of storehouse, with being using storing process difference, the result in storing process Returned by output parameter, and result is returned by function return value in User Defined SQL function.
The description of the above examples is only intended to facilitate the understand of the core idea of the present invention;Simultaneously for the general of this area Technical staff, according to the thought of the present invention, will change in specific embodiments and applications, in summary, This specification content should not be construed as limiting the invention.

Claims (2)

1. a kind of reporting system SQL implementation method, it is characterised in that comprise the following steps:
Step 1):SQL and parameter registration;On the function interface of Report Designer, Report Form Design person provides self-defined Name, the parameter name of number of parameters and each parameter and its description of function, are then submitted to system database;SQL Recognized with prefix $ $;
Step 2):SQL associated storage process is created;In data base management system, the function of all SQLs All realized by its related storing process;The name of SQL associated storage process is that SQL name removes prefix $ $ and obtain;The parameter list of all SQL associated storage processes is using unified form;Associated storage process is only wrapped Containing an input parameter and an output parameter, input parameter is used for storing process Transfer Parameters value, if SQL has Multiple parameters, then this multiple parameters, which is grouped together, is transferred to input parameter, and output parameter is used to return to storing process execution As a result;
Step 3):SQL is used in form;In Report Designer, defined in step 1 according to SQL Form be used alone or in expression formula;
Step 4):Recognize the SQL in form;In form expression parsing evaluation process, ordered according to SQL The prefix naming rule of name, recognizes SQL therein, extracts preparation parsing;
Step 5):Identification variables are with replacing in SQL parameter list;Step 4) parameter of SQL that extracts In list, variable therein and other functions are identified;The actual value of variable in parameter is asked for, the function in parameter is entered Row calculating obtains end value;Replace its appearance in parameter list with the actual value of parametric variable, held with function in parameter Row end value replaces its appearance in parameter list;Only included by above-mentioned steps, in the parameter list of SQL normal Amount;
Step 6):Prepare parameter and call SQL associated storage process;Comprise the following steps:
Prepare the input parameter of SQL associated storage process, by step 5) in the obtained parameter list containing only constant remove Front and rear bracket, is assigned to input parameter;
The output parameter of SQL associated storage process is set;
Remove the prefix $ $ of SQL name, be used as storing process name;
Component is accessed using storing process name and parameter setting data storehouse, submits storing process to be performed to database server;
Step 7):Perform SQL associated storage process and returning result;
Step 8):Receive SQL associated storage process returning result and be applied in form.
2. a kind of reporting system SQL implementation method according to claim 1, it is characterised in that step 2) in, Processing logic during SQL associated storage is comprised the following steps:
A input parameter) is received, the multiple parameters combined are resolved into single parameter;
B type conversion) is carried out to each parameter, the data type needed is converted into;
C the processing logic of SQL) is performed;
D) implementing result is set to output parameter and returned.
CN201410722935.0A 2014-12-02 2014-12-02 A kind of implementation method of reporting system SQL Expired - Fee Related CN104461531B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410722935.0A CN104461531B (en) 2014-12-02 2014-12-02 A kind of implementation method of reporting system SQL

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410722935.0A CN104461531B (en) 2014-12-02 2014-12-02 A kind of implementation method of reporting system SQL

Publications (2)

Publication Number Publication Date
CN104461531A CN104461531A (en) 2015-03-25
CN104461531B true CN104461531B (en) 2017-11-07

Family

ID=52907642

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410722935.0A Expired - Fee Related CN104461531B (en) 2014-12-02 2014-12-02 A kind of implementation method of reporting system SQL

Country Status (1)

Country Link
CN (1) CN104461531B (en)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106227896A (en) * 2016-08-28 2016-12-14 杭州合众数据技术有限公司 A kind of big data visualization fractional analysis method
CN108255967B (en) * 2017-12-26 2021-03-02 平安科技(深圳)有限公司 Method and device for calling storage process, storage medium and terminal
CN108536400A (en) * 2018-04-12 2018-09-14 珠海横琴盛达兆业科技投资有限公司 A kind of pharmacy's receipt Method of printing based on jatoolsPrinter
CN110083386B (en) * 2019-04-04 2024-03-19 平安普惠企业管理有限公司 Random number generation control method, device, computer equipment and storage medium
CN109992259B (en) * 2019-04-15 2020-10-30 成都四方伟业软件股份有限公司 Function dynamic creating method and device and electronic equipment
CN111708992B (en) * 2020-05-06 2023-07-14 咪咕文化科技有限公司 Report data access method and device, electronic equipment and storage medium
CN112416322A (en) * 2020-11-20 2021-02-26 城云科技(中国)有限公司 Implementation method for acquiring previous data in data set according to self-circulation function
CN115794043B (en) * 2023-01-31 2023-06-09 帆软软件有限公司帆软南京分公司 System and method for calculating table data aggregation processing of BI tool

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101710273A (en) * 2009-10-28 2010-05-19 金蝶软件(中国)有限公司 Method and device for analyzing multi-dimensional query sentence in online analysis processing server
CN102096664A (en) * 2009-12-09 2011-06-15 新奥特(北京)视频技术有限公司 Report generating method
CN102436498A (en) * 2011-11-14 2012-05-02 深圳市华力特电气股份有限公司 Report form generating method and relative device
US8656367B1 (en) * 2011-07-11 2014-02-18 Wal-Mart Stores, Inc. Profiling stored procedures

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101710273A (en) * 2009-10-28 2010-05-19 金蝶软件(中国)有限公司 Method and device for analyzing multi-dimensional query sentence in online analysis processing server
CN102096664A (en) * 2009-12-09 2011-06-15 新奥特(北京)视频技术有限公司 Report generating method
US8656367B1 (en) * 2011-07-11 2014-02-18 Wal-Mart Stores, Inc. Profiling stored procedures
CN102436498A (en) * 2011-11-14 2012-05-02 深圳市华力特电气股份有限公司 Report form generating method and relative device

Also Published As

Publication number Publication date
CN104461531A (en) 2015-03-25

Similar Documents

Publication Publication Date Title
CN104461531B (en) A kind of implementation method of reporting system SQL
US7757220B2 (en) Computer interchange of knowledge hierarchies
US7870221B2 (en) Multiple bindings in web service data connection
US9588742B2 (en) Rule-based automatic class generation from a JSON message
CN107273122A (en) Based on decoupling mechanism can iteration set up operation system method and its terminal
CN108694214A (en) Generation method, generating means, readable medium and the electronic equipment of data sheet
CN110276074B (en) Distributed training method, device, equipment and storage medium for natural language processing
CN104901845B (en) Domain name WHOIS automatizations of service test system and method
CN107506190A (en) XML file amending method and device based on Spring frameworks
CN105005543A (en) Interface generation apparatus and method
CN109299074A (en) A kind of data verification method and system based on templating data base view
CN115017182A (en) Visual data analysis method and equipment
CN114386853A (en) Data auditing processing method, device and equipment based on universal auditing model
Bojinov RESTful Web API Design with Node. js 10: Learn to create robust RESTful web services with Node. js, MongoDB, and Express. js
CN105302556A (en) Calculation realization method and system and server apparatus
CN102567517A (en) Device and method for issuing data of database
Shan et al. Towards integrated service adaptation a new approach combining message and control flow adaptation
CN111008011A (en) System builder for power platform application development
CN109614084A (en) Web program and its Quick Development Framework, development approach and relevant device
CN103399746B (en) Information management system convenient to develop secondarily and development method
CN102486731A (en) Method, device and system for enhancing visualization of software call stack of software
CN102663614B (en) Customer relation management is to the collocation method of service release and system
US20080022258A1 (en) Custom database system and method of building and operating the same
US8631393B2 (en) Custom database system and method of building and operating the same
CN110489109A (en) The method and device of code reuse

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20171107

Termination date: 20201202