程序设计sql文中特殊字符转换函数

 public String getLike(String key)
 {
  String strReturn;
  if(!"".equals(key) && null!=key)
  {
   key = key.replace("'","''");
   key = key.replace("[","/[");
   key = key.replace("]","/]");
   key = key.replace("%","/%");
   key = key.replace("&","/&");
   key = key.replace("_","/_");
   key = key.replace("(","/(");
   key = key.replace(")","/)");
  }
  strReturn = " like '%" + key + "%' escape '/'";
  return strReturn;
 } 

需要实例发email：xufl@jsmstc.com