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.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

@WebServlet("/ContactServlet")

public class ContactServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

public ContactServlet() {

super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//Nothing in get Method

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String name = request.getParameter("name");

String email = request.getParameter("email");

String msg = request.getParameter("msg");

try {

Class.forName("com.mysql.jdbc.Driver"); //MySQL Database Connector

//Creating a Connection to Database

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gamingsite","root","");

PreparedStatement stmt = con.prepareStatement("insert into contactus values(?,?,?)");

stmt.setString(1, name);

stmt.setString(2, email);

stmt.setString(3, msg);

int k = stmt.executeUpdate(); //Execute SQL Query

if (k>0) {

out.println("You Message Successfully Sent..!"); //Success Message

out.println("<br/>One of Our Represntatives will Get Back you Soon...");

}

}catch (Exception e) {

System.out.println(e);

}

}

}