spring的jdbc

import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;

 

public TpLog insertLinkPop(TpLog tpLog) {

  StringBuilder sql = new StringBuilder();
  sql.append(" Insert into link_pop ");
  sql.append(" (app_id, link_id , create_date , create_time , create_ts) ");
  sql.append(" values ");
  sql.append(" (:app_id, :link_id ,  now() , now(), now())");

  if (log.isDebugEnabled()) log.debug("app_id " + tpLog.getAppId());
  if (log.isDebugEnabled()) log.debug("link_id " + tpLog.getLinkId());
  if (log.isDebugEnabled()) log.debug("sql = " +sql.toString());

  KeyHolder keyHolder = new GeneratedKeyHolder();
  MapSqlParameterSource namedParameters = new MapSqlParameterSource();
  namedParameters.addValue("app_id", tpLog.getAppId());
  namedParameters.addValue("link_id", tpLog.getLinkId());
  getNamedParameterJdbcTemplate().update(sql.toString(), namedParameters, keyHolder);

  //插入主键值，tpLogId在数据库中为自动增长列
  tpLog.setTpLogId(keyHolder.getKey().intValue());
  return tpLog;
 }