###服务启动端口号
server:
  port: 2010
spring:
  application:
    name:  yjlc-Dm
#使用mybatis数据连接
#  datasource:
#     url: jdbc:dm://192.168.200.229:5236/testDB?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
#     username: SYSDBA
#     password: SYSDBA
#     driver-class-name: dm.jdbc.driver.DmDriver

#使用德鲁伊数据连接池
  datasource:
      name: dm8
      type: com.alibaba.druid.pool.DruidDataSource
      druid:
        driverClassName: dm.jdbc.driver.DmDriver
        url: jdbc:dm://192.168.200.229:5236/?testDB&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
        username: SYSDBA
        password: SYSDBA
mybatis:
  mapper-locations: classpath*:mapping/**/*.xml

package com.yjlc;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.yjlc.mapper")
public class AppDMConformity {
    public static void main(String[] args) {
        SpringApplication.run(AppDMConformity.class);
    }
}

package com.yjlc.service;

import com.yjlc.entity.UserEntity;
import com.yjlc.mapper.ConformityMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;


@Controller
public class ConformityService {

    @Autowired
    ConformityMapper conformityMapper;
    @RequestMapping("/test")
    public void Test(){
        System.out.println("进入测试类");
        UserEntity userEntity = conformityMapper.selectById();
        System.out.println("获取到实体"+userEntity.toString());


    }
}

package com.yjlc.entity;


public class UserEntity {

    private String id;
    private String name;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

package com.yjlc.mapper;

import com.yjlc.entity.UserEntity;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface ConformityMapper {

    UserEntity selectById();
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yjlc.mapper.ConformityMapper">

   <select id="selectById" resultType="com.yjlc.entity.UserEntity">
       select * from "testDB"."TABLE_1" where "id"=‘2‘;
   </select>

</mapper>

sp_set_para_value(2,‘ENABLE_ENCRYPT‘,0);