spring--JdbcTemplate--01--介绍与环境搭建

最新推荐文章于 2023-09-08 10:46:26 发布

na_tion

最新推荐文章于 2023-09-08 10:46:26 发布

阅读量302

点赞数

分类专栏： spring

本文链接：https://blog.csdn.net/na_tion/article/details/115919688

版权

spring 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

一、JdbcTemplate介绍

JDBC(Java DataBase Connectivity,java数据库连接)是一种用于执行SQL语句的Java API，即java操作SQL的规范

JdbcTemplate是spring对JDBC的封装，用于更方便的操作SQL（使用jdbc操作SQL较为繁琐）

二、使用JdbcTemplate需要引入的依赖（spring的maven项目）

<!-- jdbcTemplate实现jar -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>${spring.version}</version>
</dependency>

<!-- 数据库驱动 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.43</version>
</dependency>

<!-- 数据库连接池 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.12</version>
</dependency>
<!-- 事务管理 -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-tx</artifactId>
    <version>${spring.version}</version>
</dependency>

三、环境搭建--xml版

（1）bean.xml配置

<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns="http://www.springframework.org/schema/beans"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                           http://www.springframework.org/schema/beans/spring-beans.xsd
                            http://www.springframework.org/schema/tx
                            http://www.springframework.org/schema/tx/spring-tx.xsd
                            http://www.springframework.org/schema/aop
                            http://www.springframework.org/schema/aop/spring-aop.xsd">

    <!--创建数据源（带druid连接池）-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/fuping3?useSSL=false"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>


    <!--创建JdbcTemplate对象-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <!--注入数据源-->
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <bean id="bookDao" class="com.fuping3.dao.BookDaoImpl">
        <property name="jdbcTemplate" ref="jdbcTemplate"/>
    </bean>

    <bean id="bookService" class="com.fuping3.service.BookService">
        <property name="bookDao" ref="bookDao"/>
    </bean>
    
</beans>

（2）dao层代码

package com.fuping3.dao;

import com.fuping3.pojo.Book;

public interface BookDao {
    int addBook(Book book);
    int deleteBook(Book book);
    int updateBook(Book book);

}







package com.fuping3.dao;

import com.fuping3.pojo.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;

public class BookDaoImpl implements BookDao{

    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public int addBook(Book book) {
        String sql="INSERT INTO book(name,price) VALUES(?,?)";
        Object[] args={book.getName(),book.getPrice()};
        int update = jdbcTemplate.update(sql, args);
        return update;
    }
    @Override
    public int deleteBook(Book book) {
        String sql="DELETE FROM book WHERE id=?";
        Object[] args={book.getId()};
        int update = jdbcTemplate.update(sql, args);
        return update;
    }
    @Override
    public int updateBook(Book book) {
        String sql="UPDATE book SET name=?,price=? WHERE id=?";
        Object[] args={book.getName(),book.getPrice(),book.getId()};
        int update = jdbcTemplate.update(sql, args);
        return update;
    }
}

（3）servic层代码

package com.fuping3.service;

import com.fuping3.dao.BookDao;
import com.fuping3.pojo.Book;
import org.springframework.beans.factory.annotation.Autowired;

public class BookService {

    private BookDao bookDao;

    public void setBookDao(BookDao bookDao) {
        this.bookDao = bookDao;
    }

    public int addBook(Book book){
        System.out.println("添加业务逻辑处理。。。");
        return bookDao.addBook(book);
    }
    public int deleteBook(Book book){
        System.out.println("删除业务逻辑处理。。。");
        return bookDao.deleteBook(book);
    }
    public int updateBook(Book book){
        System.out.println("修改业务逻辑处理。。。");
        return bookDao.updateBook(book);
    }
    
}

（4）测试代码

