Return to DBFront.java CVS log

Up to [Repository] / FM2SQL / src

version info print added
quick hack for fieldName Conversion from create statement if select statement contains columnnames pre/post sql command execution works

    1: /**
    2:  * DBFront - DBFrontEnd
    3:  *
    4:  * @author rogo
    5:  */
    6: import java.util.*;
    7: public class DBFront
    8: {
    9:   static String url = "jdbc:odbc:rogo2";
   10:   static DBBean bean = new DBBean();
   11:   String query;
   12: 
   13:   public DBFront()
   14:   {
   15: 
   16:   }
   17: 
   18:   public boolean query()
   19:   {
   20:     return query(query, url);
   21:   }
   22: 
   23:   public boolean query(String query)
   24:   {
   25:     return query(query, url);
   26: 
   27:   }
   28:   public boolean query(String query, String url)
   29:   {
   30: 
   31:     this.query = query;
   32:     DBFront.url = url;
   33:     try
   34:     {
   35:       if (query != "")
   36:       {
   37:         bean.setURL(url);
   38:         bean.getConnection();
   39:         bean.makeQuery(query, 0);
   40: 
   41:       } else
   42:         throw new Exception("Empty Query");
   43: 
   44:     } catch (Exception e)
   45:     {
   46:       return false;
   47:     }
   48:     return true;
   49:   }
   50:   public Vector[] getQueryData()
   51:   {
   52:     Vector[] vecs = null;
   53:     try
   54:     {
   55: 
   56:       vecs = bean.getQueryData(query, 0);
   57: 
   58:     } catch (Exception e)
   59:     {
   60:       System.out.println("Error getting queryData " + e);
   61:     }
   62:     return vecs;
   63:   }
   64:   public Vector getNextRow()
   65:   {
   66:     Vector vec = null;
   67:     try
   68:     {
   69:       vec = bean.getNextRow();
   70:     } catch (Exception e)
   71:     {
   72:       System.out.println("Error getting next row " + e);
   73:     }
   74: 
   75:     return vec;
   76:   }
   77:   public Vector getColumnNames()
   78:   {
   79: 
   80:     return bean.getColumnNames();
   81:   }
   82: 
   83:   public void setURL(String url)
   84:   {
   85:     DBFront.url = url;
   86: 
   87:   }
   88:   public void setQuery(String query)
   89:   {
   90:     this.query = query;
   91: 
   92:   }
   93:   public void setUrlAndQuery(String url, String query)
   94:   {
   95:     DBFront.url = url;
   96:     this.query = query;
   97: 
   98:   }
   99:   public void setUserAndPasswd(String user, String passwd)
  100:   {
  101:     bean.setUserAndPasswd(user, passwd);
  102:   }
  103:   public void setUser(String user)
  104:   {
  105:     bean.setUser(user);
  106:   }
  107:   public void setPasswd(String passwd)
  108:   {
  109:     bean.setPasswd(passwd);
  110:   }
  111:   public void setConnection(String url)
  112:   {
  113:     try
  114:     {
  115:       bean.setConnection(url);
  116:     } catch (Exception e)
  117:     {
  118:       System.out.println(e);
  119:     }
  120:   }
  121: public void setConnection(String url,String user,String passwd)
  122:   {
  123:     try
  124:     {
  125:       bean.setConnection(url,user,passwd);
  126:     } catch (Exception e)
  127:     {
  128:       System.out.println(e);
  129:     }
  130:   }
  131: }