design and implement customer Registration system using JDBC-programmingraja

 Aim: Write a program to design and implement customer Registration system which allows you (Customers) to register them with your site. The data is captured by Servlet and stored in the database using JDBC.

Software used: NetBeans , edge ,MariaDB

Coding: 

DATABASE : 

MariaDB [practicle]> create table pro15

    -> ( name varchar(30),

    -> pass varchar(20),

    -> email varchar(30),

    -> country varchar(20));

Pro15.html

<form action="servlet/Register" method="post">  

Name:<input type="text" name="userName"/><br/><br/>  

Password:<input type="password" name="userPass"/><br/><br/>  

Email Id:<input type="text" name="userEmail"/><br/><br/>  

Country:  

<select name="userCountry">  

<option>India</option>  

<option>Pakistan</option>  

<option>other</option>  

</select>  

<br/><br/>  

<input type="submit" value="register"/>  

</form>  

Register.java

import java.io.*;  

import java.sql.*;  

import javax.servlet.ServletException;  

import javax.servlet.http.*;  

public class Register extends HttpServlet {  

public void doPost(HttpServletRequest request, HttpServletResponse response)  

            throws ServletException, IOException {  

response.setContentType("text/html");  

PrintWriter out = response.getWriter();  

          

String n=request.getParameter("userName");  

String p=request.getParameter("userPass");  

String e=request.getParameter("userEmail");  

String c=request.getParameter("userCountry");  

          

try{  

 Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/practicle",

            "root", "ekta");

PreparedStatement ps=con.prepareStatement(  

"insert into pro15 values(?,?,?,?)");   

ps.setString(1,n);  

ps.setString(2,p);  

ps.setString(3,e);  

ps.setString(4,c);  

          

int i=ps.executeUpdate();  

if(i>0)  

out.print("You are successfully registered...");                 

}catch (Exception e2) {System.out.println(e2);}  

          

out.close();  

}    

}  

Output: