java代码
public List<Entity> selectByNameAndIdCard(String name, String idCard) {
return super.selectList(new EntityWrapper<Entity>()
.where("name = {0}", name)
.and("idCard = {0}", idCard)
);
}
sql 输出
SELECT key_id as id, name, age, id_card as idCard
FROM t_user_info
WHERE (name = 'XXX' and idCard = 'XXXXXXXXXXXXXXXXXX')