ReissuerBook.java

import java.time.LocalDate;

public class ReissuerBook implements Runnable{
    static String name;
    public static int ret;

    public ReissuerBook(String tname){
        name = tname;
        Thread t = new Thread(this);
        t.start();
    }
    @Override
    public void run() {
        reissueBook();
    }
    synchronized static void reissueBook(){
        try{
            Database_DAO.connect();
            java.sql.Date sqlDate = Database_DAO.getBookDueDate(name);
            LocalDate ld = sqlDate.toLocalDate();
            LocalDate cd = LocalDate.now();
            if(cd.isBefore(ld)) {
                String query = "UPDATE book SET issueno=2,duedate=adddate(current_date(),15) WHERE bname=? AND issueno=1";
                Database_DAO.pst = Database_DAO.con.prepareStatement(query);
                Database_DAO.pst.setString(1, name);
                ret = Database_DAO.pst.executeUpdate();
            }
            else ret = 0;
        }
        catch(Exception e){
            System.out.println(e.getMessage());
            ret = 0;
        }
    }

}