KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > xquark > mapper > dbms > SQLStatementCustomizer


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.mapper.dbms;
24
25 /**
26  * This object perform simple SQL statement customization.
27  *
28  */
29 public class SQLStatementCustomizer
30 {
31     private static final String JavaDoc RCSRevision = "$Revision: 1.1 $";
32     private static final String JavaDoc RCSName = "$Name: $";
33
34     private String JavaDoc preparedStatement = null;
35
36     /**
37      * Constructor for SQLStatementCustomizer.
38      */
39     public SQLStatementCustomizer(String JavaDoc statement)
40     {
41         preparedStatement = statement;
42     }
43
44     public String JavaDoc getTableCreationStatement(
45         String JavaDoc tableName,
46         String JavaDoc columnSpecs)
47     {
48         StringBuffer JavaDoc sb = new StringBuffer JavaDoc();
49         int offset = preparedStatement.indexOf('?');
50         sb.append(preparedStatement.substring(0, offset));
51         sb.append(tableName);
52         int offset2 = preparedStatement.indexOf('?', offset + 1);
53         sb.append(preparedStatement.substring(offset + 1, offset2));
54         sb.append(columnSpecs);
55         sb.append(preparedStatement.substring(offset2 + 1));
56         return sb.toString();
57     }
58
59     public String JavaDoc getSelectStatement(
60         String JavaDoc columnList,
61         String JavaDoc tableName,
62         String JavaDoc filterClause)
63     {
64         StringBuffer JavaDoc sb = new StringBuffer JavaDoc();
65         int offset = preparedStatement.indexOf('?');
66         sb.append(preparedStatement.substring(0, offset));
67         sb.append(columnList);
68         int offset2 = preparedStatement.indexOf('?', offset + 1);
69         sb.append(preparedStatement.substring(offset + 1, offset2));
70         sb.append(tableName);
71         offset = offset2 + 1;
72         offset2 = preparedStatement.indexOf('?', offset);
73         sb.append(preparedStatement.substring(offset, offset2));
74         sb.append(filterClause);
75         sb.append(preparedStatement.substring(offset2 + 1));
76         return sb.toString();
77     }
78 }
79
Popular Tags