自定义mvc增删查改

package com.hd.dao;
 
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
 
import com.zc.entity.Book;
import com.zc.utli.BaseDao;
import com.zc.utli.DBAccess;
import com.zc.utli.PageBean;
import com.zc.utli.StringUtils;
 
public class BookDao extends BaseDao<Book>{
	/**
	 * 现状：增删改
	 * 	1.写sql
	 * 	2.建立链接
	 * 	3.预定义对象PreparedStatement
	 * 	4.设置参数
	 * 	5.执行sql
	 * 解决：
	 * 	
	 * @param book
	 * @throws Exception
	 */
	public void add(Book book) throws Exception {
		String sql  = "insert into t_book values(?,?,?)";
		super.executeUpdate(sql, book, new String[] {"bid","bname","price"});
	}
	
	public void delete(Book book) throws Exception {
		String sql  = "delete from t_book where bid = ?";
		super.executeUpdate(sql, book, new String[] {"bid"});
	}
	
	public void edit(Book book) throws Exception {
		String sql  = "update t_book set bname = ?,price = ? where bid = ?";
		super.executeUpdate(sql, book, new String[] {"bname","price","bid"});
	}
	
	public List<Book> list(Book book,PageBean pageBean) throws Exception {
		String sql  = "select * from t_book where 1=1 ";
		String bname = book.getBname();
		int bid = book.getBid();
		if(StringUtils.isNotBlank(bname)) {
			sql += " and bname like '%"+bname+"%'";
		}
		if(bid != 0) {
			sql += " and bid = " + bid;
		}
		return super.executeQuery(sql, Book.class, pageBean);
	}
	
	public static void main(String[] args) throws Exception {
		Book book = new Book();
		book.setBid(23224);
//		book.setBname("23225");
//		book.setPrice(23225f);
		BookDao bookDao = new BookDao();
//		bookDao.add(book);
//		bookDao.edit(book);
		bookDao.delete(book);
	}
}