1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
|
package oracle.forms.demos.stip;
import sun.misc.BASE64Encoder;
import sun.misc.BASE64Decoder;
import javax.swing.*;
import java.awt.FileDialog;
import java.awt.Frame;
import java.awt.Button;
import java.awt.*;
import java.awt.event.*;
import java.io.DataInputStream;
import java.io.FileInputStream;
import java.io.BufferedInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.util.zip.*;
import java.util.StringTokenizer;
import java.io.*;
import java.beans.*;
import java.awt.*;
import java.awt.event.*;
import java.awt.image.*;
import java.beans.*;
import java.net.*;
import javax.swing.filechooser.*;
import oracle.forms.ui.VBean;
import oracle.forms.ui.CustomEvent;
import oracle.forms.handler.IHandler;
import oracle.forms.properties.ID;
import oracle.ewt.meter.ProgressBar;
import oracle.ewt.meter.BoundedRangeModelImpl;
import oracle.ewt.thread.TaskScheduler;
import oracle.ewt.thread.Task;
import oracle.ewt.thread.TaskEvent;
public class clobWrapper extends VBean implements PropertyChangeListener
{
private static final ID file = ID.registerProperty ("file");
private static final ID value = ID.registerProperty ("val");
private static final ID c_lob = ID.registerProperty ("c_lob");//
private static final ID user = ID.registerProperty ("user");//
private static final ID pass = ID.registerProperty ("pass");//
private static final ID port = ID.registerProperty ("port");//
private static final ID db = ID.registerProperty ("db");//
private static final ID serv = ID.registerProperty ("serv");//
private static final ID column = ID.registerProperty ("column");//
private static final ID ins = ID.registerProperty ("ins");//
private static final ID updt = ID.registerProperty ("updt");//
private static final ID c_file = ID.registerProperty ("c_file");//
private static final ID c_path = ID.registerProperty ("c_path");//
private static final ID tbl = ID.registerProperty ("tbl");//
public static final ID changeEvent = ID.registerProperty ("CHANGE");
private Component comp;
private int count;
private IHandler mHandler = null;
private String User = null;
private String Pass = null;
private String Port = null;
private String Db = null;
private String Serv = null;
private String Column = null;
private String Ins = null;
private String Updt = null;
private String C_file = null;
private String C_path = null;
private String Tbl = null;
public void init(IHandler handler) {
System.out.println("0 public void init clobWrapper");
super.init(handler);
System.out.println(" entenring into the compo");
mHandler = handler;
}
public boolean setProperty(ID pid, Object value) {
if (pid == c_lob) {
try {
//dbConnect(String server,String port, String db, String user, String passwd, String slc)
dbConnect dbcon = new dbConnect(Serv, Port, Db, User, Pass,"");
dbcon.openConnection();
//(String file, String path, String table, String inst, String column, String forup)
String result = dbcon.update_clob(C_file, C_path, Tbl, Ins, Column, Updt);
dbcon.closeConnection();
}
catch(Exception ze) {
System.out.println("~~> "+ze);
}
}
if (pid == user) {
User = value.toString();
return true;
}
if (pid == pass) {
Pass = value.toString();
return true;
}
if (pid == port) {
Port = value.toString();
return true;
}
if (pid == db) {
Db = value.toString();
return true;
}
if (pid == serv) {
Serv = value.toString();
return true;
}
if (pid == column) {
Column = value.toString();
return true;
}
if (pid == ins) {
Ins = value.toString();
return true;
}
if (pid == updt) {
Updt = value.toString();
return true;
}
if (pid == c_file) {
C_file = value.toString();
return true;
}
if (pid == c_path) {
C_path = value.toString();
return true;
}
if (pid == tbl) {
Tbl = value.toString();
return true;
}
if (pid == file) {
try {
getFile gf = new getFile();
gf.addPropertyChangeListener(this);
gf.set_file_name();
System.out.println(gf.getName());
return true;
}
catch(Exception e) {
System.out.println("~~> "+e);
}
}
return true;
}
public clobWrapper() {
}
public void propertyChange(PropertyChangeEvent pce) {
System.out.println("prop changing ok");
String value_this = (String)pce.getNewValue();
System.out.println("value this");
try {
System.out.println("try");
mHandler.setProperty(value,value_this);
System.out.println("ok");
CustomEvent ce = new CustomEvent(mHandler,changeEvent);
dispatchCustomEvent(ce);
}
catch (Exception e) {
System.out.println("catch-->"+e);
}
//CustomEvent ce = new CustomEvent(mHandler,changeEvent);
//dispatchCustomEvent(ce);
}
//if the value change, send a msg
public Object getProperty(ID pid) {
/*
if (pid==value)
{
String res;
dbConnect dbc = new dbConnect("uxhades1dac","1521","ww4d","ext523","changeit","select col1, col3 from TEST_STIP where col 2 = 20");
dbc.openConnection();
res = dbc.getStringResult("col3");
dbc.closeConnection();
System.out.println("value of col3 ==> "+ res);
return res;
}
leningleningreturn = "";*/
return pid;
}
public static void main (String args[]) {
getFile gf = new getFile();
gf.set_file_name();
System.out.println(gf.getName());
}
} |
