1 --SocialMemberAndFriendMapper.xml
<!-- 获取会员ID集合 --> <select id="searchSocialMemberIds" resultMap="mallMemberFriendsResultMap"> SELECT <include refid="socialMemberFriendsAll"></include> FROM FL_SOCIAL_MEMBER_FRIENDS WHERE M_ID = #{mId} OR F_ID = #{fId} </select> <!-- 查询绿名单列表 --> <select id="searchGreenList" resultMap="socialMemberResultMap"> SELECT <include refid="socialMemberAll"/> FROM FL_SOCIAL_MEMBER <where> M_ID IN <foreach item="item" collection="list" separator="," open="(" close=")" index=""> #{item} </foreach> </where> </select> |
SocialMemberAndFriendDao
//获取会员ID的集合 //SELECT * from FL_SOCIAL_MEMBER_FRIENDS WHERE M_ID = '1' OR F_ID = '4' public List<SocialMemberFriends>searchSocialMemberIds(MallMemberFriendsmallMemberFriends); @describe: 查询绿名单列表集合 public List<SocialMember> searchGreenList(List<String>mids); |
XXX.ServiceImpl
@Autowired private SocialMemberAndFriendDaosocialMemberAndFriendDao;
绿名单列表查询 public List<SocialMember> searchSocialFriendList(MallMemberFriendsmallMemberFriends) { List<SocialMember> list =new ArrayList<SocialMember>();// 创建一个返回结果集对象 try { List<SocialMemberFriends> mallMemberFriendsList =socialMemberAndFriendDao.searchSocialMemberIds(mallMemberFriends); List<String> mids =new ArrayList<String>();//获取所有的会员ID for (SocialMemberFriendsm : mallMemberFriendsList) { long getmId =m.getmId(); mids.add(String.valueOf(getmId)); } // 通过mids集合,获取对应的绿名单列表searchGreenList list = socialMemberAndFriendDao.searchGreenList(mids); } catch (Exceptione) { e.printStackTrace(); } return list; } |
GetGreenListVo
//1.1.1.32.绿名单列表 public class GetGreenListVoimplements Serializable{ /** *[头像,昵称,性别],[ ],[ ],[ ],[ ] */ private static final long serialVersionUID = 1L; private StringheadPortrait;/*头像*/ private StringnickName; /*昵称*/ private Stringsex; /*等级*/ Setter and getter----toString() |
|
GetGreenListDto
public class GetGreenListDto implements Serializable{
private StringmemberId;//会员ID private StringfriendId ; //好友ID Setter and getter----toString() |
IGetGreenListApi
/** * 1.1.1.32.绿名单列表 * @param request * @return */ public Response<List<GetGreenListVo>> getGreenList(Request<GetGreenListDto>request); |
GetGreenListProvide
@Service("getGreenListProvide") public class GetGreenListProvideimplements IGetGreenListApi { @Autowired private SocialMemberAndFriendServicesocialMemberAndFriendService;
@Override public Response<List<GetGreenListVo>> getGreenList(Request<GetGreenListDto>request) { // TODO Auto-generated method stub Response<List<GetGreenListVo>> res = Response.create(); //创建一个返回结果集的对象,用于list集合的对象 List<GetGreenListVo>list =new ArrayList<GetGreenListVo>();//创建一个list集合用于存放返回的数据 MallMemberFriends mallMemberFriends =new MallMemberFriends();//创建一个实体对象接收Dto参数 System.out.println(request.getData().getFriendId()+"=========================="+request.getData().getMemberId()); mallMemberFriends.setfId(Long.parseLong(request.getData().getFriendId()));//获取朋友ID,并封装到实体对象中 mallMemberFriends.setmId(Long.parseLong(request.getData().getMemberId())); //获取会员ID,并封装到实体对象中 List<SocialMember> searchSocialFriendList =socialMemberAndFriendService.searchSocialFriendList(mallMemberFriends); for (SocialMembers : searchSocialFriendList) {//遍历返回的结果集,返回要显示的属性,并封装到Vo对象中 GetGreenListVo vo =new GetGreenListVo();//创建一个Vo对象,用于接收每个对象要返回的字段信息 vo.setHeadPortrait(s.getHeadPortaitSrc()); //头像 vo.setNickName(s.getNickName());//昵称 vo.setSex(String.valueOf(s.getSex()));//性别 list.add(vo); } res.setData(list);//将list集合返回到response结果集 return res; } |
Dubbo.Test
@Autowired private IGetGreenListApiiGetGreenListApi;
@Test public void test3() { log.info("aaaaaaa"); String mid ="10000001"; String fId ="4"; Request<GetGreenListDto> request =new Request<GetGreenListDto>(); GetGreenListDto dto =new GetGreenListDto(); dto.setFriendId(fId); dto.setMemberId(mid); request.setData(dto); Response<List<GetGreenListVo>> greenList =iGetGreenListApi.getGreenList(request); System.out.println("done" +greenList.getData().toString()); log.info("done" +greenList); } |
Service.test
@Slf4j public class ASocialMemberAndFriendServiceTestextends BaseTest {
private static final Loggerlog = Logger.getLogger(ASocialMemberAndFriendServiceTest.class);
@Autowired private SocialMemberAndFriendServicesocialMemberAndFriendService;
@Test public void test1() { log.info("aaaaaaa"); // 1.1.32.绿名单列表 MallMemberFriends mallmemberfriends =new MallMemberFriends(); mallmemberfriends.setmId(10000001); mallmemberfriends.setfId(4); List<SocialMember> searchSocialFriendList =socialMemberAndFriendService .searchSocialFriendList(mallmemberfriends); System.out.println("done" +searchSocialFriendList); log.info("done" +searchSocialFriendList); }
|