Search Room

Above UI we are going to create by AWT for Search Room in our Bank management system desktop application. For that first we create a window and configure its title, size and color. Here we are creating a window at Top Level so we can add this window at the top of any other window.

        
    JFrame frame = new JFrame("Search Room");
	Utils.centeredFrame(frame, winWidth, winHeight, "Search Room");
	frame.setResizable(false);
	Container mainContainer=frame.getContentPane();
	mainContainer.setBackground(Color.gray);

	int panelWid = winWidth-winWidth/20;
	int panelHig = winHeight-winHeight/10;

	JPanel panel = new JPanel();
	panel.setLayout(null);
	panel.setOpaque(false);
	panel.setBackground(Color.white);
	panel.setSize(new Dimension(winWidth-winWidth/20,winHeight-winHeight/10));
	panel.setLocation(winWidth/50,winHeight/40);
	mainContainer.add(panel,BorderLayout.CENTER);
    

After creation of window, we will add a canvas background.

    
    JComponent jcomponent=new Background(winWidth/50,winHeight/40,(winWidth-winWidth/20),winHeight-winHeight/10);// 
	mainContainer.add(jcomponent,BorderLayout.CENTER);
    

    public class Background extends JComponent {
	
		int width, height,setX,setY;

    	public Background (int setX,int setY,int width, int height) {
    		this.width=width;
    		this.height=height;
    		this.setX=setX;
    		this.setY=setY;
    	
       		setSize(width, height);
    	}
	
    	@Override
    	public void paint(Graphics g) {
        	Graphics2D g2 = (Graphics2D) g;

        	g2.setPaint(Color.white);

       

        	double x = setX;
        	double y = setY;
        	double w = width;
        	double h = height;
        	RoundRectangle2D round=new RoundRectangle2D.Double(x, y, w, h, 80, 80);
        	g2.fill(round);
        }    
	}

    

Once your window is created with custom background, we will add header.

    
    Font headingFont = new Font("Lucida",Font.BOLD,22);
	Font textFont = new Font("Lucida",0,10);
	Border borderline = BorderFactory.createLineBorder(Color.black);
	        
	        
	heading = new JLabel("Search Room");
	heading.setHorizontalAlignment(JLabel.CENTER);
	heading.setVerticalAlignment(JLabel.CENTER);
	heading.setBackground(Color.decode("#80c2b2"));
	heading.setForeground(Color.black);
	heading.setFont(headingFont);
	heading.setBounds(0,panelHig/30, panelWid, panelHig/15);
	        
	panel.add(heading);
	        
	        
	JSeparator jSeparator1 = new JSeparator();
	jSeparator1.setBackground(Color.black);
	jSeparator1.setAlignmentX(JSeparator.CENTER_ALIGNMENT);
	jSeparator1.setBounds(20, 80, winWidth-winWidth/12, panelHig/13);
	panel.add(jSeparator1);
    
    

Now create roompanel layout and add Search box and Room Table UI.

    
    TitledBorder roomTittle = BorderFactory.createTitledBorder(borderline);
	roomTittle.setTitleJustification(TitledBorder.LEFT);
	roomTittle.setTitleFont(textFont);
	roomTittle.setTitle("Search Room");
	roomTittle.setTitleColor(Color.black);

	roomPanel = new JPanel();
	roomPanel.setBounds(50,120, winWidth-winWidth/10,550);
	roomPanel.setLayout(null);
	roomPanel.setName("Search Room");
	roomPanel.setBorder(roomTittle);
	roomPanel.setBackground(Color.white);
	panel.add(roomPanel);
	        
	        
	headingFont = new Font("Lucida",Font.BOLD,16);
	JLabel searchLabel = new JLabel("Search Room");
	searchLabel.setAlignmentX(JLabel.LEFT);
	searchLabel.setForeground(Color.black);
	searchLabel.setFont(headingFont);
	searchLabel.setBounds(30,40, 150, 30);
	roomPanel.add(searchLabel);
		    
	ImageIcon backround_img = new ImageIcon("images/ic_search.png");
	Image img = backround_img.getImage();
	Image temp_img = img.getScaledInstance(20, 20, Image.SCALE_SMOOTH);
	backround_img = new ImageIcon(temp_img);
	JLabel background = new JLabel("", backround_img, JLabel.CENTER);
	background.setBounds(30,70, 20, 20);
	roomPanel.add(background);
		    
	JTextField roomSearch = new JTextField(15);
	roomSearch.setBackground(Color.decode("#FFFFFF"));
	roomSearch.setForeground(Color.black);
	roomSearch.setBounds(50,70, 200, 20);
	roomPanel.add(roomSearch);
		   
	roomSearch.getDocument().addDocumentListener(new DocumentListener() {
		@Override
		public void insertUpdate(DocumentEvent e) {
			search(roomSearch.getText());
		}
		@Override
		public void removeUpdate(DocumentEvent e) {
		    search(roomSearch.getText());
		}
		@Override
		public void changedUpdate(DocumentEvent e) {
			search(roomSearch.getText());
		}
		public void search(String str) {
			if (str.length() == 0) {
		        sorter.setRowFilter(null);
		    } else {
		        sorter.setRowFilter(RowFilter.regexFilter(str));
		    }
		}
	});
		    
     
	room_table();
		    
	panel.revalidate();
	panel.repaint();
    

