Annotation of FM2SQL/DBFront.java, revision 1.1.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>