spring batch测试，插入数据执行失败。

public JdbcBatchItemWriter fileItemWrite() {
JdbcBatchItemWriter writer = new JdbcBatchItemWriter<>();
try {
writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<>());
writer.setSql("INSERT into DiningTable(Id,Name,Number) values(:id,:name,:number)");
writer.setDataSource(dataSource);
System.out.println("write");
}catch (Exception e) {
e.printStackTrace();
}
return writer;
}

https://blog.csdn.net/levelmini/article/details/72626575