[未解决] java11 连接 sqlserver 2014 报错 The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]

问题： windows 10 上正常的 java 程序，部署到 centos 后报错 [crayon-662c… Read More

spring mvc 导出 excel

问题：解决：

package com.telsafe.crccdemo.rest;

import org.apache.poi.ss.usermodel.CellType;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.view.document.AbstractXlsView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.stream.Collectors;

@Controller
@RequestMapping("export")
public class ExportController {
    final UserService userService;

    public ExportController(final UserService userService) {
        this.userService = userService;
    }

    @PostMapping("users")
    ModelAndView users(@RequestParam(value = "path", required = false) String path) {
        final var list = .../// new ArrayList<UserVo>
        return new ModelAndView(new UserXlsView(), Map.of("list", list));
    }

    static class UserXlsView extends AbstractXlsView {

        @Override
        protected void buildExcelDocument(final Map<String, Object> map, final org.apache.poi.ss.usermodel.Workbook workbook, final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse) throws Exception {
            Objects.requireNonNull(workbook);
            var sheet = workbook.createSheet();
            final List<UserVo> users = (List<UserVo>) map.get("list");
            for (int i = 0; i < users.size(); ++i) {
                final var user = users.get(i);
                final var row = sheet.createRow(i);
                var indexCell = row.createCell(0, CellType.NUMERIC);
                indexCell.setCellValue(user.getIndex());
                row.createCell(1, CellType.STRING).setCellValue(user.getName());
                row.createCell(2, CellType.STRING).setCellValue(user.getCompanyName());
                row.createCell(3, CellType.STRING).setCellValue(user.getDepartmentName());
                row.createCell(4, CellType.STRING).setCellValue(user.getPositionName());
            }
        }
    }
}

package com.telsafe.crccdemo.rest;

import org.apache.poi.ss.usermodel.CellType;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.PostMapping;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.servlet.ModelAndView;

import org.springframework.web.servlet.view.document.AbstractXlsView;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.util.List;

import java.util.Map;

import java.util.Objects;

import java.util.stream.Collectors;

@Controller

@RequestMapping("export")

public class ExportController {

final UserService userService;

public ExportController(final UserService userService) {

this.userService = userService;

}

@PostMapping("users")

ModelAndView users(@RequestParam(value = "path", required = false) String path) {

final var list = .../// new ArrayList<UserVo>

return new ModelAndView(new UserXlsView(), Map.of("list", list));

}

static class UserXlsView extends AbstractXlsView {

@Override

protected void buildExcelDocument(final Map<String, Object> map, final org.apache.poi.ss.usermodel.Workbook workbook, final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse) throws Exception {

Objects.requireNonNull(workbook);

var sheet = workbook.createSheet();

final List<UserVo> users = (List<UserVo>) map.get("list");

for (int i = 0; i < users.size(); ++i) {

final var user = users.get(i);

final var row = sheet.createRow(i);

var indexCell = row.createCell(0, CellType.NUMERIC);

indexCell.setCellValue(user.getIndex());

row.createCell(1, CellType.STRING).setCellValue(user.getName());

row.createCell(2, CellType.STRING).setCellValue(user.getCompanyName());

row.createCell(3, CellType.STRING).setCellValue(user.getDepartmentName());

row.createCell(4, CellType.STRING).setCellValue(user.getPositionName());

}

Quarkus 怎么获取IP?

Spring Boot OpenID Connect 备忘

问题： SpringBoot 2.5.x 如何集成 OpenID Connect 登录解决： … Read More

sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

问题：

Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
	at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141) ~[na:na]
	at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126) ~[na:na]
	at java.base/java.security.cert.CertPathBuilder.build(CertPathBuilder.java:297) ~[na:na]
	at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:434) ~[na:na]
	... 98 common frames omitted

Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141) ~[na:na]

at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126) ~[na:na]

at java.base/java.security.cert.CertPathBuilder.build(CertPathBuilder.java:297) ~[na:na]

at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:434) ~[na:na]

... 98 common frames omitted

&nbs… Read More

转：Keycloak快速上手指南，只需10分钟即可接入Spring Boot/Vue前后端分离应用实现SSO单点登录

https://www.cnblogs.com/vigoz/p/12984556.html &n… Read More

spring boot quartz jdbc 集群模式配置备忘

问题：解决： pom.xml 引入 [crayon-662c18ee41dff35362143… Read More

quartz spring boot 配置清单

问题： spring boot application.yml 中 quartz 的所有配置参数清单在哪？ … Read More

vaadin 使用

问题：解决： vaadin 用 java 写代码，初看很好但是发现用 java… Read More

java9 httpclient PKIX path building failed: sun.security.provider.certpath.SunCertPath

问题：

Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:350)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:293)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:288)

Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)

at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:350)

at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:293)

at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:288)

代码 [crayon-… Read More

IT问题

程序员的疑难杂症录

Java