数据库中的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) 个答案