Examples of queryForList()

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

78
79
80
81
82
83
84
85
86
87
88
    JdbcTemplate tddlJT=new org.springframework.jdbc.core.JdbcTemplate(source);


   
      String sql="select * from pid_info_5 where warnDate is not null order by updatetime desc limit 0,3000";
    List re=tddlJT.queryForList(sql);
      System.out.println(re.size());
     
      HashMap<String,ConfigInfo> rtn=new HashMap<String, ConfigInfo>();
      for(int i=0;i<re.size();i++)
      {
View Full Code Here

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

152
153
154
155
156
157
158
159
160
161
162
        if( id == null ) {
            return;
        }

        JdbcTemplate template = new JdbcTemplate( dataSource );
        List entries = template.queryForList( "SELECT KEY, VALUE FROM SETTINGS_VALUES WHERE SETTINGS_ID=?",
                new Object[] { id } );
        for( Iterator iter = entries.iterator(); iter.hasNext(); ) {
            Map entry = (Map) iter.next();
            values.put(entry.get( "KEY" ), entry.get( "VALUE" ));
        }
View Full Code Here

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

162
163
164
165
166
167
168
169
170
171
172
        }
    }

    private void loadChildKeys() {
        JdbcTemplate template = new JdbcTemplate( dataSource );
        List keys = template.queryForList( "SELECT KEY FROM SETTINGS WHERE PARENT=" + id, String.class );

        childKeys = (String[]) keys.toArray( new String[keys.size()] );
    }

    public String getUser() {
View Full Code Here

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

85
86
87
88
89
90
91
92
93
94
95
    private void upgradeActiviti() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        List<Map<String, Object>> byteArrays =
                jdbcTemplate.queryForList("SELECT ID_, BYTES_ FROM ACT_GE_BYTEARRAY");
        for (Map<String, Object> row : byteArrays) {
            byte[] updated = new String((byte[]) row.get("BYTES_")).replaceAll(
                    "org\\.apache.syncope\\.core\\.workflow\\.activiti\\.",
                    "org.apache.syncope.core.workflow.user.activiti.task.").
                    replaceAll("org\\.apache\\.syncope\\.client\\.to\\.",
View Full Code Here

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

227
228
229
230
231
232
233
234
235
236
237
    private void upgradeReportletConf() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        List<Map<String, Object>> rcInstances =
                jdbcTemplate.queryForList("SELECT id, serializedInstance FROM ReportletConfInstance");
        for (Map<String, Object> row : rcInstances) {
            String updated = ((String) row.get("serializedInstance")).
                    replaceAll("org\\.apache\\.syncope\\.client\\.report\\.",
                    "org.apache.syncope.common.report.");
            jdbcTemplate.update("UPDATE ReportletConfInstance SET serializedInstance=? WHERE id=?",
View Full Code Here

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

258
259
260
261
262
263
264
265
266
267
268
        Context.getCommandContext().getTaskEntityManager()
                .deleteTasksByProcessInstanceId(processInstanceId, "退回", false);

        JdbcTemplate jdbcTemplate = ApplicationContextHelper
                .getBean(JdbcTemplate.class);
        List<Map<String, Object>> list = jdbcTemplate
                .queryForList(
                        "select * from ACT_HI_ACTINST where proc_inst_id_=? and end_time_ is null",
                        processInstanceId);
        Date now = new Date();

View Full Code Here

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

365
366
367
368
369
370
371
372
373
374
375
        Context.getCommandContext().getTaskEntityManager()
                .deleteTask(taskEntity, "回退", false);

        JdbcTemplate jdbcTemplate = ApplicationContextHelper
                .getBean(JdbcTemplate.class);
        List<Map<String, Object>> list = jdbcTemplate
                .queryForList(
                        "select * from ACT_HI_ACTINST where task_id_=? and end_time_ is null",
                        taskId);
        Date now = new Date();

View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForList()

188
189
190
191
192
193
194
195
196
197
198
      Map<String, Object> paramMap = new HashMap<String, Object>();
      for (ParameterContext pc : this.getSqlArguments()) {
        paramMap.put(pc.getArgument().getText(), instance.get(pc.getVariable().getName()));
      }
     
      List<Map<String, Object>> results = simpleJdbcTemplate.queryForList(actualSqlStatement, paramMap);
     
      for (ParameterContext pc : this.getResultSet()) {
        ProcessVariableValue pvv = new ProcessVariableValue();
       
        for (Map<String, Object> resultMap : results) {
View Full Code Here

Examples of org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList()

29
30
31
32
33
34
35
36
37
38
39
        batchInsertOffersAsFixture();

        SqlMapClientTemplate st = (SqlMapClientTemplate) getApplicationContext().getBean(
                "sqlMapClientTemplateWithMerger");
        @SuppressWarnings("unchecked")
        List lst = st
                .queryForList("com.alibaba.cobar.client.entities.Offer.findAllWithOrderByOnSubject");
        assertTrue(CollectionUtils.isNotEmpty(lst));
        assertEquals(5, lst.size());

        verifyOffersOrderBySubject(lst);
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.