xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java
@@ -58,4 +58,13 @@ "from t_car") Month getCarCount(@Param("year")Integer year); } @Select("SELECT\n" + "\t( MAX( amount ) - MIN( amount ) ) AS amount,\n" + "\tSUM( money ) AS money,\n" + "\t( MAX( mileage ) - MIN( mileage ) ) AS mileage, \n" + "\tSUM(amount) AS allAmount,SUM(money) AS allMoney,(MAX(mileage)) AS allMileage \n"+ "FROM\n" + "\t t_add_oil a\n" + "\t WHERE a.car_id = #{carId}") Car getCarInfoByCarId(@Param("carId")String carId); }