Spring JDBC更新数据

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

语法：

String updateQuery = "update Student set age = ? where id = ?";
jdbcTemplateObject.update(updateQuery, age, id);

在上面语法中 -

• updateQuery - 具有占位符的更新查询用来更新学生信息。
• jdbcTemplateObject - StudentJDBCTemplate 对象将 Student 对象更新到数据库表中。

更新数据方法:

	public void update(Integer id, Integer age) {
		String sql = "update Student set age = ? where id = ?";
		jdbcTemplateObject.update(sql, age, id);
		System.out.println("Updated 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("----Updating Record with ID = 22 -----");
		studentJDBCTemplate.update(22, 99);
		
		System.out.println("----Listing Record with ID = 22 -----");
		Student student = studentJDBCTemplate.getStudent(22);
		System.out.print("ID : " + student.getId());
                System.out.print(", Name : " + student.getName());
                System.out.println(", Age : " + student.getAge());
	}
}

执行结果:

三月 07, 2018 8:46:05 下午 org.springframework.context.support.ClassPathXmlApplicationContext prepareRefresh
信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@254989ff: startup date [Wed Mar 07 20:46:05 CST 2018]; root of context hierarchy
三月 07, 2018 8:46:05 下午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [application-beans.xml]
三月 07, 2018 8:46:05 下午 org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
信息: Loaded JDBC driver: com.mysql.jdbc.Driver
----Updating Record with ID = 22 -----
Wed Mar 07 20:46:06 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.
Updated Record with ID = 22
----Listing Record with ID = 22 -----
Wed Mar 07 20:46:06 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 : 22, Name : Allen, Age : 99