jsp課程設(shè)計(jì)(數(shù)據(jù)庫(kù)添刪改查)畢業(yè)論文-wenkub
2023-07-09 18:50:40 本頁(yè)面
【正文】 `Id` int(11) NOT NULL auto_increment, `login_name` varchar(45) collate gb2312_bin default NULL, `login_pwd` varchar(45) collate gb2312_bin default NULL, PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin。CREATE TABLE `use9_config` ( `Id` int(11) NOT NULL auto_increment, `web_name` varchar(45) default NULL, `web_link` varchar(45) default NULL, `web_logo` varchar(45) default NULL, `web_banner` varchar(45) default NULL, `web_right` varchar(255) default NULL, `web_keyword` varchar(255) NOT NULL, `web_page` int(10) unsigned NOT NULL, `web_ename` varchar(45) NOT NULL, `web_title` varchar(45) NOT NULL, `web_etitle` varchar(45) NOT NULL, `web_owner` varchar(45) NOT NULL, `web_qq` varchar(45) NOT NULL, `web_` varchar(45) NOT NULL, PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312。CREATE TABLE `use9_job` ( `Id` int(11) NOT NULL auto_increment, `person` varchar(45) default NULL, `number` int(11) default NULL, `work_where` varchar(255) default NULL, `pay` varchar(45) default NULL, `times` varchar(45) default NULL, `day_limit` int(11) default NULL, `job_require` longtext, PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312。CREATE TABLE `use9_news` ( `Id` int(11) NOT NULL auto_increment, `title` varchar(45) default NULL, `content` longtext, `index_pic` varchar(45) default NULL, `author` varchar(45) default NULL, `reco` int(11) default NULL, `times` varchar(45) default NULL, `mark_id` int(11) default NULL, PRIMARY KEY (`Id`), KEY `FK_use9_news_1` (`mark_id`), CONSTRAINT `FK_use9_news_1` FOREIGN KEY (`mark_id`) REFERENCES `use9_newtype` (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312。CREATE TABLE `use9_object` ( `Id` int(11) NOT NULL auto_increment, `name` varchar(45) default NULL, `introduce` longtext, `pic` varchar(45) default NULL, `mark_id` int(11) default NULL, PRIMARY KEY (`Id`), KEY `FK_use9_object_1` (`mark_id`), CONSTRAINT `FK_use9_object_1` FOREIGN KEY (`mark_id`) REFERENCES `use9_objecttype` (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312。CREATE TABLE `use9_product` ( `Id` int(11) NOT NULL auto_increment, `name` varchar(45) default NULL, `xinghao` varchar(45) default NULL, `charge` int(11) default NULL, `discount` int(11) default NULL, `havenum` int(11) default NULL, `reco` int(11) default NULL, `pic` varchar(45) default NULL, `small_pic` varchar(45) default NULL, `content` longtext, `mark_id` int(11) default NULL, PRIMARY KEY (`Id`), KEY `FK_use9_product_1` (`mark_id`), CONSTRAINT `FK_use9_product_1` FOREIGN KEY (`mark_id`) REFERENCES `use9_producttype` (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312。CREATE TABLE `use9_vip` ( `Id` int(11) NOT NULL auto_increment, `login_name` varchar(45) default NULL, `login_pwd` varchar(45) default NULL, `question` varchar(45) default NULL, `answer` varchar(45) default NULL, `use_name` varchar(45) default NULL, `sex` int(45) default NULL, `` varchar(45) default NULL, `homepage` varchar(45) default NULL, `mark` int(11) default NULL, `tel` varchar(45) default NULL, PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312。采用DAO構(gòu)架運(yùn)行截圖：CREATE TABLE `use9_producttype` ( `Id` int(11) NOT NULL auto_increment,
物理相關(guān)推薦
鄂ICP備17016276號(hào)-1