13/02/25
-----------
Q)Develop a Java web application to implement the use-case of user
registration.
registrationapplication
register.html
WEB-INF
web.xml
src
RegistrationServlet.java
classes
RegistrationServlet.class
lib
mysql-connector-java-8.0.19.jar
http://localhost:8081/registrationapplication/register.html
web.xml
---------
two
RegistrationServlet
two
/register
register.html
---------------
user registration
------------------------------------------
import javax.servlet.*;
import java.sql.*;
import java.io.*;
public class RegistrationServlet extends GenericServlet {
Connection connection;
PreparedStatement preparedStatement;
public void init(ServletConfig config){
try {
Class.forName("com.mysql.cj.jdbc.Driver");
connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/ashokitdb","root","ashokit");
preparedStatement=connection.prepareStatement("INSERT INTO USERS VALUES(?,?,?)");
}
catch(ClassNotFoundException e){
}
catch(SQLException e){
}
}
public void service(ServletRequest request,ServletResponse response) throws IOException{
String username=request.getParameter("user");
String password=request.getParameter("pwd");
String emailid=request.getParameter("email");
try{
preparedStatement.setString(1,username);
preparedStatement.setString(2,password);
preparedStatement.setString(3,emailid);
preparedStatement.executeUpdate();
}
catch (SQLException e){
}
response.setContentType("text.html");
PrintWriter pw=response.getWriter();
pw.println("");
pw.println("");
pw.println("Registration successful ");
pw.println("");
pw.println("");
pw.close();
}//service
public void destroy(){
try{
preparedStatement.close();
connection.close();
}
catch (SQLException e){
}
}
}