KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > apache > ojb > broker > accesslayer > sql > SqlInsertMNStatement


1 package org.apache.ojb.broker.accesslayer.sql;
2
3 /* Copyright 2002-2005 The Apache Software Foundation
4  *
5  * Licensed under the Apache License, Version 2.0 (the "License");
6  * you may not use this file except in compliance with the License.
7  * You may obtain a copy of the License at
8  *
9  * http://www.apache.org/licenses/LICENSE-2.0
10  *
11  * Unless required by applicable law or agreed to in writing, software
12  * distributed under the License is distributed on an "AS IS" BASIS,
13  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14  * See the License for the specific language governing permissions and
15  * limitations under the License.
16  */
17
18 import org.apache.ojb.broker.util.logging.Logger;
19
20 /**
21  * Model an INSERT Statement for M:N indirection table
22  *
23  * @author <a HREF="mailto:jbraeuchi@hotmail.com">Jakob Braeuchi</a>
24  * @version $Id: SqlInsertMNStatement.java,v 1.7.2.1 2005/12/21 22:23:44 tomdz Exp $
25  */
26 public class SqlInsertMNStatement extends SqlMNStatement
27 {
28
29     /**
30      * Constructor for SqlInsertMNStatement.
31      * @param table
32      * @param columns
33      */
34     public SqlInsertMNStatement(String JavaDoc table, String JavaDoc[] columns, Logger logger)
35     {
36         super (table, columns, logger);
37     }
38
39     /**
40      * generates a values(?,) for a prepared insert statement.
41      * @param stmt the StringBuffer
42      */
43     private void appendListOfValues(StringBuffer JavaDoc stmt)
44     {
45         int cnt = getColumns().length;
46
47         stmt.append(" VALUES (");
48
49         for (int i = 0; i < cnt; i++)
50         {
51             if (i > 0)
52             {
53                 stmt.append(',');
54             }
55             stmt.append('?');
56         }
57         stmt.append(')');
58     }
59
60     /**
61      * @see org.apache.ojb.broker.accesslayer.SqlStatement#getStatement()
62      */
63     public String JavaDoc getStatement()
64     {
65         StringBuffer JavaDoc stmt = new StringBuffer JavaDoc(1024);
66
67         stmt.append("INSERT INTO ");
68         appendTable(getTable(),stmt);
69         stmt.append(" (");
70         appendListOfColumns(getColumns(),stmt);
71         stmt.append(")");
72         appendListOfValues(stmt);
73         return stmt.toString();
74     }
75
76 }
77
78
Popular Tags