public void Add(String pname,String psex,String page,String time,String doctor,
String pclass,String condition,String treat,String medical)
{
String sql="insert into patients(pname,psex,page,time,doctor,pclass,condition,treat,medical) values ('"+pname+"','"+psex+"','"+page+"','"+time+"','"+doctor+"','"+pclass+"','"+condition+"','"+treat+"','"+medical+"')";
try {
DBConnect dbc = new DBConnect();
dbc.executeUpdate(sql);
dbc.close();
} catch (SQLException ex) {
Logger.getLogger(PatientsDAO.class.getName()).log(Level.SEVERE, null, ex);
}
}
AddServlet
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String pname=request.getParameter("pname");
String psex=request.getParameter("psex");
String page=request.getParameter("page");
String time="2011-6-5";
String doctor=request.getParameter("doctor");
String pclass=request.getParameter("pclass");
String condition=request.getParameter("condition");
String treat=request.getParameter("treat");
String medical=request.getParameter("medical"); PatientsDAO add=new PatientsDAO();
add.Add(pname, psex, page, time, doctor, pclass, condition, treat, medical);
response.sendRedirect("ListServlet"); }
String pclass,String condition,String treat,String medical)
{
String sql="insert into patients(pname,psex,page,time,doctor,pclass,condition,treat,medical) values ('"+pname+"','"+psex+"','"+page+"','"+time+"','"+doctor+"','"+pclass+"','"+condition+"','"+treat+"','"+medical+"')";
try {
DBConnect dbc = new DBConnect();
dbc.executeUpdate(sql);
dbc.close();
} catch (SQLException ex) {
Logger.getLogger(PatientsDAO.class.getName()).log(Level.SEVERE, null, ex);
}
}
AddServlet
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String pname=request.getParameter("pname");
String psex=request.getParameter("psex");
String page=request.getParameter("page");
String time="2011-6-5";
String doctor=request.getParameter("doctor");
String pclass=request.getParameter("pclass");
String condition=request.getParameter("condition");
String treat=request.getParameter("treat");
String medical=request.getParameter("medical"); PatientsDAO add=new PatientsDAO();
add.Add(pname, psex, page, time, doctor, pclass, condition, treat, medical);
response.sendRedirect("ListServlet"); }
Logger.getLogger(PatientsDAO.class.getName()).log(Level.SEVERE, null, ex);
}
Changing source level to 1.3
日志显示