011.JdbcTemplate

1.导入依赖1.导入依赖

<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.1.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.1.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>5.1.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>5.1.7.RELEASE</version>
</dependency>
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.2</version>
</dependency>

2.基本用法

package com.jdbc.utils;

import org.springframework.jdbc.core.JdbcTemplate;

public class JDBCTemplateDemo1 {

    public static void main(String[] args) {
        //1.创建JdbcTemplate对象,它依赖于DataSource
        JdbcTemplate template1 = new JdbcTemplate(JDBCUtils.getDataSource());

        for (int i = 0; i < 2000000; i++) {
            String sql="insert into tst_pdf_auto_case VALUES (?,?)";
            String case_id="case"+i;
            String case_context="case_context"+i;
            template1.update(sql,case_id,case_context);
        }

    }


}