sqlserver连接

lige

2023-12-11 58bd4f3a3a2a45544203ab605836667c4af38d76

sqlserver连接

 ltkj-admin/pom.xml

@@ -72,7 +72,12 @@
            <version>1.69</version>
        </dependency>


        <!-- sqlserver驱动包 -->
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>sqljdbc4</artifactId>
            <version>4.0</version>
        </dependency>

        <!-- Mysql驱动包 -->
        <dependency>

 ltkj-admin/src/main/resources/application-druid.yml

@@ -15,10 +15,11 @@
      # 从库数据源
      slave:
        # 从数据源开关/默认关闭
        enabled: false
        url:
        username:
        password:
        enabled: true
        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
        url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
        username: sa
        password: admin123
      # 初始连接数
      initialSize: 5
      # 最小连接池数量
@@ -34,7 +35,7 @@
      # 配置一个连接在池中最大生存的时间，单位是毫秒
      maxEvictableIdleTimeMillis: 900000
      # 配置检测连接是否有效
      validationQuery: SELECT 1 FROM DUAL
      validationQuery: SELECT 1
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false

 ltkj-admin/src/main/resources/application.yml

@@ -11,8 +11,8 @@
  # 文件路径 示例（ Windows配置D:/ltkj/uploadPath，Linux配置 /home/ltkj/uploadPath）
  # 用户换头像后的图片存储地址  测试：D:\ltkj\uploadPath\avatar\2022\12\14
  #profile: D:/ltkj/uploadPath
#  profile: https://ltpeis.xaltjdkj.cn:5502/uploadPath
  profile: http://192.168.0.5:5502/uploadPath
  profile: https://ltpeis.xaltjdkj.cn:5502/uploadPath
#  profile: http://192.168.0.5:5502/uploadPath

  # 获取ip地址开关
  addressEnabled: true
@@ -73,15 +73,15 @@
  # redis 配置
  redis:
    # 地址
#    host: 101.42.27.146
    host: localhost
    host: 101.42.27.146
#    host: localhost
    # 端口，默认为6379
    port: 6379
    # 数据库索引
    database: 0
    # 密码
#    password: 654321
    password: 123456
    password: 654321
#    password: 123456
    # 连接超时时间
    timeout: 120s
    lettuce:
@@ -211,8 +211,8 @@
#积木报表访问地址
jimu:
#  path: https://ltpeis.xaltjdkj.cn:5011/ltkj-admin
#  path: https://ltpeis.xaltjdkj.cn:5021/ltkj-admin
  path: http://192.168.0.5:5000/ltkj-admin
  path: https://ltpeis.xaltjdkj.cn:5021/ltkj-admin
#  path: http://192.168.0.5:5000/ltkj-admin
#  path: http://192.168.0.99:8081/ltkj-admin
#  path: http://192.168.0.101:5011


 ltkj-admin/src/test/java/lgTest.java

@@ -1,4 +1,6 @@
import com.ltkj.LtkjApplication;
import com.ltkj.hosp.domain.SqlTest;
import com.ltkj.hosp.mapper.TestMapper;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
import org.junit.runner.RunWith;
@@ -7,6 +9,7 @@
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;

@@ -20,20 +23,13 @@
@Slf4j
@EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class})
public class lgTest {

    @Resource
    private TestMapper testMapper;
    @Test
    public void lige() {
//        List<String> a=new ArrayList<>();
//        a.add("ozImg61ibpygYZNRWLqtrdpoICh4");
////        a.add("ozImg66H5FbsXzzAHto5Ue_SN5W4");
////        a.add("ozImg64_ViFuhCWvnwLtMWyUCz7g");
////        a.add("ozImg61ibpygYZNRWLqtrdpoICh4");
//
//        for (String s : a) {
//            WxUtil.sendSubscribeMessage(s);
//        }
        //String openid = "o524m6a1xomIOW5fymo7WmE-z3Dg";//需要该用户已经授权过该订阅消息才能发送


        final SqlTest list = testMapper.getList();
        System.out.println(list);
    }

    public static void main(String[] args) {

 ltkj-framework/src/main/java/com/ltkj/framework/config/properties/DruidProperties.java

@@ -32,8 +32,8 @@
    @Value("${spring.datasource.druid.maxEvictableIdleTimeMillis}")
    private int maxEvictableIdleTimeMillis;

    @Value("${spring.datasource.druid.validationQuery}")
    private String validationQuery;
//    @Value("${spring.datasource.druid.validationQuery}")
//    private String validationQuery;

    @Value("${spring.datasource.druid.testWhileIdle}")
    private boolean testWhileIdle;
@@ -63,7 +63,7 @@
        /**
         * 用来检测连接是否有效的sql，要求是一个查询语句，常用select 'x'。如果validationQuery为null，testOnBorrow、testOnReturn、testWhileIdle都不会起作用。
         */
        datasource.setValidationQuery(validationQuery);
//        datasource.setValidationQuery(validationQuery);
        /** 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。 */
        datasource.setTestWhileIdle(testWhileIdle);
        /** 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 */

 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/SqlTest.java

New file
@@ -0,0 +1,14 @@
package com.ltkj.hosp.domain;

import lombok.Data;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 14:55
 */
@Data
public class SqlTest {
    private String id;
    private String address;
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java

New file
@@ -0,0 +1,21 @@
package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.hosp.domain.SqlTest;
import com.ltkj.hosp.domain.TjAdvice;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 14:51
 */
@Mapper
public interface TestMapper extends BaseMapper<SqlTest> {
    @DataSource(value = DataSourceType.SLAVE)
    @Select("select * from City where id=1")
    public SqlTest getList();
}

 ltkj-hosp/src/main/resources/mapper/mall/MallOrderMapper.xml

@@ -239,9 +239,9 @@
            <if test="startTime != null and endTime !=null ">
                and  create_time between #{startTime} and #{endTime}
            </if>
            <if test="getType != null ">
                and get_type = #{getType}
            </if>
<!--            <if test="getType != null ">-->
<!--                and get_type = #{getType}-->
<!--            </if>-->
        </where>
        order by update_time desc
    </select>