Package org.springframework.jdbc

Examples of org.springframework.jdbc.Customer

371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
        declareParameter(new SqlParameter(Types.NUMERIC));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public Customer findCustomer(int id, int otherNum) {
        return (Customer) findObject(id, otherNum);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    Customer cust = query.findCustomer(1, 1);

    assertTrue("Customer id was assigned correctly", cust.getId() == 1);
    assertTrue(
      "Customer forename was assigned correctly",
      cust.getForename().equals("rod"));
  }
View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
        declareParameter(new SqlParameter(Types.VARCHAR));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public Customer findCustomer(String id) {
        return (Customer) findObject(id);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    Customer cust = query.findCustomer("rod");

    assertTrue("Customer id was assigned correctly", cust.getId() == 1);
    assertTrue("Customer forename was assigned correctly", cust.getForename().equals("rod"));
  }
View Full Code Here
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
          new SqlParameter(COLUMN_NAMES[1], COLUMN_TYPES[1]));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public Customer findCustomer(int id, String name) {
        return (Customer) findObject(
          new Object[] { new Integer(id), name });
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);

    Customer cust1 = query.findCustomer(1, "rod");
    assertTrue("Found customer", cust1 != null);
    assertTrue("Customer id was assigned correctly", cust1.getId() == 1);

    Customer cust2 = query.findCustomer(1, "Roger");
    assertTrue("No customer found", cust2 == null);
  }
View Full Code Here
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
        declareParameter(new SqlParameter(Types.VARCHAR));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public Customer findCustomer(String id) {
        return (Customer) findObject(id);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    try {
      Customer cust = query.findCustomer("rod");
      fail("Should fail if more than one row found");
    }
    catch (IncorrectResultSizeDataAccessException ex) {
      // OK
    }
View Full Code Here
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
        declareParameter(new SqlParameter(Types.NUMERIC));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    List list = query.execute(1, 1);
    assertTrue("2 results in list", list.size() == 2);
    for (Iterator itr = list.iterator(); itr.hasNext();) {
      Customer cust = (Customer) itr.next();
    }
  }
View Full Code Here
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
        declareParameter(new SqlParameter(Types.VARCHAR));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    List list = query.execute("one");
    assertTrue("2 results in list", list.size() == 2);
    for (Iterator itr = list.iterator(); itr.hasNext();) {
      Customer cust = (Customer) itr.next();
    }
  }
View Full Code Here
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
        declareParameter(new SqlParameter(Types.NUMERIC));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public Customer findCustomer(int id) {
        return (Customer) findObject(id);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    Customer cust = query.findCustomer(1);
    assertTrue("Customer id was assigned correctly", cust.getId() == 1);
    assertTrue("Customer forename was assigned correctly", cust.getForename().equals("rod"));
  }
View Full Code Here
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
        declareParameter(new SqlParameter(Types.NUMERIC));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public Customer findCustomer(int id) {
        Map params = new HashMap();
        params.put("id", new Integer(id));
        return (Customer) executeByNamedParam(params).get(0);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    try {
      Customer cust = query.findCustomer(1);
      fail("Query should not succeed since parameter declaration did not specify parameter name");
    }
    catch (InvalidDataAccessApiUsageException ex) {
      // OK - it worked
    }
View Full Code Here
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
        }
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public Customer findCustomer(int id, String country) {
        Map params = new HashMap();
        params.put("id", new Integer(id));
        params.put("country", country);
        return (Customer) executeByNamedParam(params).get(0);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    Customer cust = query.findCustomer(1, "UK");
    assertTrue("Customer id was assigned correctly", cust.getId() == 1);
    assertTrue("Customer forename was assigned correctly", cust.getForename().equals("rod"));
  }
View Full Code Here
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
        declareParameter(new SqlParameter("ids", Types.NUMERIC));
        compile();
      }

      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        return cust;
      }

      public List findCustomers(List ids) {
        Map params = new HashMap();
        params.put("ids", ids);
        return (List) executeByNamedParam(params);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    List ids = new ArrayList();
    ids.add(new Integer(1));
    ids.add(new Integer(2));
    List cust = query.findCustomers(ids);

    assertEquals("We got two customers back", cust.size(), 2);
    assertEquals("First customer id was assigned correctly", ((Customer)cust.get(0)).getId(), 1);
    assertEquals("First customer forename was assigned correctly", ((Customer)cust.get(0)).getForename(), "rod");
    assertEquals("Second customer id was assigned correctly", ((Customer)cust.get(1)).getId(), 2);
    assertEquals("Second customer forename was assigned correctly", ((Customer)cust.get(1)).getForename(), "juergen");
  }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.Customer

  • org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplateTests
  • org.springframework.jdbc.object.CustomerMapper
  • org.springframework.jdbc.object.CustomerQuery
  • org.springframework.jdbc.object.GenericSqlQueryTests
  • org.springframework.jdbc.object.SqlQueryTests
    • 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.