使用Springboot和mybatis框架开发，给出具体程序，程序包含Dao层，Mapper.xml文件，Service层，Service实现类，Controller层，使用工具类实现抽奖功能1.根据活动查询出相应奖品，并根据奖品概率选出抽中的奖品，记录到抽奖表和中奖表中 2.不在进行中的活动弹出提示 3.超过抽奖限制次数弹出提示 4限制接口频繁访问 10秒内不允许同一个用户访问2次 5抛出异常时事务需要回滚 6.需要校验用户是否存在，奖品是否存在，库存是否足够，否则给与提示

好的，以下是一个简单的抽奖系统的程序示例：

1. Dao层

@Repository
public interface PrizeDao {
    Prize getPrizeById(@Param("id") int id);
    int updatePrizeStock(@Param("id") int id, @Param("num") int num);
    int insertLottery(Lottery lottery);
    int insertWinning(Winning winning);
    int countLotteryByUser(@Param("userId") int userId, @Param("activityId") int activityId);
}

2. Mapper.xml文件

<mapper namespace="com.example.demo.dao.PrizeDao">
    <select id="getPrizeById" resultType="com.example.demo.entity.Prize">
        SELECT * FROM prize WHERE id = #{id}
    </select>
    <update id="updatePrizeStock">
        UPDATE prize SET stock = stock - #{num} WHERE id = #{id}
    </update>
    <insert id="insertLottery">
        INSERT INTO lottery(activity_id, user_id, prize_id, create_time) VALUES(#{activityId}, #{userId}, #{prizeId}, #{createTime})
    </insert>
    <insert id="insertWinning">
        INSERT INTO winning(activity_id, user_id, prize_id) VALUES(#{activityId}, #{userId}, #{prizeId})
    </insert>
    <select id="countLotteryByUser" resultType="int">
        SELECT COUNT(*) FROM lottery WHERE user_id = #{userId} AND activity_id = #{activityId}
    </select>
</mapper>

3. Service层

@Service
public class PrizeService {
    @Autowired
    private PrizeDao prizeDao;

    @Transactional(rollbackFor = Exception.class)
    public Winning lottery(int activityId, int userId) throws Exception {
        // 检查活动是否在进行中
        if (!checkActivity(activityId)) {
            throw new Exception("该活动已结束或未开始");
        }
        // 检查用户是否已经超过抽奖次数限制
        if (prizeDao.countLotteryByUser(userId, activityId) >= 3) {
            throw new Exception("您已经超过了抽奖次数限制");
        }
        // 检查用户是否频繁访问
        if (checkFrequentAccess(userId)) {
            throw new Exception("请不要频繁访问");
        }
        // 选出奖品
        Prize prize = selectPrize(activityId);
        if (prize == null) {
            throw new Exception("奖品已经全部抽完");
        }
        // 更新奖品库存
        int updated = prizeDao.updatePrizeStock(prize.getId(), 1);
        if (updated <= 0) {
            throw new Exception("奖品已经全部抽完");
        }
        // 记录抽奖记录
        Lottery lottery = new Lottery(activityId, userId, prize.getId());
        prizeDao.insertLottery(lottery);
        // 记录中奖记录
        Winning winning = new Winning(activityId, userId, prize.getId());
        prizeDao.insertWinning(winning);
        return winning;
    }

    private boolean checkActivity(int activityId) {
        // TODO: 检查活动是否在进行中
        return true;
    }

    private boolean checkFrequentAccess(int userId) {
        // TODO: 检查用户是否频繁访问
        return false;
    }

    private Prize selectPrize(int activityId) {
        // TODO: 根据概率选出奖品
        return prizeDao.getPrizeById(1);
    }
}

4. Controller层

@RestController
public class PrizeController {
    @Autowired
    private PrizeService prizeService;

    @PostMapping("/lottery")
    public ResponseEntity<?> lottery(@RequestParam int activityId, @RequestParam int userId) {
        try {
            Winning winning = prizeService.lottery(activityId, userId);
            return ResponseEntity.ok(winning);
        } catch (Exception e) {
            return ResponseEntity.badRequest().body(e.getMessage());
        }
    }
}

5. 工具类

public class FrequencyLimiter {
    private static final Map<Integer, Long> lastAccessTime = new ConcurrentHashMap<>();

    public static boolean check(int userId) {
        long now = System.currentTimeMillis();
        Long last = lastAccessTime.get(userId);
        if (last == null || now - last > 10000) {
            lastAccessTime.put(userId, now);
            return false;
        } else {
            return true;
        }
    }
}

以上是一个简单的抽奖系统的程序示例，具体实现可能需要根据实际需求进行调整和完善。