package com.liu.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.liu.pojo.Students;

public interface StudentsMapper {
	@Select("select * from student")
	List<Students> show();
	
	@Select("select count(*) from student ")
	int selCount();
	
	@Select("select * from student limit #{0},#{1}")
	List<Students> selBypage(int pageStart,int pageSize);
	
	@Update("update student set name=#{name} , sort=#{sort} , remark=#{remark} where id=#{id}")
	int updateStu(Students stu);
	
	@Delete("delete from student where id=#{id}")
	int deleteStu(int id);
	
	@Select("select * from student where name like CONCAT(CONCAT('%', #{sdfa}), '%')")
	List<Students> sel(String nickname);
	
	@Select("select * from student where sort=#{stuSort}")
	Students selBySort(int stuSort);
	
	@Insert("insert into student (name,sort,remark) values ( #{name} , #{sort} , #{remark})")
	int insertStu(Students Stu);
}