BCS Remove Hard Disk Content On DVD

Once files are safely stored on DVD they are no longer needed on the hard drive.  This utility searches the hard disk for file names matching on the DVD.  If a match is found the file on the hard drive is deleted.

dhd01

When the user clicks on the Check DVD option the following dialog appears.

dhd02

Select the hard drive directory to compare and the utility will delete all files which exists on the DVD.

A 32-bit executable program may be downloaded by clicking here.
A 64-bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Data Element Display Label

Each data element has an associated display label.  This application allows the user to update the display label.

dedn01

When the DED Data Entry option is selected the following dialog appears allowing the user to select an existing database and table.

dedn02

Simply double click on the desired data alias and table name to select it.  Once selected the following dialog will appear.

dedn03

The above dialog lists all the data element names for the selected alias and table.  To reveal the display label value simply click on the desired data element name.

dedn04

Simply key in the display label for the data element.  Exit the application by either selecting the exit option or clicking on the “X” in the application menu.

The database structure is listed below.

-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 19, 2016 at 10:17 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12
 
51&q=SET&lr=lang_en">SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
51&q=SET&lr=lang_en">SET time_zone = "+00:00";
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
 
--
-- Database: `de`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `dl`
--
 
51&q=CREATE&lr=lang_en">CREATE 51&q=TABLE&lr=lang_en">TABLE `dl` (
  `id` 51&q=INT&lr=lang_en">int(11) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL,
  `dna` 51&q=VARCHAR&lr=lang_en">varchar(75) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL,
  `lab` 51&q=VARCHAR&lr=lang_en">varchar(125) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL
) 51&q=ENGINE&lr=lang_en">ENGINE=51&q=INNODB&lr=lang_en">InnoDB 51&q=DEFAULT&lr=lang_en">DEFAULT 51&q=CHARSET&lr=lang_en">CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `dl`
--
51&q=ALTER&lr=lang_en">ALTER 51&q=TABLE&lr=lang_en">TABLE `dl`
  51&q=ADD&lr=lang_en">ADD 51&q=PRIMARY%20KEY&lr=lang_en">PRIMARY KEY (`id`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `dl`
--
51&q=ALTER&lr=lang_en">ALTER 51&q=TABLE&lr=lang_en">TABLE `dl`
  51&q=MODIFY&lr=lang_en">MODIFY `id` 51&q=INT&lr=lang_en">int(11) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL 51&q=AUTO_INCREMENT&lr=lang_en">AUTO_INCREMENT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

A 32-bit executable program may be downloaded by clicking here.
A 64-bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Eclipse Neon Data Tools Platform

It is desirable to have the Data Tools Platform available when using Eclipse Neon for the development of software. Make sure the Data Tools Platform is loaded and activated in Eclipse Neon. If the Data Tools Platform is not available use the standard Install New Software process to make it active.

To begin the Eclipse Neon installation process click on the Help option followed by the Install New Software Option.

nin01

Select All Available Sites when the dialog appears.  Traverse to the Database Development option and select it.

nin02

There may be a few prompts but simply select the defaults and the Data Tools Platform will be installed.  When prompted that Eclipse must be restarted before the updates will be applied select the Yes option and Eclipse will restart with the newly installed features available.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Java Swing Development

The current BCS Java development environment employs Eclipse Neon and the SwingBuilder plugin.

After the new java project was created click on the source folder and select New followed by the Other option until the SwingBuilder appears in the tree.

swb01

The following dialog appears and the FirstSwing name is keyed in the name field.

swb02

The SwingBuilder generated the code that appears below without coding a single line of code.

package swing;
 
import java.awt.EventQueue;
 
import javax.swing.JFrame;
import javax.swing.JTable;
import java.awt.BorderLayout;
 
public class FirstSwing {
 
	private JFrame frmFirstSwingApp;
 
	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					FirstSwing window = new FirstSwing();
					window.frmFirstSwingApp.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}
 
	/**
	 * Create the application.
	 */
	public FirstSwing() {
		initialize();
	}
 
	/**
	 * Initialize the contents of the frame.
	 */
	private void initialize() {
		frmFirstSwingApp = new JFrame();
		frmFirstSwingApp.setTitle("First Swing App");
		frmFirstSwingApp.setBounds(100, 100, 450, 300);
		frmFirstSwingApp.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
 
}

Below is a screen shot of the SwingBuilder designer.swb03

To understand the layouts used by the swing designer click here.

A 32-bit executable program may be downloaded by clicking here.
A 64-bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.