MVC做的单表的增删改查

package servlet; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import sql.SqlBean; public class Delete extends HttpServlet { /** * Constructor of the object. */ public Delete() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id=request.getParameter("id"); String name=request.getParameter("name"); String sex=request.getParameter("sex"); if(id!=null&&id.equals("")){ request.setAttribute("state","1"); request.getRequestDispatcher("/delete.jsp").forward(request,response); } else { String sql="delete from student where 1=1 "; if(id!=null&&(!id.equals(""))){ sql+=" and id='"+id+"'"; } if(name!=null&&(!name.equals(""))){ sql+=" and name='"+name+"'"; } if(sex!=null&&(!sex.equals(""))){ sql+=" and sex='"+sex+"'"; } SqlBean bean=new SqlBean(); boolean b =bean.delete(sql); if(b) { System.out.println("1"); request.getRequestDispatcher("/delete.jsp").forward(request,response); } } } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }