jdbcTemplate.execute("insert into roles(id,name,description) values (1, 'user', 'The default role given to all users.')");
jdbcTemplate.execute("insert into roles(id,name,description) values (2, 'admin', 'The admin role only given to site admins')");
jdbcTemplate.execute("insert into roles_permissions values (2, 'user:*')");
jdbcTemplate.execute("insert into roles_permissions values (2, 'view')");
jdbcTemplate.execute("insert into users(id,username,email,password) values (1, 'admin', 'sample@shiro.apache.org', '" +
new Sha256Hash("admin").toHex() + "')");
jdbcTemplate.execute("insert into users(id,username,email,password) values (2, 'user', 'sample@shiro.apache.org', '" +
new Sha256Hash("user").toHex() + "')");
jdbcTemplate.execute("insert into users_roles values (1, 2)");
jdbcTemplate.execute("insert into users_roles values (2, 1)");
}