Annotation of FM2SQL/src/DBFront.java, revision 1.1
1.1 ! rogo 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: this.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: this.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: this.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: }
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>