mybatis注解开发

public interface StudentDao2 {

​

@Select("select * from student where stu_no = #{stu_no}")

@Results({

@Result(property = "stuNo" ,column="stu_no"),

@Result(property = "stuSex",column = "stu_sex"),

@Result(property = "birth",column = "stu_birth")

})

List<Student> getAll(String stu_no);

​

@Insert("insert into student (stu_no,stu_name,stu_sex,stu_birth)values(#{stuNo},#{stuName},#{stuSex},#{birth})")

int addStudent(Student student);

​

@Delete("delete from student where stu_no = #{stu_no}")

int delOne(String stu_no);

​

@Update("update student set stu_name = #{stuName} where stu_no = #{stuNo}")

int uptStudent(Student student);

​

}