Notes

import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

/**
* Servlet implementation class UserRegistration
*/
public class UserRegistration extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse resp) throws IOException
{
String name=req.getParameter("name");
String email=req.getParameter("email");
String contact=req.getParameter("contact");
String city=req.getParameter("city");
String password=req.getParameter("password");
PrintWriter pw=resp.getWriter();
//pw.write(name+email+contact+city+password);
try
{

Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/qms","root","");
PreparedStatement ps=conn.prepareStatement("insert into register values(?,?,?,?,?,?)");
ps.setInt(1, 0);
ps.setString(2, name);
ps.setString(3, email);
ps.setString(4, contact);
ps.setString(5, city);
ps.setString(6, password);
int x=ps.executeUpdate();
if(x==1)
pw.write("A/C Created");
else
pw.write("Sorry...A/C not Created");

}
catch (Exception e) {
// TODO: handle exception
pw.write("Sorry... Error");
}
}

}