這么簡單的SQL語句還要伸手？

jdbcrealm的數(shù)據(jù)表結(jié)構(gòu)應(yīng)該是固定的，你再網(wǎng)上一搜就搜到了

/*
Navicat?MySQL?Data?Transfer

Source?Server?????????:?localhost_3306
Source?Server?Version?:?50527
Source?Host???????????:?localhost:3306
Source?Database???????:?shiro

Target?Server?Type????:?MYSQL
Target?Server?Version?:?50527
File?Encoding?????????:?65001

Date:?2018-03-30?22:31:17
*/

SET?FOREIGN_KEY_CHECKS=0;

--?----------------------------
--?Table?structure?for?`roles_permissions`
--?----------------------------
DROP?TABLE?IF?EXISTS?`roles_permissions`;
CREATE?TABLE?`roles_permissions`?(
??`id`?int(11)?NOT?NULL?DEFAULT?'0',
??`role_name`?varchar(20)?DEFAULT?NULL,
??`permission`?varchar(20)?DEFAULT?NULL,
??PRIMARY?KEY?(`id`)
)?ENGINE=InnoDB?DEFAULT?CHARSET=utf8;

--?----------------------------
--?Records?of?roles_permissions
--?----------------------------
INSERT?INTO?`roles_permissions`?VALUES?('1',?'system',?'update');

--?----------------------------
--?Table?structure?for?`users`
--?----------------------------
DROP?TABLE?IF?EXISTS?`users`;
CREATE?TABLE?`users`?(
??`id`?int(11)?NOT?NULL?AUTO_INCREMENT,
??`username`?varchar(20)?DEFAULT?NULL,
??`password`?varchar(20)?DEFAULT?NULL,
??`password_salt`?int(11)?DEFAULT?NULL,
??PRIMARY?KEY?(`id`)
)?ENGINE=InnoDB?AUTO_INCREMENT=2?DEFAULT?CHARSET=utf8;

--?----------------------------
--?Records?of?users
--?----------------------------
INSERT?INTO?`users`?VALUES?('1',?'admin',?'666',?null);

--?----------------------------
--?Table?structure?for?`user_roles`
--?----------------------------
DROP?TABLE?IF?EXISTS?`user_roles`;
CREATE?TABLE?`user_roles`?(
??`id`?int(11)?NOT?NULL?DEFAULT?'0',
??`username`?varchar(20)?DEFAULT?NULL,
??`role_name`?varchar(20)?DEFAULT?NULL,
??PRIMARY?KEY?(`id`)
)?ENGINE=InnoDB?DEFAULT?CHARSET=utf8;

--?----------------------------
--?Records?of?user_roles
--?----------------------------
INSERT?INTO?`user_roles`?VALUES?('1',?'admin',?'system');