Package de.willuhn.datasource.rmi

Examples of de.willuhn.datasource.rmi.DBIterator

582
583
584
585
586
587
588
589
590
  /**
   * @see de.willuhn.jameica.hbci.rmi.Konto#getLastschriften()
   */
  public DBIterator getLastschriften() throws RemoteException
  {
    DBIterator list = getService().createList(Lastschrift.class);
    list.addFilter("konto_id = " + getID());
    return list;
  }
View Full Code Here
592
593
594
595
596
597
598
599
600
  /**
   * @see de.willuhn.jameica.hbci.rmi.Konto#getSammelLastschriften()
   */
  public DBIterator getSammelLastschriften() throws RemoteException
  {
    DBIterator list = getService().createList(SammelLastschrift.class);
    list.addFilter("konto_id = " + getID());
    return list;
  }
View Full Code Here
602
603
604
605
606
607
608
609
610
  /**
   * @see de.willuhn.jameica.hbci.rmi.Konto#getSammelUeberweisungen()
   */
  public DBIterator getSammelUeberweisungen() throws RemoteException
  {
    DBIterator list = getService().createList(SammelUeberweisung.class);
    list.addFilter("konto_id = " + getID());
    return list;
  }
View Full Code Here
630
631
632
633
634
635
636
637
638
639
   */
  public DBIterator getProtokolle() throws RemoteException
  {
    HBCIDBService service = (HBCIDBService) getService();

    DBIterator list = service.createList(Protokoll.class);
    list.addFilter("konto_id = " + getID());
    list.setOrder("ORDER BY " + service.getSQLTimestamp("datum") + " DESC");
    return list;
  }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
  {
    List<Konto> l = new LinkedList<Konto>();
   
    try
    {
      DBIterator konten = de.willuhn.jameica.hbci.Settings.getDBService().createList(Konto.class);
      // Konten-Sortierung immer gleich. Wir verwenden diese Sortierung, damit Konten,
      // die potentiell ueber das gleiche Sicherheitsmedium abgewickelt werden, direkt
      // aufeinander folgen. Das ermoeglicht eine spaetere Gruppierung in einem HBCI-Dialog
      // Anschliessend noch Bezeichnung wegen BUGZILLA 1346, Kommentar 12
      konten.setOrder("order by blz,bic,passport_class,bezeichnung");
     
      while (konten.hasNext())
      {
        Konto k = (Konto) konten.next();
        if (k.hasFlag(Konto.FLAG_DISABLED)) // deaktivierte Konten nicht beruecksichtigen
          continue;
        SynchronizeOptions o = new SynchronizeOptions(k);
        if (o.getSynchronize())
          l.add(k);
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
157
  {
    if (StringUtils.trimToNull(uuid) == null)
      throw new JameicaException("no uuid given");
   
    DBService service = Settings.getDBService();
    DBIterator i = service.createList(DBReminder.class);
    i.addFilter("uuid = ?",uuid);
    if (i.hasNext())
      return (DBReminder) i.next();
   
    return null;
  }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
   
    // Wir speichern die Daten erstmal in einem Hash, damit wir Duplikate rausfischen koennen
    Hashtable hash = new Hashtable();
   
    // Schritt 1: Die Buchungen von Sammel-Auftraegen
    DBIterator list = Settings.getDBService().createList(SammelLastBuchung.class);
    list.addFilter("LOWER(zweck) LIKE ? OR " +
                   "LOWER(zweck2) LIKE ? OR " +
                   "LOWER(zweck3) LIKE ? OR " +
                   "LOWER(gegenkonto_name) LIKE ? OR " +
                   "gegenkonto_nr LIKE ? OR " +
                   "gegenkonto_blz LIKE ?",
                   text,text,text,text,text,text);

    while (list.hasNext())
    {
      SammelLastBuchung buchung = (SammelLastBuchung) list.next();
      SammelLastschrift ueb = (SammelLastschrift) buchung.getSammelTransfer();
      hash.put(ueb.getID(),new MyResult(ueb));
    }
   
    // Schritt 2: Sammel-Auftraege selbst
    list = Settings.getDBService().createList(SammelLastschrift.class);
    list.addFilter("LOWER(bezeichnung) LIKE ?",text);

    while (list.hasNext())
    {
      SammelLastschrift ueb = (SammelLastschrift) list.next();
      hash.put(ueb.getID(),new MyResult(ueb));
    }

    return Arrays.asList(hash.values().toArray(new MyResult[hash.size()]));
  }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
  protected DBIterator getList(Object konto, Date from, Date to, String text) throws RemoteException
  {
    if (konto == null || !(konto instanceof Konto))
        return null;

    DBIterator list = ((Konto) konto).getProtokolle();
    if (from != null) list.addFilter("datum >= ?", new Object[]{new java.sql.Date(DateUtil.startOfDay(from).getTime())});
    if (to   != null) list.addFilter("datum <= ?", new Object[]{new java.sql.Date(DateUtil.endOfDay(to).getTime())});
    if (text != null && text.length() > 0)
    {
      list.addFilter("LOWER(kommentar) like ?", new Object[]{"%" + text.toLowerCase() + "%"});
    }
   
    return list;
  }
View Full Code Here
117
118
119
120
121
122
123
124
125
   */
  private static DBIterator init() throws RemoteException
  {
    HBCIDBService service = (HBCIDBService) Settings.getDBService();

    DBIterator list = service.createList(Nachricht.class);
    list.setOrder("ORDER BY gelesen, blz, " + service.getSQLTimestamp("datum") + " desc");
    return list;
  }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
    if (search == null || search.length() == 0)
      return null;
   
    String text = "%" + search.toLowerCase() + "%";
    HBCIDBService service = (HBCIDBService) Settings.getDBService();
    DBIterator list = service.createList(Dauerauftrag.class);
    list.addFilter("LOWER(zweck) LIKE ? OR " +
                   "LOWER(zweck2) LIKE ? OR " +
                   "LOWER(zweck3) LIKE ? OR " +
                   "LOWER(empfaenger_name) LIKE ? OR " +
                   "empfaenger_konto LIKE ? OR " +
                   "empfaenger_blz LIKE ?",
                   text,text,text,text,text,text);
    list.setOrder("ORDER BY " + service.getSQLTimestamp("erste_zahlung") + " DESC");

    ArrayList results = new ArrayList();
    while (list.hasNext())
    {
      results.add(new MyResult((Dauerauftrag)list.next()));
    }
    return results;
  }
View Full Code Here
TOP

Related Classes of de.willuhn.datasource.rmi.DBIterator

  • de.willuhn.jameica.hbci.gui.action.BackupCreate
  • de.willuhn.jameica.hbci.gui.action.KontoDisable
  • de.willuhn.jameica.hbci.gui.action.KontoMerge
  • de.willuhn.jameica.hbci.gui.boxes.NachrichtBox
  • de.willuhn.jameica.hbci.gui.boxes.Overview
  • de.willuhn.jameica.hbci.gui.chart.ChartDataSaldoVerlauf
  • de.willuhn.jameica.hbci.gui.chart.ChartDataUmsatzTyp
  • de.willuhn.jameica.hbci.gui.controller.AbstractSammelTransferBuchungControl$GegenkontoListener
  • de.willuhn.jameica.hbci.gui.controller.AbstractSepaSammelTransferBuchungControl$EmpfaengerListener
  • de.willuhn.jameica.hbci.gui.controller.AbstractTransferControl$EmpfaengerListener
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.