dao mvc连接mysql_MVC模式实现数据库的增删改查

package cn.jdbc.servlet;

import java.io.IOException;

import java.util.ArrayList;

import java.util.List;

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 cn.jdbc.dao.StudentDao;

import cn.jdbc.domain.student;

import cn.jdbc.test.search_id;

/*** Servlet implementation class display*/

@WebServlet("/display")

public class display extends HttpServlet {

private static final long serialVersionUID = 1L;

/*** @see HttpServlet#HttpServlet()*/

public display() {

super();

// TODO Auto-generated constructor stub }

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

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

// TODO Auto-generated method stub//获取数据库操作的对象StudentDao dao = new StudentDao();

//获取数组对象List list = new ArrayList();

//获取查询的学号String search_sno = request.getParameter("search_no");

//获取添加的数据String add_sno = request.getParameter("add_sno");

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

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

//获取修改的数据String cg_sno = request.getParameter("cg_sno");

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

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

//获取删除的学号String del_sno = request.getParameter("del_sno");

//查询数据if(search_sno!=null){

student student= dao.find(search_sno);

list.add(student);

search_sno="";

}else{//显示所有的数据list=dao.findAll();

}

//添加数据if(add_sage!=null){

student student = new student();

student.setSno(add_sno);

student.setSname(add_sname);

student.setSage(Integer.parseInt(add_sage));

dao.insert(student);

list=dao.findAll();

add_sno="";

add_sname="";

add_sage="";

}

//修改数据if(cg_sage!=null){

student student = new student();

student.setSno(cg_sno);

student.setSname(cg_sname);

student.setSage(Integer.parseInt(cg_sage));

dao.update(student);

list=dao.findAll();

cg_sno="";

cg_sname="";

cg_sage="";

}

//删除数据if(del_sno!=null){

dao.delete(del_sno);

list=dao.findAll();

del_sno="";

}

//传递数组到jsp页面request.setAttribute("list", list);

request.getRequestDispatcher("index.jsp").forward(request, response);

}

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

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

// TODO Auto-generated method stubdoGet(request, response);

}

}