ssm整合的环境搭建 

数据库环境的搭建   基于mysql建表
 1 CREATE TABLE `tmenu` (
 2   `ID` varchar(36) NOT NULL,
 3   `ICONCLS` varchar(100) DEFAULT NULL,
 4   `SEQ` decimal(22,0) DEFAULT NULL,
 5   `TEXT` varchar(100) DEFAULT NULL,
 6   `URL` varchar(200) DEFAULT NULL,
 7   `PID` varchar(36) DEFAULT NULL,
 8   PRIMARY KEY (`ID`)
 9 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10 
11 CREATE TABLE `tresource` (
12   `ID` varchar(36) NOT NULL,
13   `SEQ` decimal(22,0) DEFAULT NULL,
14   `TEXT` varchar(100) DEFAULT NULL,
15   `URL` varchar(200) DEFAULT NULL,
16   `PID` varchar(36) DEFAULT NULL,
17   PRIMARY KEY (`ID`)
18 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19 
20 CREATE TABLE `trole` (
21   `ID` varchar(36) NOT NULL,
22   `TEXT` varchar(100) DEFAULT NULL,
23   PRIMARY KEY (`ID`)
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25 
26 CREATE TABLE `tuser` (
27   `ID` varchar(36) NOT NULL,
28   `CREATEDATETIME` timestamp NULL DEFAULT NULL,
29   `MODIFYDATETIME` timestamp NULL DEFAULT NULL,
30   `NAME` varchar(100) DEFAULT NULL,
31   `PWD` varchar(50) DEFAULT NULL,
32   `CREATE_TIME` date DEFAULT NULL,
33   `UPDATE_TIME` date DEFAULT NULL,
34   PRIMARY KEY (`ID`)
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36 
37 CREATE TABLE `trole_tresource` (
38   `ID` varchar(255) NOT NULL,
39   `RESOURCE_ID` varchar(36) DEFAULT NULL,
40   `ROLE_ID` varchar(36) DEFAULT NULL,
41   PRIMARY KEY (`ID`),
42   KEY `TRESOURCEID` (`RESOURCE_ID`),
43   KEY `TROLEID` (`ROLE_ID`),
44   CONSTRAINT `TRESOURCEID` FOREIGN KEY (`RESOURCE_ID`) REFERENCES `tresource` (`ID`),
45   CONSTRAINT `TROLEID` FOREIGN KEY (`ROLE_ID`) REFERENCES `trole` (`ID`)
46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
47 
48 CREATE TABLE `trole_tuser` (
49   `ID` varchar(36) NOT NULL,
50   `ROLE_ID` varchar(36) DEFAULT NULL,
51   `USER_ID` varchar(36) DEFAULT NULL,
52   PRIMARY KEY (`ID`)
53 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54 
55 CREATE TABLE `tuser_trole` (
56   `USER_ID` varchar(36) NOT NULL,
57   `ID` varchar(36) DEFAULT NULL,
58   `ROLE_ID` varchar(36) DEFAULT NULL,
59   PRIMARY KEY (`USER_ID`),
60   KEY `TROLE_ID` (`ROLE_ID`),
61   CONSTRAINT `TROLE_ID` FOREIGN KEY (`ROLE_ID`) REFERENCES `trole` (`ID`),
62   CONSTRAINT `TUSER_ID` FOREIGN KEY (`USER_ID`) REFERENCES `tuser` (`ID`)
63 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

向tuser表里面插入一条id为1的数据。

 

posted @ 2017-08-02 14:53  百度程序员  阅读(116)  评论(0)    收藏  举报