java666

controller


@Autowired
  private Plane Plane;// 自动注入
  /**
   * 多条件查询
   * @param map
   * @param page
   * @param limit
   * @return
   */
  @RequestMapping("/getAll")
  public Object getAll(@RequestParam Map<String, Object> map, @RequestParam int page, @RequestParam int limit) {
    map.put("page", ((page - 1) * limit));
    map.put("limit", limit);
    Result result = new Result("0", "true", Plane.getAllCount(map), Plane.getAll(map));
    return result;
  }
  /**
   * 添加
   * @param Plane
   * @return
   */
  @RequestMapping("/add")
  public Object add(Plane Plane) {
    Result result = new Result("200", "true", Plane.add(Plane), "success");
    return result;
  }
  /**
   * 编辑
   * @param Plane
   * @return
   */
  @RequestMapping("/update")
  public Object update(Plane Plane) {
    Result result = new Result("200", "true", Plane.update(Plane), "success");
    return result;
  }

}

2

@RestController
@RequestMapping("/port")

public class PortController {
@Autowired
private PortMapper airPortMapper;// 自动注入

  /**
   * 查询
   * 
   * @param
   * @return
   */
  @RequestMapping("/getAll")
  public Object getAll() {
    return PortMapper.getAll();
  }

}

mapper

@Component
public interface PlaneMapper {
List<Map<String,Object>> getALL(Map<String,Object>map);
/**
* 多条件查询
*
* @param map
* @return
*/
public List<Map<String, Object>> getAll(Map<String, Object> map);

	  /**
	   * 查询所有数据
	   * 
	   * @param map
	   * @return
	   */
	  public Integer getAllCount(Map<String, Object> map);

	  /**
	   * 添加数据
	   * 
	   * @param Plane
	   * @return
	   */
	  public Integer add(Plane Plane);

	  /**
	   * 编辑数据
	   * 
	   * @param Plane
	   * @return
	   */
	  public Integer update(Plane Plane);

}

mapper.xml

<?xml version="1.0" encoding="UTF-8"?>

-

-
SELECT plane.planeId, plane.planetype, plane.pbeginTime, plane.pendTime, plane.passengerNum, plane.beginplace, plane.destination, plane.portId, port.portId FROM plane INNER JOIN port ON plane.portId = port.portId

-

and plane.planetype like “%”#{planetype}"%"

and plane.pbeginTime > #{pbeginTime}

and plane.pendTime < #{pendTime}

and plane.portId=#{portId}

limit #{page},#{limit}

-
SELECT count(*) FROM plane INNER JOIN port ON plane.portId = port.portId

-

and plane.planetype like “%”#{planetype}"%"

and plane.pbeginTime > #{pbeginTime}

and plane.pendTime < #{pendTime}

and plane.portId=#{portId}

INSERT INTO plane VALUES (null, #{planetype},#{pbeginTime},#{pendTime},#{passengerNum}, #{beginplace}, #{destination},#{portId});

update plane setplanetype=#{planetype},pbeginTime=#{pbeginTime},pendTime=#{pendTime},passengerNum=#{passengerNum},beginplace=#{beginplace},destination=#{destination},portId=#{portId}wherer planeId=#{planeId}

2
-

SELECT port.portId, port.portName FROM plane INNER JOIN port ON plane.portId = port.portId