MySQL_FilteredRowSet1

Complete code : MySQL_FilteredRowSet1.txt

Create Table:

CREATE TABLE `mysqlvisitor1b` (
`idVIB` int(3) NOT NULL,
`fname` varchar(30) DEFAULT NULL,
`lname` varchar(30) DEFAULT NULL,
`age` int(2) NOT NULL,
PRIMARY KEY (`idVIB`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Insert Data :

INSERT INTO `test`.`mysqlvisitor1b`
(`idVIB`,`fname`,`lname`,`age`)VALUES (<{idVIB: }>,<{fname: }>,
<{lname: }>,<{age: }>);

Salient Code snippets: Connection to db suing driver manager

Printing coulmn names,unfiltered and filtered data

Filter :: class Age filter implementing Predicate

rest of the class AgeFilter:

Output: Filtering age: AgeFilter filter = new AgeFilter(30, 41, 4); where range was 30-41years at column index 4