Utils-防SQL注入参数校验工具类

最新推荐文章于 2025-07-10 18:17:47 发布

斯普润布特

最新推荐文章于 2025-07-10 18:17:47 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： Utils DBA 文章标签： Mr.chenyb

本文链接：https://blog.youkuaiyun.com/scdncby/article/details/90211968

package com.utils;

import javafx.beans.binding.When;
import org.apache.commons.lang3.StringUtils;
import org.apache.ibatis.annotations.Case;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class ConvertUtils {
	
    public static  Logger logger = LoggerFactory.getLogger(ConvertUtils.class);
			
	public final static String regex = "'|#|%|;|--| and | and|and | or | or|or | not | not|not " +
			"| use | use|use | insert | insert|insert | delete | delete|delete | update | update|update " +
			"| select | select|select | count | count|count | group | group|group | union | union|union " +
			"| create | create|create | drop | drop|drop | truncate | truncate|truncate | alter | alter|alter " +
			"| grant | grant|grant | execute | execute|execute | exec | exec|exec | xp_cmdshell | xp_cmdshell|xp_cmdshell " +
			"| call | call|call | declare | declare|declare | source | source|source | sql | sql|sql ";

    /**
     * 
     * @param