protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String fname=request.getParameter("fname"); String lname=request.getParameter("lname"); String gender=request.getParameter("gender"); String dob=request.getParameter("dob"); String addr=request.getParameter("addr"); String email=request.getParameter("email"); String phone=request.getParameter("phone"); String duname=request.getParameter("duname"); String dupwd=request.getParameter("dupwd"); try{ Class.forName("org.apache.derby.jdbc.ClientDriver"); Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/ers","root","root"); Statement stmt = conn.createStatement(); String sql = "insert into app.createaccount values('"+fname+"','"+lname+"','"+gender+"','"+dob+"','"+addr+"','"+email+"','"+phone+"','"+duname+"','"+dupwd+"')"; System.out.println(sql); int s=stmt.executeUpdate(sql); if(s==0) { request.getRequestDispatcher("CreateAccSuccess.jsp").forward(request,response); } else { request.getRequestDispatcher("CreateAccFailure.jsp").forward(request,response); } }catch(Exception e ) { e.printStackTrace(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)