KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > xquark > extractor > mysql > sql > SqlIfThenElse


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 package org.xquark.extractor.mysql.sql;
24
25 import org.xquark.extractor.sql.Context;
26 import org.xquark.extractor.sql.SqlExpression;
27
28 public class SqlIfThenElse extends org.xquark.extractor.sql.SqlIfThenElse
29 {
30
31     private static final String JavaDoc RCSRevision = "$Revision: 1.3 $";
32     private static final String JavaDoc RCSName = "$Name: $";
33
34
35     public SqlIfThenElse() {
36     }
37
38     public SqlIfThenElse(SqlExpression iif, SqlExpression tthen, SqlExpression eslse) {
39         super(iif, tthen, eslse);
40     }
41
42
43     public String JavaDoc toSql (Context context)
44     {
45         //Trace.enter(this,"toSql");
46
47         StringBuffer JavaDoc retVal = new StringBuffer JavaDoc();
48         retVal.append("CASE WHEN ( ");
49         retVal.append(_if.toSql(context));
50         retVal.append(") THEN (");
51         retVal.append(_then.toSql(context));
52
53         retVal.append(") ELSE (");
54         retVal.append(_else.toSql(context));
55         retVal.append(") END");
56
57         //Trace.exit(this,"toSql");
58 return retVal.toString();
59     }
60 }
61
Popular Tags