01: /*
02: *
03: * The DbUnit Database Testing Framework
04: * Copyright (C)2002-2004, DbUnit.org
05: *
06: * This library is free software; you can redistribute it and/or
07: * modify it under the terms of the GNU Lesser General Public
08: * License as published by the Free Software Foundation; either
09: * 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 org.slf4j.Logger;
25: import org.slf4j.LoggerFactory;
26:
27: import java.sql.Connection;
28: import java.sql.SQLException;
29: import java.util.ArrayList;
30: import java.util.List;
31:
32: /**
33: * @author Manuel Laflamme
34: * @version $Revision: 554 $
35: * @since Feb 20, 2002
36: */
37: public class SimpleStatement extends AbstractBatchStatement {
38:
39: /**
40: * Logger for this class
41: */
42: private static final Logger logger = LoggerFactory
43: .getLogger(SimpleStatement.class);
44:
45: private final List _list = new ArrayList();
46:
47: SimpleStatement(Connection connection) throws SQLException {
48: super (connection);
49: }
50:
51: public void addBatch(String sql) throws SQLException {
52: logger.debug("addBatch(sql=" + sql + ") - start");
53:
54: _list.add(sql);
55: }
56:
57: public int executeBatch() throws SQLException {
58: logger.debug("executeBatch() - start");
59:
60: int result = 0;
61: for (int i = 0; i < _list.size(); i++) {
62: String sql = (String) _list.get(i);
63: boolean r = _statement.execute(sql);
64: if (!r) {
65: result += _statement.getUpdateCount();
66: }
67: }
68: return result;
69: }
70:
71: public void clearBatch() throws SQLException {
72: logger.debug("clearBatch() - start");
73:
74: _list.clear();
75: }
76: }
|