package database;

import java.sql.Connection;

import java.sql.Date;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Arrays;

import java.util.Vector;

import javax.swing.JOptionPane;

public class BorrowRecords {

public BorrowRecords() {

}

//借阅图书

public static void Borrow(String user, int bookid, String bookname) {

Connection con = ConnectDatabase.connectDB();

PreparedStatement preSql;

String sqlStr = "insert into borrowrecords(user,bookid,bookname,borrowtime,returntime,status) values (?,?,?,now(),null,?)";

try {

preSql = con.prepareStatement(sqlStr);

preSql.setString(1, user);

preSql.setInt(2, bookid);

preSql.setString(3, bookname);

preSql.setString(4, "未还");

int ok = preSql.executeUpdate();

con.close();

ChangeBorrowState(bookid);

} catch (SQLException e) {

}

}

//借阅图书修改图书状态

private static void ChangeBorrowState(int bookid) {

Connection con = ConnectDatabase.connectDB();

PreparedStatement preSql;

String sqlStr = "update booktable set state=? where bookid = ?";

try {

preSql = con.prepareStatement(sqlStr);

preSql.setString(1, "外借");

preSql.setInt(2, bookid);

int ok = preSql.executeUpdate();

con.close();

} catch (SQLException e) {

}

}

//还书

public static void Return(String user, int bookid) {

Connection con = ConnectDatabase.connectDB();

PreparedStatement preSql;

String sqlStr = "select now()";

ResultSet rs;

Date date=null;

try {

preSql = con.prepareStatement(sqlStr);

rs = preSql.executeQuery();

while(rs.next()) {

date = rs.getDate(1);

}

sqlStr = "update borrowrecords set returntime = ? where bookid = ? and user = ? and status = ?";

preSql = con.prepareStatement(sqlStr);

preSql.setDate(1, date);

preSql.setInt(2, bookid);

preSql.setString(3, user);

preSql.setString(4, "未还");

int ok = preSql.executeUpdate();

sqlStr = "update borrowrecords set status = ? where bookid = ? and user = ? and status = ?";

preSql = con.prepareStatement(sqlStr);

preSql.setString(1, "已还");

preSql.setInt(2, bookid);

preSql.setString(3, user);

preSql.setString(4, "未还");

ok = preSql.executeUpdate();

con.close();

ChangeReturnState(bookid);

} catch (SQLException e) {

}

}

//还书图书修改图书状态

private static void ChangeReturnState(int bookid) {

Connection con = ConnectDatabase.connectDB();

PreparedStatement preSql;

String sqlStr = "update booktable set state=? where bookid = ?";

try {

preSql = con.prepareStatement(sqlStr);

preSql.setString(1, "在馆");

preSql.setInt(2, bookid);

int ok = preSql.executeUpdate();

con.close();

} catch (SQLException e) {

}

}

//比对还书

public static boolean comparison(String user,int bookid) {

Connection con = ConnectDatabase.connectDB();

PreparedStatement preSql;

ResultSet rs;

String sqlStr = "select * from borrowrecords where bookid = ? and status = ?";

try {

preSql = con.prepareStatement(sqlStr);

preSql.setInt(1, bookid);

preSql.setString(2, "未还");

rs = preSql.executeQuery();

while (rs.next()) {

String user2 = rs.getString(2);

if(user2.equals(user)) {

return true;

}else {

return false;

}

}

con.close();

return false;

} catch (SQLException e) {

return false;

}

}

}