(三) shiro通过jdbc连接数据库

1 前言 : 

shiro代码参考java1234网站《一头扎进shiro》视频敲出来的，原理这些请参视频 ,

点击  下载源码

点击 下载数据库

2 项目结构图

3 代码

JdbcRealmTest.java

package shiro;

import org.apache.shiro.SecurityUtils;
import org.apache.shiro.authc.UsernamePasswordToken;
import org.apache.shiro.config.IniSecurityManagerFactory;
import org.apache.shiro.util.Factory;
import org.apache.shiro.mgt.SecurityManager;
import org.apache.shiro.subject.Subject;

public class JdbcRealmTest {

	public static void main(String[] args) {
	  // 读取配置文件,初始化SecurityManager工厂
	  Factory<SecurityManager> factory = new IniSecurityManagerFactory("classpath:jdbc_realm.ini");
	  // 获取securityManager实例
	  SecurityManager securityManager = factory.getInstance();
	  // 把securityManager绑定到SecurityUtils中
	  SecurityUtils.setSecurityManager(securityManager);
	  // 得到当前执行的用户
	  Subject currentUser =  SecurityUtils.getSubject();
	  // 创建token令牌,用户名/密码
	  UsernamePasswordToken token = new UsernamePasswordToken("java1234","123456");
	  // 身份验证
	  try{
		  currentUser.login(token);
		  System.out.println("身份验证成功");
	  }catch(Exception e){
		  e.printStackTrace();
		  System.out.println("身份验证失败");
	  }
	  currentUser.logout();//退出
	
	  
	  
	}

}

jdbc_realm.ini

[main]
jdbcRealm=org.apache.shiro.realm.jdbc.JdbcRealm
dataSource=com.mchange.v2.c3p0.ComboPooledDataSource
dataSource.driverClass=com.mysql.jdbc.Driver
dataSource.jdbcUrl=jdbc:mysql://localhost:3306/shiro
dataSource.user=root
dataSource.password=root
jdbcRealm.dataSource=$dataSource
securityManager.realms=$jdbcRealm

log4j.properties

# debug config start
log4j.rootLogger=debug,stdout,log,errorlog,debuglog

 #   degug config over
  
  
###Console ###  
log4j.appender.stdout = org.apache.log4j.ConsoleAppender  
log4j.appender.stdout.Target = System.out  
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout  
log4j.appender.stdout.layout.ConversionPattern = %d %-5p (%F\:%L) - %m  ......  %c%n
  
### Log ###    
log4j.appender.log = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.log.File =log/info/info.log
log4j.appender.log.Append = true  
log4j.appender.log.Threshold = INFO  
log4j.appender.log.DatePattern='.'yyyy-MM-dd  
log4j.appender.log.layout = org.apache.log4j.PatternLayout  
log4j.appender.log.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} (%F\:%L) [ %t ] %m%n
### Error ###  
log4j.appender.errorlog = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.errorlog.File=log/error/error.log
log4j.appender.errorlog.Append = true  
log4j.appender.errorlog.Threshold = ERROR   
log4j.appender.errorlog.DatePattern='.'yyyy-MM-dd  
log4j.appender.errorlog.layout = org.apache.log4j.PatternLayout  
log4j.appender.errorlog.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} (%F\:%L) [ %t ] %m%n
### DEBUG ###  
log4j.appender.debuglog = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.debuglog.File=log/debug/debug.log
log4j.appender.debuglog.Append = true  
log4j.appender.debuglog.Threshold = DEBUG   
log4j.appender.debuglog.DatePattern='.'yyyy-MM-dd  
log4j.appender.debuglog.layout =org.apache.log4j.PatternLayout 
log4j.appender.debuglog.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} (%F\:%L) [ %t ] %m%n
log4j.appender.stdout.Threshold=DEBUG

##forbidding some package output log
log4j.logger.shiro=DEBUG

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>shiro.leanring</groupId>
  <artifactId>shiro</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>


  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>

  <dependencies>
  <!-- 添加 shiro需要一些包 开始 -->
    <dependency>
      <groupId>junit</groupId>
	      <artifactId>junit</artifactId>
	      <version>4.12</version>
	      <scope>test</scope>
    </dependency>
    <dependency>
		 <groupId>org.apache.shiro</groupId>
		 <artifactId>shiro-core</artifactId>
		 <version>1.2.4</version>
	</dependency>
	<dependency>
		<groupId>org.slf4j</groupId>
		<artifactId>slf4j-log4j12</artifactId>
		<version>1.7.12</version>
	</dependency> 
	<dependency>
		<groupId>log4j</groupId>
		<artifactId>log4j</artifactId>
		<version>1.2.17</version>
   </dependency>
  <!-- 添加 shiro需要一些包 结束 -->
  <!-- 添加数据源 开始 -->
    <dependency>
		<groupId>c3p0</groupId>
		<artifactId>c3p0</artifactId>
		<version>0.9.1.2</version>
	</dependency>
	<dependency>
		<groupId>commons-logging</groupId>
		<artifactId>commons-logging</artifactId>
		<version>1.2</version>
	</dependency>
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>5.1.37</version>
	</dependency>
  <!-- 添加数据源 结束 -->
  </dependencies>
</project>