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

Revisions

  1. JavaNoobPig created this gist Apr 29, 2019.
    55 changes: 55 additions & 0 deletions SpringJPA11_2.java
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,55 @@
    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);
    }

    }