====== Spring Using DataSource or JdbcTemplate ======
===== DataSource =====
Simply do
@Autowired
DataSource dataSource;
and we can use the dataSource in our code like:
String sql = "YOUR_SQL_QUERY"; //such as "UPDATE Book SET NAME = '" + String.valueOf(iRandom) + "' WHERE ID = 1"
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
int iAffectedRowCount = statement.executeUpdate(sql);
connection.close();
of course, you need to do a try catch yourself.
===== JdbcTemplate =====
Likewise Spring also provided the JDBC template, all we need to do is:
@Autowired
JdbcTemplate jdbcTemplate;
and we can use it like:
String sql = "YOUR_SQL_QUERY"; //such as "UPDATE Book SET NAME = '" + String.valueOf(iRandom) + "' WHERE ID = 1"
int iAffectedRowCount = jdbcTemplate.update(sql);
of course, you need to do a try catch yourself. For more detail on how to use JdbcTemplate, go to the reference https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html