Abnormal verification method and device of sql, storage medium and equipment

• Main Author: ZHANG DELEI
• Format: Patent
• Language: Chinese; English
• Published: 29.11.2022
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention discloses an exception verification method and device of sql, a storage medium and equipment, relates to the technical field of computers, and can solve the technical problems of large workload and low efficiency of exception verification of the sql method. The method comprises the steps that an application system quotes a mybatis framework, a user-defined interceptor is configured in the mybatis framework, and the user-defined interceptor identifies a target sql method needing to be intercepted and an annotation corresponding to the target sql method; scanning whether the target sql method is executed or not, and if yes, verifying the target sql method according to the annotation. 本发明公开了一种sql的异常校验方法、装置、存储介质及设备，涉及计算机技术领域，可解决sql方法异常校验的工作量大且效率不高的技术问题。其中方法包括：应用系统引用mybatis框架，在mybatis框架配置自定义拦截器，其中，自定义拦截器标识了需要拦截的目标sql方法以及与目标sql方法对应的注解；扫描是否执行目标sql方法，若是，则根据注解对目标sql方法进行校验。