A simple proof-of-concept of Shiro authentication with JDBC Realm and MySQL.
CSS
Latest commit a52a770 Jan 15, 2014 @pires Merge pull request #3 from congdepeng/master
The permission_name is permission in table roles_permissions that define...

README.md

simple-shiro-web-app

A simple proof-of-concept of Shiro authentication with Jetty and JDBC (MySQL) Realm.

Prerequisites

  • JDK 6
  • Maven 3.0.3 or newer

Configure MySQL database

Run the following commands:

mysql -u root -p
create database simple_shiro_web_app;  
grant all privileges on simple_shiro_web_app.* to 'root'@'localhost' identified by '123qwe';
flush privileges;

Now, populate the database with the script provided:

mysql -u root -p123qwe simple_shiro_web_app < pop_db.sql

Test

In order to build a WAR package, run the following command:

mvn clean jetty:run

Point your browser to http://localhost:9090