目标

用sring data方式创建一张employee表，包含id/name/age字段，id自增，name长度20，name/age不能为空。

创建一个通过name查询employee的方法，并测试之。

项目结构

Maven依赖

          
     
      mysql
           
     
      mysql-connector-java
           
     
      5.1.38
         
        
          
     
      org.springframework.data
           
     
      spring-data-jpa
           
     
      1.8.0.RELEASE
         
        
          
     
      org.hibernate
           
     
      hibernate-entitymanager
           
     
      4.3.6.Final
         
    

代码编写

建立对象模型

Employee.java

package com.dotleo.entity;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.Id;/** * 雇员 : 先开发实体类 ---> 自动生成数据库 * @author LiuFei * @create 2017-11-06 21:23 */@Entitypublic class Employee {    @GeneratedValue    @Id    private Integer id;    @Column(length = 20 ,nullable = false)    private String name;    @Column(nullable = false)    private Integer age;    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public Integer getAge() {        return age;    }    public void setAge(Integer age) {        this.age = age;    }    @Override    public String toString() {        return "Employee{" +                "id=" + id +                ", name='" + name + '\'' +                ", age=" + age +                '}';    }}

spring配置文件 - beans.xml 创建

此文件为最终版，可能由于部分类还没创建报错，暂时不用管

beans.xml

    
        
         
             
              
              
              
          
         
         
             
              
                  
               
              
              
                  
                       
        
         org.hibernate.cfg.ImprovedNamingStrategy
                        
        
         org.hibernate.dialect.MySQL5InnoDBDialect
                        
        
         true
                        
        
         true
                        
        
         update
                    
               
          
         
         
             
          
         
         
         
         
         
     
    

EmployeeRepository接口创建

package com.dotleo.repository;import com.dotleo.entity.Employee;import org.springframework.data.repository.Repository;/** * @author LiuFei * @create 2017-11-06 22:44 */public interface EmployeeRepository extends Repository
    
     {    public Employee findByName(String name);}
    

测试类创建

package com.dotleo.repository;import com.dotleo.entity.Employee;import org.junit.After;import org.junit.Before;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;/** * @author LiuFei * @create 2017-11-06 22:48 */public class EmployeeRepositoryTest {    ApplicationContext ctx = null;    EmployeeRepository employeeRepository = null;    @Before    public void setup() {        ctx = new ClassPathXmlApplicationContext("beans.xml");        employeeRepository = ctx.getBean(EmployeeRepository.class);    }    @After    public void tearDown() {        ctx = null;    }    @Test    public void testFindByName() {        Employee employee = employeeRepository.findByName("zhangsan");        if (employee != null) {            System.out.println(employee.toString());        }    }}