摘要：前言訪問關(guān)系型數(shù)據(jù)庫是工程常見的需求。是當(dāng)今業(yè)界應(yīng)用最廣泛的開源關(guān)系型數(shù)據(jù)庫。全家桶提供了，可以讓開發(fā)者方便快捷地開發(fā)出訪問的業(yè)務(wù)代碼。

訪問關(guān)系型數(shù)據(jù)庫是Web工程常見的需求。MySQL是當(dāng)今業(yè)界應(yīng)用最廣泛的開源關(guān)系型數(shù)據(jù)庫。Spring Boot全家桶提供了JPA，可以讓開發(fā)者方便快捷地開發(fā)出訪問MySQL的業(yè)務(wù)代碼。

1 安裝jdk1.8
2 安裝maven
3 具備Spring和SpringMVC的基礎(chǔ)知識

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

    
        org.springframework.boot
        spring-boot-starter-parent
        1.5.8.RELEASE
    

    

        
            org.springframework.boot
            spring-boot-starter-web
        

        

        
            org.springframework.boot
            spring-boot-starter-data-jpa
        

        

        
            mysql
            mysql-connector-java
        

    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
        
    

package com.example.demo;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}

spring.jpa.hibernate.ddl-auto=none
spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false
spring.datasource.username=root
spring.datasource.password=

package com.example.demo.entity;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class User {
    @Id
    @GeneratedValue(strategy= GenerationType.AUTO)
    private Integer id;

    private String name;

    private String phone;

    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 String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }
}

package com.example.demo.repository;

import com.example.demo.entity.User;
import org.springframework.data.repository.CrudRepository;

public interface UserRepository extends CrudRepository {
}

package com.example.demo.controller;

import com.example.demo.entity.User;
import com.example.demo.repository.UserRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class UserController {

    @Autowired
    private UserRepository userRepository;

    /**
     * add user
     * @param name
     * @param phone
     * @return
     */
    @RequestMapping(path="/user", method = RequestMethod.POST)
    @ResponseBody
    public String addNewUser (@RequestParam String name, @RequestParam String phone) {
        User n = new User();
        n.setName(name);
        n.setPhone(phone);
        userRepository.save(n);
        return "Success";
    }
}

curl -X POST 127.0.0.1:8080/user -d "name=tom&phone=654321"

觀察數(shù)據(jù)庫user表，發(fā)現(xiàn)增加了一條新數(shù)據(jù)

https://github.com/gzllol/spr...