ibatIS调用存储过程

bd2007

浏览: 395823 次
性别:
来自: 上海

最近访客更多访客>>

bubuhui

一往无前bhz

lovelichao

PXY

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

ibatIS调用存储过程
java

ibatIS调用存储过程 java 工作

一、ibatIS调用存储过程(调用存储过程，统一使用StoredProcedure.xml) 
1.SaleManagerAction代码: 
/** 
?* 导入单边 
?* @return 
?* @author? Invalid 
?* @throws Exception 
?* @date 2011-11-9 上午09:46:51 
?*/ 
public String importUnilateralSaleUpload() throws Exception{ 
??? Map<String,Object> result = new HashMap<String,Object>(); 
??? String uid = getUserId(); 
??? if(StringUtils.isEmpty(uid) || qqfile == null){ 
??? ??? result.put("success", false); 
??? ??? result.put("message", "3014"); 
??? ??? outPrint(JSON.toJSONString(result)); 
??? ??? return null; 
??? } 
??? try{ 
??? ??? Workbook workBook = getWorkbook(new FileInputStream(qqfile)); 
??? ??? if(workBook!=null){ 
??? ??? ??? Sheet sheet = workBook.getSheetAt(0); 
??? ??? ??? Iterator<Row> it = sheet.iterator(); 
??? ??? ??? importTotalNum = (sheet.getLastRowNum()+1); 
??? ??? ??? List<Map<String,Object>> importList = new ArrayList<Map<String,Object>>(); 
??? ??? ??? Row row = null; 
??? ??? ??? Map<String,Object> temp = null; 
??? ??? ??? String date = null; 
??? ??? ??? try{ 
??? ??? ??? ??? while(it.hasNext()){ 
??? ??? ??? ??? ??? row = it.next(); 
??? ??? ??? ??? ??? temp = new HashMap<String,Object>(); 
??? ??? ??? ??? ??? temp.put("employeeId", uid); 
??? ??? ??? ??? ??? temp.put("phone", String.format("%.0f", row.getCell(0).getNumericCellValue())); 
??? ??? ??? ??? ??? temp.put("money", row.getCell(1).getNumericCellValue()); 
??? ??? ??? ??? ??? date = row.getCell(2).getStringCellValue(); 
??? ??? ??? ??? ??? temp.put("refundDate", DateUtils.parseDate(date, DATEFORMAT)); 
??? ??? ??? ??? ??? importList.add(temp); 
??? ??? ??? ??? } 
??? ??? ??? }catch(Exception e){ 
??? ??? ??? ??? result.put("message", "3013"); 
??? ??? ??? ??? result.put("success", false); 
??? ??? ??? ??? log.error("SaleManagerAction importUnilateralSaleUpload:"+uid+","+qqfile.getName(), e); 
??? ??? ??? ??? outPrint(JSON.toJSONString(result)); 
??? ??? ??? ??? return null; 
??? ??? ??? } 
??? ??? ??? 
??? ??? ??? List<Map<String,Object>> importErrorList = new ArrayList<Map<String,Object>>(); 
??? ??? ??? Map<String,Object> presult = null; 
??? ??? ??? String code = null; 
??? ??? ??? for( Map<String,Object> saleImport : importList ) 
??? ??? ??? { 
??? ??? ??? ??? presult = saleManager 
??? ??? ??? ??? ??? .updateSaleUnilateralStateLoad( 
??? ??? ??? ??? ??? ??? ??? (String)saleImport.get("employeeId"), 
??? ??? ??? ??? ??? ??? ??? (String)saleImport.get("phone"), 
??? ??? ??? ??? ??? ??? ??? (Double)saleImport.get("money"), 
??? ??? ??? ??? ??? ??? ??? (Date)saleImport.get("refundDate")); 
??? ??? ??? ??? code = (String) presult.get("p_err_code"); 
??? ??? ??? ??? if( "0".equals(code))//退款成功 
??? ??? ??? ??? ??? importSuccess++; 
??? ??? ??? ??? if("-11".equals(code))//退款重复 
??? ??? ??? ??? ??? importRepeat++; 
??? ??? ??? ??? if("-21".equals(code)){//退款失败 
??? ??? ??? ??? ??? importError++; 
??? ??? ??? ??? ??? importErrorList.add(saleImport); 
??? ??? ??? ??? } 
??? ??? ??? } 
??? ??? ??? result.put("importTotalNum", importTotalNum); 
??? ??? ??? result.put("importSuccess", importSuccess); 
??? ??? ??? result.put("importRepeat", importRepeat); 
??? ??? ??? result.put("importError", importError); 
??? ??? ??? result.put("importErrorList", importErrorList); 
??? ??? ??? result.put("success", true); 
??? ??? }else{ 
??? ??? ??? result.put("message", "3015"); 
??? ??? ??? result.put("success", false); 
??? ??? } 
??? ??? log.info(uid+" Upload UnilateralSale Excel File:"+qqfile.getName()+",State:"+result.get("success")); 
??? }catch(Exception e){ 
??? ??? result.put("success", false); 
??? ??? log.error("SaleManagerAction importUnilateralSaleUpload:"+uid+","+qqfile.getName(), e); 
??? } 
??? outPrint(JSON.toJSONString(result)); 
??? return null; 
} 
=============================================================================================================================== 
2.SaleManagerServiceImpl: 
@Override 
public Map<String, Object> updateSaleUnilateralStateLoad(String employeeId, 
??? ??? String phone, Double money, Date refundDate) { 
??? Map<String, Object> model = new HashMap<String, Object>(); 
??? model.put("p_employee_id", employeeId); 
??? model.put("p_phone", phone); 
??? model.put("p_money", money); 
??? model.put("p_refund_date", refundDate); 
??? phoneSaleDao.updateSaleUnilateralStateLoad(model); 
??? return model; 
} 
3.PhoneSaleDAOImpl: 
@Override 
public void updateSaleUnilateralStateLoad(Map<String, Object> model) { 
??? getSqlMapClientTemplate().queryForObject("StoredProcedure.updateSaleUnilateralStateLoad",model); 
} 
4.StoredProcedure.xml(sqlMap文件): 
<?xml version="1.0" encoding="UTF-8" ?> 
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" > 
<sqlMap namespace="StoredProcedure"> 
???  
??? <parameterMap class="map" id="updateSaleUnilateralStateLoadMap"> 
??? ? ??? <parameter property="p_employee_id"??? jdbcType="VARCHAR" ??? javaType="java.lang.String" mode="IN" /> 
??? ? ??? <parameter property="p_phone"??? ??? jdbcType="VARCHAR"??? javaType="java.lang.String" mode="IN" /> 
??? ? ??? <parameter property="p_money"??? ??? jdbcType="DOUBLE"??? javaType="java.lang.Double" mode="IN" /> 
??? ? ??? <parameter property="p_refund_date"??? jdbcType="DATE"??? ??? javaType="java.util.Date" ??? mode="IN" /> 
??? ? ??? <parameter property="p_err_code"??? jdbcType="VARCHAR"??? javaType="java.lang.String" mode="OUT" /> 
??? ? ??? <parameter property="p_err_info"??? jdbcType="VARCHAR"??? javaType="java.lang.String" mode="OUT" /> 
??? </parameterMap> 
??? <procedure id="updateSaleUnilateralStateLoad" parameterMap="updateSaleUnilateralStateLoadMap">? 
??? ??? {CALL SP_PHONE_REFUND_LOAD(?,?,?,?,?,?)} 
??? </procedure> 
</sqlMap>
?
?
?



 <ul>
 <li><a href="http://dl.iteye.com/topics/download/6e4f916d-14b6-33d8-a7a4-1809fbe0388c">ibatIS调用存储过程.zip</a> (13.1 KB)</li>

 <li>下载次数: 0</li>
 </ul>

分享到：

Linux启动过程（详细说明） | Hibernate面向对象的hql语句

2012-01-31 15:38
浏览 1634
评论(0)
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论