yashhguptaa1 / clinicfromscratch Goto Github PK

Registration and Login with Spring Boot, Spring Security, Thymeleaf, Hibernate and MySQL - PART 1
Spring Boot Security Authentication with Hibernate JPA and MySQL
Spring Boot + Spring Security with JPA authentication and MySQL from scratch - Java Brains

SQL COMMANDS THAT WERE EXECUTED SUCCESSFULLY

Hibernate: select doctor0_.doctorid as doctorid1_0_, doctor0_.address as address2_0_, doctor0_.dutydays as dutydays3_0_, doctor0_.dutytime as dutytime4_0_, doctor0_.name as name5_0_, doctor0_.phone as phone6_0_, doctor0_.speciality as speciali7_0_ from doctor doctor0_
Hibernate: insert into doctor (address, dutydays, dutytime, name, phone, speciality, doctorid) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: select doctor0_.doctorid as doctorid1_0_, doctor0_.address as address2_0_, doctor0_.dutydays as dutydays3_0_, doctor0_.dutytime as dutytime4_0_, doctor0_.name as name5_0_, doctor0_.phone as phone6_0_, doctor0_.speciality as speciali7_0_ from doctor doctor0_
Hibernate: delete from doctor where doctorid=?
Hibernate: select doctor0_.doctorid as doctorid1_0_, doctor0_.address as address2_0_, doctor0_.dutydays as dutydays3_0_, doctor0_.dutytime as dutytime4_0_, doctor0_.name as name5_0_, doctor0_.phone as phone6_0_, doctor0_.speciality as speciali7_0_ from doctor doctor0_
Hibernate: update doctor set address=?, dutydays=?, dutytime=?, name=?, phone=?, speciality=? where doctorid=?
Hibernate: select doctor0_.doctorid as doctorid1_0_, doctor0_.address as address2_0_, doctor0_.dutydays as dutydays3_0_, doctor0_.dutytime as dutytime4_0_, doctor0_.name as name5_0_, doctor0_.phone as phone6_0_, doctor0_.speciality as speciali7_0_ from doctor doctor0_

We need OneToMany relationship from Doctor to Book
On using annotation @OneToMany we get Infine recursive sql queries
so we established relationship without using annotation

establish foreign key in mysql workbench
then create normal model,
define custom function in repository for that will get the result as if one to many relationship
implement it in services

Spring Security | FULL COURSE
Spring Boot + React: JWT Authentication & Authorization with Spring Security example
https://www.baeldung.com/spring-security-authentication-and-registration
https://www.baeldung.com/spring-security-registration
https://www.baeldung.com/spring-security-login-react

https://www.baeldung.com/rest-with-spring-series