JdbcTemplate概述和测试_jdbctemplate test

@Test
//测试JdbcTemplate开发步骤
public void test1() throws PropertyVetoException {

//创建数据源对象
ComboPooledDataSource dataSource=new ComboPooledDataSource();
dataSource.setDriverClass(“com.mysql.jdbc.Driver”);
//位置为本地，3306端口，test数据库
dataSource.setJdbcUrl(“jdbc:mysql://localhost:3306/test”);
//用户名
dataSource.setUser(“root”);
//用户密码
dataSource.setPassword(“123456”);
JdbcTemplate jdbcTemplate=new JdbcTemplate();
//设置数据源对象，知道数据库在哪里
jdbcTemplate.setDataSource(dataSource);
//执行操作
int row = jdbcTemplate.update(“insert into account value(?,?)”, “tom”, 5000);
System.out.println(row);
}

}

> 
> #### domain包下的account类下
> 
> 
> 

package domain;

public class Account {
private String name;
private double money;

public String getName() {
    return name;
}

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

public double getMoney() {
    return money;
}

public void setMoney(double money) {
    this.money = money;
}

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

}

#### 运行结果：


![](https://img-blog.csdnimg.cn/d10257d2a7cc4276a30af185b022e9c6.png)


 数据库中的test数据库，account表


![](https://img-blog.csdnimg.cn/71ef364add0146d79742dc2cd6215d7c.png)


###  Spring产生JdbcTemplate对象


#### 测试插入


仔细看，这些都是参数注入（用了setXxx。。），我们可以将JdbcTemplate的创建权交给Spring，将数据源DataSource的创建权也交给Spring，在Spring容器内部将数据源DateSource注入到JdbcTemplate模版对象中，配置如下：


在test测试包下创建一系列


![](https://img-blog.csdnimg.cn/bc3c5896b39f426a83b562ba69e0a213.png)



> 
> ####  在applicationContext1.xml下
> 
> 
> 

<?xml version="1.0" encoding="UTF-8"?>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="com.mysql.jdbc.Driver"/>
    <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test"/>
    <property name="user" value="root"/>
    <property name="password" value="123456"/>
</bean>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    <property name="dataSource" ref="dataSource"/>
</bean>

```

pom.xml中

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>javaMaven02</artifactId>
    <version>1.0-SNAPSHOT</version>
    <dependencies>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.32</version>
        </dependency>
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
 


        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.0.5.RELEASE</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
<!-- 导入json相关依赖       -->
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-core</artifactId>
            <version>2.9.0</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.9.0</version>
        </dependency>

        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-annotations</artifactId>
            <version>2.9.0</version>
        </dependency>
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>


    </dependencies>


</project>

JdbcTemplateTest类下

public class JdbcTemplateTest {
    @Test
  //测试Spring产生jdbcTemplate对象
    public void test2() throws PropertyVetoException {
        ApplicationContext app=new ClassPathXmlApplicationContext("applicationContext1.xml");
        JdbcTemplate jdbcTemplate=app.getBean(JdbcTemplate.class);
        int row = jdbcTemplate.update("insert into account value(?,?)", "KC", 50000);
        System.out.println(row);

    }
}

运行结果：

数据库中的变化

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上软件测试知识点，真正体系化！

[外链图片转存中…(img-AkzE2oLt-1719227328516)]
[外链图片转存中…(img-tgWIYIBI-1719227328516)]
[外链图片转存中…(img-Iy1LZODw-1719227328517)]

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上软件测试知识点，真正体系化！