spring jdbcTemplate调用存储过程

最新推荐文章于 2024-04-18 10:12:09 发布

iteye_3440

最新推荐文章于 2024-04-18 10:12:09 发布

阅读量187

点赞数

分类专栏： spring 文章标签： Spring

本文链接：https://blog.csdn.net/iteye_3440/article/details/82031173

版权

spring 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

[b]第一种方式:[/b]

List<Map<String,Object>> locationInfo=null;
locationInfo=(List<Map<String, Object>>) jdbcTemplate.execute("exec PROC_TaoBAO_State ?", new PreparedStatementCallback(){
	public Object doInPreparedStatement(PreparedStatement stmt) throws SQLException, DataAccessException {
List<HashMap<String,Object>> infoList=new ArrayList<HashMap<String,Object>>();
	stmt.setString(1,mailNo);
	ResultSet rs = stmt.executeQuery();
	while(rs.next()){
	     Map<String,Object> infoMap=new HashMap<String,Object>();
	     infoMap.put("acceptAddress",getString(rs.getString("位置")));
	     infoMap.put("remark",rs.getString("状态"));
	     infoMap.put("acceptTime",getString(rs.getString("跟踪时间")));
              infoList.add((HashMap<String, Object>) infoMap);
	}
	return infoList;
}});
return locationInfo;

[b]第二种方式:[/b]

DataSource dataSource = jdbcTemplate.getDataSource();
Connection conn=null;
Map ddMap=new HashMap();
conn=dataSource.getConnection();
CallableStatement cs = conn.prepareCall("{call Proc_AlibabaOther (?)}"); 
cs.setString(1, txLogisticId);
cs.execute();
ResultSet rs = cs.getResultSet(); 
while(rs.next()){
     ddMap.put("txLogisticId",txLogisticId);
     ddMap.put("mailNo",getString(rs.getString("mailNo")));
     ddMap.put("remark",getString(rs.getString("remark")));
     ddMap.put("acceptTime",getString(rs.getString("gmtCommit")));
ddMap.put("acceptAddress",getString(rs.getString("senderaddress")));
     ddMap.put("status", "true");
}
return ddMap;