jdbcnewslettersubscriptionrepositoryadapter.java

来自「一些很有用的spring的书籍」· Java 代码 · 共 19 行

package com.apress.springbook.chapter05;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class JdbcNewsletterSubscriptionRepositoryAdapter 
  extends JdbcDaoSupport 
  implements NewsletterSubscriptionRepositoryAdapter {

  public void addNewsletterSubscription(int memberId, String emailAdress) {
    getJdbcTemplate().update(
       "INSERT INTO t_newsletter_subscriptions (" +
       "(subscription_id, member_id, email_address) " +
       " VALUES (" +
       "newsletter_subscription_seq.nextVal(), ?, ?",
       new Object[] { new Integer(memberId), emailAdress }
    );
  }
}