Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class NewUser extends HttpServlet {
- /**
- * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
- * 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
Add Comment
Please, Sign In to add comment