MyBatis中@Insert,@Select,@Update,@Delect的使用

实习中遇到了一个神奇的组件：MyBatis中的@Insert,@Select,@Update,@Delect

在实际开发生产中可以直接在dao层的实现类中添加注解，即可实现我们想要的增删改查操作：

代码格式如下：

@Update("<script>update cm_manager set " +
            "manager_id=#{managerId}," +
            "manager_name=#{managerName}," +
            "manager_tel=#{managerTel}," +
            "manager_email=#{managerEmail}," +
            "state=#{state}," +
            "op_id=#{opId}," +
            "org_Id=#{orgId}," +
            "create_date = #{createDate,jdbcType=TIMESTAMP}," +
            "done_date = #{doneDate,jdbcType=TIMESTAMP}," +
            "effective_date = #{effectiveDate,jdbcType=TIMESTAMP}," +
            "expire_date = #{expireDate,jdbcType=TIMESTAMP}," +
            "remarks=#{remarks}," +
            "cert_code=#{certCode}," +
            "cert_type=#{certType}," +
            "trade_id=#{tradeId}," +
            "manager_sex=#{managerSex}," +
            "manager_department=#{managerDepartment}," +
            "manager_position=#{managerPosition}," +
            "manager_auth=#{managerAuth}" +
            " where id =#{id}</script>")
    public void modifyManager(CmManagerDO cmManagerDO)throws Exception;