以下代码演示了如何使用JdbcTemplate删除数据库中的某些记录。
package org.nhooo.example.spring.jdbc; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.datasource.DriverManagerDataSource; import javax.sql.DataSource; public class DeleteDemo { public static final String DRIVER = "com.mysql.jdbc.Driver"; public static final String URL = "jdbc:mysql://localhost/mediadb"; public static final String USERNAME = "root"; public static final String PASSWORD = ""; public static final String QUERY = "DELETE FROM records WHERE id = ?"; private DataSource dataSource; public DeleteDemo(DataSource dataSource) { this.dataSource = dataSource; } public void deleteRecord(Long id) { // 创建JdbcTemplate的实例并提供数据 // 源对象。 JdbcTemplate template = new JdbcTemplate(this.dataSource); // 从学生所在的数据库中删除学生记录 // id与指定参数匹配。 Object[] params = {id}; int rows = template.update(DeleteDemo.QUERY, params); System.out.println(rows + " row(s) deleted."); } /** * Returns a DataSource object. * * @return a DataSource. */ public static DataSource getDataSource() { DriverManagerDataSource ds = new DriverManagerDataSource(); ds.setDriverClassName(DeleteDemo.DRIVER); ds.setUrl(DeleteDemo.URL); ds.setUsername(DeleteDemo.USERNAME); ds.setPassword(DeleteDemo.PASSWORD); return ds; } public static void main(String[] args) { DataSource ds = getDataSource(); DeleteDemo demo = new DeleteDemo(ds); Long id = 1L; demo.deleteRecord(id); } }