7cc89e70346416bde4f3c2eb5e517c3cc75a7dac.svn-base 639 B

123456789101112131415161718
  1. package com.chinacreator.process.dao;
  2. import java.sql.SQLException;
  3. import java.util.List;
  4. import org.springframework.stereotype.Component;
  5. import com.chinacreator.process.bean.CsHisBean;
  6. import com.chinacreator.process.util.DataSource;
  7. import com.frameworkset.common.poolman.SQLExecutor;
  8. @Component
  9. public class CsHisDao {
  10. public void save(List<CsHisBean> beans) throws SQLException {
  11. String sql = "insert into TD_CSHIS_INFO(cpid,spid,userid,type,inserttime,result,vipcode,vipcpid) values(#[cpid],#[spid],#[userid],#[histype],sysdate,#[result],#[vipcode],#[vipcpid])";
  12. SQLExecutor.insertBeans(DataSource.NET3G, sql, beans);
  13. }
  14. }