jdbcTemplate

最新推荐文章于 2024-06-27 08:00:00 发布
最新推荐文章于 2024-06-27 08:00:00 发布
阅读量114 收藏
点赞数
分类专栏： spring 文章标签： spring jdbc
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40820916/article/details/115615146
版权

jdbcTemplate

增删改查方法

先在创建spring数据库，并且创建user表，如下
在这里插入图片描述
创建文件夹，层级关系如下
在这里插入图片描述
User类

package com.example.demo.entity;

import java.math.BigDecimal;

public class User {
    private Integer id;
    private String username;
    private BigDecimal money;

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public BigDecimal getMoney() {
        return money;
    }

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

	@Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", money=" + money +
                '}';
    }
}

bean1.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd">

    <!--组件扫描-->
    <context:component-scan base-package="com.example.demo"/>

    <!--引入配置文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>

    <!--数据库连接池-->
    <bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${user}"/>
        <property name="password" value="${password}"/>
    </bean>

    <!--配置jdbcTemplate-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="datasource"/>
    </bean>
</beans>

jdbc.properties

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/spring?serverTimezone=GMT%2B8&useSSL=false&useUnicode=true&characterEncoding=utf-8
user=root
password=123456

添加数据

单个数据添加

UserDao

package com.example.demo.dao;

import com.example.demo.entity.User;

public interface UserDao {
    void add(User user);
}

UserDaoImpl

package com.example.demo.dao;

import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void add(User user) {
        String sql = "insert into user values (?, ?, ?)";

        int i = jdbcTemplate.update(sql, user.getId(), user.getUsername(), user.getMoney());
        System.out.println("成功了 " + i + " 条");
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void add(User user) {
        userDao.add(user);
    }
}

MyTest

package com.example.demo;

import com.example.demo.entity.User;
import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.math.BigDecimal;

public class MyTest {
    @Test
    public void testJdbc() {
        User user = new User();
        user.setId(1);
        user.setUsername("小明");
        user.setMoney(BigDecimal.valueOf(500));
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        service.add(user);
    }
}

执行结果
在这里插入图片描述
在这里插入图片描述

批量添加

UserDao

package com.example.demo.dao;

import java.util.List;

public interface UserDao {
    void intsertMany(List<Object[]> args);
}

UserDaoImpl

package com.example.demo.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void intsertMany(List<Object[]> args) {
        String sql = "insert into user values (?, ?, ?)";
        int[] ints = jdbcTemplate.batchUpdate(sql, args);
        for (int i = 0; i < ints.length; i++) {
            if (ints[i] == 1) {
                System.out.println("第 " + (i+1) + " 条成功");
                continue;
            }
            System.out.println("第 " + (i+1) + " 条失败");
        }
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void insertMany(List<Object[]> args) {
        userDao.intsertMany(args);
    }
}

MyTest

package com.example.demo;

import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;


public class MyTest {
    @Test
    public void testJdbc() {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        List<Object[]> args = new ArrayList<>();
        Object[] obj1 = {2, "小华", BigDecimal.valueOf(500)};
        Object[] obj2 = {3, "小刚", BigDecimal.valueOf(500)};
        Object[] obj3 = {4, "小红", BigDecimal.valueOf(500)};
        args.add(obj1);
        args.add(obj2);
        args.add(obj3);
        service.insertMany(args);
    }
}

执行结果
在这里插入图片描述
在这里插入图片描述

查询数据

返回多个属性值

UserDao

package com.example.demo.dao;

import com.example.demo.entity.User;

public interface UserDao {
    void findById(Integer id);
}

UserDaoImpl

package com.example.demo.dao;

import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void findById(Integer id) {
        String sql = "select * from user where id = ?";
        //调用queryForObject(String sql, RowMapper<T> rowMapper, @Nullable Object... args)
        //使用RowMapper接口的实现类BeanPropertyRowMapper实现数据封装
        User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), 1);
        System.out.println(user);
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void findById(Integer id) {
        userDao.findById(id);
    }
}

MyTest

package com.example.demo;

import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class MyTest {
    @Test
    public void testJdbc() {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        service.findById(1);
    }
}

执行结果
在这里插入图片描述

返回某个值

UserDao

package com.example.demo.dao;

import com.example.demo.entity.User;

public interface UserDao {
    void selectCount();
}

UserDaoImpl

package com.example.demo.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void selectCount() {
        String sql = "select count(id) from user";
        int i = jdbcTemplate.queryForObject(sql, Integer.class);
        System.out.println("一共有 " + i + " 条数据");
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void selectCount() {
        userDao.selectCount();
    }
}

MyTest

package com.example.demo;

import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class MyTest {
    @Test
    public void testJdbc() {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        service.selectCount();
    }
}

执行结果
在这里插入图片描述
在这里插入图片描述

修改数据

单行数据修改

UserDao

package com.example.demo.dao;

import com.example.demo.entity.User;

public interface UserDao {
    void updateById(User user);
}

UserDaoImpl

package com.example.demo.dao;

import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void updateById(User user) {
        String sql = "update user set username = ? where id = ?";
        int i = jdbcTemplate.update(sql, user.getUsername(), user.getId());
        System.out.println("更新了 " + i + " 条数据");
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void updateById(User user) {
        userDao.updateById(user);
    }
}

MyTest

package com.example.demo;

