【SSM-Spring】JdbcTemplate(一)

最新推荐文章于 2025-11-19 06:00:00 发布

原创最新推荐文章于 2025-11-19 06:00:00 发布 · 371 阅读

0 ·

CC 4.0 BY-SA版权

SSM-Spring 专栏收录该内容

18 篇文章

订阅专栏

博客介绍了使用JDBCTemplate进行数据库操作的相关配置与测试。首先在pom.xml添加依赖，创建C3p0的properties和ApplicationContext.xml，配置C3P0数据源并导入资源文件。还展示了创建与数据库对应的DAO，以及进行单条查询、一组对象查询、统计列值查询和更新值等操作的测试。

首先：pom.xml添加依赖

<dependency>
        <groupId>commons-dbutils</groupId>
        <artifactId>commons-dbutils</artifactId>
        <version>1.6</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->

    <dependency>
        <groupId>com.mchange</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.5.2</version>
    </dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
</dependency>

<!-- https://mvnrepository.com/artifact/commons-pool/commons-pool -->
<dependency>
    <groupId>commons-pool</groupId>
    <artifactId>commons-pool</artifactId>
    <version>1.6</version>
</dependency>

<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
</dependency>



<!--1 测试必备 junit
      日志log4J-->



<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
</dependency>
<depe

ndency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>

   <!-- 2   Spring
            core
                beans
                context
                expre
                commons-logging
                aop
                jdbc
                -->
    <dependency>
        <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.3.13.RELEASE</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.3.23.RELEASE</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-beans</artifactId>
    <version>4.3.23.RELEASE</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>4.3.23.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-expression</artifactId>
    <version>4.3.23.RELEASE</version>
</dependency>

<dependency>
    <groupId>commons-logging</groupId>
    <artifactId>commons-logging</artifactId>
    <version>1.2</version>
</dependency>


<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aop</artifactId>
    <version>4.3.23.RELEASE</version>
</dependency>
<dependency>
    <groupId>aopalliance</groupId>
    <artifactId>aopalliance</artifactId>
    <version>1.0</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>4.3.1.RELEASE</version>
</dependency>

<!--   AspectJ-->

<dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjweaver</artifactId>
    <version>1.8.9</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aspects</artifactId>
    <version>4.3.1.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.5</version>
</dependency>

1创建C3p0的properties

jdbc.driverClass=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1/work?useSSL=false&serverTimezone=UTC
jdbc.user=root
jdbc.password=123456
jdbc.initialPoolSize = 5
jdbc.maxPoolSize = 10

2.ApplicationContext.xml

总代码：

2.1配置C3P0数据源

 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="${jdbc.user}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="driverClass" value="${jdbc.driverClass}"/>

        <property name="initialPoolSize" value="${jdbc.initialPoolSize}"/>
        <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/>
    </bean>

2.2导入资源文件

 <context:property-placeholder location="classpath:JDBCTEM/jdbctem.properties"/>

3.Test

public class TemTest1 {
    private ApplicationContext context = null;
    {
        context=new ClassPathXmlApplicationContext("JDBCTEM/JDBCTEMcontext.xml");
    }

    @Test
    public void tem1() throws SQLException {
        DataSource dataSource = context.getBean(DataSource.class);
        System.out.println(dataSource.getConnection());

    }
}

JDBCTemplate

创建与数据库对应的DAO

public class Day1Dao {
    private int id;
    private String name;

    @Override
    public String toString() {
        return "Day1Dao{" +
                "id=" + id +
                ", name='" + name + '\'' +
                '}';
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

在context配置第三步

<!--3配置Spring 的JDBCTemplate-->
<bean id="jdbcTemplate"
      class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>

Test

   private ApplicationContext context = null;
    private JdbcTemplate jdbcTemplate;
    {
        context=new ClassPathXmlApplicationContext("JDBCTEM/JDBCTEMcontext.xml");
        jdbcTemplate  =(JdbcTemplate) context.getBean("JdbcTemplate");
    }

1.查询一条实际得到一个对象：

在这里插入图片描述

  @Test
    public void temselect(){
        String sql = "select * from day1 where id =?";
        RowMapper<Day1Dao> rowMapper = new BeanPropertyRowMapper<Day1Dao>(Day1Dao.class);
        Day1Dao dd= jdbcTemplate.queryForObject(sql,rowMapper,1);
        System.out.println(dd);
    }

2.查询一组对象

在这里插入图片描述

@Test
    public void temselect2(){
        String sql = "select * from day1 where id >?";
        RowMapper<Day1Dao> rowMapper =  new BeanPropertyRowMapper<Day1Dao>(Day1Dao.class);
        List<Day1Dao> list  = jdbcTemplate.query(sql,rowMapper,5);
        System.out.println(list);
        for (Day1Dao dd:list
        ) {
            System.out.println(dd);
        }
    }

3.查询统计一列的值

@Test
public void testSelect3(){
    String sql ="select count(id) from day1";
    long count =  jdbcTemplate.queryForObject(sql,Long.class);
    System.out.println(count);
}