import com.fuping3.pojo.Book;
import com.fuping3.service.BookService;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestUpdate {
    public static void main(String[] args) {
        ClassPathXmlApplicationContext context=new ClassPathXmlApplicationContext("bean.xml");
        BookService bookService=context.getBean("bookService", BookService.class);
        {
            Book book=new Book("china",20);
            int result = bookService.addBook(book);
            System.out.println("执行结果："+result);
        }
        {
            Book book=new Book();
            book.setId(12);
            int result = bookService.deleteBook(book);
            System.out.println("执行结果："+result);
        }

    }
}

（5）测试代码输出

添加业务逻辑处理。。。
四月 21, 2021 6:57:00 下午 com.alibaba.druid.support.logging.JakartaCommonsLoggingImpl info
信息: {dataSource-1} inited
执行结果：1
删除业务逻辑处理。。。
执行结果：1

四、环境搭建--纯注解版

（1）数据库源相关配置代码

package com.fuping3.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

@Configuration
@ComponentScan(basePackages = {"com.fuping3"})
public class DaoConfig {
    @Bean
    public DataSource dataSource() throws Exception {
        DruidDataSource dataSource=new DruidDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/fuping3?useSSL=false");
        dataSource.setUsername("root");
        dataSource.setPassword("123456");
        return dataSource;
    }


    @Bean
    public JdbcTemplate jdbcTemplate(DataSource dataSource){
        return new JdbcTemplate(dataSource);
    }
}

（2）dao层代码

package com.fuping3.dao;

import com.fuping3.pojo.Book;

public interface BookDao {
    int addBook(Book book);
    int deleteBook(Book book);
}








package com.fuping3.dao;

import com.fuping3.pojo.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

@Repository
public class BookDaoImpl implements BookDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public int addBook(Book book) {
        String sql="INSERT INTO book(name,price) VALUES(?,?)";
        Object[] args={book.getName(),book.getPrice()};
        int update = jdbcTemplate.update(sql, args);
        return update;
    }

    @Override
    public int deleteBook(Book book) {
        String sql="DELETE FROM book WHERE id=?";
        Object[] args={book.getId()};
        int update = jdbcTemplate.update(sql, args);
        return update;
    }
}

（3）service层代码

package com.fuping3.service;

import com.fuping3.dao.BookDao;
import com.fuping3.pojo.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class BookService {
    @Autowired
    private BookDao bookDao;

    public int addBook(Book book){
        System.out.println("添加业务逻辑处理。。。");
        return bookDao.addBook(book);
    }

    public int deleteBook(Book book){
        System.out.println("删除业务逻辑处理。。。");
        return bookDao.deleteBook(book);
    }
}

（4）测试代码

import com.fuping3.config.DaoConfig;
import com.fuping3.dao.BookDao;
import com.fuping3.pojo.Book;
import com.fuping3.service.BookService;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestUpdate {
    public static void main(String[] args) {
        AnnotationConfigApplicationContext context=new AnnotationConfigApplicationContext(DaoConfig.class);
        BookService bookService=context.getBean("bookService", BookService.class);
        {
            Book book=new Book("huaxue",5);
            int result = bookService.addBook(book);
            System.out.println("执行结果："+result);
        }
        {
            Book book=new Book();
            book.setId(9);
            int result = bookService.deleteBook(book);
            System.out.println("执行结果："+result);
        }
    }
}

（5）输出

添加业务逻辑处理。。。
四月 21, 2021 6:50:28 下午 com.alibaba.druid.support.logging.JakartaCommonsLoggingImpl info
信息: {dataSource-1} inited
执行结果：1
删除业务逻辑处理。。。
执行结果：0

na_tion

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
spring--JdbcTemplate--01--介绍与环境搭建

一、JdbcTemplate介绍JDBC(Java DataBase Connectivity,java数据库连接)是一种用于执行SQL语句的Java API，即java操作SQL的规范JdbcTemplate是spring对JDBC的封装，用于更方便的操作SQL
复制链接

扫一扫