基于myEclipse和SqlServer的宿舍管理系统，实现学生宿舍信息的管理，

package com.action; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.bean.YdBean; import com.util.Constant; public class YdServlet extends HttpServlet { /** * Constructor of the object. */ public YdServlet() { 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 */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } /** * 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 doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(Constant.CONTENTTYPE); request.setCharacterEncoding(Constant.CHARACTERENCODING); YdBean yb=new YdBean(); String method=request.getParameter("method").trim(); /////////////////////////////////////////////////////////////////////// 楼层 if(method.equals("addYd")){ String hid=request.getParameter("hid"); String mid=request.getParameter("mid"); int flag=yb.addYd(hid,mid); if(flag==Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/yd/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("admin/yd/index.jsp").forward(request, response); } } else if(method.equals("delYd")){ String id=request.getParameter("id"); int flag=yb.delYd(id); if(flag==Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/yd/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("admin/yd/index.jsp").forward(request, response); } } else if(method.equals("rzYd")){ String id=request.getParameter("id"); List list=new YdBean().getYd(id); String hid=list.get(0).toString(); String mid=list.get(1).toString(); int flag=yb.addRz(hid,mid); if(flag==Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/jz/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("admin/jz/index.jsp").forward(request, response); } } else if(method.equals("delRz")){ String id=request.getParameter("id"); int flag=yb.delRz(id); if(flag==Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/jz/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("admin/jz/index.jsp").forward(request, response); } } else if(method.equals("searchLouCheng")){ String louceng=request.getParameter("louceng"); String sql="select * from classname where louceng='"+louceng+"' order by id desc"; request.setAttribute("sql", sql); request.getRequestDispatcher("admin/tong/sinfo.jsp").forward(request, response); } else if(method.equals("serarchNum")){ String type=request.getParameter("type"); String num=request.getParameter("num"); request.setAttribute("type", type); request.setAttribute("num", num); request.getRequestDispatcher("admin/tong/sinfo.jsp").forward(request, response); } ///寝室人员查询 else if(method.equals("searchBianHao")){ String hid=request.getParameter("louceng"); String sql="select member.* from member,live where member.id=live.mid and live.hid='"+hid+"' order by live.id desc"; request.setAttribute("sql", sql); request.getRequestDispatcher("admin/jz/sinfo.jsp").forward(request, response); } else if(method.equals("serarchMember")){ String member=request.getParameter("member"); String sql="select member.* from member,live where member.id=live.mid and member.name like '%"+member+"%' order by live.id desc"; request.setAttribute("sql", sql); request.getRequestDispatcher("admin/jz/sinfo.jsp").forward(request, response); } else if(method.equals("serarchTime")){ String rztime=request.getParameter("rztime"); String sql="select member.* from member,live where member.id=live.mid and live.addtime like '%"+rztime+"%' order by live.id desc"; request.setAttribute("sql", sql); request.getRequestDispatcher("admin/jz/sinfo.jsp").forward(request, response); } else if(method.equals("plDr")){ String check[] = request.getParameterValues("checkit"); if(check == null){ String id=request.getParameter("id"); request.setAttribute("message", "请选择要导入的学生！"); request.setAttribute("id", id); request.getRequestDispatcher("admin/dr/ck.jsp").forward(request, response); } else{ String hid=request.getParameter("hid"); int id[]= new int[check.length]; for(int i = 0;i<check.length;i++){ int s = Integer.parseInt(check[i]); id[i] = s; } int flag = yb.plDr(id,hid); if(flag == Constant.SUCCESS){ request.setAttribute("message", "导入成功！"); request.getRequestDispatcher("admin/dr/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("admin/dr/index.jsp").forward(request, response); } } } } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }