springMVC+Spring3.1+Ibatis整合CRUD

package cn.pss.action; import java.io.File; import java.util.Date; import java.util.List; import javax.annotation.Resource; import javax.servlet.http.HttpSession; import org.springframework.stereotype.Controller; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.multipart.commons.CommonsMultipartFile; import org.springframework.web.servlet.ModelAndView; import cn.pss.service.UserService; import cn.pss.vo.User; @Controller @RequestMapping("/user") // requestMapping(value="")中value可以直接省略不写 public class UserAction { @Resource private UserService userservice; //采用外部重定向进行页面跳转，也就是说执行一次返回的方法名称 private final String LIST="redirect:/user/list"; // modelAttribute("user") 表示直接获取到的属性放到session中 页面通过${user.username}取得 @RequestMapping("/login") public ModelAndView login(@ModelAttribute("user") User user, HttpSession session) { User name = userservice.login(user); if (name != null) { // session.setAttribute("user", name); List<User> listUser = userservice.findAll(); return new ModelAndView("user/list", "listUser", listUser); } else { return new ModelAndView("error"); } } @RequestMapping("/list") public ModelAndView list(){ List<User> listUser = userservice.findAll(); if(listUser!=null){ return new ModelAndView("user/list", "listUser", listUser); } else { return new ModelAndView("error"); } } // method代表请求方式 @RequestMapping("/add") public ModelAndView add() { return new ModelAndView("user/add"); } @RequestMapping("/insert") public ModelAndView insert(@Validated User user) { userservice.insert(user); return new ModelAndView(LIST); } @RequestMapping("/delete/{uname}") public ModelAndView delete(@PathVariable String uname) { userservice.delete(uname); return new ModelAndView(LIST); } @RequestMapping("/edit/{uname}") public ModelAndView edit(@PathVariable String uname) { User user = userservice.findByid(uname); return new ModelAndView("user/update", "user", user); } @RequestMapping("/update") public ModelAndView update(@Validated User user) { userservice.update(user); return new ModelAndView(LIST); } @RequestMapping(value = "/upload") // 将文件上传请求映射到该方法 // 设置请求参数的名称和类型 public ModelAndView upload(@RequestParam("file") CommonsMultipartFile mFile) { // 请求参数一定要与form中的参数名对应 if (!mFile.isEmpty()) { // 获取本地存储路径 File file = new File("D:/myfile"); if (!file.exists()) file.mkdirs(); File file1 = new File("d:/myfile/" + new Date().getTime() + ".xls"); // 新建一个文件 try { mFile.getFileItem().write(file1); // 将上传的文件写入新建的文件中 //mFile.transferTo(file1); // 将上传的文件写入新建的文件中 } catch (Exception e) { e.printStackTrace(); } } return new ModelAndView("upload"); } }