规范jpa有两种事务管理:一种是通过手动获取,一种通过注解
手动:
@Test
public void testshiwutwo()throws Exception {
EntityManager em=this.getEmf().createEntityManager();
em.getTransaction().begin();
try{
for(int i=0;i<5;i++)
{
User user=new User();
user.setEmail("sdsd@qqs.com"+i);
em.persist(user);
}
em.getTransaction().commit();
em.close();
}
catch (Exception e) {
System.out.print(e.getCause());
}
使用spring-test测试jpa的注解事务时,会默认回滚操作。
可以使用:
@RunWith(JUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:beans.xml" })
@Transactional //使用jpa规范的接口时,自动开启服务,出现错误会进行回滚
@TransactionConfiguration(defaultRollback=false)
public class jpatest {
@PersistenceContext
private EntityManager emt; //由spring管理的事务
@Test
public void testshiwu()throws Exception {
try{
for(int i=0;i<5;i++)
{
User user=new User();
user.setEmail("sdsd@qqs.com"+i);
emt.persist(user);
}
}
catch (Exception e) {
System.out.print(e.getCause());
}
}
//jpa 查询使用原生sql:调用存储过程或者使用
@Test
public void testlink()throws Exception {
String sql="select user.email as email,sum(click) as sumclick from news,user WHERE news.user_id=user.id GROUP BY user.id;";
List list =this.getEmt().createNativeQuery(sql).getResultList();
List<usertonews> utns=null;
if(!list.isEmpty())
{
utns=new ArrayList<usertonews>();
for(int i=0;i<list.size();i++)
{
Object[] obj = (Object[]) list.get(i);
usertonews utn=new usertonews();
utn.setEmail(obj[0].toString());
utn.setSumclick(obj[1].toString());
utns.add(utn);
}
}
// return utns;
}
}