spring dao

Spring JDBC FAQ: Can you provide an example of a SQL UPDATE query used with Spring JDBC, i.e., Spring Dao class and methods?

Here's some example Java code from a Spring Dao class where I use Spring JDBC and the JDBCTemplate update method to run a SQL UPDATE statement. In short, if you can get access to the Spring JDBCTemplate, this Spring JDBC code shows a simple example of how to execute a SQL UPDATE statement.

Spring JDBC update method

Here's the source code for my example Spring JDBC update method:

The Spring Framework gives you a great way to test your Spring JDBC (Spring DAO) code. Just use a special Spring JDBC class with a very long name, and you can test your Spring JDBC code against a real database.

Some people don't like this approach, but I think it's invaluable for (a) testing your SQL syntax when you first create it, and (b) making sure your SQL syntax is still valid after database changes occur.

Spring JDBC DELETE FAQ: Can you provide some examples of using SQL DELETE queries using Spring JDBC (Spring Dao classes and methods)?

Here are a few Spring Dao examples, specifically JDBC/SQL DELETE examples.

Spring JDBC delete example #1: Delete a record by the primary key

In this first Spring JDBC DELETE example, I pass in an id parameter, which represents the primary key in my hosts database table. This JDBC/SQL statement deletes the record from that table that matches that id field.

Spring JDBC Example/Question: How do I perform a SQL DELETE statement using JDBC and the Spring Framework?

Here's a simple Java method that I created to perform a SQL DELETE using Spring JDBC techniques:

private void deleteById(String sql, int id)
{
  getSimpleJdbcTemplate().update(sql, id);
}

To use this method you just need to call it with the SQL DELETE statement you want to run, also passing in the id of the record you want to delete, like this: