package com.kwan.spring5.dao.impl;

import com.kwan.spring5.Book;
import com.kwan.spring5.dao.BookDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

@Repository
public class BookDaoImpl implements BookDao {
    /**
     * 注入 JdbcTemplate
     */
    @Autowired
    private JdbcTemplate jdbcTemplate;

    /**
     * 添加的方法
     *
     * @param book
     */
    @Override
    public void add(Book book) {
        //1 创建 sql 语句
        String sql = "INSERT INTO t_book VALUES(?,?,?)";
        //2 调用方法实现
        Object[] args = {book.getUserId(), book.getUsername(), book.getUstatus()};
        int update = jdbcTemplate.update(sql, args);
        System.out.println(update);
    }
}