01: /*
02: * Created on 15/02/2004
03: *
04: * Swing Components - visit http://sf.net/projects/gfd
05: *
06: * Copyright (C) 2004 Igor Regis da Silva Simões
07: *
08: * This program is free software; you can redistribute it and/or
09: * modify it under the terms of the GNU General Public License
10: * as published by the Free Software Foundation; either version 2
11: * of the License, or (at your option) any later version.
12: *
13: * This program is distributed in the hope that it will be useful,
14: * but WITHOUT ANY WARRANTY; without even the implied warranty of
15: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16: * GNU General Public License for more details.
17: *
18: * You should have received a copy of the GNU General Public License
19: * along with this program; if not, write to the Free Software
20: * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
21: */
22:
23: package br.com.gfp.dao;
24:
25: import java.sql.ResultSet;
26: import java.sql.SQLException;
27:
28: import javax.swing.event.EventListenerList;
29:
30: import br.com.gfp.data.Assets;
31: import br.com.gfpshare.db.AbstractDAO;
32: import br.com.gfpshare.db.SQLCondition;
33: import br.com.gfpshare.db.SQLCondition.Condicao;
34:
35: /**
36: * Controler para os bens
37: * A idéia é que esta classe realize a formulação de relatórios.
38: * @author Igor Regis da Silva Simoes
39: */
40: public class AssetsDAO extends AbstractDAO<Assets> {
41: /**
42: * Lista de listeners de eventos do controller
43: */
44: private static final EventListenerList listeners = new EventListenerList();
45:
46: /**
47: * @see br.com.gfpshare.db.AbstractDAO#getListeners()
48: */
49: @Override
50: protected EventListenerList getListeners() {
51: return listeners;
52: }
53:
54: public Double somaValorAtual() throws SQLException {
55: Assets arg = new Assets();
56: arg.addCondicaoExtra(new SQLCondition<Integer>("DataVenda",
57: Condicao.IS_NULL));
58: ResultSet rs = executarSQL(arg,
59: "select sum(\"ValorAtual\") from \"Bem\"", true, false);
60: rs.first();
61: return rs.getDouble(1);
62: }
63: }
|