public LibrarianScreen() {
		
		@SuppressWarnings("serial")
		final DefaultTableModel model = new DefaultTableModel(){
			
			 public boolean isCellEditable(int row, int column){
				 return false;
			 }
			      
			};
		setResizable(false);
		setTitle("Library");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 812, 553);
		contentPane = new JPanel();
		contentPane.setBackground(Color.WHITE);
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);

		JLabel lblHeader = new JLabel("");
		lblHeader.setIcon(new ImageIcon(HomeWindow.class
				.getResource("/images/header.png")));
		lblHeader.setBounds(0, 0, 796, 60);
		contentPane.add(lblHeader);

		JPanel pnlSeparator = new JPanel();
		pnlSeparator.setBackground(new Color(65, 105, 225));
		pnlSeparator.setBounds(0, 60, 796, 19);
		contentPane.add(pnlSeparator);

		JPanel pnlHeader = new JPanel();
		pnlHeader.setBounds(0, 0, 394, 80);
		contentPane.add(pnlHeader);

		JLabel lblTitle = new JLabel("Title : ");
		lblTitle.setBounds(47, 172, 46, 14);
		contentPane.add(lblTitle);

		JLabel lblAuthor = new JLabel("Author : ");
		lblAuthor.setBounds(47, 204, 46, 14);
		contentPane.add(lblAuthor);

		JLabel lblGenre = new JLabel("Genre :");
		lblGenre.setBounds(47, 241, 46, 14);
		contentPane.add(lblGenre);

		JLabel lblPublisher = new JLabel("Publisher :");
		lblPublisher.setBounds(47, 266, 68, 14);
		contentPane.add(lblPublisher);

		JLabel lblYear = new JLabel("Year :");
		lblYear.setBounds(47, 291, 46, 14);
		contentPane.add(lblYear);

		JLabel lblDescription = new JLabel("Description :");
		lblDescription.setBounds(47, 328, 68, 14);
		contentPane.add(lblDescription);

		JLabel lblImage = new JLabel("Image :");
		lblImage.setBounds(47, 414, 46, 14);
		contentPane.add(lblImage);

		txtFldTitle = new JTextField();
		txtFldTitle.setBounds(137, 168, 206, 23);
		contentPane.add(txtFldTitle);
		txtFldTitle.setColumns(10);

		txtFldAuthor = new JTextField();
		txtFldAuthor.setBounds(137, 200, 206, 23);
		contentPane.add(txtFldAuthor);
		txtFldAuthor.setColumns(10);

		txtFldGenre = new JTextField();
		txtFldGenre.setBounds(137, 234, 206, 23);
		contentPane.add(txtFldGenre);
		txtFldGenre.setColumns(10);

		txtFldPublisher = new JTextField();
		txtFldPublisher.setBounds(137, 259, 206, 23);
		contentPane.add(txtFldPublisher);
		txtFldPublisher.setColumns(10);

		txtFldYear = new JTextField();
		txtFldYear.setBounds(137, 287, 206, 23);
		contentPane.add(txtFldYear);
		txtFldYear.setColumns(10);

		txtFldDesc = new JTextField();
		txtFldDesc.setBounds(137, 328, 206, 73);
		contentPane.add(txtFldDesc);
		txtFldDesc.setColumns(10);

		JButton btnViewMemberDetails = new JButton("View Member Details");
		btnViewMemberDetails.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				ViewMembers frame = new ViewMembers();
				frame.setVisible(true);
			}
		});
		btnViewMemberDetails.setBounds(10, 90, 166, 23);
		contentPane.add(btnViewMemberDetails);

		JButton btnOverdueLoans = new JButton("View Overdue Loans");
		btnOverdueLoans.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				OverdueLoans overdueLoans = new OverdueLoans();
				overdueLoans.setVisible(true);
			}
		});
		btnOverdueLoans.setBounds(210, 90, 166, 23);
		contentPane.add(btnOverdueLoans);

		JButton btnRemoveBook = new JButton("Remove Book");
		btnRemoveBook.setBounds(627, 474, 133, 23);
		contentPane.add(btnRemoveBook);

		JButton btnAddBook = new JButton("Add Book");
		btnAddBook.setBounds(137, 490, 133, 23);
		contentPane.add(btnAddBook);

		btnAddBook.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				Database data = new Database();
				//local variables
				int isbn = 0;
				int quantity = 0;
				try{
					//parse values from text fields
					isbn = Integer.parseInt(txtISBN.getText());
					quantity = Integer.parseInt(txtQuantity.getText());
						//add book to the database
						data.addBook(isbn, txtFldAuthor.getText(),
								txtFldTitle.getText(), txtFldYear.getText(),
								txtFldDesc.getText(),
								txtFldPublisher.getText(),
								txtFldGenre.getText(), txtImg.getText(), quantity);
						
						resetTextFields();
						
						
				}
				catch (Exception x) {
					JOptionPane.showMessageDialog(null, "Fields Must Contain Correct Data");
					
					x.printStackTrace();
				}

			}
		});
		
		//**************************************************************************************************//
		btnRemoveBook.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
	
					Database data = new Database();
			
						if(table.getSelectedRow()> -1){
							row = table.getSelectedRow();
							int col=0;
							Object isbn = table.getValueAt(row, col);
							int isbn2 = (Integer) isbn;
							int n;
							try {
								n = JOptionPane.showConfirmDialog(null, "Removing Book: "+data.getBookByISBN(isbn2).getTitle(), "Confirmation", JOptionPane.YES_NO_OPTION);
								if(n ==JOptionPane.YES_OPTION){
									data.removeBook(isbn2);
									model.fireTableDataChanged();
									model.setRowCount(0);
									data.populateTable(model);
									
								}
							} 
							catch (HeadlessException | SQLException x) {
								// TODO Auto-generated catch block
								x.printStackTrace();
							}
							
				
					}
						
				
				}
		});
		//***************************************************REMOVE END**********************************************//

		JButton btnFile = new JButton("Open File");
		btnFile.setBounds(140, 412, 100, 20);
		contentPane.add(btnFile);
		btnFile.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				JFileChooser fc = new JFileChooser();
				//Database data = new Database();
				
				int returnVal = fc.showOpenDialog(LibrarianScreen.this);
				if(returnVal == JFileChooser.APPROVE_OPTION){
					txtImg.setText( fc.getSelectedFile().getName());
				}
			}
		});

		JLabel lblIsbn = new JLabel("ISBN:");
		lblIsbn.setBounds(47, 141, 46, 14);
		contentPane.add(lblIsbn);

		txtISBN = new JTextField();
		txtISBN.setColumns(10);
		txtISBN.setBounds(137, 137, 206, 23);
		contentPane.add(txtISBN);

		JLabel lblQuantity = new JLabel("Quantity");
		lblQuantity.setBounds(47, 446, 46, 14);
		contentPane.add(lblQuantity);
		
		txtImg = new JTextField();
		txtImg.setColumns(10);
		txtImg.setBounds(243,412, 100, 20);
		contentPane.add(txtImg);
		
		txtQuantity = new JTextField();
		txtQuantity.setColumns(10);
		txtQuantity.setBounds(137, 443, 206, 20);
		contentPane.add(txtQuantity);
		
		JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBounds(386, 145, 374, 318);
		contentPane.add(scrollPane);
		
		table = new JTable();
		scrollPane.setViewportView(table);
		
		txtSearch = new JTextField();
		txtSearch.setBounds(386, 103, 273, 20);
		contentPane.add(txtSearch);
		txtSearch.setColumns(10);
		
		JButton btnSearch = new JButton("Search");
		btnSearch.setBounds(669, 102, 89, 23);
		contentPane.add(btnSearch);
		btnSearch.addActionListener(new ActionListener() {
			
			public void actionPerformed(ActionEvent e) {
				Database test = new Database();
				model.setRowCount(0);
				//String value = txtSearch.toString();
				
					try {	
						test.searchBooks(txtSearch.getText(), model);
					}
					catch (SQLException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					}
					if(txtSearch.getText().equals("")){
						try {
							model.setRowCount(0);
							test.populateTable(model);
						} catch (SQLException e1) {
							// TODO Auto-generated catch block
							e1.printStackTrace();
							
						}
						JOptionPane.showMessageDialog(null, "Please Enter Value");
						
					}
			}
		});
		
		Database test = new Database();
		model.addColumn("ISBN");
		model.addColumn("Author");
		model.addColumn("Title");
		model.addColumn("Quantity");
		try{
			test.populateTable(model);
			
		}
		catch(Exception e){
			
		}
		
		
		table = new JTable(model);
		table.setModel(model);
		
		table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		scrollPane.setViewportView(table);
		
		
		
		

	}