基于javaweb+mysql的ssm+maven出租车管理系统(java+ssm+html+javascript+jsp+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven出租车管理系统(java+ssm+html+javascript+jsp+mysql)
项目介绍
超级管理员角色包含以下功能: 超级管理员管理,公告管理,系统管理员管理,司机管理,车辆管理,维修保养管理,运营里程记录等功能。
普通管理员角色包含以下功能: 普通管理员登录,公告管理,司机管理,出租车信息管理,维修保养管理,运营里程管理等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:HTML+CSS+JavaScript+jsp
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录
* @param carsRepair
* @return
*/
@RequestMapping(value = "/saveCarsRepair", produces = "text/html;charset=UTF-8")
@ResponseBody
public String saveCarsRepair(CarsRepair carsRepair) {
Integer saveNoNull = carsRepairService.saveNoNull(carsRepair);
if (saveNoNull > 0)
return "true";
return "false";
}
/**
* 分页查询全部
*
* @param page
* @param rows
* @return
*/
@RequestMapping(value = "/queryAllCarsRepair", produces = "text/html;charset=UTF-8")
@ResponseBody
public Pager queryAllAdvice(Integer page, Integer rows) {
PageInfo<CarsRepair> queryPageList = carsRepairService.queryPageList(
page, rows);
List<CarsRepair> list = queryPageList.getList();
List<CarsRepairShow> listShow = new ArrayList<CarsRepairShow>();
for (CarsRepair carsRepair : list) {
listShow.add(pinJie(carsRepair));
}
Integer countNumber = carsRepairService.queryCount(null);
return new Pager(countNumber, listShow);
}
@RequestMapping(value = "/queryLikeAll", produces = "text/html;charset=UTF-8")
@ResponseBody
public Pager queryLikeAll(CarsRepairShow carsRepairShow, Integer page,
Integer rows) {
Pager queryLikeAll = carsRepairService.queryLikeAll(carsRepairShow,
page, rows);
return queryLikeAll;
}
@RequestMapping(value = "/saveUpdateDeleteCarsRepair", produces = "text/html;charset=UTF-8")
public Pager queryAllDrivers(Integer page, Integer rows){
PageInfo<Drivers> queryPageList = driversService.queryPageList(page, rows);
List<Drivers> list = queryPageList.getList();
Integer queryCount = driversService.queryCount(null);
return new Pager(queryCount,list);
}
/**
* 模糊查询
* @param driver
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryLikeDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryLikeDrivers(Drivers driver,Integer page,Integer rows){
return driversService.queryLikeDrivers(driver, rows, page);
}
/**
* 添加司机信息与更新司机信息
* @param driver
* @return
*/
@RequestMapping(value="/saveUpdateDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public String saveUpdateDrivers(Drivers driver, @RequestParam MultipartFile filePhoto, HttpServletRequest request){
Integer saveNoNull =null;
String uploadFile = uploadFile(filePhoto,request,driver.getIdCard());
driver.setPhoto(uploadFile);
if(driver.getDriverId()==null){
driver.setCreateTime(new Date());
saveNoNull = driversService.saveNoNull(driver);
}else{
saveNoNull =driversService.updateNoNull(driver);
}
if(saveNoNull>0)
return "true";
return "false";
}
/**
* 删除司机信息
* @param driverId
} catch (Exception e) {
}
return idCard+substring;
}
}
package cn.lvhaosir.controller;
@Controller
@RequestMapping("/cars")
public class CarsController {
@Autowired
private CarsService carsService;
/**
* 分页查询所有车辆信息
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryAllCars",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryAllCars(Integer page, Integer rows){
PageInfo<Cars> queryPageList = carsService.queryPageList(page, rows);
List<Cars> list = queryPageList.getList();
Integer countNumber = carsService.countNumber(null);
return new Pager(countNumber,list);
}
/**
* 分页,模糊查询
* @param driverId
* @return
*/
@RequestMapping(value="/deleteDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public String deleteDrivers(Integer driverId){
//首先去查询是否在使用
driversService.delete(driverId);
return "true";
}
/**
* 为下拉列表提供数据
* @return
*/
@RequestMapping(value="/allDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public List<Drivers> allDriver(){
return driversService.queryAllList();
}
/**
* 展示 司机个人信息
* @param driverId
* @return
*/
@RequestMapping(value="/queryDriver",produces="text/html;charset=UTF-8")
public ModelAndView queryDrivers(Integer driverId){
Drivers queryById = driversService.queryById(driverId);
return new ModelAndView("driver","driver",queryById);
}
/**
* 文件上传
* @param file
* @param request
* @param sellerId
* @return
*/
private String uploadFile(MultipartFile file, HttpServletRequest request, String idCard){
//传入的是身份证号
File targetFile = null;
String substring=null;
try {
String path = request.getSession().getServletContext()
.getRealPath("upload");
if(path==null){
path="/yjdata/www/www/chebida/upload";
}
String fileName = file.getOriginalFilename();
return "false";
}else{
session.setAttribute("loginNickName", queryByParam.getNickName());
session.setAttribute("userAdmin", queryByParam.getUserAdmin());
return "true";
}
}
@RequestMapping(value="/outLogin",produces="text/html;charset=UTF-8")
public String outLogin(HttpSession session){
session.removeAttribute("loginNickName");
return "redirect:/login.action";
}
}
package cn.lvhaosir.interceptors;
public class SessionInterceptor implements HandlerInterceptor {
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
// TODO Auto-generated method stub
HttpSession session = request.getSession();
Object attribute = session.getAttribute("loginNickName");
if (attribute == null) {
// String requestUri = request.getRequestURI();
// System.out.println("拦截的"+attribute+" "+requestUri);
response.sendRedirect(request.getContextPath()+"/login.jsp");
return false;
}
return true;
/*String requestUri = request.getRequestURI();
if (requestUri.startsWith(request.getContextPath())) {
requestUri = requestUri.substring(
HttpServletResponse response, Object handler, Exception ex)
throws Exception {
}
}
package cn.lvhaosir.controller;
@Controller
@RequestMapping("/advices")
public class AdvicesController {
@Autowired
private AdvicesService advicesService;
/**
* 查询全部
* @return
*/
@RequestMapping(value="/queryAll",produces="text/html;charset=UTF-8")
public List<Advices> queryAll(){
return advicesService.queryAllList();
}
/**
* 分页查询全部
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryAllAdvice",produces="text/html;charset=UTF-8")
* @return
*/
@RequestMapping(value="/saveUpdateCars",produces="text/html;charset=UTF-8")
@ResponseBody
public String saveUpdateCars(Cars car,@RequestParam MultipartFile carPhoto,HttpServletRequest request){
String uploadFile = uploadFile(carPhoto,request,car.getEngineNumber());
car.setPhoto(uploadFile);
Integer saveNoNull =null;
if(car.getCarId()==null){
//添加
car.setCreateTime(new Date());
saveNoNull=carsService.saveNoNull(car);
}else{
//修改
saveNoNull = carsService.updateNoNull(car);
}
if(saveNoNull>0)
return "true";
return "false";
}
/**
* 删除司机信息
* @param driverId
* @return
*/
@RequestMapping(value="/deleteCars",produces="text/html;charset=UTF-8")
@ResponseBody
public String deleteDrivers(Integer carId){
//首先去查询是否在使用
carsService.delete(carId);
return "true";
}
@RequestMapping(value="/queryCars",produces="text/html;charset=UTF-8")
public ModelAndView queryCars(Integer driverId){
Cars c=new Cars();
c.setDriverId(driverId);
Cars queryById=carsService.queryByParam(c);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryCarsById",produces="text/html;charset=UTF-8")
public ModelAndView queryCarsById(Integer carId){
Cars queryById=carsService.queryById(carId);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryAll",produces="text/html;charset=UTF-8")
@ResponseBody
public List<Cars> queryAll(){
return carsService.queryAllList();
Integer saveNoNull =null;
String uploadFile = uploadFile(filePhoto,request,driver.getIdCard());
driver.setPhoto(uploadFile);
if(driver.getDriverId()==null){
driver.setCreateTime(new Date());
saveNoNull = driversService.saveNoNull(driver);
}else{
saveNoNull =driversService.updateNoNull(driver);
}
if(saveNoNull>0)
return "true";
return "false";
}
/**
* 删除司机信息
* @param driverId
* @return
*/
@RequestMapping(value="/deleteDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public String deleteDrivers(Integer driverId){
//首先去查询是否在使用
driversService.delete(driverId);
return "true";
}
/**
* 为下拉列表提供数据
* @return
*/
@RequestMapping(value="/allDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public List<Drivers> allDriver(){
return driversService.queryAllList();
}
/**
* 展示 司机个人信息
* @param driverId
* @return
*/
@RequestMapping(value="/queryDriver",produces="text/html;charset=UTF-8")
public ModelAndView queryDrivers(Integer driverId){
Drivers queryById = driversService.queryById(driverId);
return new ModelAndView("driver","driver",queryById);
}
/**
return "true";
}
@RequestMapping(value="/queryCars",produces="text/html;charset=UTF-8")
public ModelAndView queryCars(Integer driverId){
Cars c=new Cars();
c.setDriverId(driverId);
Cars queryById=carsService.queryByParam(c);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryCarsById",produces="text/html;charset=UTF-8")
public ModelAndView queryCarsById(Integer carId){
Cars queryById=carsService.queryById(carId);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryAll",produces="text/html;charset=UTF-8")
@ResponseBody
public List<Cars> queryAll(){
return carsService.queryAllList();
}
/**
* 文件上传
* @param file
* @param request
* @param sellerId
* @return
*/
private String uploadFile(MultipartFile file, HttpServletRequest request,String engineNumber){
//传入的是身份证号
File targetFile = null;
String substring=null;
try {
String path = request.getSession().getServletContext()
.getRealPath("upload");
if(path==null){
path="/yjdata/www/www/chebida/upload";
}
String fileName = file.getOriginalFilename();
int lastIndexOf = fileName.lastIndexOf(".");
substring = fileName.substring(lastIndexOf);
targetFile = new File(path, engineNumber+substring);
if (!targetFile.exists()) {
targetFile.mkdirs();
}
@Controller
@RequestMapping("/carsRepair")
public class CarsRepairController {
@Autowired
private CarsRepairService carsRepairService;
@Autowired
private CarsService carsService;
@Autowired
private DriversService driversService;
/**
* 根据条件查询所有的 车辆维修保养记录
*
* @param carId
* @return
*/
@RequestMapping(value = "/allCarsRepair", produces = "text/html;charset=UTF-8")
public ModelAndView queryAllCarsRepair(Integer carId) {
CarsRepair cr = new CarsRepair();
cr.setCarId(carId);
List<CarsRepair> queryParamList = carsRepairService.queryAllOrderby(cr);
return new ModelAndView("carsRepairList", "CarsRepairList",
queryParamList);
}
/**
* 新增 车辆维修保养记录
*
* @param carsRepair
* @return
*/
@RequestMapping(value = "/saveCarsRepair", produces = "text/html;charset=UTF-8")
@ResponseBody
public String saveCarsRepair(CarsRepair carsRepair) {
Integer saveNoNull = carsRepairService.saveNoNull(carsRepair);
if (saveNoNull > 0)
return "true";
return "false";
}
@Controller
@RequestMapping("/carsRepair")
public class CarsRepairController {
@Autowired
private CarsRepairService carsRepairService;
@Autowired
private CarsService carsService;
@Autowired
private DriversService driversService;
/**
* 根据条件查询所有的 车辆维修保养记录
*
* @param carId
* @return
*/
@RequestMapping(value = "/allCarsRepair", produces = "text/html;charset=UTF-8")
public ModelAndView queryAllCarsRepair(Integer carId) {
CarsRepair cr = new CarsRepair();
cr.setCarId(carId);
List<CarsRepair> queryParamList = carsRepairService.queryAllOrderby(cr);
return new ModelAndView("carsRepairList", "CarsRepairList",
queryParamList);
}
/**
* 新增 车辆维修保养记录
*
* @param carsRepair
* @return
*/
@RequestMapping(value = "/saveCarsRepair", produces = "text/html;charset=UTF-8")
@ResponseBody
return carsService.queryListCars(car, rows, page);
}
/**
* 新增或修改车辆信息
* @param car
* @return
*/
@RequestMapping(value="/saveUpdateCars",produces="text/html;charset=UTF-8")
@ResponseBody
public String saveUpdateCars(Cars car,@RequestParam MultipartFile carPhoto,HttpServletRequest request){
String uploadFile = uploadFile(carPhoto,request,car.getEngineNumber());
car.setPhoto(uploadFile);
Integer saveNoNull =null;
if(car.getCarId()==null){
//添加
car.setCreateTime(new Date());
saveNoNull=carsService.saveNoNull(car);
}else{
//修改
saveNoNull = carsService.updateNoNull(car);
}
if(saveNoNull>0)
return "true";
return "false";
}
/**
* 删除司机信息
* @param driverId
* @return
*/
@RequestMapping(value="/deleteCars",produces="text/html;charset=UTF-8")
@ResponseBody
public String deleteDrivers(Integer carId){
//首先去查询是否在使用
carsService.delete(carId);
return "true";
}
@RequestMapping(value="/queryCars",produces="text/html;charset=UTF-8")
public ModelAndView queryCars(Integer driverId){
Cars c=new Cars();
c.setDriverId(driverId);
Cars queryById=carsService.queryByParam(c);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryCarsById",produces="text/html;charset=UTF-8")
public ModelAndView queryCarsById(Integer carId){
Cars queryById=carsService.queryById(carId);
@Controller
@RequestMapping("/cars")
public class CarsController {
@Autowired
private CarsService carsService;
/**
* 分页查询所有车辆信息
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryAllCars",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryAllCars(Integer page, Integer rows){
PageInfo<Cars> queryPageList = carsService.queryPageList(page, rows);
List<Cars> list = queryPageList.getList();
Integer countNumber = carsService.countNumber(null);
return new Pager(countNumber,list);
}
/**
* 分页,模糊查询
* @param car
* @param page
* @param rows
* @param rows
* @return
*/
@RequestMapping(value="/queryLikeDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryLikeDrivers(Drivers driver,Integer page,Integer rows){
return driversService.queryLikeDrivers(driver, rows, page);
}
/**
* 添加司机信息与更新司机信息
* @param driver
* @return
*/
@RequestMapping(value="/saveUpdateDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public String saveUpdateDrivers(Drivers driver, @RequestParam MultipartFile filePhoto, HttpServletRequest request){
Integer saveNoNull =null;
String uploadFile = uploadFile(filePhoto,request,driver.getIdCard());
driver.setPhoto(uploadFile);
if(driver.getDriverId()==null){
driver.setCreateTime(new Date());
saveNoNull = driversService.saveNoNull(driver);
}else{
saveNoNull =driversService.updateNoNull(driver);
}
if(saveNoNull>0)
return "true";
return "false";
}
/**
* 删除司机信息
* @param driverId
* @return
*/
@RequestMapping(value="/deleteDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public String deleteDrivers(Integer driverId){
//首先去查询是否在使用
driversService.delete(driverId);
return "true";
}
/**
* 为下拉列表提供数据
* @return
*/
@RequestMapping(value="/allDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public List<Drivers> allDriver(){
return driversService.queryAllList();
}
public class SessionInterceptor implements HandlerInterceptor {
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
// TODO Auto-generated method stub
HttpSession session = request.getSession();
Object attribute = session.getAttribute("loginNickName");
if (attribute == null) {
// String requestUri = request.getRequestURI();
// System.out.println("拦截的"+attribute+" "+requestUri);
response.sendRedirect(request.getContextPath()+"/login.jsp");
return false;
}
return true;
/*String requestUri = request.getRequestURI();
if (requestUri.startsWith(request.getContextPath())) {
requestUri = requestUri.substring(
request.getContextPath().length(), requestUri.length());
}
// /sellers/queryPagerAll.action
String[] strUrl = { "/sellerinfo/querySellerInfo.action",
"/sellers/queryPagerAll.action",
"/sellers/queryCondition.action",
"/sellerwork/queryAll.action", "/sellerwork/queryOne.action",
"/userinfo/queryUserInfo.action",
"/users/queryPagerAll.action", "/users/queryCondition.action",
@Controller
@RequestMapping("/advices")
public class AdvicesController {
@Autowired
private AdvicesService advicesService;
/**
* 查询全部
* @return
*/
@RequestMapping(value="/queryAll",produces="text/html;charset=UTF-8")
public List<Advices> queryAll(){
return advicesService.queryAllList();
}
/**
* 分页查询全部
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryAllAdvice",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryAllAdvice(Integer page, Integer rows){
PageInfo<Advices> queryPageList = advicesService.queryPageList(page, rows);
List<Advices> list = queryPageList.getList();
Integer countNumber = advicesService.queryCount(null);
return new Pager(countNumber,list);
}
@RequestMapping(value="/saveUpdateDeleteAdvice",produces="text/html;charset=UTF-8")
@ResponseBody
public String saveUpdateDeleteAdvice(Advices advice){
Integer saveNoNull =null;
if(advice.getId()==null){
advice.setCreateTime(new Date());
saveNoNull = advicesService.saveNoNull(advice);
}else{
if(advice.getTitle()==null){
saveNoNull =advicesService.delete(advice.getId());
}else{
saveNoNull =advicesService.updateNoNull(advice);
}
}
if(saveNoNull >0)
return "true";
return "false";
}
}
return carsService.queryAllList();
}
/**
* 文件上传
* @param file
* @param request
* @param sellerId
* @return
*/
private String uploadFile(MultipartFile file, HttpServletRequest request,String engineNumber){
//传入的是身份证号
File targetFile = null;
String substring=null;
try {
String path = request.getSession().getServletContext()
.getRealPath("upload");
if(path==null){
path="/yjdata/www/www/chebida/upload";
}
String fileName = file.getOriginalFilename();
int lastIndexOf = fileName.lastIndexOf(".");
substring = fileName.substring(lastIndexOf);
targetFile = new File(path, engineNumber+substring);
if (!targetFile.exists()) {
targetFile.mkdirs();
}
file.transferTo(targetFile);
// request.setAttribute("filePath",targetFile.getAbsolutePath());
} catch (Exception e) {
}
return engineNumber+substring;
}
}
package cn.lvhaosir.controller;
@Controller
@RequestMapping("/users")
public class UsersController {
}else{
Cars queryById = carsService.queryById(carId);
if(queryById==null){
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), "信息失踪了", "信息失踪了");
}else{
Integer driverId = queryById.getDriverId();
if(driverId==null){
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), queryById.getCarNumber(),
"信息失踪了");
}else{
Drivers queryById2 = driversService.queryById(driverId);
if(queryById2==null){
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), queryById.getCarNumber(),
"信息失踪了");
}else{
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), queryById.getCarNumber(),
queryById2.getDriverName());
}
}
}
}
return crs;
}
}
package cn.lvhaosir.controller;
String fileName = file.getOriginalFilename();
int lastIndexOf = fileName.lastIndexOf(".");
substring = fileName.substring(lastIndexOf);
targetFile = new File(path, engineNumber+substring);
if (!targetFile.exists()) {
targetFile.mkdirs();
}
file.transferTo(targetFile);
// request.setAttribute("filePath",targetFile.getAbsolutePath());
} catch (Exception e) {
}
return engineNumber+substring;
}
}
package cn.lvhaosir.controller;
@Controller
@RequestMapping("/users")
public class UsersController {
@Autowired
private UsersService usersService;
/**
* 分页查询全部
* @param page
@ResponseBody
public String deleteDrivers(Integer carId){
//首先去查询是否在使用
carsService.delete(carId);
return "true";
}
@RequestMapping(value="/queryCars",produces="text/html;charset=UTF-8")
public ModelAndView queryCars(Integer driverId){
Cars c=new Cars();
c.setDriverId(driverId);
Cars queryById=carsService.queryByParam(c);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryCarsById",produces="text/html;charset=UTF-8")
public ModelAndView queryCarsById(Integer carId){
Cars queryById=carsService.queryById(carId);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryAll",produces="text/html;charset=UTF-8")
@ResponseBody
public List<Cars> queryAll(){
return carsService.queryAllList();
}
/**
* 文件上传
* @param file
* @param request
* @param sellerId
* @return
*/
private String uploadFile(MultipartFile file, HttpServletRequest request,String engineNumber){
//传入的是身份证号
File targetFile = null;
String substring=null;
try {
String path = request.getSession().getServletContext()
.getRealPath("upload");
* 分页查询所有车辆信息
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryAllCars",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryAllCars(Integer page, Integer rows){
PageInfo<Cars> queryPageList = carsService.queryPageList(page, rows);
List<Cars> list = queryPageList.getList();
Integer countNumber = carsService.countNumber(null);
return new Pager(countNumber,list);
}
/**
* 分页,模糊查询
* @param car
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryLikeCars",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryLikeCars(Cars car,Integer page,Integer rows){
return carsService.queryListCars(car, rows, page);
}
/**
* 新增或修改车辆信息
* @param car
* @return
*/
@RequestMapping(value="/saveUpdateCars",produces="text/html;charset=UTF-8")
@ResponseBody
public String saveUpdateCars(Cars car,@RequestParam MultipartFile carPhoto,HttpServletRequest request){
String uploadFile = uploadFile(carPhoto,request,car.getEngineNumber());
car.setPhoto(uploadFile);
Integer saveNoNull =null;
if(car.getCarId()==null){
//添加
car.setCreateTime(new Date());
saveNoNull=carsService.saveNoNull(car);
}else{
//修改
saveNoNull = carsService.updateNoNull(car);
}
if(saveNoNull>0)
return "true";
@Controller
@RequestMapping("/cars")
public class CarsController {
@Autowired
private CarsService carsService;
/**
* 分页查询所有车辆信息
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryAllCars",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryAllCars(Integer page, Integer rows){
PageInfo<Cars> queryPageList = carsService.queryPageList(page, rows);
List<Cars> list = queryPageList.getList();
Integer countNumber = carsService.countNumber(null);
return new Pager(countNumber,list);
}
/**
* 分页,模糊查询
* @param car
* @param page
* @param rows
c.setDriverId(driverId);
Cars queryById=carsService.queryByParam(c);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryCarsById",produces="text/html;charset=UTF-8")
public ModelAndView queryCarsById(Integer carId){
Cars queryById=carsService.queryById(carId);
return new ModelAndView("car","car",queryById);
}
@RequestMapping(value="/queryAll",produces="text/html;charset=UTF-8")
@ResponseBody
public List<Cars> queryAll(){
return carsService.queryAllList();
}
/**
* 文件上传
* @param file
* @param request
* @param sellerId
* @return
*/
private String uploadFile(MultipartFile file, HttpServletRequest request,String engineNumber){
//传入的是身份证号
File targetFile = null;
String substring=null;
try {
String path = request.getSession().getServletContext()
.getRealPath("upload");
if(path==null){
path="/yjdata/www/www/chebida/upload";
}
String fileName = file.getOriginalFilename();
int lastIndexOf = fileName.lastIndexOf(".");
substring = fileName.substring(lastIndexOf);
targetFile = new File(path, engineNumber+substring);
if (!targetFile.exists()) {
targetFile.mkdirs();
}
file.transferTo(targetFile);
private Logger log=Logger.getLogger(DriversController.class.getName());
@Autowired
private DriversService driversService;
/**
* 分页查询,所有司机信息
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryAllDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryAllDrivers(Integer page, Integer rows){
PageInfo<Drivers> queryPageList = driversService.queryPageList(page, rows);
List<Drivers> list = queryPageList.getList();
Integer queryCount = driversService.queryCount(null);
return new Pager(queryCount,list);
}
/**
* 模糊查询
* @param driver
* @param page
* @param rows
* @return
*/
@RequestMapping(value="/queryLikeDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public Pager queryLikeDrivers(Drivers driver,Integer page,Integer rows){
return driversService.queryLikeDrivers(driver, rows, page);
}
/**
* 添加司机信息与更新司机信息
* @param driver
* @return
*/
@RequestMapping(value="/saveUpdateDrivers",produces="text/html;charset=UTF-8")
@ResponseBody
public String saveUpdateDrivers(Drivers driver, @RequestParam MultipartFile filePhoto, HttpServletRequest request){
Integer saveNoNull =null;
String uploadFile = uploadFile(filePhoto,request,driver.getIdCard());
driver.setPhoto(uploadFile);
} else {
saveNoNull = carsRepairService.updateNoNull(carsRepair);
}
}
if (saveNoNull > 0)
return "true";
return "false";
}
private CarsRepairShow pinJie(CarsRepair carsRepair) {
Integer carId = carsRepair.getCarId();
CarsRepairShow crs = new CarsRepairShow();
if(carId==null){
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), "信息失踪了", "信息失踪了");
}else{
Cars queryById = carsService.queryById(carId);
if(queryById==null){
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), "信息失踪了", "信息失踪了");
}else{
Integer driverId = queryById.getDriverId();
if(driverId==null){
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), queryById.getCarNumber(),
"信息失踪了");
}else{
Drivers queryById2 = driversService.queryById(driverId);
if(queryById2==null){
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
carsRepair.getCreateTime(), queryById.getCarNumber(),
"信息失踪了");
}else{
crs = new CarsRepairShow(carsRepair.getCarsRepairId(),
carsRepair.getCarsRepairType(),
carsRepair.getCarsRepairText(), carsRepair.getCarId(),
@Controller
@RequestMapping("/carsRepair")
public class CarsRepairController {
@Autowired
private CarsRepairService carsRepairService;
@Autowired
private CarsService carsService;
@Autowired
private DriversService driversService;
/**
* 根据条件查询所有的 车辆维修保养记录
*
* @param carId
* @return
*/
@RequestMapping(value = "/allCarsRepair", produces = "text/html;charset=UTF-8")
public ModelAndView queryAllCarsRepair(Integer carId) {
CarsRepair cr = new CarsRepair();
cr.setCarId(carId);
List<CarsRepair> queryParamList = carsRepairService.queryAllOrderby(cr);
return new ModelAndView("carsRepairList", "CarsRepairList",
queryParamList);
}
/**
* 新增 车辆维修保养记录
*
* @param carsRepair
* @return
*/
@RequestMapping(value = "/saveCarsRepair", produces = "text/html;charset=UTF-8")
@ResponseBody