插入单个Bean

public void insert(Study study){
    String sql = "insert `name`,`age`,`sex` values (:name,:age,:sex)";
    SqlParameterSource sps = new BeanPropertySqlParameterSource(study);
    NamedParameterJdbcTemplate npjt = new NamedParameterJdbcTemplate(jdbcTemplate.getDataSource());
    npjt.update(sql,sps);
}

批量插入Bean

public void insert(List<Study> studyList){
    String sql = "insert `name`,`age`,`sex` values (:name,:age,:sex)";
    SqlParameterSource[] sps = SqlParameterSourceUrils.createBatch(studyList);
    NamedParameterJdbcTemplate npjt = new NamedParameterJdbcTemplate(jdbcTemplate.getDataSource());
    npjt.batchUpdate(sql,sps);
}