怎样用JPA的EntityManager执行原生sql返回ResultSet-CSDN论坛

怎样用JPA的EntityManager执行原生sql返回ResultSet-CSDN论坛

试：

[java] view plaincopy
package com.cndatacom.jpa.test;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.cndatacom.jpa.entity.User;


public class TestNativeQuery {
EntityManagerFactory emf = null;

@Before
public void before() {
//根据在persistence.xml中配置的persistence-unit name 创建EntityManagerFactory
emf = Persistence.createEntityManagerFactory("myJPA");
}

@After
public void after() {
//关闭EntityManagerFactory
if(null != emf) {
emf.close();
}
}


@Test
public void testNativeQuery1() {
EntityManager em = emf.createEntityManager();
//定义SQL
String sql = "SELECt * FROM t_user";

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息