SpringBootJPA 原生《upate、select 》sql写法

    @Resource
    EntityManager entityManager;    
	@Transactional
    @Override
    public Long addRemark(AddRemarkDTO req) {
        RemarkInfoPO remarkInfoPO = new RemarkInfoPO();
        DCBeanUtils.copy(req, remarkInfoPO);
        RemarkInfoPO po = remarkInfoDAO.save(remarkInfoPO);
        String sql ="update subject_data_point_rel f set f.active_status =0   where f.subject_page_rel_id ="+req.getForeignId()+"  and f.name = "+req.getName()+" ";
        Query query = entityManager.createNativeQuery(sql);
        query.executeUpdate();
        return po.getId();

有可能会帮助大家、最快完成工作的任务。。。