public class NewUser extends HttpServlet { /** * Processes requests for both HTTP GET and POST * methods. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); HttpSession session = request.getSession(false); String [] query = new String[5]; query[0] = (String)request.getParameter("username"); query[1] = (String)request.getParameter("password"); query[2] = (String)request.getParameter("confPassword"); query[3] = (String)request.getParameter("name"); query[4] = (String)request.getParameter("address"); Jdbc jdbc = (Jdbc)session.getAttribute("dbbean"); if (jdbc == null) request.getRequestDispatcher("/WEB-INF/conErr.jsp").forward(request, response); else { jdbc.insert(query); request.setAttribute("message", query[0]+" has been registered successfully!"); } public void insert(String[] str){ PreparedStatement ps = null; try { ps = connection.prepareStatement("INSERT INTO CUSTOMER VALUES (?,?,?,?)",PreparedStatement.RETURN_GENERATED_KEYS); ps.setString(1, str[0].trim()); ps.setString(2, str[1]); ps.setString(3, str[3]); ps.setString(4, str[4]); ps.executeUpdate(); ps.close(); System.out.println("1 row added."); } catch (SQLException ex) { Logger.getLogger(Jdbc.class.getName()).log(Level.SEVERE, null, ex); } } # | Username | Password | Name | Address | ID