在网上找了一下,没找到,然后尝试配置了下,可用。需要用到两个包:c3p0-0.9.1.2.jar和mssqljdbc4_2008.jar
[main]ds = com.mchange.v2.c3p0.ComboPooledDataSourceds.driverClass = com.microsoft.sqlserver.jdbc.SQLServerDriverds.user = 用户ds.password = 密码ds.jdbcUrl = jdbc:sqlserver://localhost:1433;DatabaseName=数据库jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealmjdbcRealm.permissionsLookupEnabled = truejdbcRealm.authenticationQuery = SELECT password FROM 用户表 WHERE account = ?jdbcRealm.userRolesQuery = SELECT role FROM 角色表 WHERE account = ?jdbcRealm.permissionsQuery = SELECT permission FROM 权限表 WHERE account = ?jdbcRealm.dataSource = $dsauthc.loginUrl = /loginperms.unauthorizedUrl = /loginroles.unauthorizedUrl = /login[urls]/login = anon/chklogin = anon/* = authc