//-----------IT17045940

//-----------Dias A.M.A.P.

//-----------G-1.2

import java.sql.*;

import java.io.IOException;

import javax.servlet.RequestDispatcher;

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("/Addgame")

public class Addgame extends HttpServlet {

private static final long serialVersionUID = 1L;

public Addgame() {

super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

}

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request, response);

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

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

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

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

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

try {

Class.forName("com.mysql.jdbc.Driver");

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

Statement ps = conn.createStatement();

String sql = "insert into game(GameName , Price , Size , Requirements , Description) values ('"+GameName+"','"+Price

+"','"+Size+"','"+Requirements+"','"+Description+"')";

int i = ps.executeUpdate(sql);

if(i > 0)

{

System.out.print("Record Added Successfully");

response.sendRedirect("displayGameHistory.jsp") ;

}

else

{

System.out.print("There is a problem in updating Record.");

}

}

catch(SQLException | ClassNotFoundException sql)

{

request.setAttribute("error", sql);//session

System.out.println(sql);

}

}

}