Guest User

Alevsk JDBC States Example

a guest
Sep 18th, 2011
158
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DROP TABLE IF EXISTS `states`;
  2.  
  3. CREATE TABLE `states` (
  4.   `id_state` int(11) NOT NULL AUTO_INCREMENT,
  5.   `name` varchar(45) DEFAULT NULL,
  6.   PRIMARY KEY (`id_state`)
  7. ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
  8.  
  9.  
  10. INSERT INTO `states` (`id_state`,`name`)
  11. VALUES
  12.     (1,'Aguascalientes'),
  13.     (2,'Baja California'),
  14.     (3,'Baja California Sur'),
  15.     (4,'Campeche'),
  16.     (5,'Chiapas'),
  17.     (6,'Chihuahua'),
  18.     (7,'Coahuila de Zaragoza'),
  19.     (8,'Colima'),
  20.     (9,'Distrito Federal'),
  21.     (10,'Durango'),
  22.     (11,'Guanajuato'),
  23.     (12,'Guerrero'),
  24.     (13,'Hidalgo'),
  25.     (14,'Jalisco'),
  26.     (15,'M√©xico'),
  27.     (16,'Michoac√°n de Ocampo'),
  28.     (17,'Morelos'),
  29.     (18,'Nayarit'),
  30.     (19,'Nuevo Le√≥n'),
  31.     (20,'Oaxaca'),
  32.     (21,'Puebla'),
  33.     (22,'Quer√©taro'),
  34.     (23,'Quintana Roo'),
  35.     (24,'San Luis Potos√≠'),
  36.     (25,'Sinaloa'),
  37.     (26,'Sonora'),
  38.     (27,'Tabasco'),
  39.     (28,'Tamaulipas'),
  40.     (29,'Tlaxcala'),
  41.     (30,'Veracruz de Ignacio de la Llave'),
  42.     (31,'Yucat√°n'),
  43.     (32,'Zacatecas');
RAW Paste Data