一、创建spring项目 项目名称:spring101302二、在项目上添加jar包 1.在项目中创建lib目录 /lib 2.在lib目录下添加spring支持 commons-logging.jar junit-4.10.jar log4j.jar mysql-connector-java-5.1.18-bin.jar spring-beans-3.2.0.RELEASE.jar spring-context-3.2.0.RELEASE.jar spring-core-3.2.0.RELEASE.jar spring-expression-3.2.0.RELEASE.jar spring-jdbc-3.2.0.RELEASE.jar spring-tx-3.2.0.RELEASE.jar com.springsource.com.mchange.v2.c3p0-0.9.1.2.jar三、在项目中添加配置文件 1.在项目中创建conf目录 2.在conf目录下添加spring核心配置文件 配置文件名称: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" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <!-- 1.配置数据库连接池 --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/spring"></property> <property name="driverClass" value="com.mysql.jdbc.Driver"></property> <property name="user" value="root"></property> <property name="password" value="root"></property> </bean> <!-- 2.配置JdbcTemplate --> <bean id="jdbctemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <!-- 给属性注入值 --> <property name="dataSource" ref="dataSource"></property> </bean></beans>四、测试 1.在项目上创建test目录 /test 2.在test目录下创建测试包 包名:cn.jbit.spring101301.test 3.在测试包下创建测试类 测试类名:JdbcTemplateDemo.java 测试类的内容: public class JdbcTemplateDemo { /** * 使用spring jdbctemplate添加数据 */ @Test public void testJdbcTemplate(){ ApplicationContext context = new ClassPathXmlApplicationContext("classpath:applicationContext.xml"); JdbcTemplate jdbcTemplate = (JdbcTemplate) context.getBean("jdbctemplate"); String sql = "INSERT INTO temp(tid,tname) VALUES(3,'wangwu')"; jdbcTemplate.execute(sql); } }
本文转自 素颜猪 51CTO博客,原文链接:http://blog.51cto.com/suyanzhu/1563221