Skip to content

Instantly share code, notes, and snippets.

@JavaNoobPig

JavaNoobPig/SpringJPA11_2.java

Created April 29, 2019 05:51
Show Gist options
  • Save JavaNoobPig/608b676ee746fc14f737abf3ba5f22c2 to your computer and use it in GitHub Desktop.
Save JavaNoobPig/608b676ee746fc14f737abf3ba5f22c2 to your computer and use it in GitHub Desktop.
Download ZIP
SpringJPA11_2
Raw
SpringJPA11_2.java
package com.pig.jpa.hibernate.demo.repository;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.Query;
import javax.persistence.TypedQuery;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import com.pig.jpa.hibernate.demo.DemoApplication;
import com.pig.jpa.hibernate.demo.entity.Course;
@RunWith(SpringRunner.class)
@SpringBootTest(classes=DemoApplication.class)
public class JPQLTest {
private Logger logger=LoggerFactory.getLogger(this.getClass());
@Autowired
EntityManager em;
@Test
public void jpql_basic() {
//課程說此resultlist內包含的物件尚不為Course物件，而是Row type
Query query = em.createQuery("select c from Course c");
List resultlist = query.getResultList();
logger.info("jpql_basic:select c from Course c ->{}",resultlist);
//不過我用下面這行證明確實是Course物件
logger.info("jpql_basic:type of list inside -> {}",resultlist.get(0) instanceof Course);
}
@Test
public void jpql_typed() {
//強制限定回傳之物件種類
TypedQuery<Course> query= em.createQuery("select c from Course c",Course.class);
List<Course> resultlist=query.getResultList();
logger.info("jpql_typed:select c from Course c ->{}",resultlist);
}
@Test
public void jpql_where() {
//WHERE條件
TypedQuery<Course> query= em.createQuery("select c from Course c where name like 'Spring Boot%' ",Course.class);
List<Course> resultlist=query.getResultList();
logger.info("jpql_where:select c from Course c ->{}",resultlist);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment