SpringBoot JPA实现查询多值

<dependency>

       <groupid>org.springframework.boot</groupid>

       <artifactid>spring-boot-starter-jdbc</artifactid>

     </dependency>

     <!-- 数据库驱动 -->

     <dependency>

       <groupid>com.oracle</groupid>

       <artifactid>ojdbc6</artifactid>

       <version> 11.2 . 0.3 </version>

     </dependency>

<!-- 定义spring-boot-starter-data-jpa -->

      <dependency>

         <groupid>org.springframework.boot</groupid>

         <artifactid>spring-boot-starter-data-jpa</artifactid>

   </dependency>

package cn.xdl.entity;

import java.io.serializable;

import javax.persistence.column;

import javax.persistence.entity;

import javax.persistence.id;

import javax.persistence.table;

@entity

@table (name= "emp" ) //通常和@entity配合使用,只能标注在实体的class定义处,表示实体对应的数据库表的信息

public class emp implements serializable{

   /**

    *

    */

   private static final long serialversionuid = 1l;

   @id //定义了映射到数据库表的主键的属性,一个实体只能有一个属性被映射为主键置于getxxxx()前

   @column (name= "empno" ) //name表示表的名称默认地,表名和实体名称一致,只有在不一致的情况下才需要指定表名

   private integer empno;

   @column (name= "ename" )

   private string ename;

   @column (name= "job" )

   private string job;

   @column (name= "mgr" )

   private int mgr;

   public integer getempno() {

     return empno;

   }

   public void setempno(integer empno) {

     this .empno = empno;

   }

   public string getename() {

     return ename;

   }

   public void setename(string ename) {

     this .ename = ename;

   }

   public string getjob() {

     return job;

   }

   public void setjob(string job) {

     this .job = job;

   }

   public int getmgr() {

     return mgr;

   }

   public void setmgr( int mgr) {

     this .mgr = mgr;

   }

   @override

   public string tostring() {

     return "emp [empno=" + empno + ", ename=" + ename + ", job=" + job + ", mgr=" + mgr + "]" ;

   }

}

package cn.xdl.jpa;

import org.springframework.data.jpa.repository.jparepository;

import cn.xdl.entity.emp;

//jparepository:jpa资源库

/**

  * 1.所有继承该接口的都被spring所管理，改接口作为标识接口，功能就是用来控制domain模型的

  * 2.spring data可以让我们只定义接口，只要遵循spring data的规范,无需写实现类。

  *

  */

public interface empdao extends jparepository<emp, integer>{

}

@springbootapplication

public class mybootapplication {

   public static void main(string[] args) throws sqlexception {

     applicationcontext ioc = springapplication.run(mybootapplication. class , args);

     // 自动配置创建datasource，id名为datasource

     datasource ds = ioc.getbean( "datasource" , datasource. class );

     system.out.println(ds);

     system.out.println( "=================" );

     system.out.println( "=================" );

     system.out.println( "=================" );

     empdao empdao = ioc.getbean( "empdao" , empdao. class );

     /**

      * 遍历

      */

     list<emp> empdatas = empdao.findall();

     for (emp emp : empdatas) {

       system.out.println(emp);

     }

   }

}