spring queryforlist 固定的sql语句(SQL语句固定不变,如何用queryforlist,还是用别的方法???)
public List<CustomInquire> getInquireDate(char service_level)
throws DataAccessException {
String sql = "SELECT T1.create_date SUP_Create_date,T1.accessurl,T1.title,T1.contact_person,T1.update_date,T1.company_name_gb,T1.company_name_en,T1.productids,T1.country,T1.region,T1.email_1,T1.content"
+"FROM"
+"(SELECT /*+ ordered*/ sup.create_date,sup.accessurl,buy.buyer_id, u.contact_person, u.email_1, buy.title, buy.content,sup.service_level,"
+"buy.update_date, buy.supplierid, buy.productids,u.fromshow_id,sup.company_name_gb, sup.company_name_en,u.fromtype_id,u.phone1, u.fax1,mas.name_gb country, region.name_gb region,buy.visitor_source, buy.visitor_keyword"
+"FROM globalmarket.suppliers sup, " +
"globalmarket.buy_inquiry buy, " +
"globalmarket.buy_users u," +
"globalmarket.mas_country mas," +
"globalmarket.region region"
+"WHERE ((u.buyer_id = buy.buyer_id)" +
"AND(buy.supplierid = sup.supplier_id)"
+"AND sup.ENDTIME >= sysdate"
+"AND (u.country_id = mas.country_id)"
+"AND (region.region_id = mas.region_id)"
+"AND (sup.service_level='X' or sup.service_level='T')"
+"AND (sup.create_date> TO_DATE('2008-6-4 00:00','yyyy-mm-dd hh24:mi'))"
+"AND (buy.update_date > TO_DATE('2008-6-25 00:00','yyyy-mm-dd hh24:mi')) "
+")"
+") T1"
+"ORDER BY update_date DESC";
Object[] args = new Object[]{new Character(service_level)};
List lst = this.simpleJdbcTemplate.queryForList(sql, args);
System.out.println(lst);
return lst;
}
throws DataAccessException {
String sql = "SELECT T1.create_date SUP_Create_date,T1.accessurl,T1.title,T1.contact_person,T1.update_date,T1.company_name_gb,T1.company_name_en,T1.productids,T1.country,T1.region,T1.email_1,T1.content"
+"FROM"
+"(SELECT /*+ ordered*/ sup.create_date,sup.accessurl,buy.buyer_id, u.contact_person, u.email_1, buy.title, buy.content,sup.service_level,"
+"buy.update_date, buy.supplierid, buy.productids,u.fromshow_id,sup.company_name_gb, sup.company_name_en,u.fromtype_id,u.phone1, u.fax1,mas.name_gb country, region.name_gb region,buy.visitor_source, buy.visitor_keyword"
+"FROM globalmarket.suppliers sup, " +
"globalmarket.buy_inquiry buy, " +
"globalmarket.buy_users u," +
"globalmarket.mas_country mas," +
"globalmarket.region region"
+"WHERE ((u.buyer_id = buy.buyer_id)" +
"AND(buy.supplierid = sup.supplier_id)"
+"AND sup.ENDTIME >= sysdate"
+"AND (u.country_id = mas.country_id)"
+"AND (region.region_id = mas.region_id)"
+"AND (sup.service_level='X' or sup.service_level='T')"
+"AND (sup.create_date> TO_DATE('2008-6-4 00:00','yyyy-mm-dd hh24:mi'))"
+"AND (buy.update_date > TO_DATE('2008-6-25 00:00','yyyy-mm-dd hh24:mi')) "
+")"
+") T1"
+"ORDER BY update_date DESC";
Object[] args = new Object[]{new Character(service_level)};
List lst = this.simpleJdbcTemplate.queryForList(sql, args);
System.out.println(lst);
return lst;
}
...全文
相关推荐
Java 使用JdbcTemplate 中的queryForList发生错误解决办法
主要介绍了Java 使用JdbcTemplate 中的queryForList发生错误解决办法的相关资料,需要的朋友可以参考下
Spring框架JdbcTemplate类中查询方法介绍
Spring框架JdbcTemplate类中查询方法介绍
Spring jdbc具名参数使用方法详解
主要介绍了Spring jdbc具名参数使用方法详解,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
Spring_JdbcTemplate的用法
Spring_JdbcTemplate的用法实例
Spring JdbcTemplate 调用 Oracle 存储过程 与 Oracle 驱动下载
目录 前 言 Oracle 驱动下载 Oracle 数据源配置 execute 调用无返回值存储过程 execute 调用单个返回值存储过程 execute 调用返回结果集存储过程 call 方法调用存储过程 前 言 1、关于 JdbcTemplate 的介绍、pom 依赖、DI 注入可以参考《Spring JdbcTemplate 模板剖析 之 常用 增删改查》,本文继续介绍 JdbcTemplate 调用数据库的存储过程,虽然 Mysql 也有存储过程,但是为了尽可能的多覆盖一点,本文选择调用 Oracle 的存储过程,其它数据库也是同理。 1)execute 方法:能执行任何 SQL



