package controll;

import java.io.BufferedReader;

import java.io.IOException;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import com.alibaba.fastjson.JSON;

import com.alibaba.fastjson.JSONObject;

import demo.JDBC;

/**

?* Servlet implementation class Servlet

?*/

@WebServlet("/ADD")

public class Servlet extends HttpServlet {

private static final long serialVersionUID = 1L;

? ? ??

? ? /**

? ? ?* @see HttpServlet#HttpServlet()

? ? ?*/

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

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

// TODO Auto-generated method stub

response.setContentType("text/html;charset=utf-8");

? ? HttpSession session=request.getSession();

? ? String count=request.getParameter("count");

? ? JDBC jdbc=new JDBC();

? ?switch(count) {

? ?case "1":

try {

? ?if(jdbc.insert(request, response)==1)

? ?{

? ?response.getWriter().write("YES");

? ?}

? ?else

? ?response.getWriter().write("NO");

} catch (ClassNotFoundException | SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

? ?break;

? ?case "2":

? ?try {

? ?if(jdbc.change(request, response)==1)

? ?{

? ?response.getWriter().write("YES");

? ?}

? ?else

? ?response.getWriter().write("NO");

? ?;

} catch (ClassNotFoundException | SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

? ?break;

? ?case "3":

? ?try {

? ?if(jdbc.delete(request, response)==1)

? ?{

? ?response.getWriter().write("YES");

? ?}

? ?else

? ?response.getWriter().write("NO");

} catch (ClassNotFoundException | SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

? ?break;

? ?case "4":

? ?try {

? ?response.getWriter().write(jdbc.view(request, response));

} catch (ClassNotFoundException | SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

? ?break;

? ?}? ?

}

}