Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.charging_service' doesn't exist
### The error may exist in file [C:\Users\PC\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\ITSPLATFORM\WEB-INF\classes\mapper\ChargingServiceinfoMapper.xml]
### The error may involve com.haylion.mapper.ChargingServiceinfoMapper.selectAppointmentByDayReview-Inline
### The error occurred while setting parameters
### SQL: select distinct b.chargerseqno,a.vehicleid,date_format(a.appointstarttime,'%h:%i'),date_format(a.appointendtime,'%h:%i'), b.chargepower,a.chgenergy from charging_service a,charging_pile b where 1=1 and a.chargerid = b.chargerid and b.chargerseqno = ? and a.vehicleid = ? order by date_format(a.appointstarttime,'%Y-%m-%d') = curdate();
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.charging_service' doesn't exist
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.charging_service' doesn't exist] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.charging_service' doesn't exist
### The error may exist in file [C:\Users\PC\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\ITSPLATFORM\WEB-INF\classes\mapper\ChargingServiceinfoMapper.xml]
### The error may involve com.haylion.mapper.ChargingServiceinfoMapper.selectAppointmentByDayReview-Inline
### The error occurred while setting parameters
### SQL: select distinct b.chargerseqno,a.vehicleid,date_format(a.appointstarttime,'%h:%i'),date_format(a.appointendtime,'%h:%i'), b.chargepower,a.chgenergy from charging_service a,charging_pile b where 1=1 and a.chargerid = b.chargerid and b.chargerseqno = ? and a.vehicleid = ? order by date_format(a.appointstarttime,'%Y-%m-%d') = curdate();
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.charging_service' doesn't exist
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.charging_service' doesn't exist] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.charging_service' doesn't exist
检查ChargingServiceinfoMapper.xml