框架知识-spring-第三章：认识spring+JDBCTemplate

本文链接：https://blog.youkuaiyun.com/u014692224/article/details/112201901

1、jdbctemplate：

1.方便操作jdbc操作数据库

2、操作

1.引入相关jar包
在这里插入图片描述
mysql和druid数据库连接池的jar包

代码
Book

package com.changxiong.spring.entity;

/**
 * @author changxiong
 * @create 2020-12-30-10:30 PM
 */
public class Book {
    private String id;
    private String name;
    private String age;

    public Book() {
        super();
    }

    public Book(String id, String name, String age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public String getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "Book{" +
                "id='" + id + '\'' +
                ", name='" + name + '\'' +
                ", age='" + age + '\'' +
                '}';
    }
}

bookIDao

package com.changxiong.spring.bookDao;

import com.changxiong.spring.entity.Book;

import java.util.List;

/**
 * @author changxiong
 * @create 2020-12-30-10:33 PM
 */
public interface bookIDao {

    Book query(String id);

    List<Book> queryAll();

    void addBook(Book book);

    void updateBook(Book book);

    int countBook();

    void deleteBook(String id);

    public void batchAdd(List<Object[]> lists);
}

bookDaoImpl

package com.changxiong.spring.bookDao;

import com.changxiong.spring.entity.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author changxiong
 * @create 2020-12-30-10:33 PM
 */
@Repository
public class bookDaoImpl implements bookIDao {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public Book query(String id) {
        String sql="select * from book where id = ?";
        Book book = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(Book.class), id);
        return book;
    }

    @Override
    public List<Book> queryAll() {
        String sql = "select * from book";
        List<Book> bookList = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Book>(Book.class));
        return bookList;
    }

    @Override
    public void addBook(Book book) {
        String sql = "insert into book values(?,?,?)";
        Object[] str={book.getId(),book.getAge(),book.getName()};
        jdbcTemplate.update(sql,str);
    }

    @Override
    public void updateBook(Book book) {
        String sql = "update book set age=? where id=?";
        Object[] str={book.getAge(),book.getId()};
        jdbcTemplate.update(sql,str);
    }

    @Override
    public void deleteBook(String id) {
        String sql = "delete from book where id=?";
        jdbcTemplate.update(sql,id);
    }


    @Override
    public int countBook() {
        String sql = "select count(*) from book";
        Integer i = jdbcTemplate.queryForObject(sql, Integer.class);
        return i;
    }

    @Override
    public void batchAdd(List<Object[]> lists) {
        String sql="insert into book values(?,?,?)";
        int[] ints = jdbcTemplate.batchUpdate(sql,lists);

    }
}

bookServiceImpl

package com.changxiong.spring.bookService;

import com.changxiong.spring.bookDao.bookIDao;
import com.changxiong.spring.entity.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author changxiong
 * @create 2020-12-30-10:32 PM
 */
@Service
public class bookServiceImpl {

    @Autowired
    private bookIDao bookIDao;

    public void addBook(Book book) {
        bookIDao.addBook(book);

    }

    public List<Book> queryAll() {
        List<Book> books = bookIDao.queryAll();

        return books;
    }

    public Book query(String id) {
        Book book = bookIDao.query(id);
        return book;
    }

    public void updateBook(Book book) {
        bookIDao.updateBook(book);
    }

    public int countBook() {
        int i = bookIDao.countBook();
        return i;
    }

    public void deleteBook(String id) {
        bookIDao.deleteBook(id);
    }

    public void batchAdd(List<Object[]> lists){
        bookIDao.batchAdd(lists);
    }
}

jdbcTest

package com.changxiong.spring;

import com.changxiong.spring.bookService.bookServiceImpl;
import com.changxiong.spring.entity.Book;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

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

/**
 * @author changxiong
 * @create 2020-12-30-11:07 PM
 */
public class jdbcTest {

    public static void main(String[] args) {
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");

        bookServiceImpl bookServiceImpl = context.getBean("bookServiceImpl", bookServiceImpl.class);

        //查询操作
        String id = "1";
        Book book = bookServiceImpl.query(id);
        System.out.println(book.getAge());

        System.out.println();

        //查询全部操作
        List<Book> books = bookServiceImpl.queryAll();
        System.out.println(books.toString());

        System.out.println();

        //新增对象
        Book book1=new Book();
        book1.setId("5");
        book1.setAge("135");
        book1.setName("小米1");

        bookServiceImpl.addBook(book1);

        //更改对象
        book1.setAge("100");
        bookServiceImpl.updateBook(book1);

        //删除对象
        String id1 = "5";
        bookServiceImpl.deleteBook(id1);

        //批量添加
        List<Object[]> lsits=new ArrayList<>();

        Object[] books1={"10","tom","21"};
        Object[] books2={"12","keone","23"};
        Object[] books3={"13","xiaoling","22"};

        lsits.add(books1);
        lsits.add(books2);
        lsits.add(books3);

        bookServiceImpl.batchAdd(lsits);


        //批量删除修改
        //..

    }
}

config

package com.changxiong.spring.config;

import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.EnableAspectJAutoProxy;
import org.springframework.stereotype.Component;

/**
 * @author changxiong
 * @create 2020-12-30-5:04 PM
 */
@Component
@ComponentScan(basePackages = {"com.changxiong.spring"})
@EnableAspectJAutoProxy(proxyTargetClass = true)
public class config {

}

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:p="http://www.springframework.org/schema/p"
       xmlns:util="http://www.springframework.org/schema/util"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
                           http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd
                           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
                           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">


    <!--开启扫描-->
    <context:component-scan base-package="com.changxiong.spring"/>
    <!--配置连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${prop.driverClass}"></property>
        <property name="url" value="${prop.url}"></property>
        <property name="username" value="${prop.userName}"></property>
        <property name="password" value="${prop.password}"></property>
    </bean>

    <context:property-placeholder location="jdbc.properties"></context:property-placeholder>


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

jdbc.properties

prop.driverClass=com.mysql.jdbc.Driver
prop.url=jdbc:mysql://127.0.0.1:3306/crm?characterEncoding=utf8
prop.userName=root
prop.password=123456