10.1

package com.example.demo11.Mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo11.entity.Attendance;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface AttendanceMapper extends BaseMapper<Attendance> {
    @Insert("INSERT INTO tbl_attendance (id, username, user_id, workshop,team ,start_time ,end_time) VALUES (#{id}, #{username}, #{userId}, #{workshop},#{team},now(),now())")
    int insertAttendance(Attendance attendance);

    @Update("UPDATE tbl_attendance SET end_time = now() WHERE user_id = #{userId}")
    int updateAttendance(String userId);
}