Package org.springframework.jdbc

Examples of org.springframework.jdbc.Customer

304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
    params.put("id", new SqlParameterValue(Types.DECIMAL, new Integer(1)));
    params.put("country", "UK");
    final List customers = new LinkedList();
    jt.query(SELECT_NAMED_PARAMETERS, params, new RowCallbackHandler() {
      public void processRow(ResultSet rs) throws SQLException {
        Customer cust = new Customer();
        cust.setId(rs.getInt(COLUMN_NAMES[0]));
        cust.setForename(rs.getString(COLUMN_NAMES[1]));
        customers.add(cust);
      }
    });
    assertEquals(1, customers.size());
    Customer cust = (Customer) customers.get(0);
    assertTrue("Customer id was assigned correctly", cust.getId() == 1);
    assertTrue("Customer forename was assigned correctly", cust.getForename().equals("rod"));
  }
View Full Code Here
873
874
875
876
877
878
879
880
881
882
        }
        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;
      }
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
    Map params = new HashMap();
    params.put("id", new SqlParameterValue(Types.DECIMAL, new Integer(1)));
    params.put("country", "UK");
    List customers = jt.query(SELECT_NAMED_PARAMETERS, params, new RowMapper() {
      public 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;
      }
    });
    assertEquals(1, customers.size());
    Customer cust = (Customer) customers.get(0);
    assertTrue("Customer id was assigned correctly", cust.getId() == 1);
    assertTrue("Customer forename was assigned correctly", cust.getForename().equals("rod"));
  }
View Full Code Here
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(mockDataSource);
    Map params = new HashMap();
    params.put("id", new SqlParameterValue(Types.DECIMAL, new Integer(1)));
    params.put("country", "UK");
    Customer cust = (Customer) jt.queryForObject(SELECT_NAMED_PARAMETERS, params, new RowMapper() {
      public 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;
      }
    });
    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
        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;
      }
View Full Code Here
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
        declareParameter(new SqlParameter("id1", 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;
      }
View Full Code Here
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
        declareParameter(new SqlParameter("id1", 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;
      }
View Full Code Here
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
        declareParameter(new SqlParameter("id1", 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(Integer id) {
        Map params = new HashMap();
        params.put("id1", id);
        return (List) executeByNamedParam(params);
      }
    }

    CustomerQuery query = new CustomerQuery(mockDataSource);
    List cust = query.findCustomers(new Integer(1));

    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
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
        declareParameter(new SqlParameter("id1", 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(Integer id1) {
        Map params = new HashMap();
View Full Code Here
371
372
373
374
375
376
377
378
379
380
        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;
      }
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.