spring,springmvc,mybatits集成实例--多表查询

package com.ct.rd.bg.controller; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import com.ct.rd.bg.model.Employeer; import com.ct.rd.bg.service.IEmployeerService; import com.ct.rd.bg.util.EncoderUtil; /* * @author yhh * @time：2017年9月3日 下午3:51:03 */ @Controller public class EmployeerController { @Autowired private IEmployeerService employeerService; @RequestMapping(value = "/insert", method = RequestMethod.GET) public String add() throws ParseException { Employeer employeer =new Employeer(); employeer .setDid(1); employeer .setSex("女"); employeer .setName("陈娟"); employeer .setPosition("UI工程师"); employeer .setTelephone("15467789294"); employeer .setEmail("78956234@qq.com"); employeer .setState("在职"); String birthday = "08/31/1990"; SimpleDateFormat sdf= new SimpleDateFormat("MM/dd/yyyy"); Date dateBirthday = (Date) sdf.parse(birthday); employeer .setBirthday(dateBirthday ); String joincompanytime = "12/01/2015"; Date dateJoin = (Date) sdf.parse(joincompanytime); employeer .setJoincompanytime(dateJoin ); employeerService.addEmployeer(employeer); return "../index"; } @RequestMapping(value = "/delete", method = RequestMethod.GET) public String delete() { int id = 2005; employeerService.deleteEmployeer(id); return "../index"; } @RequestMapping(value = "/update", method = RequestMethod.GET) public String update() { int id = 2008; Employeer employeer = employeerService.findEmployeerById(id); if (null != employeer) { employeer.setPosition("美工"); employeerService.updateEmployeer(employeer); } return "../index"; } @RequestMapping(value ="/findAll", method = RequestMethod.GET) public String findAll(ModelMap model) { List<Employeer> employeersList = new ArrayList<Employeer>(); employeersList = employeerService.findAllEmployeer(); model.addAttribute("employeersList", employeersList); return "../views/employeerList"; } @RequestMapping(value ="/findEmployeerByName", method = RequestMethod.GET) public String findEmployeerByName(ModelMap model, @RequestParam("inputText") String inputText) { List<Employeer> employeersList= new ArrayList<Employeer>(); employeersList= employeerService.findEmployeerByName(EncoderUtil.encodeStr(inputText)); model.addAttribute("employeersList", employeersList); return "../views/employeerList"; } @RequestMapping(value ="/findOnbusinessByEid", method = RequestMethod.GET) public String findOnbusinessByEid(ModelMap model, @RequestParam("inputText") int eid) { Employeer employeer= employeerService.findOnbusinessByEid(eid); model.addAttribute("employeer", employeer); return "../views/onbusinessList"; } }