在实际开发中使用SpringJDBC有两种方式：
1. 在Dao中添加属性JdbcTemplate并用Spring注入；
JdbcTemplate类被设计成为线程安全的，所以可以在IOC 容器中声明它的单个实例，并将这个实例注入到所有的 DAO 实例中。JdbcTemplate也利用了Java 1.5 的特定(自动装箱，泛型，可变长度等)来简化开发。
2. 使Dao继承JdbcDaoSupport；
Spring JDBC 框架还提供了一个 JdbcDaoSupport 类来简化 DAO 实现，该类声明了 jdbcTemplate 属性，它可以从 IOC 容器中注入，或者自动从数据源中创建。
Dao设计示例：
1. 添加jdbcTemplate属性，用注解配置
1.1 添加Dao
package xyz.huning.dao.impl.jdbctemplate.annotation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;
import xyz.huning.dao.impl.Employee;
import xyz.huning.dao.impl.IEmployeeDao;
@Repository
public class EmployeeDao implements IEmployeeDao{
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public Employee getEmployeeById(int id) {
String sql = "select id,name,level from t_employee where id = ?";
RowMapper<Employee> rowMapper = new BeanPropertyRowMapper<Employee>(Employee.class);
return jdbcTemplate.queryForObject(sql, rowMapper, id);
}
}
1.2 添加配置
<?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"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<context:component-scan base-package="xyz.huning.dao.impl.jdbctemplate.annotation"></context:component-scan>
<!-- 导入资源文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置 C3P0 数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
<property name="driverClass" value="${jdbc.driverClass}"></property>
<property name="initialPoolSize" value="${c3p0.initialPoolSize}"></property>
<property name="minPoolSize" value="${c3p0.minPoolSize}"></property>
<property name="maxPoolSize" value="${c3p0.maxPoolSize}"></property>
<property name="maxIdleTime" value="${c3p0.maxIdleTime}"></property>
<property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"></property>
</bean>
<!--配置Spring的JdbcTemplate-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
1.3 添加测试类
package xyz.huning.dao.impl.jdbctemplate.annotation;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import xyz.huning.dao.impl.Employee;
public class Main {
public static void main(String[] args) {
ApplicationContext ctx = new ClassPathXmlApplicationContext("jdbctemplate-annotation.xml");
EmployeeDao employeeDao = ctx.getBean("employeeDao", EmployeeDao.class);
Employee employee = employeeDao.getEmployeeById(1);
System.out.println(employee);
((ClassPathXmlApplicationContext)ctx).close();
}
}
2. 添加jdbcTemplate属性，用XML配置
2.1 添加Dao
package xyz.huning.dao.impl.jdbctemplate.xml;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import xyz.huning.dao.impl.Employee;
import xyz.huning.dao.impl.IEmployeeDao;
public class EmployeeDao implements IEmployeeDao{
private JdbcTemplate jdbcTemplate;
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public Employee getEmployeeById(int id) {
String sql = "select id,name,level from t_employee where id = ?";
RowMapper<Employee> rowMapper = new BeanPropertyRowMapper<Employee>(Employee.class);
return jdbcTemplate.queryForObject(sql, rowMapper, id);
}
}
2.2 添加配置
<?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"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<!-- 导入资源文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置 C3P0 数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
<property name="driverClass" value="${jdbc.driverClass}"></property>
<property name="initialPoolSize" value="${c3p0.initialPoolSize}"></property>
<property name="minPoolSize" value="${c3p0.minPoolSize}"></property>
<property name="maxPoolSize" value="${c3p0.maxPoolSize}"></property>
<property name="maxIdleTime" value="${c3p0.maxIdleTime}"></property>
<property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"></property>
</bean>
<!--配置Spring的JdbcTemplate-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="employeeDao" class="xyz.huning.dao.impl.jdbctemplate.xml.EmployeeDao">
<property name="jdbcTemplate" ref="jdbcTemplate"></property>
</bean>
</beans>
2.3 添加测试类
package xyz.huning.dao.impl.jdbctemplate.xml;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import xyz.huning.dao.impl.Employee;
public class Main {
public static void main(String[] args) {
ApplicationContext ctx = new ClassPathXmlApplicationContext("jdbctemplate-xml.xml");
EmployeeDao employeeDao = ctx.getBean("employeeDao", EmployeeDao.class);
Employee employee = employeeDao.getEmployeeById(1);
System.out.println(employee);
((ClassPathXmlApplicationContext)ctx).close();
}
}
3. 继承JdbcDaoSupport ，用注解配置
备注： 可以选择向Dao中注入JdbcTemplate或者向Dao中注入dataSource
3.1 添加Dao
package xyz.huning.dao.impl.jdbcdaosuppport.annotation;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.stereotype.Repository;
import xyz.huning.dao.impl.Employee;
import xyz.huning.dao.impl.IEmployeeDao;
@Repository
public class EmployeeDao extends JdbcDaoSupport implements IEmployeeDao{
@Autowired
public void injectDataSource(DataSource dataSource)
{
setDataSource(dataSource);
}
// @Autowired
// public void injectJdbcTemplate(JdbcTemplate jdbcTemplate)
// {
// setJdbcTemplate(jdbcTemplate);
// }
@Override
public Employee getEmployeeById(int id) {
String sql = "select id,name,level from t_employee where id = ?";
RowMapper<Employee> rowMapper = new BeanPropertyRowMapper<Employee>(Employee.class);
return getJdbcTemplate().queryForObject(sql, rowMapper, id);
}
}
3.2 添加配置
<?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"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<context:component-scan base-package="xyz.huning.dao.impl.jdbcdaosuppport.annotation"></context:component-scan>
<!-- 导入资源文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置 C3P0 数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
<property name="driverClass" value="${jdbc.driverClass}"></property>
<property name="initialPoolSize" value="${c3p0.initialPoolSize}"></property>
<property name="minPoolSize" value="${c3p0.minPoolSize}"></property>
<property name="maxPoolSize" value="${c3p0.maxPoolSize}"></property>
<property name="maxIdleTime" value="${c3p0.maxIdleTime}"></property>
<property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"></property>
</bean>
<!--配置Spring的JdbcTemplate-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
3.3 添加测试类
package xyz.huning.dao.impl.jdbcdaosuppport.annotation;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import xyz.huning.dao.impl.Employee;
public class Main {
public static void main(String[] args) {
ApplicationContext ctx = new ClassPathXmlApplicationContext("jdbcdaosuppport-annotation.xml");
EmployeeDao employeeDao = ctx.getBean("employeeDao", EmployeeDao.class);
Employee employee = employeeDao.getEmployeeById(1);
System.out.println(employee);
((ClassPathXmlApplicationContext)ctx).close();
}
}
4. 继承JdbcDaoSupport ，用XML配置
备注： 可以选择向Dao中注入JdbcTemplate或者向Dao中注入dataSource
4.1 添加Dao
package xyz.huning.dao.impl.jdbcdaosupport.xml;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import xyz.huning.dao.impl.Employee;
import xyz.huning.dao.impl.IEmployeeDao;
public class EmployeeDao extends JdbcDaoSupport implements IEmployeeDao{
@Override
public Employee getEmployeeById(int id) {
String sql = "select id,name,level from t_employee where id = ?";
RowMapper<Employee> rowMapper = new BeanPropertyRowMapper<Employee>(Employee.class);
return getJdbcTemplate().queryForObject(sql, rowMapper, id);
}
}
4.2 添加配置
<?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"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<!-- 导入资源文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置 C3P0 数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
<property name="driverClass" value="${jdbc.driverClass}"></property>
<property name="initialPoolSize" value="${c3p0.initialPoolSize}"></property>
<property name="minPoolSize" value="${c3p0.minPoolSize}"></property>
<property name="maxPoolSize" value="${c3p0.maxPoolSize}"></property>
<property name="maxIdleTime" value="${c3p0.maxIdleTime}"></property>
<property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"></property>
</bean>
<!--向Dao中注入JdbcTemplate-->
<!--
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="employeeDao" class="xyz.huning.dao.impl.jdbcdaosupport.xml.EmployeeDao">
<property name="jdbcTemplate" ref="jdbcTemplate"></property>
</bean>
-->
<!--向Dao中注入dataSource-->
<bean id="employeeDao" class="xyz.huning.dao.impl.jdbcdaosupport.xml.EmployeeDao">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
4.3 添加测试类
package xyz.huning.dao.impl.jdbcdaosupport.xml;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import xyz.huning.dao.impl.Employee;
public class Main {
public static void main(String[] args) {
ApplicationContext ctx = new ClassPathXmlApplicationContext("jdbcdaosuppport-xml.xml");
EmployeeDao employeeDao = ctx.getBean("employeeDao", EmployeeDao.class);
Employee employee = employeeDao.getEmployeeById(1);
System.out.println(employee);
((ClassPathXmlApplicationContext)ctx).close();
}
}
相关推荐
开发工具 spring-jdbc-4.3.6.RELEASE开发工具 spring-jdbc-4.3.6.RELEASE开发工具 spring-jdbc-4.3.6.RELEASE开发工具 spring-jdbc-4.3.6.RELEASE开发工具 spring-jdbc-4.3.6.RELEASE开发工具 spring-jdbc-4.3.6....
java开发之SpringMVC + Spring + SpringJDBC整合.zip
Spring Data JDBC API。 Spring Data JDBC 开发文档。 官网 Spring Data JDBC API
Spring+JDBC组合开发
包含Springjdbc的相关jar包，Spring 框架对JDBC的简单封装，提供了JdbcTemplate对象简化了JDBC的开发。
Spring JDBC Spring的JDBC模块负责数据库资源管理和错误处理，大大简化了开发人员对数据库的操作，使得开发人员可以从繁琐的数据库操作中解脱出来，从而将更多的精力投入到编写业务逻辑当中。 Spring JdbcTemplate...
这里整理了齐全的jar包 ,我是在开发的过程中积累的,很多是跟别人要的,希望能帮到系伙伴们.不够的请联系我
用spring4.0.5版本开发的，spring mvc，spring jdbc，最简单的用户登录，注册和修改的系统。适合初学者学习。
Spring数据库开发--SpringJDBC的配置
里面有springjdbc的使用，在配置文件中还包含了一份详细的mybatis-generator配置以及自动生成的mybatis代码，加快开发的效率
NULL 博文链接：https://countme.iteye.com/blog/1136544
创建一个java工程，名为springJDBC，包和类组织如下图所示。 测试资源文件夹放配置文件业务层具体业务逻辑（登录、注册、选课等等）领域对象放实体类持久层负责数据的访问和操作 测试 资源文件夹 放配置文件 业务层 ...
Spring Data JDBC Extensions API。 Spring Data JDBC Extensions 开发文档
SpringMVC3 + SpringJDBC 整合示例 主要功能包括CRUD，权限过滤，分页查询等。 数据库：MySQL 集成开发工具：Eclipse。
spring开发用到的相关jar包（jdbc，json，mybatis等）
该资源中包含spring框架开发已经进行JDBC开发所需要的所有基本开发类。
spring+jdbc整合开发环境搭建,基于xml和注解配置事务管理
druid-1.1.9.jarmysql-connector-java-5.1.7-bin.jarspring-jdbc-5.2.6.RELEASE.jarspring-orm-5.2.6.RELEASE.jarspring-tx-5.2.6.RELEASE.jar
1、mini-jdbc：针对spring jdbc的一些不方便的地方，做了一些封装，大小写不敏感，简化了日常的开发工作。 基于spring jdbc的RowMapper自动实现对象映射，大部分功能已经由spring jdbc实现了。2、数据类型的设计：...
让我们在开发中以及开发后期进行测试时，直接使用Junit结合spring一起测试。 本套课程中，我们将全面剖析Spring和SpringMVC两个部分。从应用场景分析，到基本用法的入门案例，再到高级特性的分析及使用，最后是执行...