Source code: org/objectstyle/ashwood/dbutil/Sequence.java
1 /* ====================================================================
2 *
3 * Copyright(c) 2003, Andriy Shapochka
4 * All rights reserved.
5 *
6 * Redistribution and use in source and binary forms, with or without
7 * modification, are permitted provided that the following conditions
8 * are met:
9 *
10 * 1. Redistributions of source code must retain the above
11 * copyright notice, this list of conditions and the following
12 * disclaimer.
13 *
14 * 2. Redistributions in binary form must reproduce the above
15 * copyright notice, this list of conditions and the following
16 * disclaimer in the documentation and/or other materials
17 * provided with the distribution.
18 *
19 * 3. Neither the name of the ASHWOOD nor the
20 * names of its contributors may be used to endorse or
21 * promote products derived from this software without
22 * specific prior written permission.
23 *
24 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
25 * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
26 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
27 * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
28 * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
29 * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
30 * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
31 * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
32 * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
33 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
34 *
35 * ====================================================================
36 *
37 * This software consists of voluntary contributions made by
38 * individuals on behalf of the ASHWOOD Project and was originally
39 * created by Andriy Shapochka.
40 *
41 */
42
43 package org.objectstyle.ashwood.dbutil;
44
45 import java.io.*;
46
47 public class Sequence implements Serializable {
48
49 private String name = "SEQ";
50 private int increment = 10;
51 private int initialValue = 1;
52
53 public Sequence() {
54 }
55 public Sequence(String name) {
56 setName(name);
57 }
58
59 public String getName() {
60 return name;
61 }
62 public void setName(String name) {
63 this.name = name;
64 }
65 public void setIncrement(int increment) {
66 this.increment = increment;
67 }
68 public int getIncrement() {
69 return increment;
70 }
71 public void setInitialValue(int initialValue) {
72 this.initialValue = initialValue;
73 }
74 public int getInitialValue() {
75 return initialValue;
76 }
77
78 public void toCreateSQL(PrintWriter out) {
79 out.println("CREATE SEQUENCE " + name);
80 out.println(" START WITH " + initialValue);
81 out.print(" INCREMENT BY " + increment);
82 }
83
84 public void toDropSQL(PrintWriter out) {
85 out.print("DROP SEQUENCE " + name);
86 }
87 }