jpa执行sql脚本
EntityManager manager = getEntityManager();
Query q = manager.createNativeQuery("BEGIN " + sql + " END;");
q.executeUpdate();
jpa执行原生sql(注意sql语句不能带分号)
EntityManager manager = getEntityManager();
Query q = manager.createNativeQuery(" INSERT INTO TEST (ID,USERNAME) VALUES ('1','路飞') ");
q.executeUpdate();