svlt

/*
    Document   : addAuditor.java
    Created on : April 3, 2017, 4:09:34 PM
    Author     : Muhammad Shahrul Haniff 040471
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class addAuditor extends HttpServlet {
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String affilition = request.getParameter("affilition");
        String address = request.getParameter("address");

        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/auditorcoursemanagement", "root", "");

            PreparedStatement ps = con.prepareStatement("insert into auditor values(?,?,?,?)");

            ps.setString(1, id);
            ps.setString(2, name);
            ps.setString(3, affilition);
            ps.setString(4, address);

            int i = ps.executeUpdate();
            if (i > 0)
            {
            //out.print("You are successfully registered...");
            out.print("<script>alert('Successfully registered...');document.location.href='home.html';</script>");
            }

        } catch (Exception e2) {
            System.out.println(e2);
            out.print("<script>alert('NOT successfully registered...');document.location.href='addAuditor.html';</script>");
        }

        out.close();
    }

}