欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

java防止sql注入,javasql注入,public final

来源: javaer 分享于  点击 31925 次 点评:216

java防止sql注入,javasql注入,public final


public final static String filterSQLInjection(String s) {    if (s == null || "".equals(s)) {        return "";    }    try {        s = s.trim().replaceAll("</?[s,S][c,C][r,R][i,I][p,P][t,T]>?", "");//script        s = s.trim().replaceAll("[a,A][l,L][e,E][r,R][t,T]\\(", "").replace("\"", "");// alert        s = s.trim().replace("\\.swf", "").replaceAll("\\.htc", "");        s = s.trim().replace("\\.php\\b", "").replaceAll("\\.asp\\b", "");        s = s.trim().replace("document\\.", "").replaceAll("[e,E][v,V][a,A][l,L]\\(", "");        s = s.trim().replaceAll("'", "").replaceAll(">", "");        s = s.trim().replaceAll("<", "").replaceAll("=", "");        s = s.trim().replaceAll(" [o,O][r,R]", "");        s = s.trim().replaceAll("etc/", "").replaceAll("cat ", "");        s = s.trim().replaceAll("/passwd ", "");        s = s.trim().replaceAll("sleep\\(", "").replaceAll("limit ", "").replaceAll("LIMIT ", "");        s = s.trim().replaceAll("[d,D][e,E][l,L][e,E][t,T][e,E] ", "");// delete        s = s.trim().replaceAll("[s,S][e,E][l,L][e,E][c,C][t,T] ", "");// select;        s = s.trim().replaceAll("[u,U][p,P][d,D][a,A][t,T][e,E] ", "");// update        s = s.trim().replaceAll("[d,D][e,E][l,L][a,A][y,Y] ", "").replaceAll("waitfor ", "");        s = s.trim().replaceAll("print\\(", "").replaceAll("md5\\(", "");        s = s.trim().replaceAll("cookie\\(", "").replaceAll("send\\(", "");        s = s.trim().replaceAll("response\\.", "").replaceAll("write\\(", "")                .replaceAll("&amp;", "");    } catch (Exception e) {        e.printStackTrace();        return "";    }    return s;} 
相关栏目:

用户点评