2020-05-26：Springboot 连接oracle数据库配置

1.在application.properties配置账号密码等信息
server.port=8080
server.servlet.context-path=/share-center-report
spring.thymeleaf.prefix=classpath:/templates/
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=
spring.datasource.username=
spring.datasource.password=

2.引入依赖
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>

    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.3.2</version>
    </dependency>

3.在启动类配置扫描mapper
@MapperScan({"com.example.demo1.mapper"})

4.编写demo测试
public interface testMapper {
@Select("select * from test_data")
List<TestVo> test();
}
/自定义realm程序/
public class MyRealm extends AuthorizingRealm{
@Resource
private testMapper testMapper;
@Override
protected AuthorizationInfo doGetAuthorizationInfo(PrincipalCollection principalCollection) {
System.out.println("授权");
return null;
}

@Override
protected AuthenticationInfo doGetAuthenticationInfo(AuthenticationToken authenticationToken) throws AuthenticationException {
    System.out.println("认证");
    String name=null;
    String password=null;
    List<TestVo> test = testMapper.test();
    for (TestVo vo:test
         ) {
        name = vo.getName();
        password = vo.getPassword();
    }
    UsernamePasswordToken token = (UsernamePasswordToken) authenticationToken;
    char[] password1 = (char[]) token.getPassword();
    String username = token.getUsername();
    String s = new String(password1);
    if (!username.equals(name)){
        return null;
    }
    if (!s.equals(password)){
        return null;
    }
    return new SimpleAuthenticationInfo("",password,"");
}

}