I'm learning the combination of Spring Boot and jdbcTemplate for some basic crud operations, and trying to better understand which update method I should choose.
I understand that the following two class approaches (adapted from this post) will write the same record to the database.
Example 1:
public class InsertDemo {
private static final String sql =
"INSERT INTO records (title, " +
" release_date, " +
" artist_id, " +
" label_id, " +
" created) " +
"VALUES (?, ?, ?, ?, ?)";
private DataSource dataSource;
public InsertDemo(DataSource dataSource) {
this.dataSource = dataSource;
}
public void saveRecord(String title, Date releaseDate,
Integer artistId, Integer labelId) {
JdbcTemplate template = new JdbcTemplate(this.dataSource);
Object[] params = new Object[] {
title, releaseDate, artistId, labelId, new Date()
};
int[] types = new int[] {
Types.VARCHAR,
Types.DATE,
Types.INTEGER,
Types.INTEGER,
Types.DATE
};
int row = template.update(sql, params, types);
System.out.println(row + " row inserted.");
}
Example 2:
public class InsertDemo {
private static final String sql =
"INSERT INTO records (title, " +
" release_date, " +
" artist_id, " +
" label_id, " +
" created) " +
"VALUES (?, ?, ?, ?, ?)";
private DataSource dataSource;
public InsertDemo(DataSource dataSource) {
this.dataSource = dataSource;
}
public void saveRecord(String title, Date releaseDate,
Integer artistId, Integer labelId) {
JdbcTemplate template = new JdbcTemplate(this.dataSource);
Object[] params = new Object[] {
title, releaseDate, artistId, labelId, new Date()
};
int row = template.update(sql, params);
System.out.println(row + " row inserted.");
}
but I'm unclear on why I would/should use the first one that specifies argument types. I've read the javadoc but I'm still not sure why I would need to specify the types. What am I missing?
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
