Java程序实例 包括Java各知识点的实例

-- Table "gods" DDL CREATE TABLE gods ( sizes varchar(28) DEFAULT NULL, offers varchar(22) DEFAULT NULL, depict varchar(22) DEFAULT NULL, type varchar(22) DEFAULT NULL, price double(10,0) DEFAULT NULL, name varchar(100) DEFAULT NULL, id int(10) NOT NULL AUTO_INCREMENT, size varchar(12) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- Table "staff" DDL CREATE TABLE staff ( wage varchar(30) DEFAULT NULL, worklen varchar(30) DEFAULT NULL, depart varchar(100) DEFAULT NULL, address varchar(500) DEFAULT NULL, sex varchar(4) DEFAULT NULL, age int(4) DEFAULT NULL, name varchar(55) DEFAULT NULL, id int(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- Table "userMess" DDL CREATE TABLE usermess ( phone varchar(50) DEFAULT NULL, email varchar(100) DEFAULT NULL, address varchar(200) DEFAULT NULL, sex varchar(4) DEFAULT NULL, compass varchar(20) DEFAULT NULL, nich varchar(30) DEFAULT NULL, password varchar(30) DEFAULT NULL, name varchar(100) DEFAULT NULL, id int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- Table "image" DDL CREATE TABLE image ( url varchar(256) DEFAULT NULL, name varchar(100) DEFAULT NULL, id int(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;