报错:### Error updating database. Cause: java.sql.SQLException: ORA-00926: 缺失 VALUES 关键字### The error may involve com.cn.ssm.dao.OrderSatisFactionDao.addOrderSatisFaction-Inline### The error occurred while setting parameters### SQL: INSERT INTO APP_SA
第一种: 因为Mysql数据每次发送sql语句的长度不能超过1M,所以,每次发送insert语句以固定长度发送: 将sql语句在provider中,以固定长度装入List集合中,然后返回service层,调用mapp,发送sql语句 //provider类 public class sql { private List <String> sqlList = new ArrayList<>(); private void makeUpSql(StringBuilder sql, St
@Override public int insertHouseTypeScene(int htid, String name, String icon,int sort, List<HouseTypeSceneDeviceReqParam> houseTypeSceneDeviceReqParam) { HouseTypeSceneReqParam param = new HouseTypeSceneReqParam(htid, name, icon, sort); int sid = da