/*
 * 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.todo.dao;

import com.kickmogu.rhythm.todo.*;

/**
 * @author mogu
 */
public interface TodoWorkerDao {
    public Class BEAN = TodoWorker.class;
    
    public static final String BasicSql = "select TodoWorker.*, Member.name as memberName from TodoWorker, Member where ";
    public static final String JoinSql = " and TodoWorker.memberId = Member.id";

    public static final String getTodoWorker_SQL = BasicSql + " TodoWorker.id = ? " + JoinSql;
    public static final String listTodoWorkers_SQL = BasicSql + " todoid = ? " + JoinSql + " order by TodoWorker.kind desc";
    
    public int update(TodoWorker todowk);
    
    public int insert(TodoWorker todowk);

    public int delete(TodoWorker todowk);
    
    public TodoWorker getTodoWorker(int id);

    public TodoWorker[] listTodoWorkers(int todoid);
}
