日期:2014-05-16 浏览次数:20638 次
这里的方法只对使用了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>?
?
?
?