JdbcTemplate类中的execute方法

系统管理员 2023-10-07 10:22 9阅读 0赞

使用execute方法建一张用户表，execute()方法里可以执行SQL语句.  
**JdbcTemplateTest.java:**

package com.liu.jdbc;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import org.springframework.jdbc.core.JdbcTemplate;
    
    public class JdbcTemplateTest {
        
    	public static void main(String[] args) {
        
    		ApplicationContext applicationContext = new ClassPathXmlApplicationContext("ApplicationContext.xml");
    		
    		JdbcTemplate jdbcTemplate = (JdbcTemplate) applicationContext.getBean("jdbcTemplate");
    		
    		jdbcTemplate.execute("create table user(id int primary key auto_increment,username varchar(20))");
    		System.out.println("user表创建成功");
    	}
    
    }

ApplicationContext.xml配置文件：

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">
    		
    		
    		<bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource">
    			
    			<property name="driverClassName" value = "com.mysql.jdbc.Driver"></property>
    			
    			<property name="url" value = "jdbc:mysql://localhost:3306/test"></property>
    			
    			<property name="username" value = "root"></property>
    			
    			<property name="password" value = "root"></property>
    		</bean>
    		
    		<bean id = "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate">
    			
    			<property name="dataSource" ref = "dataSource"></property>
    		</bean>
    
    
    </beans>

需要的包：  
![在这里插入图片描述][20200302233826565.png]

[20200302233826565.png]: https://img-blog.csdnimg.cn/20200302233826565.png