英文:
Unable to save form tomysql database in spring boot thymeleaf application
问题
抱歉,我无法完成您的要求。
英文:
I built a simply CRUB using spring boot and thymeleaf but the form does not save values to the database on submit.
Here is my controller:
@Controller
public class ClientController {
private static final Logger LOG = LoggerFactory.getLogger(ClientController.class);
@Autowired
private ClientRepository clientRepository;
@GetMapping("/patients")
public String getAllClients(Model model) {
    List<Client> clients = clientRepository.findAll();
    model.addAttribute("clients", clients);
    return "patient/list-patients";
}
@GetMapping("/add-patient")
public String addClient(Model model) {
    model.addAttribute("client", new Client());
    return "patient/add-patient";
}
@PostMapping("/add-patient")
public String addClient(@Valid @ModelAttribute Client client, BindingResult bindingResult) {
	LOG.info("Saving client: {}", client);
    if (bindingResult.hasErrors()) {
    return "patient/add-patient";
    }
    clientRepository.save(client);
    return "redirect:/add-patient";
}
@GetMapping("/edit/{id}")
public String editClient(@PathVariable("id") Long id, Model model) {
    model.addAttribute("client", clientRepository.findById(id).orElse(null));
    return "patient-edit";
}
    @GetMapping("/delete/{id}")
    public String deleteClient(@PathVariable("id") Long id) {
        clientRepository.deleteById(id);
        return "redirect:/patients";
    }
}
The model has the following code:
@Entity
@Data
public class Client {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String patientId;
    
    @Size(min=2, max=30)
    private String firstName;
    @Size(min=2, max=30)
    private String lastName;
    private String otherName;
    private String gender;
    private String email;
    private Date dateOfBirth;
    private String ageGroup;
    private String phoneNumber;
    private String address;
    
//    Identity
    private String cardType;
    private String cardNumber;
    private String iDCardNumber;
    
    
    //getters and setters
}
And finally, the form is as follows:
< div >
    <
    form action = "#"
th: action = "@{/add-patient}"
method = "post" >
    <
    p >
    <
    label
for = "firstName" > First Name: < /label> <
    input type = "text"
id = "firstName"
name = "firstName" / >
    <
    /p> <
    p >
    <
    label
for = "lastName" > Last Name: < /label> <
    input type = "text"
id = "lastName"
name = "lastName" / >
    <
    /p> <
    p >
    <
    label
for = "otherName" > Other Name(s): < /label> <
    input type = "text"
id = "otherName"
name = "otherName" / >
    <
    /p> <
    p >
    <
    label
for = "dateOfBirth" > Date of Birth: < /label> <
    input type = "date"
id = "dateOfBirth"
name = "dateOfBirth" / >
    <
    /p> <
    p >
    <
    label
for = "address" > Address: < /label> <
    input type = "text"
id = "address"
name = "address" / >
    <
    /p> <
    p >
    <
    label
for = "email" > Email: < /label> <
    input type = "email"
id = "email"
name = "email" / >
    <
    /p> <
    p >
    <
    label
for = "phoneNumber" > Phone Number: < /label> <
    input type = "tel"
id = "phoneNumber"
name = "phoneNumber" / >
    <
    /p> <
    p >
    <
    label
for = "gender" > Gender: < /label> <
    select id = "gender"
name = "gender" >
    <
    option value = "Male" > Male < /option> <
    option value = "Female" > Female < /option> <
    option value = "Other" > Other < /option> <
    /select> <
    /p> <
    p >
    <
    label
for = "ageGroup" > Age Group: < /label> <
    select id = "ageGroup"
name = "ageGroup" >
    <
    option value = "Under 18" > Under 18 < /option> <
    option value = "18-25" > 18 - 25 < /option> <
    option value = "26-35" > 26 - 35 < /option> <
    option value = "36-45" > 36 - 45 < /option> <
    option value = "46-55" > 46 - 55 < /option> <
    option value = "Over 55" > Over 55 < /option> <
    /select> <
    /p> <
    p >
    <
    label
for = "cardType" > Card Type: < /label> <
    select id = "cardType"
name = "cardType" >
    <
    option value = "passport" > Passport < /option> <
    option value = "Ghana Card" > Ghana Card < /option> <
    /select> <
    /p> <
    p >
    <
    label
for = "cardNumber" > Card Number: < /label> <
    input type = "text"
id = "cardNumber"
name = "cardNumber" / >
    <
    /p> <
    input type = "submit"
value = "Save" / >
    <
    /form> <
    /div>
答案1
得分: 0
已解决,显然我需要使用以下方法更新我的控制器:
@PostMapping("/add-patient")
public String addClient(@ModelAttribute Client client) {
    LOG.info("Saving client: {}", client);
    // 格式化日期
    Date date = client.getDateOfBirth();
    DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
    String strDate = dateFormat.format(date);
    client.setDateOfBirth(client.getDateOfBirth());
    clientRepository.save(client);
    return "redirect:/add-patient";
}
最后添加:
@DateTimeFormat(pattern = "yyyy-MM-dd")
这对我起作用。
英文:
Solved it, apparently i have to update my controller with the method:
    @PostMapping("/add-patient")
public String addClient(@ModelAttribute Client client) {
    LOG.info("Saving client: {}", client);
    
    // Format the date
    Date date = client.getDateOfBirth();
    DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
    String strDate = dateFormat.format(date);
    
    client.setDateOfBirth(client.getDateOfBirth());
    
    clientRepository.save(client);
    
    return "redirect:/add-patient";
}
and finally add
> @DateTimeFormat(pattern = "yyyy-MM-dd")
Worked for me
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。


评论