dimanche 22 mars 2015

Add Search button into java CRUD web app

Please, help to add Search button into java CRUD web app. Search button is for searching user by name. Project made in Eclipse LUNA IDE. There's a lot of code, so I leave a link to the project: http://ift.tt/1HlFGAq


Script to populate the database:



DROP DATABASE IF EXISTS test;
CREATE DATABASE test DEFAULT CHARACTER SET `utf8`;
GRANT USAGE ON test.* TO `root`@`localhost` IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON test.* TO root@localhost;
FLUSH PRIVILEGES;
USE test;
CREATE TABLE `User` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
`age` int(11) DEFAULT NULL,
`admin` bit(1) NOT NULL DEFAULT TRUE,
`timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

insert into `User` (`name`, `age`, `admin`, `timestamp`)
values ('Mark Zuckerberg', '33', 1, '2008-01-01 00:00:01');
insert into `User` (`name`, `age`, `admin`, `timestamp`)
values ('Pavel Durov', '30', 0, '2009-01-01 00:00:01');




Aucun commentaire:

Enregistrer un commentaire