spring-template的使用

最新推荐文章于 2025-07-24 13:02:14 发布

原创最新推荐文章于 2025-07-24 13:02:14 发布 · 893 阅读

2 ·

CC 4.0 BY-SA版权

j 专栏收录该内容

26 篇文章

订阅专栏

本文介绍如何使用Spring框架配置JDBC模板和C3P0数据源，并通过示例展示如何进行更新操作和批量插入测试。

xml基本配置


    <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="driverClass" value="${jdbc.driverClass}"> </property>
        <property name="jdbcUrl" value="${jdbc.jdbcUrl}"> </property>
    </bean>

    <!--配置spring的jdbc模板类-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

导入org.springframework.transaction-3.1.2.RELEASE.jar这个jar包，不然会报错

简单的测试


    //测试修改
    @Test
    public void testupdaate(){
        String sql = "UPDATE house_info SET house_place = ? WHERE house_id = ?";
        jdbcTemplate.update(sql,"456465",3);
    }

    @Test
    //测试批量增加
    public void batchadd(){
        String sql = "insert into house_info(house_location,house_source,house_area,house_type,house_nature,house_state,house_place) values(?,?,?,?,?,?,?)";
        ArrayList<Object[]> objects = new ArrayList<>();
        objects.add(new Object[]{"as", "a", "12.21", "a", "a", "s", "2"});
        objects.add(new Object[]{"as", "a", "12.21", "a", "a", "s", "2"});
        objects.add(new Object[]{"as", "a", "12.21", "a", "a", "s", "2"});
        objects.add(new Object[]{"as", "a", "12.21", "a", "a", "s", "2"});
        objects.add(new Object[]{"as", "a", "12.21", "a", "a", "s", "2"});

        int[] ints = jdbcTemplate.batchUpdate(sql, objects);
        System.out.println(ints.length);

    }