/**
* Handles requests for the application home page.
*/
@Controller
public class HomeController {
@Autowired
private SqlSession sqlSession;
/**
* Simply selects the home view to render by returning its name.
*/
@RequestMapping(value = "/result", method = RequestMethod.POST)
public ModelAndView home(Locale locale, Model model, HttpServletRequest request, HttpServletResponse response)
{
try
{
request.setCharacterEncoding("UTF-8");
String val1 = request.getParameter("val1");
String val2 = request.getParameter("val2");
String val3 = request.getParameter("val3");
String check = request.getParameter("check");
if(check.equals("select"))
{
int idx = Integer.parseInt(request.getParameter("selectIdx"));
/*
여기가 문제!!!
*/
}
else
{
try{
if(check.equals("insert"))
{
Vo vo = new Vo(val1, val2, val3);
sqlSession.insert("userControlMapper.insert", vo);
}
else if(check.equals("delete"))
{
Vo vo = new Vo(val1, val2, val3);
int idx = Integer.parseInt(request.getParameter("delIdx"));
sqlSession.delete("userControlMapper.delete", idx);
}
else if(check.equals("update"))
{
int idx = Integer.parseInt(request.getParameter("upIdx"));
Vo vo = new Vo(idx, val1, val2, val3);
sqlSession.update("userControlMapper.update", vo);
}
}
catch(Exception e){
}
List<HashMap<String, String>> outputs = sqlSession.selectList("userControlMapper.selectAll");
ModelAndView mav=new ModelAndView("result","m" , outputs);
return mav;
}
}
catch(Exception e){
}
return null;
}
}
