|
1 package jimm.datavision.testdata.oracle;
2 import jimm.datavision.testdata.Office;
3 import jimm.datavision.testdata.Job;
4 import jimm.datavision.testdata.AggregateTestData;
5 import java.util.Iterator  ;
6 import java.util.Calendar ;
7
8 class CreateData {
9
10 public static void main(String [] args) {
11 System.out.println("delete from office;");
12 for (Iterator iter = Office.offices(); iter.hasNext(); ) {
13 Office o = (Office)iter.next();
14 System.out.println("insert into office values (" + o.id + ", '"
15 + o.name + "', '" + o.abbrev + "', '" + o.fax
16 + "', '" + o.email + "', '"
17 + (o.visible ? 'Y' : 'N') + "');");
18 }
19
20 System.out.println("delete from jobs;");
21 for (Iterator iter = Job.jobs(); iter.hasNext(); ) {
22 Job j = (Job)iter.next();
23 System.out.println("insert into jobs values (" + j.id + ", '"
24 + j.title + "', " + j.fk_office_id + ", '"
25 + j.company + "', '" + j.location + "', '"
26 + j.description + "', '"
27 + (j.visible ? 'Y' : 'N') + "', to_date('"
28 + j.post_date.get(Calendar.YEAR) + '-'
29 + (j.post_date.get(Calendar.MONTH) + 1) + '-'
30 + j.post_date.get(Calendar.DATE)
31 + "','yyyy-mm-dd'), "
32 + (j.hourly_rate == null ? "NULL"
33 : j.hourly_rate.toString())
34 + ");");
35 }
36
37 System.out.println("delete from aggregate_test;");
38 for (Iterator iter =
39 AggregateTestData.aggregateTestData("../aggregate_test.dat");
40 iter.hasNext(); ) {
41 AggregateTestData data = (AggregateTestData)iter.next();
42 System.out.println("insert into aggregate_test values ('" + data.col1()
43 + "', '" + data.col2() + "', " + data.value()
44 + ");");
45
46 }
47 }
48
49 }
50 |
Popular Tags |
Java API By Example, From Geeks To Geeks.