Examples of HBCIDBService

Examples of de.willuhn.jameica.hbci.rmi.HBCIDBService

43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
  {
    List<Schedule<Umsatz>> result = new LinkedList<Schedule<Umsatz>>();
   
    try
    {
      HBCIDBService service = Settings.getDBService();
      DBIterator list = service.createList(Umsatz.class);
      if (k != null)
        list.addFilter("konto_id = " + k.getID());

      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())});
      list.setOrder("ORDER BY " + service.getSQLTimestamp("datum"));

      while (list.hasNext())
      {
        Umsatz u = (Umsatz) list.next();
        result.add(new Schedule(u.getDatum(),u,false));
View Full Code Here

Examples of de.willuhn.jameica.hbci.rmi.HBCIDBService

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
  {
    if (search == null || search.length() == 0)
      return null;
   
    String text = "%" + search.toLowerCase() + "%";
    HBCIDBService service = (HBCIDBService) Settings.getDBService();
    DBIterator list = service.createList(Ueberweisung.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("termin") + " DESC");

    ArrayList results = new ArrayList();
    while (list.hasNext())
    {
      results.add(new MyResult((Ueberweisung)list.next()));
View Full Code Here

Examples of de.willuhn.jameica.hbci.rmi.HBCIDBService

39
40
41
42
43
44
45
46
47
48
49
50
  {
    List<Schedule<SepaDauerauftrag>> result = new LinkedList<Schedule<SepaDauerauftrag>>();
   
    try
    {
      HBCIDBService service = Settings.getDBService();
      DBIterator list = service.createList(SepaDauerauftrag.class);
      if (k != null)
        list.addFilter("konto_id = " + k.getID());

      while (list.hasNext())
      {
View Full Code Here

Examples of de.willuhn.jameica.hbci.rmi.HBCIDBService

74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
      // Daten nicht dauernd neu laden, wenn der User durch die Monate blaettert
      // Da wir einen Request-Scope haben, bleibt der Resultset auch nur solange
      // erhalten, wie sich der User auf der gleichen View befindet.
      if (list == null)
      {
        HBCIDBService service = Settings.getDBService();
        this.list = service.createList(type);
        if (k != null)
          list.addFilter("konto_id = " + k.getID());
        this.list.setOrder("ORDER BY " + service.getSQLTimestamp("termin"));
      }
      list.begin(); // rest pointer
     
      while (this.list.hasNext())
      {
View Full Code Here

Examples of de.willuhn.jameica.hbci.rmi.HBCIDBService

46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
  {
    if (search == null || search.length() == 0)
      return null;
   
    String text = "%" + search.toLowerCase() + "%";
    HBCIDBService service = (HBCIDBService) Settings.getDBService();
    DBIterator list = service.createList(SepaLastschrift.class);
    list.addFilter("LOWER(zweck) LIKE ? OR " +
                   "LOWER(empfaenger_name) LIKE ? OR " +
                   "LOWER(creditorid) LIKE ? OR " +
                   "LOWER(mandateid) LIKE ? OR " +
                   "LOWER(endtoendid) LIKE ? OR " +
                   "LOWER(empfaenger_konto) LIKE ?",
                   text,text,text,text,text,text);
    list.setOrder("ORDER BY " + service.getSQLTimestamp("termin") + " DESC");

    ArrayList results = new ArrayList();
    while (list.hasNext())
    {
      results.add(new MyResult((SepaLastschrift)list.next()));
View Full Code Here

Examples of de.willuhn.jameica.hbci.rmi.HBCIDBService

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
  {
    if (search == null || search.length() == 0)
      return null;
   
    String text = "%" + search.toLowerCase() + "%";
    HBCIDBService service = (HBCIDBService) Settings.getDBService();
    DBIterator list = service.createList(AuslandsUeberweisung.class);
    list.addFilter("LOWER(zweck) LIKE ? OR " +
                   "LOWER(empfaenger_name) LIKE ? OR " +
                   "LOWER(endtoendid) LIKE ? OR " +
                   "LOWER(empfaenger_konto) LIKE ?",
                   text,text,text,text);
    list.setOrder("ORDER BY " + service.getSQLTimestamp("termin") + " DESC");

    ArrayList results = new ArrayList();
    while (list.hasNext())
    {
      results.add(new MyResult((AuslandsUeberweisung)list.next()));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.