Servlet
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;
}
}
}
