package com.chinacreator.process.dao; import java.sql.SQLException; import java.util.List; import org.springframework.stereotype.Component; import com.chinacreator.process.bean.CsHisBean; import com.chinacreator.process.util.DataSource; import com.frameworkset.common.poolman.SQLExecutor; @Component public class CsHisDao { public void save(List beans) throws SQLException { String sql = "insert into TD_CSHIS_INFO(cpid,spid,userid,type,inserttime,result,vipcode,vipcpid) values(#[cpid],#[spid],#[userid],#[histype],sysdate,#[result],#[vipcode],#[vipcpid])"; SQLExecutor.insertBeans(DataSource.NET3G, sql, beans); } }