You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
80 lines
3.3 KiB
80 lines
3.3 KiB
package Controller;
|
|
|
|
import java.sql.SQLException;
|
|
import java.util.Vector;
|
|
|
|
import Model.access.BorrowAccess;
|
|
import Tool.TimeTool;
|
|
|
|
/**
|
|
* 借阅归还表的控制器
|
|
* @author rsw
|
|
*
|
|
*/
|
|
public class BorrowCon {
|
|
BorrowAccess borrowdao = new BorrowAccess();
|
|
|
|
public boolean insertBorrow(String number, int b_name, int borrowdate, int duedate,int b_id) throws SQLException {
|
|
return borrowdao.insertBorrow(number, b_name, borrowdate, duedate,b_id);
|
|
}
|
|
|
|
/**
|
|
* 查询借阅信息
|
|
*/
|
|
public Object[][] queryBorrowInfo(String number1, String number2, boolean isreturn) throws SQLException {
|
|
Object[][] borrowData = new Object[borrowdao.queryBorrowInfo(number1, number2, isreturn).size()][8];
|
|
for (int i = 0; i < borrowData.length; i++) {
|
|
borrowData[i][0] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(0);
|
|
borrowData[i][1] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(1);
|
|
borrowData[i][2] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(2);
|
|
borrowData[i][3] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(3);
|
|
borrowData[i][4] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(4);
|
|
borrowData[i][5] = TimeTool.stampToDate(
|
|
borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(5).toString());
|
|
borrowData[i][6] = TimeTool.stampToDate(
|
|
borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(6).toString());
|
|
|
|
}
|
|
return borrowData;
|
|
}
|
|
/**
|
|
* 获取实际归还时间
|
|
*/
|
|
public Object[][] queryBorrowReturnDate(String number1, String number2, boolean isreturn) throws SQLException {
|
|
Object[][] borrowData = new Object[borrowdao.queryBorrowInfo(number1, number2, isreturn).size()][8];
|
|
for (int i = 0; i < borrowData.length; i++) {
|
|
borrowData[i][0] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(0);
|
|
borrowData[i][1] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(1);
|
|
borrowData[i][2] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(2);
|
|
borrowData[i][3] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(3);
|
|
borrowData[i][4] = borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(4);
|
|
borrowData[i][5] = TimeTool.stampToDate(
|
|
borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(5).toString());
|
|
borrowData[i][6] = TimeTool.stampToDate(
|
|
borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(6).toString());
|
|
borrowData[i][7] = TimeTool.stampToDate(
|
|
borrowdao.queryBorrowInfo(number1, number2, isreturn).elementAt(i).elementAt(7).toString());
|
|
}
|
|
return borrowData;
|
|
}
|
|
/**
|
|
* 图书归还
|
|
*/
|
|
public boolean returnBorrow(int returndate,int borrow_id,int b_id) throws SQLException {
|
|
return borrowdao.returnBorrow(returndate,borrow_id,b_id);
|
|
}
|
|
/**
|
|
* 查询此书是否被借阅
|
|
* @throws SQLException
|
|
*/
|
|
public boolean queryExistBook(int borrow_b_id) throws SQLException {
|
|
return borrowdao.queryExistBook(borrow_b_id);
|
|
}
|
|
/**
|
|
* 查询此书是否被借阅
|
|
*/
|
|
public boolean queryIsBorrowBook(int borrow_b_id,String count)throws SQLException {
|
|
return borrowdao.queryIsBorrowBook(borrow_b_id, count);
|
|
}
|
|
}
|