EntityManager操作数据库

增删改查、alter、动态表名可自行拼接
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

@PersistenceContext或者@Autowired
private EntityManager em;

String sql =“xxxx=?xxx=?”；
query.setParameter(1, pointx);
query.setParameter(2, pointy);
Query query =em.createNativeQuery(sql);
query.getResultList();查询
query.executeUpdate();更新或者操作