KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > dbunit > database > statement > SimpleStatement


1 /*
2  *
3  * The DbUnit Database Testing Framework
4  * Copyright (C)2002-2004, DbUnit.org
5  *
6  * This library is free software; you can redistribute it and/or
7  * modify it under the terms of the GNU Lesser General Public
8  * License as published by the Free Software Foundation; either
9  * version 2.1 of the License, or (at your option) any later version.
10  *
11  * This library is distributed in the hope that it will be useful,
12  * but WITHOUT ANY WARRANTY; without even the implied warranty of
13  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14  * Lesser General Public License for more details.
15  *
16  * You should have received a copy of the GNU Lesser General Public
17  * License along with this library; if not, write to the Free Software
18  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
19  *
20  */

21
22 package org.dbunit.database.statement;
23
24 import java.sql.Connection JavaDoc;
25 import java.sql.SQLException JavaDoc;
26 import java.util.ArrayList JavaDoc;
27 import java.util.List JavaDoc;
28
29 /**
30  * @author Manuel Laflamme
31  * @version $Revision: 1.6 $
32  * @since Feb 20, 2002
33  */

34 public class SimpleStatement extends AbstractBatchStatement
35 {
36     private final List JavaDoc _list = new ArrayList JavaDoc();
37
38     SimpleStatement(Connection JavaDoc connection) throws SQLException JavaDoc
39     {
40         super(connection);
41     }
42
43     public void addBatch(String JavaDoc sql) throws SQLException JavaDoc
44     {
45         _list.add(sql);
46     }
47
48     public int executeBatch() throws SQLException JavaDoc
49     {
50         int result = 0;
51         for (int i = 0; i < _list.size(); i++)
52         {
53             String JavaDoc sql = (String JavaDoc)_list.get(i);
54             boolean r = _statement.execute(sql);
55             if(!r)
56             {
57                 result += _statement.getUpdateCount();
58             }
59         }
60         return result;
61     }
62
63     public void clearBatch() throws SQLException JavaDoc
64     {
65         _list.clear();
66     }
67 }
68
69
70
71
72
73
Popular Tags