Day70-回顾Spring篇之JdbcTemplate

Day71-回顾Spring篇之JdbcTemplate

准备工作

创建一个新项目,添加如下依赖:

<dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.7.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.7.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.48</version>
        </dependency>
</dependencies>

准备数据库:

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50018
Source Host           : localhost:3306
Source Database       : test01

Target Server Type    : MYSQL
Target Server Version : 50018
File Encoding         : 65001

Date: 2022-10-04 15:46:09
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `user2`
-- ----------------------------
DROP TABLE IF EXISTS `user2`;
CREATE TABLE `user2` (
  `id` int(20) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `address` varchar(20) default NULL,
  `favorites` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user2
-- ----------------------------
INSERT INTO `user2` VALUES ('1', '张三', '北京', '唱');
INSERT INTO `user2` VALUES ('2', '李四', '上海', 'rap');
INSERT INTO `user2` VALUES ('3', '王五', '深圳', '篮球');
INSERT INTO `user2` VALUES ('4', '赵六', '广东', '跳');

准备一个实体类

package com.fu.jdbc;

public class User {

    private Integer id;
    private String username;
    private String address;
    private String favorites;

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

    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 String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getFavorites() {
        return favorites;
    }

    public void setFavorites(String favorites) {
        this.favorites = favorites;
    }
}

写了一个测试案例:

import com.fu.jdbc.config.JdbcConfig;
import org.junit.Before;
import org.junit.Test;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;

public class Main {

    private JdbcTemplate jdbcTemplate;

    @Before
    public void before(){
        AnnotationConfigApplicationContext ctx = new AnnotationConfigApplicationContext(JdbcConfig.class);
        jdbcTemplate = ctx.getBean(JdbcTemplate.class);
    }

    @Test
    public void insert(){
        int i = jdbcTemplate.update("insert into user2 (username ,address) values(?,?);","fushijie","www.jcut.com");
        System.out.println(i);
    }
}