Here is Room table .

    
    private void room_table() {		
			
		// TODO Auto-generated method stub
		String[] columnNames = {"Room No", "Price", "status", "Student Name", "Allotment Date"};
			
		DefaultTableModel model = new DefaultTableModel();
		sorter = new TableRowSorter<>(model);

	    model.setColumnIdentifiers(columnNames); 
			
		roomTable = new JTable();
		roomTable.setRowSorter(sorter);
		roomTable.setBounds(30,120, winWidth-winWidth/7, 400);
		
		roomPanel.add(roomTable);
		roomTable.setModel(model);

		JScrollPane scrollPane = new JScrollPane(roomTable);
		scrollPane.setBounds(30,120, winWidth-winWidth/7,400);
		roomTable.setFillsViewportHeight(true);
		roomPanel.add(scrollPane);
			
		DefaultTableCellRenderer centerRenderer = new DefaultTableCellRenderer();
		centerRenderer.setHorizontalAlignment( JLabel.CENTER );
		roomTable.getColumnModel().getColumn(0).setCellRenderer( centerRenderer );
		roomTable.getColumnModel().getColumn(1).setCellRenderer( centerRenderer );
		roomTable.getColumnModel().getColumn(2).setCellRenderer( centerRenderer );
		roomTable.getColumnModel().getColumn(3).setCellRenderer( centerRenderer );
		roomTable.getColumnModel().getColumn(4).setCellRenderer( centerRenderer );
			
		
		roomTable.getTableHeader().setFont(new Font("SansSerif", 1, 13));
		roomTable.getTableHeader().setBackground(Color.decode("#4287f5"));
		roomTable.getTableHeader().setForeground(Color.decode("#FFFFFF"));
			
		roomTable.getColumnModel().getColumn(0).setPreferredWidth(30);
		roomTable.getColumnModel().getColumn(1).setPreferredWidth(30);
		roomTable.getColumnModel().getColumn(4).setPreferredWidth(30);
		roomTable.setRowHeight(30);
	
			
		room_table_update();
		
	}
        

Here's the logic to fetch data from database and show in table.

    
	private void room_table_update() {		
			
		int CC;
		String room_no, std_id = null;
			
		Connection conn = SQLiteJDBCDriverConnection.connect1();
		try {
				
			PreparedStatement insert = conn.prepareStatement("select room_no, room_rent, status from room");
			ResultSet rs = insert.executeQuery();
				
				
			DefaultTableModel dft = (DefaultTableModel)roomTable.getModel();
			dft.setRowCount(0);
				
			while(rs.next()) {
				Vector v2 = new Vector();
					
				insert = conn.prepareStatement("SELECT alloted_to, allotment_date FROM room_alloted where room_number IS ?");
				insert.setString(1, rs.getString("room_no"));
				ResultSet rs3 = insert.executeQuery();
				
				v2.add(rs.getString("room_no"));
				v2.add(rs.getString("room_rent"));
				v2.add(rs.getString("status"));
					
					
				while(rs3.next()) {
						
					std_id = rs3.getString("alloted_to");
						
					insert = conn.prepareStatement("select student_name from student where student_id LIKE'%"+std_id+"%'");
					ResultSet rs0 = insert.executeQuery();
						
					while(rs0.next()) {
							v2.add(rs0.getString("student_name"));
					}
						
					v2.add(rs3.getString("allotment_date"));
						
				}
				
				dft.addRow(v2);
					
			}
				
			conn.close();
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
			
	}

Here is logic dashboard visibility.

	frame.getContentPane().setBackground(Color.gray);
	        
	frame.addWindowListener(new WindowAdapter(){  
	    public void windowClosing(WindowEvent e) {  
	        frame.dispose();
	        dashboardFrame.setVisible(true);
	    }  
	});  
			
	frame.setVisible(true);
	
	

At last we add logic to table rows change their position.

public void tableChanged(TableModelEvent e) {
	// TODO Auto-generated method stub
	int row = e.getFirstRow();
	int column = e.getColumn();
	TableModel model = (TableModel)e.getSource();
	String columnName = model.getColumnName(column);
	Object data = model.getValueAt(row, column);
	        

	System.out.println(columnName+data+"Wrong");
}