spring jdbc 模板的使用

缺乏、安全感 2022-05-08 13:14 188阅读 0赞

配置文件

package com.test;  
  
import static org.junit.Assert.\*;  
  
import org.junit.Test;  
import org.junit.runner.RunWith;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.jdbc.core.JdbcTemplate;  
import org.springframework.jdbc.datasource.DriverManagerDataSource;  
import org.springframework.test.context.ContextConfiguration;  
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;  
@RunWith(SpringJUnit4ClassRunner.class)  
@ContextConfiguration("classpath:applicationContext.xml")  
public class MyTest \{  
@Autowired  
JdbcTemplate jdbcTemplate;  
@Test  
public void test() \{  
  
jdbcTemplate.update("insert into student values(null,?,?,?,?)","asdf","123456","123456","非洲");  
\}  
  
\}  
注意点：并没有扫描

引入jar包需要注意引入aop在spring4中

如果使用dbcp的数据库连接池配置为

<?xml version="1.0" encoding="UTF-8"?>  
<beans xmlns="http://www.springframework.org/schema/beans"  
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"  
xmlns:jdbc="http://www.springframework.org/schema/jdbc"  
xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd  
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd">  
  
  
  
<bean id="datasource"  
class="org.apache.commons.dbcp.BasicDataSource">  
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>  
<property name="url" value="jdbc:mysql:///students"></property>  
<property name="username" value="root"></property>  
<property name="password" value="123"></property>  
</bean>  
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">  
<property name="dataSource" ref="datasource"></property>  
</bean>  
</beans>  
\---------------------  
作者：zhunquanjiong6199  
来源：CSDN  
原文：https://blog.csdn.net/zhunquanjiong6199/article/details/82659670?utm\_source=copy  
版权声明：本文为博主原创文章，转载请附上博文链接！