util/SQL_Encode.java

   1
   2 package org.de.metux.util;
   3
   4 public class SQL_Encode
   5 {
   6     public static String Text(String s)
   7     {
   8         if (s==null)
   9             return null;
  10
  11         return "'"+escape(s)+"'";
  12     }
  13
  14     public static String escape(String s)
  15     {
  16         if (s==null)
  17             return "";
  18
  19         char[] chars = s.toCharArray();
  20
  21         String res = "";
  22         for (int x=0; x<chars.length; x++)
  23         {
  24             switch (chars[x])
  25             {
  26                 case '\'':      res += "\\'";           break;
  27                 case '"':       res += "\\\"";          break;
  28                 default:        res += chars[x];        break;
  29             }
  30         }
  31         return res;
  32     }
  33
  34     public static String Name(String s)
  35     {
  36         if (s==null)
  37             return "";
  38         return "\""+escape(s)+"\"";
  39     }
  40
  41     public static String Float(float f)
  42     {
  43         return "'"+f+"'";
  44     }
  45
  46     public static String Oid(long oid)
  47     {
  48         return String.valueOf(oid);
  49     }
  50 }