jdbc連接數據庫實現增刪改查，springboot如何對本地數據庫增刪改查_SpringBoot 數據庫操作 增刪改查

1、pom添加依賴

org.springframework.boot

spring-boot-starter-data-jpa

mysql

jdbc連接數據庫實現增刪改查。mysql-connector-java

org.apache.poi

poi

3.11

2、application.properties文件中添加數據庫配置

jdbc增刪改查，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

springboot注解？# 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

spring mvc教程。# 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

mybatis教程？@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;

MySQL增刪改查，}publicString getName() {returnname;

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

}publicString getLink() {returnlink;

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

}publicString getImg() {returnimg;

springboot、}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;

mybatisplus增刪改查，}

}

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);

mybatis注解增刪改查、@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;

springboot怎么寫接口、@RequestMapping("/link")

@RestControllerpublic classLinkController {

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

*@return

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

spring增刪改查，@ResponseBodypublic ListgetlinklList(String name) {return (List) linkRepository.findAll();

} }

6、數據庫的添加，修改操作

Link link= new Link();

link.setLink("aaa");

java對數據庫的增刪改查？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(); //刪除所有數據