seecoder-devcloud/web/src/main/java/seecoder/devcloud/web/dao/user/GroupMemberMapper.java

//package seecoder.devcloud.web.dao.user;
//
//import org.apache.ibatis.annotations.*;
//import seecoder.devcloud.web.model.po.user.Group;
//import seecoder.devcloud.web.model.po.user.UserPO;
//
//import java.util.List;
//
///**
// * @author PuHong Weng
// * @date 2021/3/4
// * @description:
// */
//@Mapper
//public interface GroupMemberMapper {
//
//    @Insert("insert into group_member (group_id,user_id) values (#{groupId}, #{userId}) ")
//    int insert(@Param("groupId") int groupId,@Param("userId") int userId);
//
//    @Delete("delete from group_member where group_id = #{groupId} and user_id = #{userId}")
//    int delete(@Param("groupId") int groupId,@Param("userId")  int userId);
//
//    @Select("select user_id from group_member where group_id = #{groupId}")
//    List<Integer> selectUserIdsByGroupId(int groupId);
//
//    @Select("select group_id from group_member where user_id = #{userId}")
//    List<Integer> selectGroupIdsByUserId(int groupId);
//
//    @Select("select u.* from group_member gm, user u where u.id = gm.user_id and gm.group_id = #{groupId}")
//    List<UserPO> selectUsersByGroupId(int groupId);
//
//    @Select("select g.* from group_member gm, group g where g.id = gm.group_id and gm.userId = #{userId}")
//    List<Group> selectGroupsByUserId(int userId);
//
//}