用jdbcTemplate查询SQI语句

String sql = " select PLAN_ID planId , SALE_TYPE saletype, AGENT_CODE agentCode, SALE_ORG_ID saleOrgId, START_TIME startTime, END_TIME endTime, RATE rate, STATE state, CREATEOR createor, AUDITOR auditor, CREATE_TIME createTime, AUDIT_TIME auditTime,"
                                +" PASS_TIME passTime, MODIFY_TIME modifyTime, MANAGE_COM manageCom, TOPIC_ID topicId, PLAN_TYPE planType, BRANCH_TYPE branchType"
                                +" from PD_PLAN_SALE_APPLY WHERE ( SALE_ORG_ID = '"+yAgentCom+"' and TOPIC_ID =  '"+ytopicId +"') ";   

//要执行的SQL语句
     List<Map<String, Object>> queryForList = jdbcTemplate.queryForList(sql);//将结果封装到List集合中
     System.out.println(JSON.toJSONString(queryForList));//输出结果