junit4测试

package com.beiyanght.cxrs.portal.domain.usermanage;




import java.util.List;


import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.TypedQuery;


import org.junit.Test;
import org.springframework.context.support.ClassPathXmlApplicationContext;


import com.beiyanght.cxrs.portal.business.usermanage.dto.UserNetDto;
import com.beiyanght.cxrs.portal.enumitem.SexItem;




public class UserNetTest {


@Test
public void testFindByCondition() {
ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("classpath*:/applicationContext-tomcat-db.xml");
EntityManagerFactory businessEntityManagerFactory = (EntityManagerFactory) ctx.getBean("businessEntityManagerFactory");
EntityManager em = businessEntityManagerFactory.createEntityManager();
em.getTransaction().begin();
StringBuffer sqlString = new StringBuffer();
sqlString.append(" SELECT u.name,u.sex,u.loginName,ud.companyName,ud.foundedDate, cp.companyTypeName,ud.organCode,td.tradeName,ud.phone, " +
"us.status,u.insertDate, u.updateDate, u.operator, us.note " +
"FROM UserNet u LEFT JOIN UserDetail ud ON ud.user = u " +
"LEFT JOIN UserStatus us On us.user = u " +
"LEFT JOIN CompanyType cp ON ud.companyType = cp " +
"LEFT JOIN Trade td ON ud.trade = td ");
TypedQuery<Object[]> querySelect = em.createQuery(sqlString.toString(),Object[].class);
List<Object[]> result = querySelect.getResultList();
for(Object[] user:result){
if(null != user[1]){
UserNetDto u = new UserNetDto();
SexItem sex = (SexItem)user[1];
u.setSex(sex.getValue());
if(null != user[10]){
u.setInsertDate(user[10].toString());
}
}

}

em.getTransaction().commit();
em.close();
businessEntityManagerFactory.close();
}


@Test
public void testFindByUserId() {
ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("classpath*:/applicationContext-tomcat-db.xml");
EntityManagerFactory businessEntityManagerFactory = (EntityManagerFactory) ctx.getBean("businessEntityManagerFactory");
EntityManager em = businessEntityManagerFactory.createEntityManager();
em.getTransaction().begin();
Integer userId = 1;
  String sqlSelect = "SELECT u FROM UserStatus u WHERE 1= 1 AND u.user.id = :userId ";
 TypedQuery<UserStatus> querySelect = em.createQuery(sqlSelect, UserStatus.class);
 querySelect.setParameter("userId", userId);
 UserStatus u= querySelect.getSingleResult();
em.getTransaction().commit();
em.close();
businessEntityManagerFactory.close();
}

}