Spring+Hibernate+mysql的网上调查系统源码

package com.mySurvey.action; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.web.bind.ServletRequestBindingException; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.servlet.mvc.multiaction.MultiActionController; import com.mySurvey.bean.Survey; import com.mySurvey.bean.SurveyChild; import com.mySurvey.bean.SurveyChildCount; import com.mySurvey.bean.SurveyOption; import com.mySurvey.domain.SetSurvey; import com.mySurvey.domain.SetSurveyChild; import com.mySurvey.domain.SetSurveyChildCount; import com.mySurvey.domain.SetSurveyOption; public class SetSurveyAction extends MultiActionController{ //定义要设定调查名称后要返回的页面 private String surveyName; //定义要设定调查项目后要返回的页面 private String surveyOption; //定义要设定调查子项目后要返回的页面 private String surveyChildOption; //定义要填写调查时要返回的页面 private String survey; //定义要填写调查后要返回的页面 private String surveyOK; //定义要依赖注入的处理逻辑setSurvey private SetSurvey setSurvey; //定义要依赖注入的处理逻辑setSurveyOption private SetSurveyOption setSurveyOption; //定义要依赖注入的处理逻辑setSurveyChild private SetSurveyChild setSurveyChild; //定义要依赖注入的处理逻辑setSurveyChild private SetSurveyChildCount setSurveyChildCount; //封装调查基本信息 public Survey getSurveyCommand(HttpServletRequest req, HttpServletResponse res) { Survey survey = new Survey(); try { //判断是否是新增或者修改还是删除，如果是新增则不需要id if (req.getParameter("id" + (String)req.getParameter("checkbox") + "") != null) { survey.setId(Integer.valueOf(req.getParameter("id" + (String)req.getParameter("checkbox") + ""))); } //获取调查基本信息new String(((String)req.getParameter("name" + (String)req.getParameter("checkbox") + "").getBytes("iso8859-1")),"GBK") survey.setName(new String(((String)req.getParameter("name" + (String)req.getParameter("checkbox") + "")).getBytes("iso8859-1"),"GBK")); survey.setDataTime1((String)req.getParameter("dataTime1" + (String)req.getParameter("checkbox") + "")); survey.setDataTime2((String)req.getParameter("dataTime2" + (String)req.getParameter("checkbox") + "")); } catch (Exception ex) { ex.printStackTrace(); } return survey; } //封装调查项目信息 public SurveyOption getSurveyOptionCommand(HttpServletRequest req, HttpServletResponse res) { SurveyOption surveyOption = new SurveyOption(); try { //判断是否是新增或者修改还是删除，如果是新增则不需要id if (req.getParameter("id" + (String)req.getParameter("checkbox") + "") != null) { surveyOption.setId(Integer.valueOf(req.getParameter("id" + (String)req.getParameter("checkbox") + ""))); } //获取调查项目名称 surveyOption.setName(new String(((String)req.getParameter("name" + (String)req.getParameter("checkbox") + "")).getBytes("iso8859-1"),"GBK")); } catch (Exception ex) { ex.printStackTrace(); } return surveyOption; } //封装调查子项目信息 public SurveyChild getSurveyChildCommand(HttpServletRequest req, HttpServletResponse res) { SurveyChild surveyChild = new SurveyChild(); try { //判断是否是新增或者修改还是删除，如果是新增则不需要id if (req.getParameter("id" + (String)req.getParameter("checkbox") + "") != null) { surveyChild.setId(Integer.valueOf(req.getParameter("id" + (String)req.getParameter("checkbox") + ""))); } //获取调查子项目名称 surveyChild.setName(new String(((String)req.getParameter("name" + (String)req.getParameter("checkbox") + "")).getBytes("iso8859-1"),"GBK")); } catch (Exception ex) { ex.printStackTrace(); } return surveyChild; } //新增Survey public ModelAndView insertSurvey(HttpServletRequest req, HttpServletResponse res) throws ServletRequestBindingException { //强制转换成Survey Survey survey = getSurveyCommand(req, res); Map model = new HashMap(); //进行新增调查基本信息的业务逻辑处理 getSetSurvey().insertSurvey(survey); //获取已有的调查名称 List listSurveys = getSetSurvey().querySurvey(); //将已有的调查名称传递给页面 model.put("listSurveys", listSurveys); //存放消息 model.put("survey", survey); model.put("userId", (String)req.getParameter("userId")); model.put("msg", getSetSurvey().getMsg()); return new ModelAndView(getSurveyName(), model); } //修改Survey public ModelAndView updateSurvey(HttpServletRequest req, HttpServletResponse res) throws ServletRequestBindingException { //强制转换成Survey Survey survey = getSurveyCommand(req, res); Map model = new HashMap(); //进行修改调查名称的业务逻辑处理 getSetSurvey().updateSurvey(survey); //获取已有的调查名称 List listSurveys = getSetSurvey().querySurvey(); //将已有的调查名称传递给页面 model.put("listSurveys", listSurveys); //存放消息 model.put("survey", survey); model.put("userId", (String)req.getParameter("userId")); model.put("msg", getSetSurvey().getMsg()); return new ModelAndView(getSurveyName(), model); } //删除Survey public ModelAndView deleteSurvey(HttpServletRequest req, HttpServletResponse res) throws ServletRequestBindingException { //强制转换成Survey Survey survey = getSurveyCommand(req, res); Map model = new HashMap(); //进行删除调查名称的业务逻辑处理 getSetSurvey().deleteSurvey(survey); //获取已有的调查名称 List listSurveys = getSetSurvey().querySurvey(); //将已有的调查名称传递给页面 model.put("listSurveys", listSurveys); //存放消息 model.put("survey", survey); model.put("userId", (String)req.getParameter("userId")); model.put("msg", getSetSurvey().getMsg()); return new ModelAndView(getSurveyName(), model); } //新增SurveyOption public ModelAndView insertSurveyOption(HttpServletRequest req, HttpServletResponse res) throws ServletRequestBindingException { //强制转换成SurveyOption SurveyOption surveyOption = getSurveyOptionCommand(req, res); Map model = new HashMap(); //进行新增调查项目的业务逻辑处理 surveyOption.setSurveyId(Integer.valueOf((String)req.getParameter("surveyId"))); getSetSurveyOption().insertSurveyOption(surveyOption); //获取已有的调查项目 List listSurveyOptions = getSetSurveyOption().querySurveyOption(surveyOption.getSurveyId()); //将已有的调查名称传递给页面 model.put("listSurveyOptions", listSurveyOptions); //存放消息 model.put("msg", getSetSurveyOption().getMsg()); try { model.put("surveyName", new String(((String)req.getParameter("surveyName")).getBytes("iso8859-1"),"GBK")); } catch (Exception ex) { ex.printStackTrace(); } model.put("surveyId", (String)req.getParameter("surveyId")); model.put("userId", (String)req.getParameter("userId")); return new ModelAndView(getSurveyOption(), model); } //修改SurveyOption public ModelAndView updateSurveyOption(HttpServletRequest req, HttpServletResponse res) throws ServletRequestBindingException { //强制转换成SurveyOption SurveyOption surveyOption = getSurveyOptionCommand(req, res); Map model = new HashMap(); //进行修改调查项目的业务逻辑处理 surveyOption.setSurveyId(Integer.valueOf((String)req.getParameter("surveyId"))); getSetSurveyOption().updateSurveyOption(surveyOption); //获取已有的调查项目 List listSurveyOptions = getSetSurveyOption().querySurveyOption(surveyOption.getSurveyId()); //将已有的调查名称传递给页面 model.put("listSurveyOptions", listSurveyOptions); //存放消息 model.put("ms