package jnpf.tmsMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.tmsEntity.TmsCourseEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
@Mapper
|
public interface TmsCourseMapper extends BaseMapper<TmsCourseEntity> {
|
|
@Select("SELECT MAX(course_no) FROM tms_course WHERE course_no LIKE CONCAT(#{prefix}, '%') AND (f_delete_mark = 0 OR f_delete_mark IS NULL)")
|
String selectMaxCourseNo(@Param("prefix") String prefix);
|
}
|
