KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > allinone > MultiReference


1 package allinone;
2
3 import com.lutris.appserver.server.sql.*;
4 import com.lutris.util.*;
5 import org.enhydra.dods.*;
6 import java.sql.SQLException JavaDoc;
7
8
9 import javax.swing.*;
10 import java.util.*;
11 import java.awt.*;
12 import java.awt.event.*;
13 import java.net.*;
14 import java.io.*;
15 import org.apache.log4j.Logger;
16 import org.apache.log4j.xml.DOMConfigurator;
17 import com.lutris.appserver.server.sql.*;
18 import allinone.data.tableA.*;
19 import allinone.data.tableB.*;
20 import allinone.data.tableC.*;
21 import allinone.data.tableD.*;
22
23 public class MultiReference{
24     void showTables(DBTransaction dbTrans){
25         try{
26             NDCTableAQuery queryA = new NDCTableAQuery(dbTrans);
27             NDCTableADO[] allADO = queryA.getDOArray();
28             System.err.println();
29             System.err.println("-------------TableA-----begin----------");
30             if(allADO!=null) {
31                 if(allADO.length>0)System.err.println("---oid------someData------refToC---refToD-----");
32                 for(int i=0; i<allADO.length; i++){
33                     System.err.print(" "+allADO[i].getHandle());
34                     System.err.print(" "+allADO[i].getSomedata());
35                     System.err.print(" "+(null != allADO[i].getReftoc()?allADO[i].getReftoc().getHandle():"null"));
36                     System.err.print(" "+(null != allADO[i].getReftob()?allADO[i].getReftob().getHandle():"null"));
37                     System.err.println();
38                 }
39             } else {
40                 System.err.println("noData");
41             }
42             System.err.println("-------------TableA-----end------------");
43
44             NDCTableBQuery queryB = new NDCTableBQuery(dbTrans);
45             NDCTableBDO[] allBDO = queryB.getDOArray();
46             System.err.println();
47             System.err.println("-------------TableB-----begin----------");
48             if(allBDO!=null) {
49                 if(allBDO.length>0)System.err.println("---oid------someData------refToD-----");
50                 for(int i=0; i<allBDO.length; i++){
51                     System.err.print(" "+allBDO[i].getHandle());
52                     System.err.print(" "+allBDO[i].getSomedata());
53                     System.err.print(" "+(null != allBDO[i].getReftod()?allBDO[i].getReftod().getHandle():"null"));
54                     System.err.println();
55                 }
56             } else {
57                 System.err.println("noData");
58             }
59             System.err.println("-------------TableB-----end------------");
60
61             NDCTableCQuery queryC = new NDCTableCQuery(dbTrans);
62             NDCTableCDO[] allCDO = queryC.getDOArray();
63             System.err.println();
64             System.err.println("-------------TableC-----begin----------");
65             if(allCDO!=null) {
66                 if(allCDO.length>0)System.err.println("---oid------someData------refToD-----");
67                 for(int i=0; i<allCDO.length; i++){
68                     System.err.print(" "+allCDO[i].getHandle());
69                     System.err.print(" "+allCDO[i].getSomedata());
70                     System.err.print(" "+(null != allCDO[i].getReftod()?allCDO[i].getReftod().getHandle():"null"));
71                     System.err.println();
72                 }
73             } else {
74                 System.err.println("noData");
75             }
76             System.err.println("-------------TableC-----end------------");
77
78             NDCTableDQuery queryD = new NDCTableDQuery(dbTrans);
79             NDCTableDDO[] allDDO = queryD.getDOArray();
80             System.err.println();
81             System.err.println("-------------TableD-----begin----------");
82             if(allDDO!=null) {
83                 if(allDDO.length>0)System.err.println("---oid------someData--------");
84                 for(int i=0; i<allDDO.length; i++){
85                     System.err.print(" "+allDDO[i].getHandle());
86                     System.err.print(" "+allDDO[i].getSomedata());
87                     System.err.println();
88                 }
89             } else {
90                 System.err.println("noData");
91             }
92             System.err.println("-------------TableD-----end------------");
93         }catch(Exception JavaDoc e){
94             e.printStackTrace();
95         }
96     }
97
98     public void runTest(DBTransaction dbTrans1) {
99         try {
100             boolean autoWrite = ((StandardDatabaseManager)DODS.getDatabaseManager()).getDatabaseManagerConfiguration().getAutoWrite();
101             System.err.println("___ - + * startin MultRef with unDelete * + - ___");
102             showTables(dbTrans1);
103
104             NDCTableDDO tableD1 = NDCTableDDO.createVirgin(dbTrans1);
105             tableD1.setSomedata("tableD1");
106             tableD1.save();
107             NDCTableDDO tableD2 = NDCTableDDO.createVirgin(dbTrans1);
108             tableD2.setSomedata("tableD2");
109             tableD2.save();
110             NDCTableDDO tableD3 = NDCTableDDO.createVirgin(dbTrans1);
111             tableD3.setSomedata("tableD3");
112             tableD3.save();
113             NDCTableDDO tableD4 = NDCTableDDO.createVirgin(dbTrans1);
114             tableD4.setSomedata("tableD4");
115             tableD4.save();
116             NDCTableDDO tableD5 = NDCTableDDO.createVirgin(dbTrans1);
117             tableD5.setSomedata("tableD5");
118             tableD5.save();
119             NDCTableDDO tableD6 = NDCTableDDO.createVirgin(dbTrans1);
120             tableD6.setSomedata("tableD6");
121             tableD6.save();
122             if(!autoWrite)
123                 dbTrans1.write();
124
125             NDCTableCDO tableC1 = NDCTableCDO.createVirgin(dbTrans1);
126             tableC1.setSomedata("tableC1");
127             tableC1.setReftod(tableD1);
128             tableC1.save();
129             NDCTableCDO tableC2 = NDCTableCDO.createVirgin(dbTrans1);
130             tableC2.setSomedata("tableC2");
131             tableC2.setReftod(tableD2);
132             tableC2.save();
133             NDCTableCDO tableC3 = NDCTableCDO.createVirgin(dbTrans1);
134             tableC3.setSomedata("tableC3");
135             tableC3.setReftod(tableD3);
136             tableC3.save();
137             NDCTableCDO tableC4 = NDCTableCDO.createVirgin(dbTrans1);
138             tableC4.setSomedata("tableC4");
139             tableC4.setReftod(tableD4);
140             tableC4.save();
141             NDCTableCDO tableC5 = NDCTableCDO.createVirgin(dbTrans1);
142             tableC5.setSomedata("tableC5");
143             tableC5.setReftod(tableD5);
144             tableC5.save();
145             NDCTableCDO tableC6 = NDCTableCDO.createVirgin(dbTrans1);
146             tableC6.setSomedata("tableC6");
147             tableC6.setReftod(tableD6);
148             tableC6.save();
149             if(!autoWrite)
150                 dbTrans1.write();
151
152             NDCTableBDO tableB1 = NDCTableBDO.createVirgin(dbTrans1);
153             tableB1.setSomedata("tableB1");
154             tableB1.setReftod(tableD1);
155             tableB1.save();
156             NDCTableBDO tableB2 = NDCTableBDO.createVirgin(dbTrans1);
157             tableB2.setSomedata("tableB2");
158             tableB2.setReftod(tableD2);
159             tableB2.save();
160             NDCTableBDO tableB3 = NDCTableBDO.createVirgin(dbTrans1);
161             tableB3.setSomedata("tableB3");
162             tableB3.setReftod(tableD3);
163             tableB3.save();
164             NDCTableBDO tableB4 = NDCTableBDO.createVirgin(dbTrans1);
165             tableB4.setSomedata("tableB4");
166             tableB4.setReftod(tableD4);
167             tableB4.save();
168             NDCTableBDO tableB5 = NDCTableBDO.createVirgin(dbTrans1);
169             tableB5.setSomedata("tableB5");
170             tableB5.setReftod(tableD5);
171             tableB5.save();
172             NDCTableBDO tableB6 = NDCTableBDO.createVirgin(dbTrans1);
173             tableB6.setSomedata("tableB6");
174             tableB6.setReftod(tableD6);
175             tableB6.save();
176             if(!autoWrite)
177                 dbTrans1.write();
178
179             NDCTableADO tableA1 = NDCTableADO.createVirgin(dbTrans1);
180             tableA1.setSomedata("tableA1");
181             tableA1.setReftob(tableB1);
182             tableA1.setReftoc(tableC1);
183             tableA1.save();
184             NDCTableADO tableA2 = NDCTableADO.createVirgin(dbTrans1);
185             tableA2.setSomedata("tableA2");
186             tableA2.setReftob(tableB2);
187             tableA2.setReftoc(tableC2);
188             tableA2.save();
189             NDCTableADO tableA3 = NDCTableADO.createVirgin(dbTrans1);
190             tableA3.setSomedata("tableA3");
191             tableA3.setReftob(tableB3);
192             tableA3.setReftoc(tableC3);
193             tableA3.save();
194             NDCTableADO tableA4 = NDCTableADO.createVirgin(dbTrans1);
195             tableA4.setSomedata("tableA4");
196             tableA4.setReftob(tableB4);
197             tableA4.setReftoc(tableC4);
198             tableA4.save();
199             NDCTableADO tableA5 = NDCTableADO.createVirgin(dbTrans1);
200             tableA5.setSomedata("tableA5");
201             tableA5.setReftob(tableB5);
202             tableA5.setReftoc(tableC5);
203             tableA5.save();
204             NDCTableADO tableA6 = NDCTableADO.createVirgin(dbTrans1);
205             tableA6.setSomedata("tableA6");
206             tableA6.setReftob(tableB6);
207             tableA6.setReftoc(tableC6);
208             tableA6.save();
209             if(!autoWrite)
210                 dbTrans1.write();
211             dbTrans1.commit();
212             //dbTrans1.release();
213
//dbTrans1 = DODS.getDatabaseManager().createTransaction();
214

215             System.err.println("rows inserted");
216             showTables(dbTrans1);
217
218             System.err.print("delete1 --- ");
219             tableD1.delete();
220             System.err.print("delete2 --- ");
221             tableD2.delete();
222             System.err.print("delete3 --- ");
223             tableD3.delete();
224             System.err.print("delete4 --- ");
225             tableD4.delete();
226             System.err.print("delete5 --- ");
227             tableD5.delete();
228             System.err.println("delete6 ---");
229             tableD6.delete();
230             if(!autoWrite)
231                 dbTrans1.write();
232
233             showTables(dbTrans1);
234
235             System.err.print("unDelete1 --- ");
236             tableD1.unDelete();
237             System.err.println("newD1:"+tableD1.getHandle());
238             System.err.print("unDelete2 --- ");
239             tableD2.unDelete();
240             System.err.println("newD2:"+tableD2.getHandle());
241             if(!autoWrite)
242                 dbTrans1.write();
243
244             System.err.println("after undelete there are two D's, aren't they?");
245             showTables(dbTrans1);
246
247             tableD1.delete();
248             tableD2.delete();
249
250             if (null != dbTrans1)
251                 dbTrans1.commit();
252             System.err.println("that's all folks, table are empty now, I hope :) ");
253             showTables(dbTrans1);
254         }catch (Exception JavaDoc ex){
255             System.err.println(ex.toString());
256             ex.printStackTrace();
257         }
258     }
259 }
260
Popular Tags