14-Spring5 整合JdbcTemplate的步骤

Spring 框架对 JDBC 进行封装，使用 JdbcTemplate 方便实现对数据库操作

这是实现JdbcTemplate操作需要的jar包

1.创建数据库

2.编写java代码

配置文件bean1.xml

BookService

package com.limi.service;

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

@Service
public class BookService {

    @Autowired
    private JdbcTemplate jdbcTemplate;

	//获取书的数量
    public int getBookCount(){
        String sql ="select count(*) from t_book";
        Integer count = jdbcTemplate.queryForObject(sql, Integer.class);
        return count;
    }
}

测试类MyTest

package com.limi.test;
import com.limi.service.BookService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;

public class MyTest {

    @Test
    public void test1(){
        //1.加载bean的xml文件, 以src为根目录
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");

        //2.获取配置的对象, 参数1:bean的id值, 参数2: 类名.class
        BookService bookService = context.getBean("bookService", BookService.class);

        //3.使用对象
        System.out.println("书的数量="+bookService.getBookCount());

    }
}

3.测试结果