dataformat.java

连接mysql数据库的javabean

package bean.format;
public class dataFormat{
public static String strReplace(String sBody,String sFrom,String sTo)
{
   int i,j,k,l;
  if((sBody==null)||(sBody.equals("")))return "";
  i=0;
  j=sFrom.length();
  k=sTo.length();
  StringBuffer sss=new StringBuffer(sBody.length());
  boolean bFirst=true;
  l=i;
  while(sBody.indexOf(sFrom,i)!=-1){
  i=sBody.indexOf(sFrom,i);
  sss.append(sBody.substring(l,i));
  sss.append(sTo);
  i+=j;
  l=i;
}
  sss.append(sBody.substring(l));
  return sss.toString();
}
public static String toSql(String str)
{
   String sql=new String(str);
   return strReplace(sql,"'","''");
}
}