以下示例将展示如何使用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