mybatis对删除,修改,新增操作没有设置返回类型,我们可以执行完这些操作之后,返回个参数作为执行是不是正确
1新增
//新增考勤请假
public String addAttendanceLeave(Map map);
<select id="addAttendanceLeave" parameterType="Map" resultType="String">
insert into AttendanceLeave
(PKID,StudentID,ClassID,LeaveContent,StartTime,EndTime,CreateTime,Creater,DStatus)
VALUES
(#{PKID},#{StudentID},#{ClassID},#{LeaveContent},#{StartTime},#{EndTime},getdate(),#{UserId},0)
select 0
</select>
或者
//修改考勤请假
public String updateAttendanceLeave(Map map);
<select id="updateAttendanceLeave" parameterType="Map" resultType="String">
update AttendanceLeave set StudentID=#{StudentID},ClassID=#{ClassID},LeaveContent=#{LeaveContent},StartTime=#{StartTime},EndTime=#{EndTime},ModifyTime=getdate(),Modifier=#{UserId} where PKID=#{PKID}
select 0
</select>
或者
//删除考勤请假
public String delAttendanceLeave(Map map);
<select id="delAttendanceLeave" parameterType="Map" resultType="String">
delete from AttendanceLeave where PKID=#{PKID}
select 0
</select>