課程
/后端開發(fā)
/Java
/Shiro安全框架入門
求個(gè)建表語句
2018-07-14
源自：Shiro安全框架入門 3-4
正在回答
```
--
-- Table structure for table `roles_permissions`
DROP TABLE IF EXISTS `roles_permissions`;
CREATE TABLE `roles_permissions` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `role_name` varchar(255) DEFAULT NULL,
? `permission` varchar(255) NOT NULL,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- Dumping data for table `roles_permissions`
LOCK TABLES `roles_permissions` WRITE;
INSERT INTO `roles_permissions` VALUES (1,'admin','user:select'),(2,'admin','user:delete'),(3,'user','user:select');
UNLOCK TABLES;
-- Table structure for table `test_user`
DROP TABLE IF EXISTS `test_user`;
CREATE TABLE `test_user` (
? `user_name` varchar(255) NOT NULL,
? `password` varchar(255) NOT NULL,
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- Dumping data for table `test_user`
LOCK TABLES `test_user` WRITE;
INSERT INTO `test_user` VALUES (1,'xiaoming','654321');
-- Table structure for table `user_roles`
DROP TABLE IF EXISTS `user_roles`;
CREATE TABLE `user_roles` (
? `username` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- Dumping data for table `user_roles`
LOCK TABLES `user_roles` WRITE;
INSERT INTO `user_roles` VALUES (1,'Mark','admin'),(2,'Mark','user');
-- Table structure for table `users`
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
? `password` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `users`
LOCK TABLES `users` WRITE;
INSERT INTO `users` VALUES (1,'Mark','283538989cef48f3d7d8a1c1bdf2008f');
慕容8287587 提問者
慕仔0092249
被自己蠢哭了onclick（）放錯(cuò)位置了可以看看firebug這門課程。
十分感謝
這個(gè)建表語句是寫在哪里呀？MySQL里還是IDEA里面？
莫槑
知道了? 十分感謝
謝謝啦
舉報(bào)
從零入門Shiro安全框架
3 回答哪里有建表語句
1 回答session共享有什么用處
1 回答session共享會(huì)出現(xiàn)什么問題
2 回答有個(gè)分布是共享的問題
2 回答數(shù)據(jù)庫表sql能發(fā)一下嘛？
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號(hào)-11 京公網(wǎng)安備11010802030151號(hào)
購課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號(hào)
2018-07-14
```
--
-- Table structure for table `roles_permissions`
--
DROP TABLE IF EXISTS `roles_permissions`;
CREATE TABLE `roles_permissions` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `role_name` varchar(255) DEFAULT NULL,
? `permission` varchar(255) NOT NULL,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `roles_permissions`
--
LOCK TABLES `roles_permissions` WRITE;
INSERT INTO `roles_permissions` VALUES (1,'admin','user:select'),(2,'admin','user:delete'),(3,'user','user:select');
UNLOCK TABLES;
--
-- Table structure for table `test_user`
--
DROP TABLE IF EXISTS `test_user`;
CREATE TABLE `test_user` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `user_name` varchar(255) NOT NULL,
? `password` varchar(255) NOT NULL,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `test_user`
--
LOCK TABLES `test_user` WRITE;
INSERT INTO `test_user` VALUES (1,'xiaoming','654321');
UNLOCK TABLES;
--
-- Table structure for table `user_roles`
--
DROP TABLE IF EXISTS `user_roles`;
CREATE TABLE `user_roles` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `username` varchar(255) DEFAULT NULL,
? `role_name` varchar(255) DEFAULT NULL,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `user_roles`
--
LOCK TABLES `user_roles` WRITE;
INSERT INTO `user_roles` VALUES (1,'Mark','admin'),(2,'Mark','user');
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `username` varchar(255) DEFAULT NULL,
? `password` varchar(255) DEFAULT NULL,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
INSERT INTO `users` VALUES (1,'Mark','283538989cef48f3d7d8a1c1bdf2008f');
UNLOCK TABLES;
```
2022-03-26
被自己蠢哭了onclick（）放錯(cuò)位置了可以看看firebug這門課程。
2020-02-28
十分感謝
2019-04-21
這個(gè)建表語句是寫在哪里呀？MySQL里還是IDEA里面？
2019-02-24
知道了? 十分感謝
2019-01-14
謝謝啦