import java.util.List;

 import org.apache.ibatis.annotations.Delete;

 import org.apache.ibatis.annotations.Insert;

 import org.apache.ibatis.annotations.Select;

 import org.apache.ibatis.annotations.SelectKey;

 import org.apache.ibatis.annotations.Update;

 import com.jmu.bean.Student;

 public interface IStudentDao {

     @Insert(value = { "insert into student(name,age,score) values(#{name},#{age},#{score})" })

     void insertStudent(Student student);

     @Insert("insert into student(name,age,score) values(#{name},#{age},#{score})")

     @SelectKey(statement = "select @@identity", resultType = int.class, keyProperty = "id", before = false)

     void insertStudentCacheId(Student student);// 插入后获取

     @Delete(value = "delete from student where id=#{XXX}")

     void deleteStudentById(int id);

     @Update("update student set name=#{name},age=#{age},score=#{score} where id=#{id}") // 只用到一个value属性，可以不写

     void updateStudent(Student student);

     @Select("select id,name,age,score from student")

     List<Student> selectAllStudents();// 查询所有

     @Select("select id,name,age,score from student where id=#{JJJ}")

     Student selectStudentById(int id); // 根据id查询

     @Select("select id,name,age,score from student where name like '%' #{XXX} '%'")

     List<Student> selectStudentsByName(String name);// 模糊查询

 }