以下示例将展示如何使用Spring jdbc进行插入查询。将向student
表中插入几条记录。
语法:
String insertQuery = "insert into student (name, age) values (?, ?)";
jdbcTemplateObject.update( insertQuery, name, age);
在上面语法中 -
insertQuery
- 具有占位符的插入语句。jdbcTemplateObject
-StudentJDBCTemplate
对象将Student
对象插入到数据库中。
插入数据方法
public void create(String name, Integer age) {
String insertQuery = "insert into Student(name,age) values(?,?)";
jdbcTemplateObject.update(insertQuery, name, age);
System.out.println("Created Record Name = " + name + " Age = " + age);
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("------Records Creation--------");
studentJDBCTemplate.create("Allen", 17);
studentJDBCTemplate.create("Ray", 18);
studentJDBCTemplate.create("Mark", 20);
}
}
输出结果:
三月 07, 2018 6:22:33 下午 org.springframework.context.support.ClassPathXmlApplicationContext prepareRefresh
信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@254989ff: startup date [Wed Mar 07 18:22:33 CST 2018]; root of context hierarchy
三月 07, 2018 6:22:34 下午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [application-beans.xml]
三月 07, 2018 6:22:34 下午 org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
信息: Loaded JDBC driver: com.mysql.jdbc.Driver
------Records Creation--------
Wed Mar 07 18:22:34 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.
Created Record Name = Allen Age = 17
Wed Mar 07 18:22:34 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.
Created Record Name = Ray Age = 18
Wed Mar 07 18:22:34 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.
Created Record Name = Mark Age = 20
数据库