代码/restaurants/target/classes/mapper/UserMapper.xml

（完整代码） 654B 

<?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.mall.mapper.UserMapper">

    <select id="selectUser" resultType="com.mall.entity.User">
        select
        *
        from user
        where id in
        <foreach item="id" collection="list" open="(" separator="," close=")">
            #{id}
        </foreach>
    </select>

    <select id="getUserByRand" resultType="com.mall.vo.UserVo">
       SELECT * FROM user as t1 WHERE t1.id>=(RAND()*(SELECT MAX(id) FROM user)) and t1.identity = 3   LIMIT 10;
    </select>
</mapper>

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。