Scribd Logo
Upload

Welcome to Scribd!

  • 40 views

    Regdata

    Uploaded by

    Code Bind
    This document contains a Java servlet class called regdata that handles HTTP POST requests. The doPost method connects to a MySQL database, inserts user registration data received in the HTTP request (name, username, password, mobile number) into a login table using a prepared statement, and forwards the request to a JSP page. It catches any exceptions that may occur during the database insertion process.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Regdata

    Uploaded by

    Code Bind
    40 views3 pages
    This document contains a Java servlet class called regdata that handles HTTP POST requests. The doPost method connects to a MySQL database, inserts user registration data received in the HTTP request (name, username, password, mobile number) into a login table using a prepared statement, and forwards the request to a JSP page. It catches any exceptions that may occur during the database insertion process.

    Original Description:

    RegisterPage

    Original Title

    regdata

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a Java servlet class called regdata that handles HTTP POST requests. The doPost method connects to a MySQL database, inserts user registration data received in the HTTP request (name, username, password, mobile number) into a login table using a prepared statement, and forwards the request to a JSP page. It catches any exceptions that may occur during the database insertion process.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    40 views3 pages

    Regdata

    Uploaded by

    Code Bind
    This document contains a Java servlet class called regdata that handles HTTP POST requests. The doPost method connects to a MySQL database, inserts user registration data received in the HTTP request (name, username, password, mobile number) into a login table using a prepared statement, and forwards the request to a JSP page. It catches any exceptions that may occur during the database insertion process.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    package com.

    reg;

    import java.io.IOException;

    import java.sql.Connection;

    import java.sql.DriverManager;

    import java.sql.PreparedStatement;

    import javax.servlet.ServletException;

    import javax.servlet.annotation.WebServlet;

    import javax.servlet.http.HttpServlet;

    import javax.servlet.http.HttpServletRequest;

    import javax.servlet.http.HttpServletResponse;

    /**

    * Servlet implementation class regdata

    */

    @WebServlet("/regdata")

    public class regdata extends HttpServlet {

    private static final long serialVersionUID = 1L;

    /**

    * @see HttpServlet#HttpServlet()

    */

    public regdata() {

    super();

    // TODO Auto-generated constructor stub

    /**
    * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

    */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws


    ServletException, IOException {

    // TODO Auto-generated method stub

    response.getWriter().append("Served at: ").append(request.getContextPath());

    /**

    * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

    */

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws


    ServletException, IOException {

    try {

    // JDBC driver name and database URL

    final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";

    final String DB_URL = "jdbc:mysql://localhost/mydm";

    // Database credentials

    final String USER = "root";

    final String PASS = "root";

    System.out.println("hi");

    Connection conn = null;

    PreparedStatement stmt = null;

    //STEP 2: Register JDBC driver

    Class.forName(JDBC_DRIVER);

    //STEP 3: Open a connection


    System.out.println("Connecting to a selected database...");

    conn = DriverManager.getConnection(DB_URL, USER, PASS);

    System.out.println("Connected database successfully...");

    //STEP 4: Execute a query

    System.out.println("Inserting records into the table...");

    stmt = conn.prepareStatement("insert into login values(?,?,?,?)");

    stmt.setString(1, request.getParameter("n1"));

    stmt.setString(2, request.getParameter("un1"));

    stmt.setString(3, request.getParameter("pass"));

    stmt.setString(4,request.getParameter("mno1"));

    stmt.executeUpdate();

    System.out.println("Inserted records into the table...");

    request.getRequestDispatcher("login.jsp").forward(request, response);

    catch(Exception e)

    System.out.println("wrong");

    e.printStackTrace();

    You might also like