springboot+spring-data-jpa

1.配置pxm.xml

        <dependency>
            <groupId>org.springframework.data</groupId>
            <artifactId>spring-data-jpa</artifactId>
            <version>1.10.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>     

   <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.39</version>
   </dependency>

2.application.properties 配置

# 数据源配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
spring.datasource.username=test
spring.datasource.password=123123
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#JPA (JpaBaseConfiguration, HibernateJpaAutoConfiguration)
spring.data.jpa.repositories.enabled=true
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.DefaultNamingStrategy
spring.jpa.generate-ddl=false
spring.jpa.show-sql=true
spring.jpa.hibernate.naming_strategy=org.hibernate.cfg.DefaultNamingStrategy
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

3.实体类

@Entity
@Table(name = "user", schema = "test", catalog = "")
public class UserModel {
    private int id;
    private String name;
    private String sex;
    private Integer age;

    @Id
    @Column(name = "id", nullable = false)
    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    @Basic
    @Column(name = "name", nullable = true, length = 20)
    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    @Basic
    @Column(name = "sex", nullable = true, length = 2)
    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    @Basic
    @Column(name = "age", nullable = true)
    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

4.编写一个Repository类

package com.lj.data.repositories;

import com.lj.data.models.UserModel;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by LJ on 2018/3/14.
 */
public interface UserRepository extends JpaRepository<UserModel, Integer>, JpaSpecificationExecutor<UserModel> {
    @Query("select a from UserModel a")
    List<UserModel> getUsers();
}

5.service层

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserRepository usersRepository;

    @Override
    public List<UserModel> findAll() {
        return usersRepository.getUsers();
    }

    @Override
    public void add(UserModel userModel) {
        usersRepository.save(userModel);
    }
}

public interface UserService {
    List<UserModel> findAll();

    void add(UserModel usersModel);
}

6.controller层

@RestController
public class UserController {

    private final static Logger logger = LoggerFactory.getLogger(UserController.class);
    @Autowired
    private UserService userService;

    @RequestMapping(value = "/getAll")
    public List<UserModel> getAll() {
        return userService.findAll();
    }

    @RequestMapping(value = "/add")
    public void add() {
        UserModel model = new UserModel();
        model.setName("张三");
        model.setSex("男");
        model.setAge(12);
        userService.add(model);
    }
}

7.测试一下: http://127.0.0.1:8080/add

http://127.0.0.1:8080/getAll