mybatis返回update数据的指定值

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xhkjedu.mapper.system.TeacherDao">
    <!--结束抢答指定抢答学生并返回学生的id-->
    <update id="endAskAndDesignStu">
        <selectKey keyProperty="student.studentid" resultType="int" order="AFTER">SELECT s.studentid FROM cc_ask_student s WHERE s.asktid=2 ORDER BY s.asksid LIMIT 1</selectKey>
        UPDATE cc_ask_student s SET s.studentselected=1 WHERE s.asktid=#{student.asktid} ORDER BY s.asksid LIMIT 1
    </update>

</mapper>
@Data
public class CCAskStudentBean {
    private Integer asksid;//课堂互动学生表主键id
    private Integer asktid;//教师互动发起方主键id(cc_ask_teacher)
    private Integer studentid;//学生id
    private String studentradio;//学生单选题答案(单选和理解状态)
    private Integer radiocorrect;//学生单选是否正确0默认未批阅1正确2错误
    private String studentpic;//学生简答题图片地址
    private String studentthumb;//学生简单题图片缩略图地址
    private Integer studentselected;//学生是否被选中0默认1选中
    private Integer createtime;//创建时间(时间戳)
    private String username;//学生姓名
    private Integer radionum;//选择题选项数量
    private String radioanswer;//单选题正确答案(大写字母)
    private Integer classid;//课堂id
}


@Repository
public interface TeacherDao {
    Integer endAskAndDesignStu(@Param("student") CCAskStudentBean student);
}

@Service
public class TeacherService {

    @Autowired
    TeacherDao teacherDao;
    public Integer endAskAndDesignStu(Integer asktid){
        CCAskStudentBean student = new CCAskStudentBean();
        student.setAsktid(asktid);
        teacherDao.endAskAndDesignStu(student);
        return student.getStudentid();
    }
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值