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(); //删除所有数据