package com.wyhello.myspace.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.wyhello.myspace.pojo.Author;

public interface AuthorMapper {

	@Select("SELECT * FROM Author")
	List<Author> selectAuthors();
	Author selectAuthor(int id);
	int insertAuthor(Author author);
	int updateAuthor(Author author);
	int deleteAuthor(int id);
	
	//List<Author> selectAuthorPage(int offset, int pagesize);
	List<Author> selectAuthorsPage(Map paramList);
	
	List<Author> selectAuthorsPage2(int offset, int pagesize);
	
	List<Author> selectAuthorsPage3(@Param(value="offset") int offset, @Param(value="pagesize") int pagesize);
	int updateAuthorIfNecessary(Author author);
	
	Author selectForUsernamePassword(@Param(value="username") String username, @Param(value="password") String password);

	Author selectAuthorForUsername(String username);
}