首页>代码>Spring+Spring MVC+Maven+bootstrap+mysql+JdbcTemplate图书馆后台管理系统>/book/src/main/java/com/book/dao/BookDao.java
package com.book.dao; import com.book.domain.Book; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; import org.springframework.stereotype.Repository; import java.math.BigDecimal; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; @Repository public class BookDao { private JdbcTemplate jdbcTemplate; @Autowired public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } private final static String ADD_BOOK_SQL="INSERT INTO book_info VALUES(NULL ,?,?,?,?,?,?,?,?,?,?,?)"; private final static String DELETE_BOOK_SQL="delete from book_info where book_id = ? "; private final static String EDIT_BOOK_SQL="update book_info set name= ? ,author= ? ,publish= ? ,ISBN= ? ,introduction= ? ,language= ? ,price= ? ,pubdate= ? ,class_id= ? ,pressmark= ? ,state= ? where book_id= ? ;"; private final static String QUERY_ALL_BOOKS_SQL="SELECT * FROM book_info "; private final static String QUERY_BOOK_SQL="SELECT * FROM book_info WHERE book_id like ? or name like ? "; //查询匹配图书的个数 private final static String MATCH_BOOK_SQL="SELECT count(*) FROM book_info WHERE book_id like ? or name like ? "; //根据书号查询图书 private final static String GET_BOOK_SQL="SELECT * FROM book_info where book_id = ? "; public int matchBook(String searchWord){ String swcx="%"+searchWord+"%"; return jdbcTemplate.queryForObject(MATCH_BOOK_SQL,new Object[]{swcx,swcx},Integer.class); } public ArrayList<Book> queryBook(String sw){ String swcx="%"+sw+"%"; final ArrayList<Book> books=new ArrayList<Book>(); jdbcTemplate.query(QUERY_BOOK_SQL, new Object[]{swcx,swcx}, new RowCallbackHandler() { public void processRow(ResultSet resultSet) throws SQLException { resultSet.beforeFirst(); while (resultSet.next()){ Book book =new Book(); book.setAuthor(resultSet.getString("author")); book.setBookId(resultSet.getLong("book_id")); book.setClassId(resultSet.getInt("class_id")); book.setIntroduction(resultSet.getString("introduction")); book.setIsbn(resultSet.getString("isbn")); book.setLanguage(resultSet.getString("language")); book.setName(resultSet.getString("name")); book.setPressmark(resultSet.getInt("pressmark")); book.setPubdate(resultSet.getDate("pubdate")); book.setPrice(resultSet.getBigDecimal("price")); book.setState(resultSet.getInt("state")); book.setPublish(resultSet.getString("publish")); books.add(book); } } }); return books; } public ArrayList<Book> getAllBooks(){ final ArrayList<Book> books=new ArrayList<Book>(); jdbcTemplate.query(QUERY_ALL_BOOKS_SQL, new RowCallbackHandler() { public void processRow(ResultSet resultSet) throws SQLException { resultSet.beforeFirst(); while (resultSet.next()){ Book book =new Book(); book.setPrice(resultSet.getBigDecimal("price")); book.setState(resultSet.getInt("state")); book.setPublish(resultSet.getString("publish")); book.setPubdate(resultSet.getDate("pubdate")); book.setName(resultSet.getString("name")); book.setIsbn(resultSet.getString("isbn")); book.setClassId(resultSet.getInt("class_id")); book.setBookId(resultSet.getLong("book_id")); book.setAuthor(resultSet.getString("author")); book.setIntroduction(resultSet.getString("introduction")); book.setPressmark(resultSet.getInt("pressmark")); book.setLanguage(resultSet.getString("language")); books.add(book); } } }); return books; } public int deleteBook(long bookId){ return jdbcTemplate.update(DELETE_BOOK_SQL,bookId); } public int addBook(Book book){ String name=book.getName(); String author=book.getAuthor(); String publish=book.getPublish(); String isbn=book.getIsbn(); String introduction=book.getIntroduction(); String language=book.getLanguage(); BigDecimal price=book.getPrice(); Date pubdate=book.getPubdate(); int classId=book.getClassId(); int pressmark=book.getPressmark(); int state=book.getState(); return jdbcTemplate.update(ADD_BOOK_SQL,new Object[]{name,author,publish,isbn,introduction,language,price,pubdate,classId,pressmark,state}); } public Book getBook(Long bookId){ final Book book =new Book(); jdbcTemplate.query(GET_BOOK_SQL, new Object[]{bookId}, new RowCallbackHandler() { public void processRow(ResultSet resultSet) throws SQLException { book.setAuthor(resultSet.getString("author")); book.setBookId(resultSet.getLong("book_id")); book.setClassId(resultSet.getInt("class_id")); book.setIntroduction(resultSet.getString("introduction")); book.setIsbn(resultSet.getString("isbn")); book.setLanguage(resultSet.getString("language")); book.setName(resultSet.getString("name")); book.setPressmark(resultSet.getInt("pressmark")); book.setPubdate(resultSet.getDate("pubdate")); book.setPrice(resultSet.getBigDecimal("price")); book.setState(resultSet.getInt("state")); book.setPublish(resultSet.getString("publish")); } }); return book; } public int editBook(Book book){ Long bookId=book.getBookId(); String name=book.getName(); String author=book.getAuthor(); String publish=book.getPublish(); String isbn=book.getIsbn(); String introduction=book.getIntroduction(); String language=book.getLanguage(); BigDecimal price=book.getPrice(); Date pubdate=book.getPubdate(); int classId=book.getClassId(); int pressmark=book.getPressmark(); int state=book.getState(); return jdbcTemplate.update(EDIT_BOOK_SQL,new Object[]{name,author,publish,isbn,introduction,language,price,pubdate,classId,pressmark,state,bookId}); } }
最近下载更多
1587039373 LV3
1月4日
小白jmhuang LV12
2023年12月6日
低调人 LV38
2022年12月16日
嗯啊哈尔滨西湖 LV1
2022年12月15日
微信网友_6248713511227392 LV11
2022年12月5日
1803466516 LV4
2022年7月9日
Simon_ydl LV5
2022年5月23日
2678465764 LV1
2022年5月6日
97987179 LV1
2022年4月9日
742773198 LV2
2022年3月18日
最近浏览更多
akittyboy LV9
4月16日
LisboyR
4月11日
暂无贡献等级
暂无贡献等级
黑 LV7
3月29日
1437047954
3月7日
暂无贡献等级
jhyan127
2月18日
暂无贡献等级
kkkllll LV2
1月23日
duoduo1234 LV2
1月15日
1587039373 LV3
1月4日
WBelong LV7
2023年12月25日