spring框架-jdbcTemplate

首先 dao层：

dao

　　-bookdao（interface）

　　-bookdaoimpl

service层：

　　bookService

实体类对象

　　entiry-book

测试类 Test-TestBook

结构如图所示：

xml配置：

<?xml version="1.0" encoding="UTF-8"?>
       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 http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    
    







    
    
        
        
        
        

    
    
    
        
        
    

jdbc的配置文件：
　　

#prop.url=jdbc:mysql://localhost:3306/user_db?rewriteBatchedStatements=true
prop.url=jdbc:mysql://localhost:3306/user_db?useUnicode=true&characterEncoding=utf-8
prop.username=root
prop.password=110120
prop.driverClassName=com.mysql.jdbc.Driver

initialSize=10
maxActive=20
maxWait=1000
filters=wall

所需要jar包：

 下面为具体代码：

dao层代码：

package com.dao;

import com.entiry.Book;

import java.util.List;

public interface bookDAO {
   void add(Book book) ;

    void update(Book book);
    void delById(String Id);

    int selectCount();



    Book selectBook(String id);

    List findList();

    void addBatchList(List list);

 void batchUpdateBook(List lists);

 void batchDel(List list);
}

package com.dao;

import com.entiry.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.Arrays;
import java.util.List;

@Repository
public class bookDAOImpl  implements bookDAO{
    //注入jdbcTemplate
    @Autowired
    private JdbcTemplate jdbcTemplate;
    //添加的方法
    @Override
    public void add(Book book) {
        String sql = "insert into book values(?,?,?)";
        int update = jdbcTemplate.update(sql, book.getUserId(), book.getUsername(), book.getUstatus());
        if (update == 1){
            System.out.println("添加成功");
        }else {
            System.out.println("添加失败");
        }
    }

    @Override
    public void update(Book book) {
        String sql = "update book set username = ?,usatus = ? where user_id = ?";
        int update = jdbcTemplate.update(sql, book.getUsername(), book.getUstatus(), book.getUserId());
        if (update == -1){
            System.out.println("修改成功");
        }else {
            System.out.println("修改失败");
        }
    }

    @Override
    public void delById(String Id) {
        String sql = "delete from book where user_id = ?";

        int update = jdbcTemplate.update(sql, Id);
        if (update == 1){
            System.out.println("删除成功");
        }else {
            System.out.println("删除失败");
        }

    }

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

    }

    @Override
    public Book selectBook(String id) {
        String sql = "select * from book  where user_id = ?";
        Book book = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper(Book.class), id);

        return book;
    }

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

    @Override
    public void addBatchList(List list) {
        String sql = "insert into book values(?,?,?)";
        int[] ints = jdbcTemplate.batchUpdate(sql,list);
        System.out.println(Arrays.toString(ints));
    }

    @Override
    public void batchUpdateBook(List lists) {
        String sql = "update book set username =?,usatus = ? where user_id = ?";
        int[] ints = jdbcTemplate.batchUpdate(sql, lists);
        System.out.println(Arrays.toString(ints));
    }

    @Override
    public void batchDel(List list) {
        String sql ="delete from book where user_id = ?";
        int[] ints = jdbcTemplate.batchUpdate(sql, list);
        System.out.println(Arrays.toString(ints));
    }
}
service层：

package com.service;

import com.dao.bookDAO;
import com.entiry.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class BookService {
    //注入dao
    @Autowired
    private bookDAO bookdao;
    //添加
    public void addBook(Book book){
        bookdao.add(book);
    }
    //修改
    public void update(Book book){
        bookdao.update(book);
    }
    //删除
    public void delById(String Id){
        bookdao.delById(Id);
    }
    //查询返回某个值
    public int FindCount(){
        return  bookdao.selectCount();
    }
    //查询返回某个对象
    public Book findBook(String id){
        return bookdao.selectBook(id);
    }
    //返回多个对象
    public List findList(){
        return  bookdao.findList();
    }
    //批量添加
    public void BatchAdd(List list){
        bookdao.addBatchList(list);

    }
    //批量修改
    public void batchUpdateBook(List