Data authority control method and system based on annotation

The invention discloses an annotation-based data authority control method, which comprises the following steps that: when a certain persistent layer method is executed, an annotation analyzer firstly analyzes a method signature of the method and analyzes a specific execution type; after the signature of the method is obtained, the annotation parser can extract annotation information on the method; and the SQL processor obtains an original SQL statement corresponding to the method and an analysis result of the annotation analyzer according to the method signature. According to the method, the SQL is dynamically compiled through the annotation parameters, the original service codes and SQL statements do not need to be adjusted, only the annotations need to be added to the related service methods, and starting or closing can be automatically controlled; due to the fact that the annotation is in the method level, when one SQL is used in multiple methods and one method is added with the annotation, normal use of t