数据库

10 数据库编程.pptx
file1.txt
mysql-connector-java-5.1.46.jar
t2_1.javat3.javat1.javat2.java

CREATE TABLE `websites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(20) NOT NULL DEFAULT '' COMMENT '站点名称',
  `url` varchar(255) NOT NULL DEFAULT '',
  `alexa` int(11) NOT NULL DEFAULT '0' COMMENT 'Alexa 排名',
  `country` char(10) NOT NULL DEFAULT '' COMMENT '国家',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

INSERT INTO `websites` VALUES ('1', 'Google', 'Google Company', '1', 'USA'), ('2', '淘宝', 'Taobao', '13', 'CN'), ('3', 'baidu', 'Baidu Company', '5892', ''), ('4', 'WeiBo', 'Sina Company', '20', 'CN'), ('5', 'Facebook', 'FACEBOOK', '3', 'USA');