Main Page | Class Hierarchy | Alphabetical List | Class List | File List | Class Members | Related Pages
DBUtil.java

00001 package edu.virtualschool.jwaa.dbms;
00002 
00003 import java.util.Collection;
00004 import java.util.Iterator;
00005 
00006 import org.apache.log4j.Logger;
00007 
00011 public class DBUtil
00012 {
00013   private final static Logger logger = Logger.getLogger(DBUtil.class.getName());
00014 
00018   public final static String quote(final Object o)
00019   {
00020     if (o == null)
00021       return "\"null\"";
00022     final String s = o.toString();
00023     int n = 0;
00024     for (int i = 0; i < s.length(); i++)
00025       if (s.charAt(i) == '"')
00026         n++;
00027     if (n == 0)
00028       return "\"" + s + "\"";
00029 
00030     StringBuffer buf = new StringBuffer(s.length() + n);
00031     for (int i = 0; i < s.length(); i++)
00032     {
00033       if (s.charAt(i) == '"')
00034         buf.append("\\\"");
00035       else
00036         buf.append(s.charAt(i));
00037     }
00038     return buf.toString();
00039   }
00044   public final static String asSQLSet(Object[] list)
00045   {
00046     int l = list.length;
00047     StringBuffer buf = new StringBuffer();
00048     for (int i = 0; i < l; i++)
00049       buf.append("'" + list[i] + "'" + (i < l - 1 ? "," : ""));
00050     return buf.toString();
00051   }
00059   public final static String asSQLSet(Collection list)
00060   {
00061     StringBuffer buf = new StringBuffer();
00062     for (Iterator it = list.iterator(); it.hasNext();)
00063       buf.append("'" + it.next() + "'" + (it.hasNext() ? "," : ""));
00064     return buf.toString();
00065   }
00066 }