/*
 * Copyright 2007 Kickmogu Co. Ltd. All rights reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, 
 * either express or implied. See the License for the specific language
 * governing permissions and limitations under the License.
 */



/*
 * 作成日: 2005/06/23
 *
 * TODO この生成されたファイルのテンプレートを変更するには次へジャンプ:
 * ウィンドウ - 設定 - Java - コード・スタイル - コード・テンプレート
 */
package com.kickmogu.rhythm.addressbook.dao;

import com.kickmogu.rhythm.core.*;

/**
 * @author mogu
 *
 */
public interface EmailAddressDao {
    public Class BEAN = EmailAddress.class;
    public static final String getEmailAddress_QUERY = "id = ?";
    public static final String list_SQL = "select EmailAddress.* from EmailAddress, AddressBookEmailAddress, AddressBook "
    	+ " where registrant = ? and AddressBook.id = AddressBookEmailAddress.addressBookId and EmailAddress.id = AddressBookEmailAddress.emailAddressId";
    
    public int update(EmailAddress eaddr);
    
    public int insert(EmailAddress eaddr);

    public int delete(EmailAddress eaddr);
    
    public EmailAddress getEmailAddress(int id);
    public EmailAddress[] list(int registrant);
}
