SimpleJdbcInsert操作数据库的时候
private SimpleJdbcInsert simpleInsert;
public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
public void leaveBillAdd(LeaveBill lb) {
// TODO Auto-generated method stub
simpleInsert = new SimpleJdbcInsert(jdbcTemplate);
simpleInsert.withTableName("byd_wk_leavebill");----------------------------表名
SqlParameterSource parameters = new BeanPropertySqlParameterSource(lb);-------------------这里的类的属性必须和DB端的字段名称一致
Number newId = simpleInsert.execute(parameters);
System.out.println(newId);
}