obaid abbassi

I am using springboot data jpa to save my employee here is my entity class import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.GenerationType; import jakarta.persistence.Id; @Entity public class Employee {    public int getEmpId() {        return EmpId;    }    public void setEmpId(int empId) {        EmpId = empId;    }    @Override    public String toString() {        return "Employee{" +                "EmpId=" + EmpId +                ", EmpName=" + EmpName +                '}';    }    @Id    @GeneratedValue(strategy = GenerationType.IDENTITY)    private int EmpId;    public String getEmpName() {        return EmpName;    }    public void setEmpName(String empName) {        EmpName = empName;    }    private String EmpName; }

this is my service class
import com.example.rest_springboot_jpa.Entity.Employee; import com.example.rest_springboot_jpa.Repository.EmployeeRepository; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @Service public class EmployeeService {    @Autowired    EmployeeRepository employeeRepository;    public void addEmployee(Employee employee){        employeeRepository.save(employee);    } }

this is my employee repository package com.example.rest_springboot_jpa.Repository; import com.example.rest_springboot_jpa.Entity.Employee; import org.springframework.data.repository.CrudRepository; import org.springframework.stereotype.Repository; import org.springframework.web.bind.annotation.RestController; public interface EmployeeRepository extends CrudRepository<Employee,Integer> { }

this is my controller class package com.example.rest_springboot_jpa.Controller; import com.example.rest_springboot_jpa.Entity.Employee; import com.example.rest_springboot_jpa.Repository.EmployeeRepository; import com.example.rest_springboot_jpa.Service.EmployeeService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; @RestController public class EmployeeController {    @Autowired    EmployeeRepository employeeRepository;    @Autowired    EmployeeService employeeService;    @PostMapping("/add" )    public void addEmployee(Employee employee,@RequestParam("name") String name){ employee.setEmpName(name);      employeeService.addEmployee(employee);    } }

this is my simple jsp page
<form method="post" action="/add">    <input type="text" placeholder="enter your text" name="name">    <input type="submit"> </form> Now when i submit value to controller I got error says java.sql.SQLSyntaxErrorException: Table 'emp.employee' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.30.jar:8.0.30] asking me for table so Its not my resposiblilty to create table why jpa not creating table this is properties file spring.datasource.url=jdbc:mysql://localhost:3306/emp spring.datasource.username=root spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.password= spring.jpa.properties.hibernate.Dialect=org.hibernate.dialect.MySQL55Dialect spring.jpa.hibernate.ddt-auto=create

So should I change patient to OneToMany and doctor to ManyToOne??

I got the duplicate key problem in db
because patientID is repeating if same patient takes appointment with another doctor
is it caused for OneToOne relation?

I have two entities patient and doctor I want to build relation between patient and doctor

like
@Entity Class Patient{ @Id private int pId; private int pName; @OneToOne private Doctor doctor; } @Entity Class Doctor{ @Id private int dId; private int dName; @OneToOne private Patient patient; }
Now I want to get dId in patient table and pId in Doctor table vice versa
is this a valid mapping?

<input type="time" id="time">

<a href="Patient_Booking?time=<script>document.getElementById('time').value</script>"
is it possible to pass time in anchor tag

so how can we convert it in 12hour formate

but input field time am pm is also given on selecting it still no string

i tried with form its working but problem is I got the time like

time is 20:37 without am and pm

How I would no this time is am or pm?

no

Hello!
I am getting user input time and date and fetching it in servlet to save in data base but getting null values my logic is
<input type="time" name="time" id="time"> <input type="date" name="date" id="date">

in servlet

String time=request.getParameter("time") String date=request.getParameter("date")

how to get values ?

thanks a lot, it worked.

Now please tell me can we use any other technology for frontend with same project instead of index.jsp like react app.js etc please guide me
can spring mvc handle data from react and send it in db like mysql?

Hello I m creating a spring mvc web project using intellijiee IDE and tomcat 9 server every thing going perfect
I m facing problem with my urls

If I put all my jsp files inside WEB_INF->VIEW->index.jsp,about.jsp

on starting my server 404 error is there but if I put index.jsp under Webapp it works perfect

but problem is when I hit url like localhost:8080/about it works because I configure it in controller
but when I hit localhost:8080/ 404 error is found because my index page is not now inside VIEW folder

below all jsps are under WEB_INF->VIEW->about.jsp,help.jsp,contact.jsp but my index is not under it because on starting server I face 404
when I hit /home index.jsp not runs It shows 404 but a little trick works If I put index.jsp inside VIEW as well and webapp folder too then my problem solves
What Should I do?
@Controller public class HomeController {    @RequestMapping("/home") public String home(){    return "index"; }    @RequestMapping("/about")    public String about(){        return "about";    }    @RequestMapping("/contact")    public String contact(){            return "contact";    }    @RequestMapping("/help")    public String help(){        System.out.println("this is help");        return "help";    } }

no reply from experts?

My directory structure is attached

Here is my entity class
package com.your_notes.yournotes; import jakarta.persistence.Entity; import jakarta.persistence.Id; import jakarta.persistence.Table; @Entity @Table(name = "notesdata") public class Demodata { @Id    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public Demodata(String name) {        this.name = name;    }    private String name;    public Demodata() {    } }