版权声明:本文为博主原创文章,未经博主允许不得转载
项目在Idea整体轮廓
1.Car.java
```package com.mr.model;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Car {
private Integer carId;
private String carName;
private String carPrice;
}
2.CarVo.java
package com.mr.vo;
import com.mr.model.Car;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@AllArgsConstructor
@Data
@NoArgsConstructor
public class CarVo extends Car {
// 车辆起始价格
private String carStartPrice;
// 车辆结束价格
private String carEndPrice;
}
3.LayUiController.java
package com.mr.controller;
import com.github.pagehelper.PageInfo;
import com.mr.model.Car;
import com.mr.service.ILayUiService;
import com.mr.util.DataGridVo;
import com.mr.util.Page;
import com.mr.vo.CarVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
/**
*
*/
@Controller
@RequestMapping("LayUi")
public class LayUiController {
@Autowired
private ILayUiService layUiService;
/**
* 查询
* @param
* @return
*/
/* @RequestMapping("queryCar")
@ResponseBody
public DataGridVo<Car> queryCar(Page page){
List<Car> cars=layUiService.queryCar(page);
PageInfo<Car> pageCar = new PageInfo<Car>(cars);
DataGridVo<Car> car = new DataGridVo<Car>(0,"",pageCar.getTotal(),pageCar.getList());
return car;
}*/
/**
* 查询+分页
* @param
* @return
*//*
@RequestMapping("queryCar")
@ResponseBody
public LayResult<Car> queryCar(Page page){
return layUiService.queryCar(page);
}*/
/**
* 查询+分页+条件查询
*/
@RequestMapping("queryCar")
@ResponseBody
public DataGridVo<Car> queryCar(Page page, CarVo vo){
PageInfo<Car> pageList = layUiService.queryCar(page,vo);
DataGridVo<Car> pageVo = new DataGridVo<Car>();
pageVo.setCount(pageList.getTotal());
pageVo.setData(pageList.getList());
return pageVo;
}
/**
* 新增
*/
@RequestMapping("addCar")
@ResponseBody
public String addCar(Car car){
layUiService.addCar(car);
return "新增成功";
}
/**
* 删除
*/
@RequestMapping("deleteCar")
@ResponseBody
public String deleteCar(Integer id){
layUiService.deleteCar(id);
return "删除成功";
}
/**
* 根据Id回显一条数据
*/
@RequestMapping("selectByCarId")
@ResponseBody
public ModelAndView selectByCarId(Integer id){
Car car = layUiService.selectByCarId(id);
ModelAndView modelAndView = new ModelAndView("../../Ui/update");
modelAndView.addObject("car",car);
return modelAndView ;
}
/**
* 修改
*
*/
@ResponseBody
@RequestMapping("updateCar")
public String updateStudent(Car car){
try {
layUiService.updateCar(car);
return "ok";
}catch (Exception e){
e.printStackTrace();
return "error";
}
}
}``
4.ILayUiService.java
import com.github.pagehelper.PageInfo;
import com.mr.model.Car;
import com.mr.util.LayResult;
import com.mr.util.Page;
import com.mr.vo.CarVo;
/**
*
*/
public interface ILayUiService {
/**
* 查询+分页
* @param
* @return
*/
//LayResult<Car> queryCar(Page page);
/**
* 新增
*/
void addCar(Car car);
/**
* 删除
* @param id
*/
void deleteCar(Integer id);
/**
* 根据Id回显一条数据
*/
Car selectByCarId(Integer id);
/**
* 修改
* @param car
*/
void updateCar(Car car);
/**
* 查询+分页+条件查询
*/
PageInfo<Car> queryCar(Page page, CarVo vo);
/**
* 查询
* @param
* @return
*/
// List<Car> queryCar(Page page);
}
5.LayUiServiceImpl.java
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.mr.mapper.LayUiMapper;
import com.mr.model.Car;
import com.mr.service.ILayUiService;
import com.mr.util.LayResult;
import com.mr.util.Page;
import com.mr.vo.CarVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
*
*/
@Service(value="layUiService")
public class LayUiServiceImpl implements ILayUiService{
@Autowired
private LayUiMapper layUiMapper;
/**
* 查询
* @param
* @return
*/
/* public List<Car> queryCar(Page page) {
return layUiMapper.queryCar();
}*/
/**
* 查询+分页
* @param
* @return
*/
/*public LayResult<Car> queryCar(Page page) {
if(page==null){
page=new Page();
}
PageHelper.startPage(page.getPage(),page.getLimit());
List<Car> cars = layUiMapper.queryCar();
PageInfo<Car> info = new PageInfo<Car>(cars);
LayResult<Car> carLayResult = new LayResult<Car>();
carLayResult.setCode(0);
carLayResult.setCount(info.getTotal());
carLayResult.setData(info.getList());
return carLayResult;
}*/
/**
* 新增
*/
public void addCar(Car car) {
layUiMapper.addCar(car);
}
/**
* 删除
* @param
*/
public void deleteCar(Integer id) {
layUiMapper.deleteCar(id);
}
/**
* 根据Id回显一条数据
* @param id
* @return
*/
public Car selectByCarId(Integer id) {
return layUiMapper.selectByCarId(id);
}
public void updateCar(Car car) {
layUiMapper.updateCar(car);
}
/**
* 查询+分页+条件查询
*
*
*/
public PageInfo<Car> queryCar(Page page, CarVo vo) {
if(page ==null){
page = new Page();
}
PageHelper.startPage(page.getPage(),page.getLimit());
List<Car> list = layUiMapper.queryCar(vo);
PageInfo<Car> pageList = new PageInfo<Car>(list);
return pageList;
}
}
6.LayUiMapper.java
import com.mr.model.Car;
import com.mr.vo.CarVo;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
*
*/
public interface LayUiMapper {
/**
* 查询+分页
* @param
* @return
*/
// List<Car> queryCar();
/**
* 新增
* @param
*/
void addCar(Car car);
/**
* 删除
* @param
*/
void deleteCar(Integer id);
/**
* 根据Id回显一条数据
* @param id
* @return
*/
Car selectByCarId(Integer id);
//修改
void updateCar(Car car);
/**
* 查询+分页+条件查询
*
*
*/
List<Car> queryCar(@Param("cars") CarVo vo);
/**
* 查询
* @param
* @return
*/
//List<Car> queryCar();
}
7.LayUiMapper.XML
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mr.mapper.LayUiMapper">
<!--查询+分页-->
<!--List<Car> queryCar();-->
<!--<select id="queryCar" resultType="car">
select car_id,car_name,car_price from t_car
</select>-->
<!-- /**
* 新增
* @param
*/
void addCar(Car car);-->
<insert id="addCar" parameterType="car">
insert into t_car(car_name,car_price)values(#{carName},#{carPrice})
</insert>
<!--删除-->
<!-- void deleteCar(Integer id);-->
<delete id="deleteCar" parameterType="int">
delete from t_car where car_id=#{carId}
</delete>
<!-- /**
* 根据Id回显一条数据
* @param id
* @return
*/
Car selectByCarId(Integer id);-->
<select id="selectByCarId" parameterType=