package com.book.dao.impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.book.dao.BaseDao;
import com.book.dao.DaoFactory;
import com.book.dao.IBookDao;
import com.book.entity.Book;
import com.book.entity.Borrow;
import com.book.util.DateUtils;
import com.mysql.cj.util.Util;
import cn.hutool.core.lang.Console;
public class BookDaoImpl extends BaseDao implements IBookDao {
public Book selectByISBN(String ISBN) {
Book m = new Book();
String sql = "select * from book a LEFT OUTER JOIN book_sort b ON a.`sort_id` = b.`sort_id` where ISBN = ?";
Object[] obj = { ISBN };
ResultSet rs = selectJDBC(sql, obj);
try {
while (rs.next()) {
m.setISBN(rs.getString("iSBN"));
m.setBook_author(rs.getString("book_author"));
m.setBook_name(rs.getString("book_name"));
m.setBook_borrow(rs.getInt("book_borrow"));
m.setBook_price(rs.getBigDecimal("book_price"));
m.setBook_pub(rs.getString("book_pub"));
m.setBook_record(rs.getString("book_record"));
m.setSort_id(rs.getInt("sort_id"));
m.setSort_name(rs.getString("sort_name"));
}
return m;
} catch (Exception e) {
e.printStackTrace();
return null;
} finally {
closeJDBC();
}
}
public List<Book> selectByName(String name) {
List<Book> lists = new ArrayList<Book>();
String sql = "select * from book a LEFT OUTER JOIN book_sort b ON a.`sort_id` = b.`sort_id` where book_name like \"%\"?\"%\"";
Object[] obj = { name };
ResultSet rs = selectJDBC(sql, obj);
try {
while (rs.next()) {
Book m = new Book();
m.setISBN(rs.getString("iSBN"));
m.setBook_author(rs.getString("book_author"));
m.setBook_name(rs.getString("book_name"));
m.setBook_borrow(rs.getInt("book_borrow"));
m.setBook_price(rs.getBigDecimal("book_price"));
m.setBook_pub(rs.getString("book_pub"));
m.setBook_record(rs.getString("book_record"));
m.setSort_id(rs.getInt("sort_id"));
m.setSort_name(rs.getString("sort_name"));
lists.add(m);
}
return lists;
} catch (Exception e) {
e.printStackTrace();
return null;
} finally {
closeJDBC();
}
}
public boolean checkIsExist(String id) {
String sql = "select ISBN from book where ISBN = ?";
Object[] obj = { id };
ResultSet rs = selectJDBC(sql, obj);
try {
if (rs.next()) {
return true;
} else {
return false;
}
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
closeJDBC();
}
}
public int insert(Book m) {
boolean result = checkIsExist(m.getISBN());
if (result) {
return -1;
}
String sql = "insert into book (ISBN, book_name, book_author, book_pub, book_borrow, sort_id, book_record, book_price) values (?,?,?,?,?,?,?,?)";
Object[] obj = { m.getISBN(), m.getBook_name(), m.getBook_author(), m.getBook_pub(), m.getBook_borrow(),
m.getSort_id(), m.getBook_record(), m.getBook_price() };
int lines = updateJDBC(sql, obj);
if (lines > 0) {
closeJDBC();
return 1;
}
closeJDBC();
return 0;
}
public int update(Book m, String ISBN) {
String sql = "update book set ISBN = ?, book_name = ?, book_author = ?, book_pub = ?, book_borrow = ?, sort_id = ?, book_record = ?, book_price = ? where ISBN = ?";
Object[] obj = { m.getISBN(), m.getBook_name(), m.getBook_author(), m.getBook_pub(), m.getBook_borrow(),
m.getSort_id(), m.getBook_record(), m.getBook_price(), ISBN };
int lines = updateJDBC(sql, obj);
if (lines > 0) {
return 1;
}
return 0;
}
public List<Book> selectList() {
List<Book> lists = new ArrayList<Book>();
// String sql = "select * from book";
// 左外连接查询
String sql = "SELECT * FROM book a LEFT OUTER JOIN book_sort b ON a.`sort_id` = b.`sort_id`";
Object[] obj = {};
ResultSet rs = selectJDBC(sql, obj);
try {
while (rs.next()) {
Book m = new Book();
m.setISBN(rs.getString("ISBN"));
m.setBook_author(rs.getString("book_author"));
m.setBook_name(rs.getString("book_name"));
m.setBook_borrow(rs.getInt("book_borrow"));
m.setBook_price(rs.getBigDecimal("book_price"));
m.setBook_pub(rs.getString("book_pub"));
m.setBook_record(rs.getString("book_record"));
m.setSort_id(rs.getInt("sort_id"));
m.setSort_name(rs.getString("sort_name"));
lists.add(m);
}
return lists;
} catch (SQLException e) {
e.printStackTrace();
return null;
} finally {
closeJDBC();
}
}
public int deleteByISBN(String ISBN) {
String sql = "delete from book where ISBN = ?";
Object[] obj = { ISBN };
int lines = updateJDBC(sql, obj);
if (lines > 0) {
closeJDBC();
return 1;
}
closeJDBC();
return 0;
}
/**
* 借阅操作，修改book的book_borrow的值，0为可借阅，1为已借阅，另外在借阅表添加借阅书籍的数据
*
* @param ISBN
* 书唯一编号
* @param s_id
* 借阅人编号
* @param borrow_date
* 借阅日期（一般为当天）
* @param expect_return_date
* 归还日期
* @return
*/
public boolean updateBookStatus(String ISBN, String s_id, String borrow_date, String expect_return_date) {
Book m = new Book();
String sql = "select * from book where ISBN = ?";
Object[] obj = { ISBN };
ResultSet rs = selectJDBC(sql, obj);
try {
while (rs.next()) {
m.setISBN(rs.getString("iSBN"));
m.setBook_author(rs.getString("book_author"));
m.setBook_name(rs.getString("book_name"));
if (rs.getInt("book_borrow") != 0) {
return false;
}
m.setBook_borrow(1);
m.setBook_price(rs.getBigDecimal("book_price"));
m.setBook_pub(rs.getString("book_pub"));
m.setBook_record(rs.getString("book_record"));
m.setSort_id(rs.getInt("sort_id"));
}
int result = update(m, ISBN);
if (result == 0) {
System.out.println("==图书更新状态失败");
return false;
}
// 在借阅表中添加数据
Borrow borrow = new Borrow();
borrow.setBook_borrow(m.getBook_borrow());
borrow.setBook_name(m.getBook_name());
borrow.setBorrow_date(borrow_date);
borrow.setExpect_return_date(expect_return_date); // 预计归还日期由用户设置
borrow.setISBN(m.getISBN());
borrow.setPrice(m.getBook_price());
borrow.setReturn_date(expect_return_date); // 当归还时才设置日期
borrow.setS_id(s_id);
result = DaoFactory.getIBorrowDaoInstance().insert(borrow);
if (result == 0) {
System.out.println("==借阅插入数据失败");
return false;
}
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
closeJDBC();
}
}
/**
* 归还操作
*/
public boolean returnBookStatus(String ISBN, String return_date) {
Book m = new Book();
String sql = "select * from book where ISBN = ?";
Object[] obj = { ISBN };
ResultSet rs = selectJDBC(sql, obj);
try {
while (rs.next()) {
m.setISBN(rs.getString("iSBN"));
m.setBook_author(rs.getString("book_author"));
m.setBook_name(rs.getString("book_name"));
if (rs.getInt("book_borrow") != 1) {
return false;
}
m.setBook_borrow(0);
m.setBook_price(rs.getBigDecimal("book_price"));
m.setBook_pub(rs.getString("book_pub"));
m.setBook_record(rs.getString("book_record"));
m.setSort_id(rs.getInt("sort_id"));
}
int result = update(m, ISBN);
if (result == 0) {
System.out.println("==图书更新状态失败");
return false;
}
// 在借阅表中修改数据
Borrow borrow = new Borrow();
borrow.setISBN(m.getISBN());
borrow.setBook_borrow(2); //借阅表中2为已归还
borrow.setReturn_date(return_date); // 当归还时才设置日期
result = DaoFactory.getIBorrowDaoInstance().update_returnbook(borrow);
if (result == 0) {
System.out.println("==借阅修改数据失败");
return false;
}
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
closeJDBC();
}
}
}
基于JSP+Servlet+JDBC+mysql的图书管理系统源码(课程设计).zip
版权申诉
180 浏览量
2023-07-25
15:52:02
上传
评论
收藏 15.62MB ZIP 举报
基于JSP+Servlet+JDBC+mysql的图书管理系统源码(课程设计).zip （312个子文件） 
$PRODUCT_WORKSPACE_FILE$ 489B BookDaoImpl.class 8KB BookDaoImpl.class 8KB BookDaoImpl.class 8KB BookDaoImpl.class 8KB BorrowDaoImpl.class 5KB BorrowDaoImpl.class 5KB BorrowDaoImpl.class 5KB BorrowDaoImpl.class 5KB StudentDaoImpl.class 5KB StudentDaoImpl.class 5KB StudentDaoImpl.class 5KB StudentDaoImpl.class 5KB ManagerDaoImpl.class 4KB ManagerDaoImpl.class 4KB ManagerDaoImpl.class 4KB ManagerDaoImpl.class 4KB BookSortDaoImpl.class 4KB BookSortDaoImpl.class 4KB BookSortDaoImpl.class 4KB EditBookServlet.class 3KB EditBookServlet.class 3KB EditBookServlet.class 3KB AddBookServlet.class 3KB AddBookServlet.class 3KB AddBookServlet.class 3KB StudentRegisterServlet.class 3KB StudentRegisterServlet.class 3KB StudentRegisterServlet.class 3KB ManagerRegisterServlet.class 3KB ManagerRegisterServlet.class 3KB ManagerRegisterServlet.class 3KB BaseDao.class 2KB BaseDao.class 2KB BaseDao.class 2KB BaseDao.class 2KB StudentLoginServlet.class 2KB StudentLoginServlet.class 2KB StudentLoginServlet.class 2KB ManagerLoginServlet.class 2KB ManagerLoginServlet.class 2KB ManagerLoginServlet.class 2KB BorrowBookServlet.class 2KB AddBookSortServlet.class 2KB AddBookSortServlet.class 2KB AddBookSortServlet.class 2KB Book.class 2KB Book.class 2KB Book.class 2KB Book.class 2KB Borrow.class 2KB Borrow.class 2KB Borrow.class 2KB Borrow.class 2KB BorrowBookServlet.class 2KB BorrowBookServlet.class 2KB Student.class 2KB Student.class 2KB Student.class 2KB Student.class 2KB ReturnBookServlet.class 2KB ReturnBookServlet.class 2KB ReturnBookServlet.class 2KB QueryBorrowByIdServlet.class 2KB QueryBorrowByIdServlet.class 2KB QueryBorrowByIdServlet.class 2KB QueryBookByNameServlet.class 2KB QueryBookByNameServlet.class 2KB QueryBookByNameServlet.class 2KB QueryBorrowByISBNServlet.class 2KB QueryBorrowByISBNServlet.class 2KB QueryBorrowByISBNServlet.class 2KB QueryBookByISBNServlet.class 2KB QueryBookByISBNServlet.class 2KB QueryBookByISBNServlet.class 2KB DeleteBookServlet.class 2KB DeleteBookServlet.class 2KB DeleteBookServlet.class 2KB BookServiceImpl.class 2KB BookServiceImpl.class 2KB BookServiceImpl.class 2KB BookServiceImpl.class 2KB ManagerServiceImpl.class 2KB ManagerServiceImpl.class 2KB ManagerServiceImpl.class 2KB ManagerServiceImpl.class 2KB StudentServiceImpl.class 2KB StudentServiceImpl.class 2KB StudentServiceImpl.class 2KB StudentServiceImpl.class 2KB BookSortServlet.class 2KB BookSortServlet.class 2KB BookSortServlet.class 2KB ServiceFactory.class 2KB ServiceFactory.class 2KB ServiceFactory.class 2KB ServiceFactory.class 2KB BorrowServlet.class 2KB BorrowServlet.class 2KB BorrowServlet.class 2KB共 312 条
- 1
- 2
- 3
- 4
资源评论
