springboot如何对本地数据库增删改查_SpringBoot 数据库操作 增删改查

1、pom添加依赖

org.springframework.boot

spring-boot-starter-data-jpa

mysql

mysql-connector-java

org.apache.poi

poi

3.11

2、application.properties文件中添加数据库配置

spring.datasource.url = jdbc:mysql://localhost:3306/dss

spring.datasource.username =root

spring.datasource.password= 123spring.datasource.driverClassName=com.mysql.jdbc.Driver

# Specify the DBMS

spring.jpa.database=MYSQL

# Show or not logforeach sql query

spring.jpa.show-sql = true# Hibernate ddl auto (create, create-drop, update)

spring.jpa.hibernate.ddl-auto =update

# Naming strategy

spring.jpa.hibernate.naming-strategy =org.hibernate.cfg.ImprovedNamingStrategy

# stripped before adding them to the entity manager)

spring.jpa.properties.hibernate.dialect= org.hibernate.dialect.MySQL5Dialect

3、创建Entity实体类

packagecom.haha.demo;importjavax.persistence.Entity;importjavax.persistence.GeneratedValue;importjavax.persistence.Id;import javax.persistence.*;

@Entity

@Table(name= "link")public classLink {

@Id

@GeneratedValue(strategy=GenerationType.AUTO)privateInteger id;privateString name;privateString link;privateString img;privateInteger code;privateString shijian;publicLink(){

}publicInteger getId() {returnid;

}public voidsetId(Integer id) {this.id =id;

}publicString getName() {returnname;

}public voidsetName(String name) {this.name =name;

}publicString getLink() {returnlink;

}public voidsetLink(String link) {this.link =link;

}publicString getImg() {returnimg;

}public voidsetImg(String img) {this.img =img;

}publicInteger getCode() {returncode;

}public voidsetCode(Integer code) {this.code =code;

}publicString getShijian() {returnshijian;

}public voidsetShijian(String shijian) {this.shijian =shijian;

}

}

4、创建接口类

packagecom.haha.demo;importjava.util.List;importorg.springframework.data.jpa.repository.Query;importorg.springframework.data.repository.CrudRepository;public interface LinkRepository extends CrudRepository{

ListfindByName(String name);

@Query("SELECT m FROM Link m where m.name like %?1% order by id desc ")

Listsearch(String name);

}

5、创建Controller

packagecom.haha.demo;importorg.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.*;importjava.util.List;

@RequestMapping("/link")

@RestControllerpublic classLinkController {

@AutowiredprivateLinkRepository linkRepository;/*** 查询列表

*@return

*/@PostMapping(value= "/list")

@ResponseBodypublic ListgetlinklList(String name) {return (List) linkRepository.findAll();

} }

6、数据库的添加，修改操作

Link link= new Link();

link.setLink("aaa");

link.setName("aaa");

link.setImg("aaa");

link.setShijian("1505090911");

link.setCode(9);

link.setId(10); //修改操作添加此句，添加操作略去此句

linkRepository.save(link);

7、数据库的删除操作

linkRepository.deleteById(7); //删除id为7的选项

linkUrlRepository.deleteAll(); //删除所有数据