Spring ————SimpleJdbcInsert

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);
}