4.4、创建dao层

package com.wzy.jdbctemplate.dao;
import com.wzy.jdbctemplate.pojo.Book;
public interface BookDao {
    void insertBook(Book book);
}

package com.wzy.jdbctemplate.dao.impl;
import com.wzy.jdbctemplate.dao.BookDao;
import com.wzy.jdbctemplate.pojo.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
@Repository
public class BookDaoImpl implements BookDao {
    @Autowired
    JdbcTemplate jdbcTemplate;
    @Override
    public void insertBook(Book book) {
        //创建sql语句
        String sql = "insert into book(id,username,password,email) values (?,?,?,?)";
        //调佣 jdbcTemplate 的 update 方法，插入数据
        //Object[] args = {book.getId(), book.getUsername(), book.getPassword(), book.getEmail()};
        //int update = jdbcTemplate.update(sql, args);
        int update = jdbcTemplate.update(sql, book.getId(), book.getUsername(), book.getPassword(), book.getEmail());
        System.out.println(update);
    }
}