Spring JDBC删除数据

最新推荐文章于 2025-05-18 16:23:14 发布

原创最新推荐文章于 2025-05-18 16:23:14 发布 · 1.5k 阅读

2 ·

CC 4.0 BY-SA版权

Spring JDBC 专栏收录该内容

15 篇文章

订阅专栏

本文介绍如何使用SpringJdbc进行数据库表记录的删除操作。通过具体代码展示了如何删除指定ID的学生信息，并展示了完整的执行过程及结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

以下示例将展示如何使用Spring jdbc执行删除数据库表中的记录，这里演示如何删除指定student表中的记录。

语法：

String deleteQuery = "delete from Student where id = ?";
jdbcTemplateObject.update(deleteQuery, id);

在上面语法中 -

deleteQuery - 具有占位符的删除查询语句用来删除指定的学生信息。
jdbcTemplateObject - StudentJDBCTemplate 对象将 Student 对象从数据库中删除。

删除数据方法

public void delete(Integer id) {
		String sql = "delete from Student where id = ?";
		jdbcTemplateObject.update(sql,id);
		System.out.println("Deleted Record with ID = " + id);
		return;
	}

执行程序:

public class MainApp {

	public static void main(String[] args) {

		ApplicationContext context = new ClassPathXmlApplicationContext("application-beans.xml");

		StudentJDBCTemplate studentJDBCTemplate = (StudentJDBCTemplate) context.getBean("studentJDBCTemplate");

		System.out.println("----Delete Record with ID = 22 -----");
		studentJDBCTemplate.delete(22);

		System.out.println("------Listing Multiple Records--------");
		List<Student> students = studentJDBCTemplate.listStudents();
		for (Student record : students) {
			System.out.print("ID : " + record.getId());
			System.out.print(", Name : " + record.getName());
			System.out.println(", Age : " + record.getAge());
		}
	}
}

执行结果:

三月 07, 2018 8:52:58 下午 org.springframework.context.support.ClassPathXmlApplicationContext prepareRefresh
信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@254989ff: startup date [Wed Mar 07 20:52:58 CST 2018]; root of context hierarchy
三月 07, 2018 8:52:58 下午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [application-beans.xml]
三月 07, 2018 8:52:59 下午 org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
信息: Loaded JDBC driver: com.mysql.jdbc.Driver
----Delete Record with ID = 22 -----
Wed Mar 07 20:52:59 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Deleted Record with ID = 22
------Listing Multiple Records--------
Wed Mar 07 20:52:59 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
ID : 23, Name : Ray, Age : 18
ID : 24, Name : Mark, Age : 20