(二十四)ORM框架Bee如何表达field is not null

例如,查email为空的用户信息.

或查,查email为非空的用户信息

//where email is null

//where email is not null

			Suid suid = BeeFactory.getHoneyFactory().getSuid();
			Condition condition10 = BeeFactoryHelper.getCondition();
			condition10.op("email", Op.eq, null);
			List<TestUser> list10 = suid.select(new TestUser(), condition10);
			Printer.printList(list10);
			
			//where email is not null
			Condition condition11 = BeeFactoryHelper.getCondition();
			condition11.op("email", Op.nq, null);
//			condition11.op("email", Op.notEqual, null);
			List<TestUser> list11 = suid.select(new TestUser(), condition11);
			Printer.printList(list11);

生成的sql:

[INFO] [Bee] select SQL: select id,email,last_name,name from test_user where email is null
[INFO] [Bee]  | <--  select rows: 1
...
[INFO] [Bee] select SQL: select id,email,last_name,name from test_user where email is not null