日期:2014-05-16 浏览次数:20566 次
这里的方法只对使用了ibatis框架的有效
dao方法:
public void insertSalaryBudget(List<SalaryBudgetTo> salaryBudgetList) { final List<SalaryBudgetTo> tmpList = salaryBudgetList; this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() { public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException { executor.startBatch(); for (SalaryBudgetTo obj : tmpList) { if(obj!=null){ Long userId=UserUtil.getUserId(); String user="-1"; if(userId!=null){ user=userId.toString(); } obj.setCreateBy(user); obj.setCreateDt(new Date()); obj.setUpdateBy(user); obj.setUpdateDt(new Date()); obj.setActByType("B"); executor.insert("salary.insertSalaryBudget", obj); } } executor.executeBatch(); return null; } }); }
?ibatis中sqlmaps配置:
<insert id="salary.insertSalaryBudget" parameterClass="salaryBudgetTo"> INSERT INTO xc.tb_salary_budget( pk, slry_month, user_id, bus_type, bus_child_type, amount, del_flag, create_by, create_dt, update_dt, update_by, delete_by, act_by_type ) VALUES( XC.XC_SQ_SALARY_BUDGET.nextval, #slryMonth#, #userId#, #busType#, #busChildType#, #amount#, 1, #createBy#, #createDt#, #updateDt#, #updateBy#, #deleteBy#, #actByType# ) </insert>?
?
?
?