有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

数据库中的java Spring最后一个ID作为JSP中的默认输入值。。怎样

我正在编写一个应用程序,在显示数据库中的最后一个ID时遇到了一些问题,我希望JSP中的输入字段有一个默认值,即数据库中的最后一个ID。我尝试了一些选项,比如value="id" or value "${patient.id}",但都没用。我该怎么做才对?下面是一个代码:

登记病人。jsp:

<p style="font-size: 26">
        ID<input style="font-family: Century Gothic; font-size: 26"
            type="text" value="//LAST ROW FROM DB//" name="id" disabled="disabled" />

控制器:

    @RequestMapping(value="/registration.html", method = RequestMethod.GET)
public ModelAndView registrationPatient(@ModelAttribute("patient") Patient patient){

    setAppContext();

    clinicService.getNextId(patient);

    ModelAndView reg = new ModelAndView("RegistrationPatient");
    return reg;

}

临床医生服务:

     public String getNextId(Patient patient){
     ClassPathXmlApplicationContext ctx = new   ClassPathXmlApplicationContext("clinicconfig.xml");
      patientDAO = ctx.getBean("patientDAO", PatientDAOImpl.class);

      patient.setId(patient.getId());

      return patientDAO.getNextId(patient);

    }

PatientDAOImpl:

public String getNextId(Patient patient) {
    String query = "SELECT idpatient FROM virtualclinic.patient ORDER BY idpatient DESC LIMIT 1";
    Connection con = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    try{
        con = dataSource.getConnection();
        ps = con.prepareStatement(query);
        rs = ps.executeQuery();

        while (rs.next()){
            int PID;
            PID = Integer.parseInt(rs.getString(1));
            int nextPID = PID + 1;
            patient.setId(String.valueOf(nextPID));
        }
       return patient.getId();

    }catch(SQLException e){
        e.printStackTrace();
    }

共 (0) 个答案