import com.example.demo.entity.User;
import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class MyTest {
    @Test
    public void testJdbc() {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        User user = new User();
        user.setId(1);
        user.setUsername("小华");
        service.updateById(user);
    }
}

执行结果
在这里插入图片描述
在这里插入图片描述

批量修改

UserDao

package com.example.demo.dao;

import java.util.List;

public interface UserDao {
    void updateMany(List<Object[]> args);
}

UserDaoImpl

package com.example.demo.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void updateMany(List<Object[]> args) {
        String sql = "update user set username = ? where id = ?";
        int[] ints = jdbcTemplate.batchUpdate(sql, args);
        for (int i = 0; i < ints.length; i++) {
            if (ints[i] == 1) {
                System.out.println("第 " + (i+1) + " 条成功");
                continue;
            }
            System.out.println("第 " + (i+1) + " 条失败");
        }
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void updateMany(List<Object[]> args) {
        userDao.updateMany(args);
    }
}

MyTest

package com.example.demo;

import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.ArrayList;
import java.util.List;

public class MyTest {
    @Test
    public void testJdbc() {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        List<Object[]> args = new ArrayList<>();
        //参数要按顺序赋值
        Object[] obj1 = {"小华2", 2};
        Object[] obj2 = {"小刚2", 3};
        args.add(obj1);
        args.add(obj2);
        service.updateMany(args);
    }
}

执行结果
在这里插入图片描述
在这里插入图片描述

删除数据

单行删除

UserDao

package com.example.demo.dao;

import com.example.demo.entity.User;

public interface UserDao {
    void deleteById(Integer id);
}

UserDaoImpl

package com.example.demo.dao;

import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void deleteById(Integer id) {
        String sql = "delete from user where id = ?";
        int i = jdbcTemplate.update(sql, id);
        System.out.println("删除了 " + i + " 条数据");
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void deleteById(Integer id) {
        userDao.deleteById(id);
    }
}

MyTest

package com.example.demo;

import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class MyTest {
    @Test
    public void testJdbc() {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        service.deleteById(1);
    }
}

执行结果
在这里插入图片描述
在这里插入图片描述

批量删除

UserDao

package com.example.demo.dao;

import java.util.List;

public interface UserDao {
    void deleteMany(List<Object[]> args);
}

UserDaoImpl

package com.example.demo.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public class UserDaoImpl implements UserDao{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void deleteMany(List<Object[]> args) {
        String sql = "delete from user where id = ?";
        int[] ints = jdbcTemplate.batchUpdate(sql, args);
        for (int i = 0; i < ints.length; i++) {
            if (ints[i] == 1) {
                System.out.println("第 " + (i+1) + " 条成功");
                continue;
            }
            System.out.println("第 " + (i+1) + " 条失败");
        }
    }
}

UserService

package com.example.demo.service;

import com.example.demo.dao.UserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService{
    @Autowired
    private UserDao userDao;

    public void deleteMany(List<Object[]> args) {
        userDao.deleteMany(args);
    }
}

MyTest

package com.example.demo;

import com.example.demo.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.ArrayList;
import java.util.List;

public class MyTest {
    @Test
    public void testJdbc() {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService service = context.getBean("userService", UserService.class);
        List<Object[]> args = new ArrayList<>();
        Object[] obj1 = {2};
        Object[] obj2 = {3};
        args.add(obj1);
        args.add(obj2);
        service.deleteMany(args);
    }
}

执行结果
在这里插入图片描述
在这里插入图片描述

奋斗的磊哥→_→
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
JDBC Template
Rankis的博客
03-14 498
JDBC Template 一.简化持久化操纵，Spring在JDBC API之上提供了JDBC Template组件传统： JDBC Template： /*JDBC Template提供统一的模板方法，在保留代码灵活性的基础上尽量减少持久化代码*/ /*jabc api*/ Statement statement=conn.createStatement(); ResultSet resu...
JDBCTemplate
weixin_52875557的博客
10-19 5781
目录 1、什么是JDBC 2、什么是JDBCTemplate 3、快速上手JDBCTemplate 4.调用JdbcTemplate的方法来完成CRUD的操作 1、什么是JDBC JDBC（Java DataBase Connectivity,java数据库连接）：是一种用于执行SQL语句的Java API，可以为多种关系数据库提供统一访问，它由一组用Java语言编写的类和接口组成。 2、什么是JDBCTemplate Template意思是模板，JDBCTemplate是Spring为我们
详细分析JdbcTemplate的基本知识 | 拓展OracleJdbcTemplate（附Demo）
最新发布
码农研究僧的博客
06-27 2003
需要支持多种类型的数据库，或者不特定于某一种数据库，建议使用JdbcTemplate 主要与Oracle数据库交互，并且需要一些Oracle特有的功能优化，可以考虑使用OracleJdbcTemplate
JdbcTemplate
03-21
Spring对数据库的操作在jdbc上面做了深层次的封装，使用spring的注入功能，可以把DataSource注册到JdbcTemplate之中。
JdbcTemplate基本使用
01-27
JdbcTemplate是Spring框架中用于简化JDBC操作的工具类，它提供了一种更安全、更易用的方式来执行数据库操作，避免了手动管理数据库资源和处理潜在的资源泄露问题。通过JdbcTemplate，开发者可以专注于SQL语句的编写...
jdbctemplate
03-30
The JdbcTemplate is a class in the Spring Framework that provides a simplified way to interact with a database using JDBC (Java Database Connectivity). It provides a set of methods for executing SQL ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值