<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId> </dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId> </dependency>
spring:profiles:active: devdatasource:driver-class-name: com.mysql.jdbc.Driverurl: jdbc:mysql://127.0.0.1:3306/dbgirlusername: rootpassword: rootjpa:hibernate:ddl-auto: updateshow-sql: true
3接口GirlRepository(继承一个接口)
import org.springframework.data.jpa.repository.JpaRepository;public interface GirlRepository extends JpaRepository<Girl,Integer> {}
一个数据库有几个内模式。
import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id;@Entity public class Girl {@Id@GeneratedValueprivate Integer id;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getCupSize() {return cupSize;}public void setCupSize(String cupSize) {this.cupSize = cupSize;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}private String cupSize;private Integer age;/*** 记得要有一个构造函数*/public Girl(){} }
import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.List;@RestController public class GirlController {@Autowiredpublic GirlRepository girlRepository;/*** 查询所有女生列表* @return*/@GetMapping(value = "/girls")public List<Girl> girlList(){return girlRepository.findAll();}/*** 添加一个女生*/@PostMapping(value = "/girls")public Girl addGirl(@RequestParam("cupSize") String cupSize,@RequestParam("age") Integer age){Girl girl = new Girl();girl.setCupSize(cupSize);girl.setAge(age);return girlRepository.save(girl);}/*** 查询一个女生* @param id* @return*/@GetMapping(value = "/girls/{id}")public Girl GirlFindONe(@PathVariable("id") Integer id){return girlRepository.findOne(id);}/*** 更新一个女生* @param id* @param cupSize* @param age* @return*/@PutMapping(value = "/girls/{id}")public Girl girlUpdate(@PathVariable("id") Integer id,@RequestParam("cupSize") String cupSize,@RequestParam("age") Integer age){Girl girl = new Girl();girl.setId(id);girl.setCupSize(cupSize);girl.setAge(age);return girlRepository.save(girl);}/*** 删除一个女生* @param id*/@DeleteMapping(value = "/girls/{id}")public void girlDelete(@PathVariable("id") Integer id){girlRepository.delete(id);} }
java jdbc执行sql语句、
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态