本文整理了Java中com.baomidou.mybatisplus.core.conditions.query.QueryWrapper.eq方法的一些代码示例，展示了QueryWrapper.eq的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。QueryWrapper.eq方法的具体详情如下：
包路径：com.baomidou.mybatisplus.core.conditions.query.QueryWrapper
类名称：QueryWrapper
方法名：eq

QueryWrapper.eq介绍

暂无

代码示例

代码示例来源：origin: baomidou/mybatis-plus

@Test
  void testPrefixOrder() {
    System.out.println(Wrappers.query().eq("order_id", 1).getSqlSegment());
  }
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
void test1() {
  QueryWrapper<User> ew = new QueryWrapper<User>()
    .eq("xxx", 123)
    .and(i -> i.eq("andx", 65444).le("ande", 66666))
    .ne("xxx", 222);
  log(ew.getSqlSegment());
  ew.getParamNameValuePairs().forEach((k, v) -> System.out.println("key = " + k + " ; value = " + v));
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(7)
void testLogicSelectCountWithoutDistinct() {
  QueryWrapper<CommonLogicData> queryWrapper = new QueryWrapper<>();
  queryWrapper.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonLogicMapper.selectCount(queryWrapper);
  Assertions.assertEquals(2, count);
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(8)
void testCountDistinctWithoutDistinct() {
  QueryWrapper<CommonData> queryWrapper = new QueryWrapper<>();
  queryWrapper.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonDataMapper.selectCount(queryWrapper);
  Assertions.assertEquals(2, count);
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(1)
void testCountDistinct() {
  QueryWrapper<CommonData> distinct = new QueryWrapper<>();
  distinct.select("distinct test_int");
  distinct.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonDataMapper.selectCount(distinct);
  Assertions.assertEquals(1, count);
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(2)
void testCountDistinctTwoColumn() {
  QueryWrapper<CommonData> distinct = new QueryWrapper<>();
  distinct.select("distinct test_int, test_str");
  distinct.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonDataMapper.selectCount(distinct);
  Assertions.assertEquals(1, count);
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(3)
void testLogicCountDistinct() {
  QueryWrapper<CommonLogicData> distinct = new QueryWrapper<>();
  distinct.select("distinct test_int");
  distinct.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonLogicMapper.selectCount(distinct);
  Assertions.assertEquals(1, count);
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
  @Order(Integer.MAX_VALUE)
  void pageCountZeroTest() {
    IPage page = studentMapper.selectPage(new Page<>(), Wrappers.<H2Student>query().eq("name", "无"));
    if (null != page) {
      System.out.println("total: " + page.getTotal());
    }
  }
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
void testNested() {
  QueryWrapper<User> queryWrapper = new QueryWrapper<User>()
    .and(i -> i.eq("id", 1).nested(j -> j.ne("id", 2)))
    .or(i -> i.eq("id", 1).and(j -> j.ne("id", 2)))
    .nested(i -> i.eq("id", 1).or(j -> j.ne("id", 2)));
  logSqlSegment("测试 Nested 下的方法", queryWrapper);
  logParams(queryWrapper);
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(9)
void testSelectPageWithoutDistinct() {
  QueryWrapper<CommonData> queryWrapper = new QueryWrapper<>();
  queryWrapper.eq("test_int", 25).or().eq("test_str", "test");
  IPage<CommonData> page = commonDataMapper.selectPage(new Page<>(1, 10), queryWrapper);
  Assertions.assertEquals(2, page.getTotal());
  Assertions.assertNotNull(page.getRecords().get(0));
  Assertions.assertNotNull(page.getRecords().get(1));
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(10)
void testSelectPageWithDistinct() {
  QueryWrapper<CommonData> queryWrapper = new QueryWrapper<>();
  queryWrapper.select("distinct test_int, test_str");
  queryWrapper.eq("test_int", 25).or().eq("test_str", "test");
  IPage<CommonData> page = commonDataMapper.selectPage(new Page<>(1, 10), queryWrapper);
  Assertions.assertEquals(1, page.getTotal());
  Assertions.assertNotNull(page.getRecords().get(0));
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
void testQueryWrapper() {
  logSqlSegment("去除第一个 or,以及自动拼接 and,以及手动拼接 or,以及去除最后的多个or", new QueryWrapper<User>().or()
    .ge("age", 3).or().ge("age", 3).ge("age", 3).or().or().or().or());
  logSqlSegment("多个 or 相连接,去除多余的 or", new QueryWrapper<User>()
    .ge("age", 3).or().or().or().ge("age", 3).or().or().ge("age", 3));
  logSqlSegment("嵌套,正常嵌套", new QueryWrapper<User>()
    .nested(i -> i.eq("id", 1)).eq("id", 1));
  logSqlSegment("嵌套,第一个套外的 and 自动消除", new QueryWrapper<User>()
    .and(i -> i.eq("id", 1)).eq("id", 1));
  logSqlSegment("嵌套,多层嵌套", new QueryWrapper<User>()
    .and(i -> i.eq("id", 1).and(j -> j.eq("id", 1))));
  logSqlSegment("嵌套,第一个套外的 or 自动消除", new QueryWrapper<User>()
    .or(i -> i.eq("id", 1)).eq("id", 1));
  logSqlSegment("嵌套,套内外自动拼接 and", new QueryWrapper<User>()
    .eq("id", 11).and(i -> i.eq("id", 1)).eq("id", 1));
  logSqlSegment("嵌套,套内外手动拼接 or,去除套内第一个 or", new QueryWrapper<User>()
    .eq("id", 11).or(i -> i.or().eq("id", 1)).or().eq("id", 1));
  logSqlSegment("多个 order by 和 group by 拼接,自动优化顺序,last方法拼接在最后", new QueryWrapper<User>()
    .eq("id", 11)
    .last("limit 1")
    .orderByAsc("id", "name", "sex").orderByDesc("age", "txl")
    .groupBy("id", "name", "sex").groupBy("id", "name"));
  logSqlSegment("只存在 order by", new QueryWrapper<User>()
    .orderByAsc("id", "name", "sex").orderByDesc("age", "txl"));
  logSqlSegment("只存在 group by", new QueryWrapper<User>()
    .groupBy("id", "name", "sex").groupBy("id", "name"));
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
  @Order(Integer.MAX_VALUE)
  void delete() {
    userMapper.delete(new QueryWrapper<>(new H2User().setAge(AgeEnum.TWO))
      .eq("name", "Tony"));
  }
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
  @Order(27)
  void testServiceChainQuery() {
    H2User tomcat = userService.query().eq("name", "Tomcat").one();
    Assertions.assertNotNull(tomcat, "tomcat should not be null");
    userService.query().nested(i -> i.eq("name", "Tomcat")).list();
    userService.lambdaUpdate().set(H2User::getName, "Tom").eq(H2User::getName, "Tomcat").update();
  }
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
void testCompare() {
  QueryWrapper<User> queryWrapper = new QueryWrapper<User>()
    .allEq(getMap()).allEq((k, v) -> true, getMap())
    .eq("id", 1).ne("id", 1)
    .or().gt("id", 1).ge("id", 1)
    .lt("id", 1).le("id", 1)
    .or().between("id", 1, 2).notBetween("id", 1, 3)
    .like("id", 1).notLike("id", 1)
    .or().likeLeft("id", 1).likeRight("id", 1);
  logSqlSegment("测试 Compare 下的方法", queryWrapper);
  logParams(queryWrapper);
}

代码示例来源：origin: baomidou/mybatis-plus

h2User.setAge(AgeEnum.TWO);
h2User.setDesc("测试置空");
Assertions.assertEquals(1, userMapper.update(h2User, new QueryWrapper<H2User>().eq("name", NQQ)));

代码示例来源：origin: tomoya92/pybbs

public List<Topic> selectAuthorOtherTopic(Integer userId, Integer topicId, Integer limit) {
 QueryWrapper<Topic> wrapper = new QueryWrapper<>();
 wrapper
   .eq("user_id", userId)
   .orderByDesc("in_time");
 if (topicId != null) {
  wrapper.lambda().ne(Topic::getId, topicId);
 }
 if (limit != null) wrapper.last("limit " + limit);
 return topicMapper.selectList(wrapper);
}

代码示例来源：origin: baomidou/mybatis-plus

@Test
@Order(1)
void crudTest() {
  for (int i = 0; i < 10; i++) {
    logicDeleteMapper.insert(new H2User("mp" + i, AgeEnum.ONE));
  }
  log(logicDeleteMapper.selectList(new QueryWrapper<H2User>().orderByAsc("`desc`")));
  log(logicDeleteMapper.selectOne(new QueryWrapper<H2User>().last("limit 1")));
  H2User h2User = new H2User();
  h2User.setDesc("1");
  h2User.setName("2");
  log(logicDeleteMapper.selectList(new QueryWrapper<>(h2User).orderByAsc("name")));
  for (long i = 0; i < 10L; i++) {
    defaultMapper.insert(new H2Student(i, "Tom长大了", 1));
  }
  log(logicDeleteMapper.selectList(new QueryWrapper<>(h2User).eq("name","2").orderByAsc("name")));
  log(defaultMapper.selectList(new QueryWrapper<H2Student>().orderByAsc("id")));
  log(defaultMapper.selectOne(new QueryWrapper<H2Student>().last("limit 1")));
  H2Student h2Student = new H2Student();
  h2Student.setId(1L);
  h2Student.setAge(2);
  log(defaultMapper.selectList(new QueryWrapper<>(h2Student).orderByAsc("id")));
}

代码示例来源：origin: yujunhao8831/spring-boot-start-current

@Override
public List< UserRole > listByUserId ( Long userId ) {
  if ( Objects.isNull( userId ) ) {
    return Collections.emptyList();
  }
  return super.list( new QueryWrapper< UserRole >().eq( "user_id" , userId ) );
}

代码示例来源：origin: lord-of-code/loc-framework

@RequestMapping(value = "/mybatisPlusOp1", method = RequestMethod.GET)
public String mybatisOp1() throws SQLException {
 String name = UUID.randomUUID().toString();
 log.info("demo info is {}, uuid is {}",
   demoInfoRead.selectList(new QueryWrapper<DemoInfo>().eq("name", name)), name);
 demoInfoWrite.insert(DemoInfo.builder().name(name).age(1200).score(10).build());
 return "ok";
}