about me

|search

JDBC in practice:
It is explained in detail as with Netbeans add the project  a Swing JFrame.

JDBC in practice:
It is explained in detail as with Netbeans you create a new project desktop GUI.

JDBC in practice:
Peek under the mask and all its components, is reported:
1. the type of graphical component
2. the name in the project
3. the programming code for the management of associated events.
 

4 Building Database
 

-- Versione MySQL: 5.0.26
-- Database: MyCustomers --

-- CREATE DATABASE `MyCustomers` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure `computers`
-- 

CREATE TABLE `computers` (
  `codArticle` varchar(5) NOT NULL,
  `description` varchar(50) default NULL,
  `price` float default NULL,
  PRIMARY KEY  (`codArticle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `computers` (`codArticle`, `description`, `price`) VALUES 
('KTB00', 'PC Tower IBM Intel', 850.5),
('KTB01', 'PC Dell AMD', 500),
('KTB02', 'Notebook Acer Aspire1510 ', 1500);

-- --------------------------------------------------------

₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪

8   Lesson3

Tools:                            
IDE : Netbeans5.5
Beans: Swing 
VisualEditor: Matisse
DB Server : MySql 5.0
Driver: com.mysql.jdbc.Driver
Database: MyCustomers
Tabelle: Customer
_____________________________

Target:
This lesson will build an application that loads data from table Customer of the 
database MyCustomers and displays them in a custom mask as Data Entry. 
Also performing searches on the data according to field Firstname and Zip 
by means of a filter. 
It is also managed the field photos type Blob. 
The application performs operations Edit, Cancellation and Inserting records.

₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪₪