KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > xquark > extractor > microsoft > sql > SfSubString


1 /*
2  * This file belongs to the XQuark distribution.
3  * Copyright (C) 2003 Universite de Versailles Saint-Quentin.
4  *
5  * This program is free software; you can redistribute it and/or
6  * modify it under the terms of the GNU Lesser General Public
7  * License as published by the Free Software Foundation; either
8  * version 2.1 of the License, or (at your option) any later version.
9  *
10  * This program is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13  * Lesser General Public License for more details.
14  *
15  * You should have received a copy of the GNU Lesser General Public
16  * License along with this program; if not, write to the Free Software
17  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307.
18  * You can also get it at http://www.gnu.org/licenses/lgpl.html
19  *
20  * For more information on this software, see http://www.xquark.org.
21  */
22
23
24
25 package org.xquark.extractor.microsoft.sql;
26
27
28 import org.xquark.extractor.sql.Context;
29 import org.xquark.extractor.sql.SqlExpression;
30
31 public class SfSubString extends org.xquark.extractor.sql.SfSubString
32 {
33
34     private static final String JavaDoc RCSRevision = "$Revision: 1.4 $";
35     private static final String JavaDoc RCSName = "$Name: $";
36
37
38     public SfSubString()
39     {
40         super();
41     }
42
43     public SfSubString(SqlExpression arg0, SqlExpression arg1)
44     {
45         super(arg0, arg1);
46     }
47
48     public SfSubString(SqlExpression arg0, SqlExpression arg1, SqlExpression arg2)
49     {
50         super(arg0, arg1, arg2);
51     }
52
53     public String JavaDoc toSql (Context context)
54     {
55         //Trace.enter(this,"toSql");
56
57
58         StringBuffer JavaDoc retVal = new StringBuffer JavaDoc();
59         String JavaDoc arg0 = null;
60         String JavaDoc arg1 = null;
61         String JavaDoc arg2 = null;
62
63         retVal.append("SUBSTRING(");
64         arg0 = getArgument(0).toSql(context);
65         retVal.append(arg0);
66         int num = getArgumentNumber();
67
68         arg1 = getArgument(1).toSql(context);
69         retVal.append(",");
70         retVal.append(arg1);
71
72         if ( 2 < num){
73             retVal.append(",");
74             arg2 = getArgument(2).toSql(context);
75             retVal.append(arg2);
76         }
77         else {
78             retVal.append(",");
79             retVal.append("LEN(");
80             retVal.append(arg0);
81             retVal.append(")");
82             /* the following is not neccessary
83             retVal.append("-");
84             retVal.append(arg1);
85             retVal.append("+1");
86             */
87         }
88         retVal.append(")");
89
90         //Trace.exit(this,"toSql");
91 return retVal.toString();
92     }
93 }
94
Popular Tags