一、问题描述
springboot + mybatis项目测试报错:
Error evaluating expression 'ticketNos'. ...
是由于方法传参类型未对应
JPA改版mybatis中 疏忽:
JPA中ticketNos是string字符串(以逗号分割,sql识别)
mybatis要是List 或 String [] 才可以
/**
* 获取活动下的错题
*/
public List<Map<String, Object>> studentErrorList(List<String> ticketNoList, Long testId) {
// 根据活动id查询对应的表后缀
String tableSuffix = examBasTestTablesuffixService.getTestSuffix(testId);
// String ticketNos = "";
// for (String ticketNo : ticketNoList) {
// ticketNos += "," + "'" + ticketNo + "'";
// }
// if (ticketNos.length() > 0) {
// ticketNos = ticketNos.substring(1);
// }
List<Map<String, Object>> errorList = examWkSheetMapper.findErrorBookByTestIdAndTicketNos(tableSuffix, ticketNoList, testId);
return errorList;
}