我尝试使用Apache库读取excel文件,并得到以下错误:
org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845(XSSFCell.java:246) at com.ge.aviation.TeamDataProcessor.process(TeamDataProcessor.java:174) at com.ge.aviation.BatchCall$1.run(BatchCall.java:的数字单元格中的文本值30) j
假设一些像这样的SET @var2 = 'val2';
INSERT INTO my_table (?,?), -- ... imagine here a lot of values";
EXECUTE stmt USING @var1,@var2,@var1,@var2,@var1,@var2;
DEALLOCATE PREPAR