主要代码:
/**
* 根据用户id查询用户信息
* @return
*/
@Select("select * from tblstudent where studentId =#{studentId}")
public Student selectStudentById(Integer studentId);
/**
* 通过学生姓名模糊查询用户信息
* @return
*/
@Select("select * from tblstudent where studentName LIKE concat('%',#{studentName},'%')")
public List<Student> selectStudentByName(String studentName);
/**
* 插入学生信息
* @return
*/
@Insert("insert into tblstudent(studentName,age,studentNo,birthDay)values(#{studentName},#{age},#{studentNo},#{birthDay})")
public int addStudent(Student student);
/**
*更新学生信息
* @return
*/
@Update("update tblstudent set studentName = #{studentName},age = #{age} where studentId = #{studentId} ")
public int updateStudent(Student student);
/**
* 刪除学生信息
* @return
*/
@Delete("delete from tblstudent where studentId =#{studentId}")
public int deleteStudent(Integer id);