Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.JdbcTemplate.query()

541
542
543
544
545
546
547
548
549
550
551
        String qq_SQL = "select *  from Customer " +
                        "where CustomerName = ? ";
        Object[] qq_SQLParams = new Object[] {pName };
        // TODO [112,Info]: Using the * in a query rather than explicitly enumerating the column list is often inefficient.
        JdbcTemplate qq_Template = dBConnection.getTemplate();
        List qq_List = qq_Template.query(qq_SQL, qq_SQLParams, new BeanRowMapper(aCustomer, Customer.class));
        if (!qq_List.isEmpty()) {
            aCustomer = (Customer)DataAccessUtils.singleResult(qq_List);
        }
        qq_RowCount = qq_List.size();
        recsReturned = qq_RowCount;
View Full Code Here
586
587
588
589
590
591
592
593
594
595
596
            pSelHoldCustName,
            pSelHoldStockName
        };
        // TODO [112,Info]: Using the * in a query rather than explicitly enumerating the column list is often inefficient.
        JdbcTemplate qq_Template = dBConnection.getTemplate();
        List qq_List = qq_Template.query(qq_SQL, qq_SQLParams, new BeanRowMapper(aHolding, Holding.class));
        if (!qq_List.isEmpty()) {
            aHolding = (Holding)DataAccessUtils.singleResult(qq_List);
        }
        qq_RowCount = qq_List.size();
        recsReturned = qq_RowCount;
View Full Code Here
626
627
628
629
630
631
632
633
634
635
636
                        "from Holding " +
                        "where CustomerName = ? ";
        Object[] qq_SQLParams = new Object[] {pName };
        // TODO [112,Info]: Using the * in a query rather than explicitly enumerating the column list is often inefficient.
        JdbcTemplate qq_Template = dBConnection.getTemplate();
        aCustomersHoldingList = (Array_Of_Holding)qq_Template.query(qq_SQL, qq_SQLParams, new ArrayRowMapper(aCustomersHoldingList, Array_Of_Holding.class));

        return aCustomersHoldingList;
    }

    /**
 
View Full Code Here
175
176
177
178
179
180
181
182
183
184
185
        String qq_SQL = "select *  from Customer " +
                        "where CustomerName = ? ";
        Object[] qq_SQLParams = new Object[] {pName };
        // TODO [112,Info]: Using the * in a query rather than explicitly enumerating the column list is often inefficient.
        JdbcTemplate qq_Template = dBConnection.getTemplate();
        List qq_List = qq_Template.query(qq_SQL, qq_SQLParams, new BeanRowMapper(aCustomer, Customer.class));
        if (!qq_List.isEmpty()) {
            aCustomer = (Customer)DataAccessUtils.singleResult(qq_List);
        }
        qq_RowCount = qq_List.size();
        recsReturned = qq_RowCount;
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
            pSelHoldCustName,
            pSelHoldStockName
        };
        // TODO [112,Info]: Using the * in a query rather than explicitly enumerating the column list is often inefficient.
        JdbcTemplate qq_Template = dBConnection.getTemplate();
        List qq_List = qq_Template.query(qq_SQL, qq_SQLParams, new BeanRowMapper(aHolding, Holding.class));
        if (!qq_List.isEmpty()) {
            aHolding = (Holding)DataAccessUtils.singleResult(qq_List);
        }
        qq_RowCount = qq_List.size();
        recsReturned = qq_RowCount;
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
                        "from Holding " +
                        "where CustomerName = ? ";
        Object[] qq_SQLParams = new Object[] {pName };
        // TODO [112,Info]: Using the * in a query rather than explicitly enumerating the column list is often inefficient.
        JdbcTemplate qq_Template = dBConnection.getTemplate();
        aCustomersHoldingList = (Array_Of_Holding)qq_Template.query(qq_SQL, qq_SQLParams, new ArrayRowMapper(aCustomersHoldingList, Array_Of_Holding.class));

        return aCustomersHoldingList;
    }

    /**
 
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
    JdbcTemplate template = EasyMock.createMock(JdbcTemplate.class);
    provider.setJdbcTemplate(template);
    provider.setDialect(new DerbyDialect());

    // Expectations
    EasyMock.expect(template.query(EasyMock.anyObject(PreparedStatementCreator.class), EasyMock.anyObject(RowMapper.class)))
        .andReturn(countRes);
    EasyMock.expect(
        template.query(EasyMock.capture(creator),
            EasyMock.capture(mapper))).andReturn(
        objects);
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    // Expectations
    EasyMock.expect(template.query(EasyMock.anyObject(PreparedStatementCreator.class), EasyMock.anyObject(RowMapper.class)))
        .andReturn(countRes);
    EasyMock.expect(
        template.query(EasyMock.capture(creator),
            EasyMock.capture(mapper))).andReturn(
        objects);
    // Test
    EasyMock.replay(template);
    JsonObject result = provider.getEvents(0, "base", new CriteriaAdapter(0, 100,
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
            DataSource ds = (DataSource) getApplicationContext().getBean(dsName);
            JdbcTemplate template = new JdbcTemplate(ds);

            // Execute the SQL query and build a results object.  This result will consist of one
            // rowname -> rowvalue map for each row in the result set
            results = template.query(spelSqlQuery, new ColumnMapRowMapper());
            log.debug("found {} results for query {}", results.size(), spelSqlQuery);

            if (cache != null) {
                log.debug("Adding SQL results to cache {}, query: {}, substituted query: {}", cache.getName(),
                        sqlQuery, spelSqlQuery);
View Full Code Here
200
201
202
203
204
205
206
207
208
209
210
      selectStatementToUse = strat.createSelectStatement();

      Dao.selectStatements.put(type, selectStatementToUse);
    }

    List<T> results = select.query(selectStatementToUse,
        new Object[] { id }, new TemplateRowMapper<T>(type));

    if (results.size() > 0) {
      return results.get(0);
    }
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.