String BookName=jTextField7.getText();
   String Member_ID=jTextField1.getText();
   if(Member_ID.isEmpty())
        JOptionPane.showMessageDialog(this,"Please Enter Member ID.");
   try
        {
                Class.forName("java.sql.Driver");
    Connection con=(Connection)
            DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","12345");
    Statement stmt=(Statement) con.createStatement();
    String QUERY="SELECT NameOfBook FROM Record WHERE Member_ID='"+Member_ID+"';";
    ResultSet rs=stmt.executeQuery(QUERY);
    if(rs.getRow()==0)
    {String query="UPDATE Record SET NameOfBook='"+BookName+"' WHERE Member_ID='"+Member_ID+"';";
                    int RS=stmt.executeUpdate(query);

    String Query="SELECT NameOfBook2 FROM Record WHERE Member_ID='"+Member_ID+"';";
    ResultSet Rs=stmt.executeQuery(Query);
    String queryy="UPDATE Record SET NameOfBook='"+BookName+"' WHERE Member_ID='"+Member_ID+"';";
                    int RSS=stmt.executeUpdate(queryy);
    }
    else
    JOptionPane.showMessageDialog(this,"More books cannot be issued until the previous ones are returned.");

        }
            catch(Exception e)
             {
     JOptionPane.showMessageDialog(this,e.getMessage());
                    }