import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class RegisterServlet extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
String name=request.getParameter("username");
String email=request.getParameter("email");
String password=request.getParameter("password");
try
{
Class.forName("org.postgresql.Driver");
Connection con=DriverManager.getConnection("jdbc:postgresql://localhost:8088/users","postgres","199326");
PreparedStatement stmt=con.prepareStatement("insert into users values(?,?,?)");
stmt.setString(1, name);
stmt.setString(2, email);
stmt.setString(3, password);
int i=stmt.executeUpdate();
out.println("<b>You are successfully Registered</b>");
con.close();
}
catch(Exception e)
{
out.println("<b>Registration failed</b>");
out.println("<b>Error:</b>" +e);
}
}
}