springboot CRUD

一、添加pom.xml依赖

1、添加模板支持依赖

<dependency>
    	<groupId>org.springframework.boot</groupId>
    	<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>

2、添加数据库访问JPA支持依赖

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

3、添加mysql数据库支持依赖

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

二、在resources目录下创建application.properties文件，配置数据库连接信息，如下：

spring.datasource.url=jdbc:mysql://localhost:3306/shangpin
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

三、java类：repository、controller

在src/main/java包下创建repository包，并创建***Rep.java接口文件:

package shangpin.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import shangpin.entity.ShangPin;

public interface ShangPinRep extends JpaRepository<ShangPin, Integer>{
	
}

在src/main/java包下创建controller包，并创建***controller.java类文件:

没有做页面，测试数据在java类中写死，在URL中直接访问requestmapping进行测试。

package shangpin.controller; 

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import shangpin.entity.ShangPin;
import shangpin.repository.ShangPinRep;

@RestController
@RequestMapping("/shangPin")
public class ShangPinController {
	@Autowired
	private ShangPinRep shangPinRep;
	
	/**
	 * 查询商品
	 */
	@RequestMapping("/chaXunShangPin")
	public List<ShangPin> chaXunShangPin(){
		return shangPinRep.findAll();
	}
	
	/**
	 * 添加商品
	 */
	@RequestMapping("/tianJiaShangPin")
	public void tianJiaShangPin(){
		ShangPin sp = new ShangPin();
		sp.setShangPinBianHao("shangpinbianhao001");
		sp.setShangPinMingCheng("shangpinmingcheng001");
		shangPinRep.save(sp);
	}
	
	/**
	 * 删除商品
	 */
	@RequestMapping("/shanChuShangPin")
	public String shanChuShangPin(){
		int id = 1;
		shangPinRep.delete(id);
		return "OK";
	}
	
	/**
	 * 更新商品
	 */
	@RequestMapping("/gengXinShangPin")
	public String gengXinShangPin(){
		ShangPin sp = new ShangPin();
		sp.setId(1);
		sp.setShangPinBianHao("001");
		sp.setShangPinMingCheng("mingcheng0011");
		shangPinRep.saveAndFlush(sp);
		return "OK";
	}
}

四、创建mysql数据库表并添加测试数据：

CREATE TABLE `NewTable` (
`id`  int(9) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT ,
`shangpinbianhao`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`shangpinmingcheng`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)

五、启动服务，进行测试，在数据库表中查看数据增删改查结果。