Spread the word.

Share the link on social media.

Share
  • Facebook
Have an account? Sign In Now

Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have permission to ask a question, You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

SIKSHAPATH

SIKSHAPATH Logo SIKSHAPATH Logo

SIKSHAPATH Navigation

  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Shop
    • Internshala Answers
Search
Ask A Question

Mobile menu

Close
Ask A Question
  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Shop
    • Internshala Answers
Home/ Questions/Q 16897
Next
Answered

SIKSHAPATH Latest Questions

Pavanagg
  • 2
  • 2
Pavanagg
Asked: May 5, 20222022-05-05T19:39:57+05:30 2022-05-05T19:39:57+05:30In: Computer Science

Write a Signup servlet that enables the user to register …

  • 2
  • 2

Write a Signup servlet that enables the user to register a user from an HTML form, as shown in Figure below. Suppose the user information is stored in a database table named Account with three columns: email, password, and confirm password(a local or cloud database is acceptable). The servlet performs the following tasks:
a. Verify that the password and confirm password are the same. If not, report the error and prompt the user the inconsistency.
b. If the user already exists in the database, report that this user is already in the system.

c. If the user does not exist in the database, save the user’s email, password to the database.

Write a Signup servlet that enables the user to register ...

  • 1 1 Answer
  • 141 Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    1 Answer

    • Voted
    • Oldest
    • Recent
    1. ADMIN 2
      Best Answer
      ADMIN 2
      2022-05-05T19:48:03+05:30Added an answer on May 5, 2022 at 7:48 pm

      CODE:

       

      import java.io.*;
      import javax.servlet.*;
      import javax.servlet.http.*;
      import java.sql.*;
      
      public class Register extends HttpServlet {
      
      protected void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
      response.setContentType("text/html;charset=UTF-8");
      PrintWriter out = response.getWriter();
      ResultSet rs = null;
      
      String email = request.getParameter("email");
      String pass = request.getParameter("pass");
      String confrmPass = request.getParameter("confrmPass");
      
      if (pass != confrmPass) {
      out.println("Entered password and confirm password are not same.");
      }
      else {
      try {
      Class.forName("com.mysql.jdbc.Driver");
      Connection con = DriverManager.getConnection
      ("localhost:3306","username","password");
      
      String sql = "SELECT * FROM login WHERE email = ?";
      
      preparedStatement = connection.prepareStatement(sql);
      preparedStatement.setString(1, email);
      
      rs = preparedStatement.getResultSet();
      
      if(rs.next()) {
      out.println("User already exists!");
      }
      else {
      PreparedStatement ps = con.prepareStatement
      ("insert into Student values(?,?)");
      ps.setString(1, email);
      ps.setString(2, pass);
      int i = ps.executeUpdate();
      if(i > 0) {
      out.println("User sucessfully registered!");
      }
      } 
      }
      catch(Exception se) {
      se.printStackTrace();
      }
      }
      }
      }
      
      
        • 3
      • Reply
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn

    Leave an answer
    Cancel reply

    You must login to add an answer.

    Forgot Password?

    Need An Account, Sign Up Here

    Sidebar

    store ads

    Stats

    • Questions 1k
    • Answers 1k
    • Posts 149
    • Best Answers 89
    • This Free AI Tool Translates Entire Books in Minute !
    • AI News: 🎬 Hollywood’s AI Studios, 🎓 OpenAI’s Latest Gift to Educators, 🚚 Class8 Bags $22M, 🧠 Google Gemini’s Memory Upgrade
    • AI NEWS: Legal Action Against OpenAI, $16M Paid, & Elon Musk’s Praise from Investor 🤖💰📑 | AI Boosts Cloud Seeding for Water Security 🌱💧
    • AI News: 🎬AI Video Tool Scam Exposed🤯, 🛰️ AI-Powered Drones to Ukraine 😱, Google’s $20M AI Push, Sam Altman Joins SF’s Leadership Team
    • AI News: 🤝 Biden Meets Xi on AI Talks, 💡 Xavier Niel’s Advice for Europe, ♻️ Hong Kong’s Smart Bin Revolution, 🚀 AI x Huawei

    Explore

    • Recent Questions
    • Questions For You
    • Answers With Time
    • Most Visited
    • New Questions
    • Recent Questions With Time

    Footer

    SIKSHAPATH

    Helpful Links

    • Contact
    • Disclaimer
    • Privacy Policy Notice
    • TERMS OF USE
    • FAQs
    • Refund/Cancellation Policy
    • Delivery Policy for Sikshapath

    Follow Us

    © 2021-24 Sikshapath. All Rights Reserved

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.