JPQL测试用例
package cn.itcast.test; import cn.itcast.dao.CustomerDao; import cn.itcast.domain.Customer; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.annotation.Rollback; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import org.springframework.transaction.annotation.Transactional; import java.util.Arrays; import java.util.List; @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(locations = "classpath:applicationContext.xml")//指定spring容器的配置信息 public class JpqlTest { @Autowired private CustomerDao customerDao; @Test public void testFindJPQL() { Customer customer = customerDao.findJpql("传智播客"); System.out.println(customer); } @Test public void testFindCustNameAndId() { Customer customer = customerDao.findCustNameAndId(1L, "传智播客"); System.out.println(customer); } /** * 测试jpql的更新操作 * *springDataJpa中使用jpql完成 更新/删除操作 * *需要手动添加事务的支持 * *默认会执行结束之后，回滚事务 * @Rollback：设置是否自动回滚 * false | true */ @Test @Transactional//添加事务的支持 @Rollback(value = false) public void testUpdateCustomer() { customerDao.updateCustomer(4L, "黑马程序员"); } //测试sql查询 @Test public void testFindSql() { List<Object[]> list = customerDao.findSql("传智播客%"); for (Object[] obj : list) { System.out.println(Arrays.toString(obj)); } } //测试方法命名规则的查询 @Test public void testNaming() { Customer customer = customerDao.findByCustName("传智播客"); System.out.println(customer); } //测试方法命名规则的查询 @Test public void testFindByCustNameLike() { List<Customer> list = customerDao.findByCustNameLike("传智播客%"); for (Customer customer : list) { System.out.println(customer); } } //测试方法命名规则的查询 @Test public void testFindByCustNameLikeAndCustIndustry() { Customer customer = customerDao.findByCustNameLikeAndCustIndustry("传智播客%", "it教育"); System.out.println(customer); } }如果觉得有收获，不妨花个几秒钟点个赞，欢迎关注我的公众号玩编程地码农，目前专注于写java相关、数据结构与算法和计算机基础等。