原生SQL

SELECT
	config.dwid,
	config.dwname,
	config.displaycode,
	config.displayname,
	gather.origclass
FROM
	`eqm_equipdisplayconfig` config
LEFT JOIN eqm_equipgather_item gather ON gather.dwid = config.dwid
WHERE
	config.tenantid = 9
AND config.displaycode LIKE 'RP_%'

	SELECT
		gather.dwid,
		gather.dwname,
		config.displaycode,
		config.displayname,
		gather.origclass
	FROM
		`eqm_equipdisplayconfig` config
	LEFT JOIN 
		eqm_equiprecord_item recorditem ON recorditem.equiprecordid = config.equirecordid
	LEFT JOIN 
		eqm_equipgather_item gather ON gather.equiprecorditemid =recorditem.id
	WHERE
		config.tenantid = 9
	AND config.displaycode LIKE 'RP_%'

String sql = "SELECT config.dwid,config.dwname,config.displaycode,config.displayname,gather.origclass FROM `eqm_equipdisplayconfig` config LEFT JOIN eqm_equipgather_item gather ON gather.dwid = config.dwid WHERE config.tenantid = "
					+ tenantid + " AND config.displaycode LIKE '" + sign + "%'";
			Query query = em.createNativeQuery(sql);
			query.unwrap(SQLQuery.class).addScalar("dwid", StandardBasicTypes.STRING)
					.addScalar("dwname", StandardBasicTypes.STRING).addScalar("displaycode", StandardBasicTypes.STRING)
					.addScalar("displayname", StandardBasicTypes.STRING)
					.addScalar("origclass", StandardBasicTypes.STRING)
					.setResultTransformer(Transformers.aliasToBean(EquipDisplayconfigVo.class));
			@SuppressWarnings("unchecked")
			List<EquipDisplayconfigVo> configvos = query.getResultList();