首页 > 代码库 > Spring使用jdbcJdbcTemplate和三种方法配置数据源

Spring使用jdbcJdbcTemplate和三种方法配置数据源

三种方法配置数据源

1.需要引入jar包:spring-jdbc-4.3.2.RELEASE.jar

<!-- spring内置,springJdbc,配置数据源 -->    <bean id="dataSource"        class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>        <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"></property>        <property name="username" value="123"></property>        <property name="password" value="123"></property>    </bean>

2.需要引入2个jar包:(1).spring-framework-3.0.2.RELEASE-dependencies\org.apache.commons\com.springsource.org.apache.commons.dbcp\1.2.2.osgi\com.springsource.org.apache.commons.dbcp-1.2.2.osgi.jar

(2).spring-framework-3.0.2.RELEASE-dependencies\org.apache.commons\com.springsource.org.apache.commons.pool\1.5.3\com.springsource.org.apache.commons.pool-1.5.3.jar

<!-- dbcp,配置数据源 -->    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>        <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"></property>        <property name="username" value="123"></property>        <property name="password" value="123"></property>    </bean>

3.c3p0配置数据源,并引用了一个在src目录下自定义创建的一个.properties文件,并使用${}设值

!需要引入jar包:spring-framework-3.0.2.RELEASE-dependencies\com.mchange.c3p0\com.springsource.com.mchange.v2.c3p0\0.9.1.2\com.springsource.com.mchange.v2.c3p0-0.9.1.2.jar

<!-- c3p0,配置数据源 -->    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">        <property name="driverClass" value="${jdbc.driver}"></property>        <property name="jdbcUrl" value="${jdbc.url}"></property>        <property name="user" value="${jdbc.name}"></property>        <property name="password" value="${jdbc.password}"></property>    </bean>

 

Spring连接数据库

1.创建dao

public interface SelectAllEmpDao {    public void selectAll();}

2.创建实现类

public class SelectAllEmpImpl extends JdbcDaoSupport implements SelectAllEmpDao {    @Override    public void selectAll() {        String sql = "select * from emp";        List<Map<String, Object>> list = this.getJdbcTemplate().queryForList(                sql);        List<Emp> empList = new ArrayList<Emp>();        for (Map<String, Object> map : list) {            Emp e = new Emp();            e.setId(((BigDecimal) map.get("id")).intValueExact());            e.setName(map.get("name").toString());            e.setAge(((BigDecimal) map.get("age")).intValueExact());            empList.add(e);        }    }}

3.配置xml

(1)配置数据源

<!-- spring内置,springJdbc,配置数据源 -->    <bean id="dataSource"        class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>        <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"></property>        <property name="username" value="bdqn"></property>        <property name="password" value="bdqn"></property>    </bean>

(2)配置jdbcTemplate,并引用dataSource

<!-- 配置template,并为其注入dataSource -->    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">        <property name="dataSource" ref="dataSource"></property>    </bean>

(3).注册业务bean,并引用jdbcTemplate

<!-- 查询emp所有记录数 -->    <bean id="selectAllEmpDao" class="cn.cnsdhzzl.dao.impl.SelectAllEmpImpl">        <property name="jdbcTemplate" ref="jdbcTemplate"></property>    </bean>

(4)测试

@Test    // Spring使用jdbc查询表中所有记录    public void selectAll() {        ApplicationContext ac = new ClassPathXmlApplicationContext(                "applicationContext.xml");        SelectAllEmpDao selectAllEmpDao = (SelectAllEmpDao) ac                .getBean("selectAllEmpDao");        selectAllEmpDao.selectAll();    }

 

Spring使用jdbcJdbcTemplate和三种方法配置数据源