import com.yd.common.data.CIPPageInfo;

import com.yd.common.data.CIPReqCondition;

import com.yd.common.exception.CIPDaoException;

import com.yd.common.runtime.CIPErrorCode;

import com.yd.wms.busi.dao.impl.WMS_busi_outboundDaoImpl;

import com.yd.wms.busi.data.WMS_busi_outboundData;

import com.yd.wms.busi.data.po.WMS_busi_outboundPO;

import java.util.List;

import java.util.Map;

import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;

import org.springframework.jdbc.core.simple.SimpleJdbcInsert;

import org.springframework.jdbc.support.KeyHolder;

import org.springframework.stereotype.Repository;

    public int addData(WMS_busi_outboundPO po) {

        SimpleJdbcInsert insertActor = new SimpleJdbcInsert(jdbcTemplate).withTableName("riv_outbound_notice_h").usingGeneratedKeyColumns("ONH_ID");

        try{

            KeyHolder keyHolder = insertActor.executeAndReturnKeyHolder(new BeanPropertySqlParameterSource(po));

             return keyHolder.getKey().intValue();

        }catch(Exception e) {

            log.error(e);

            throw new CIPDaoException(CIPErrorCode.ERROR_DATABASE_TECH_EXCEPTION);

        }

     }

import org.springframework.dao.InvalidDataAccessApiUsageException;

import org.springframework.jdbc.core.BatchPreparedStatementSetter;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import org.springframework.jdbc.core.PreparedStatementCreator;

import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;

import org.springframework.jdbc.support.GeneratedKeyHolder;

import org.springframework.jdbc.support.KeyHolder;

KeyHolder keyHolder = new GeneratedKeyHolder();

        jdbcTemplate.getJdbcOperations().update(new PreparedStatementCreator() {

            public PreparedStatement createPreparedStatement(Connection con) throws SQLException {

                PreparedStatement ps = con.prepareStatement(OmsSqlConstants.SAVE_MATERIAL_FOR_QM, new String[] {"mat_id"});

                ps.setString(1, materialProxy.getRivMaterial().getMatCode());

                ps.setInt(2, materialProxy.getRivMaterial().getMatOwnerId());

                ps.setString(3, materialProxy.getRivMaterial().getMatName());

                ps.setString(4, materialProxy.getRivMaterial().getMatShortName());

                ps.setString(5, materialProxy.getRivMaterial().getMatEnName());

                ps.setString(6, materialProxy.getRivMaterial().getMatSpec());

                ps.setString(7, materialProxy.getRivMaterial().getMatBarcode());

                ps.setString(8, materialProxy.getRivMaterial().getMatBasicUomName());

                ps.setBigDecimal(9, materialProxy.getRivMaterial().getMatShelfLifeDays());

                ps.setInt(10, materialProxy.getRivMaterial().getMatIsFragile());

                ps.setInt(11, materialProxy.getRivMaterial().getStatus());

                ps.setTimestamp(12, new Timestamp(System.currentTimeMillis()));

                ps.setInt(13, SecurityContextHelper.getCurrentUserId());

                ps.setString(14, materialProxy.getRivMaterial().getMatInternalBarcode());

                ps.setString(15, materialProxy.getRivMaterial().getGenMethod());

                ps.setInt(16, SecurityContextHelper.getCurrentUserId());

                ps.setString(17, materialProxy.getRivMaterial().getMatSkc());

                return ps;

            }

        }, keyHolder);

/** 物料表记录保存 **/

    public final static String SAVE_MATERIAL_FOR_QM = "insert into riv_material \n" +

            "    (mat_code, mat_owner_id, mat_name, mat_short_name, mat_en_name, mat_spec, \n" +

            "    mat_barcode, mat_basic_uom_name, mat_shelf_life_days, mat_is_fragile, status, create_time, \n" +

            "    create_user_id, MAT_INTERNAL_BARCODE, GEN_METHOD, update_user_id,mat_skc) " +

            "    values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?) ";