Alevsk JDBC States Example

DROP TABLE IF EXISTS `states`;

CREATE TABLE `states` (
  `id_state` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_state`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;


INSERT INTO `states` (`id_state`,`name`)
VALUES
    (1,'Aguascalientes'),
    (2,'Baja California'),
    (3,'Baja California Sur'),
    (4,'Campeche'),
    (5,'Chiapas'),
    (6,'Chihuahua'),
    (7,'Coahuila de Zaragoza'),
    (8,'Colima'),
    (9,'Distrito Federal'),
    (10,'Durango'),
    (11,'Guanajuato'),
    (12,'Guerrero'),
    (13,'Hidalgo'),
    (14,'Jalisco'),
    (15,'México'),
    (16,'Michoac√°n de Ocampo'),
    (17,'Morelos'),
    (18,'Nayarit'),
    (19,'Nuevo León'),
    (20,'Oaxaca'),
    (21,'Puebla'),
    (22,'Querétaro'),
    (23,'Quintana Roo'),
    (24,'San Luis Potosí'),
    (25,'Sinaloa'),
    (26,'Sonora'),
    (27,'Tabasco'),
    (28,'Tamaulipas'),
    (29,'Tlaxcala'),
    (30,'Veracruz de Ignacio de la Llave'),
    (31,'Yucat√°n'),
    (32,'Zacatecas');