初次使用IDEA连接sql server并建立Web项目遇到的疑难问题和解决_idea中添加sql server依赖

1.sql server设置和Jar包

若是连接Sql server，对应服务器实例的登录方式必须为SQL Server 和 Windows 身份验证模式并设置sa登录名和密码，若初始为Windows 身份验证模式的，请根据更改服务器身份验证模式 - SQL Server | Microsoft Learn 加入sa登录名和密码。

对应Sql server的jar包在 Download - JDBC Driver for SQL Server | Microsoft Learn

对应的依赖为

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>12.6.0.jre11</version>
</dependency>

2.MAVEN配置错误 —— Unable to import maven project: See logs for details

错误代码log：

	at com.google.inject.internal.Errors.throwCreationExceptionIfErrorsExist(Errors.java:576)
	at com.google.inject.internal.InternalInjectorCreator.initializeStatically(InternalInjectorCreator.java:163)
	at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:110)
	at com.google.inject.Guice.createInjector(Guice.java:87)
	at com.google.inject.Guice.createInjector(Guice.java:69)
	at com.google.inject.Guice.createInjector(Guice.java:59)
	at org.codehaus.plexus.DefaultPlexusContainer.addComponent(DefaultPlexusContainer.java:344)
	at org.codehaus.plexus.DefaultPlexusContainer.addComponent(DefaultPlexusContainer.java:333)
	at org.jetbrains.idea.maven.server.Maven3ServerEmbedderImpl.customizeComponents(Maven3ServerEmbedderImpl.java:561)
	at org.jetbrains.idea.maven.server.Maven3ServerEmbedderImpl.customize(Maven3ServerEmbedderImpl.java:532)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:346)
	at sun.rmi.transport.Transport$1.run(Transport.java:200)
	at sun.rmi.transport.Transport$1.run(Transport.java:197)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
	at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:276)
	at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:253)
	at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:162)
	at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
	at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
	at com.sun.proxy.$Proxy204.customize(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:179)
	at com.intellij.execution.rmi.RemoteUtil.access$300(RemoteUtil.java:39)
	at com.intellij.execution.rmi.RemoteUtil$2$1$1.compute(RemoteUtil.java:160)
	at com.intellij.openapi.util.ClassLoaderUtil.runWithClassLoader(ClassLoaderUtil.java:66)
	at com.intellij.execution.rmi.RemoteUtil.executeWithClassLoader(RemoteUtil.java:231)
	at com.intellij.execution.rmi.RemoteUtil$2$1.invoke(RemoteUtil.java:157)
	at com.sun.proxy.$Proxy204.customize(Unknown Source)
	at org.jetbrains.idea.maven.server.MavenEmbedderWrapper.doCustomize(MavenEmbedderWrapper.java:96)
	at org.jetbrains.idea.maven.server.MavenEmbedderWrapper.onWrappeeCreated(MavenEmbedderWrapper.java:49)
	at org.jetbrains.idea.maven.server.RemoteObjectWrapper.getOrCreateWrappee(RemoteObjectWrapper.java:42)
	at org.jetbrains.idea.maven.server.MavenEmbedderWrapper.doCustomize(MavenEmbedderWrapper.java:96)
	at org.jetbrains.idea.maven.server.MavenEmbedderWrapper.lambda$customizeForResolve$1(MavenEmbedderWrapper.java:69)
	at org.jetbrains.idea.maven.server.RemoteObjectWrapper.perform(RemoteObjectWrapper.java:76)
	at org.jetbrains.idea.maven.server.MavenEmbedderWrapper.customizeForResolve(MavenEmbedderWrapper.java:68)
	at org.jetbrains.idea.maven.project.MavenProjectsTree.resolve(MavenProjectsTree.java:1249)
	at org.jetbrains.idea.maven.project.MavenProjectsProcessorResolvingTask.perform(MavenProjectsProcessorResolvingTask.java:44)
	at org.jetbrains.idea.maven.project.MavenProjectsProcessor.doProcessPendingTasks(MavenProjectsProcessor.java:132)
	at org.jetbrains.idea.maven.project.MavenProjectsProcessor.access$000(MavenProjectsProcessor.java:32)
	at org.jetbrains.idea.maven.project.MavenProjectsProcessor$2.run(MavenProjectsProcessor.java:107)
	at org.jetbrains.idea.maven.utils.MavenUtil.lambda$runInBackground$5(MavenUtil.java:446)
	at com.intellij.openapi.application.impl.ApplicationImpl$1.run(ApplicationImpl.java:305)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
2024-04-01 13:10:20,177 [341339760]  ERROR -      #org.jetbrains.idea.maven - IntelliJ IDEA 2018.1  Build #IU-181.4203.550 
2024-04-01 13:10:20,177 [341339760]  ERROR -      #org.jetbrains.idea.maven - JDK: 1.8.0_152-release 
2024-04-01 13:10:20,177 [341339760]  ERROR -      #org.jetbrains.idea.maven - VM: OpenJDK 64-Bit Server VM 
2024-04-01 13:10:20,177 [341339760]  ERROR -      #org.jetbrains.idea.maven - Vendor: JetBrains s.r.o 
2024-04-01 13:10:20,177 [341339760]  ERROR -      #org.jetbrains.idea.maven - OS: Windows 10 
2024-04-01 13:10:20,177 [341339760]  ERROR -      #org.jetbrains.idea.maven - Last Action: Maven.ReimportProject 
2024-04-01 13:10:53,202 [341372785]   INFO - ide.actions.ShowFilePathAction - 
Exit code 1 

错误原因解析：

1、maven配置的本地仓库地址与项目中使用的不一致

2、项目目录内的.idea目录存在不明配置

错误修正：

使用IDEA自带的MAVEN

3.Maven的setting.xml

<?xml version="1.0" encoding="UTF-8"?>
<settings xmlns="http://maven.apache.org/SETTINGS/1.2.0"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.2.0 https://maven.apache.org/xsd/settings-1.2.0.xsd">
  
  <!-- 本地仓库地址-->
  <localRepository>D:\jar_dll_tomcat\MavenRepository</localRepository>
 
  <pluginGroups>
    <!-- pluginGroup
     | Specifies a further group identifier to use for plugin lookup.
    <pluginGroup>com.your.plugins</pluginGroup>
    -->
  </pluginGroups>
 
  <proxies>
    <!-- proxy
     | Specification for one proxy, to be used in connecting to the network.
     |
    <proxy>
      <id>optional</id>
      <active>true</active>
      <protocol>http</protocol>
      <username>proxyuser</username>
      <password>proxypass</password>
      <host>proxy.host.net</host>
      <port>80</port>
      <nonProxyHosts>local.net|some.host.com</nonProxyHosts>
    </proxy>
    -->
  </proxies>
 
  <servers>
  </servers>
  
  <mirrors>
    <mirror>
      <id>alimaven</id>
      <mirrorOf>central</mirrorOf>
      <name>aliyun maven</name>
      <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
    </mirror>
  </mirrors>
 
  <profiles>
    <profile>
　　<!-- profile的唯一标识 -->
        <id>jdk</id>     
        <!-- 自动触发profile的条件逻辑 -->
        <activation>
            <activeByDefault>false</activeByDefault>
            <jdk>1.8</jdk>
        </activation>
        <!-- 扩展属性列表 -->
        <properties>
			<maven.compiler.source>1.8</maven.compiler.source>
			<maven.compiler.target>1.8</maven.compiler.target>
			<maven.compiler.compilerVersion>1.8</maven.compiler.compilerVersion>
		</properties>
        <!-- 远程仓库列表 -->
        <repositories />
        <!-- 插件仓库列表 -->
        <pluginRepositories />
    </profile>
	
  </profiles>
 
  <!-- activeProfiles
   | List of profiles that are active for all builds.
   |
  <activeProfiles>
    <activeProfile>alwaysActiveProfile</activeProfile>
    <activeProfile>anotherAlwaysActiveProfile</activeProfile>
  </activeProfiles>
  -->
</settings>

3.Maven的ssm改为Spring boot，启动tomact报错

关于【Factory method 'formContentFilter' threw exception】类似类型的错误

1.Spring boot不需要web.xml

解决方案：将web.xml文件删去

2.formContentFilter是springboot的内部包抛出的异常，异常的指向却是一个jackson的包内异常，说明是一个引用错误依赖，跟踪源码发现却是存在依赖冲突

解决方案：使用jackson：2.11.2
1、删除jackson的包，替换其他类json框架。
2、升级jackson的版本，jackson最好使用2.11.0及以上版本

①jackson-databind < 2.9.10.8，存在反序列化远程代码执行漏洞（CVE-2020-35490/CVE-2020-35491），远程攻击者可通过精心构造的恶意载荷利用该漏洞在系统执行任意代码；
②jackson-databind 2.11.0及以上版本与spring-boot版本兼容。

4.layui试图在前台输出数据，报错：Uncaught TypeError: s.parents is not a function 

试图输出的数据不是个合规的变量，换到后台输出，如果换成后台还是不行，就清一下浏览器缓存。

5.关于lodop免费版的打印问题

Lodop(6.111及之后版本)按域名的高级注册号和使用方式(域名为:snailpet.cn,localhost):
在页面装载之后，调用Lodop普通函数之前执行一次如下语句：
LODOP.SET_LICENSES("","EE0887D00FCC7D29375A695F728489A6","C94CEE276DB2187AE6B65D56B3FC2848","");
假如您采用了LodopFuncs.js文件(6.0之后)，简单办法是把该语句放到此文件内那个注明“空白位置”的地方。

本注册号语句成功生效之后会有如下表现：
1：打印维护界面不再有“关于”按钮；
2：直接打印时输出结果的左下角不再有试用版字样；
3：导出的Excel文件里也不再有试用版字样；
5：打印设计界面也不再有“关于”按钮；
（更多注册功效参考价格表相关说明）

如果注册号测试无效，可用以下简单步骤排查：
一、在SET_LICENSES语句前后加alert提示语句，例如：
LODOP.SET_LICENSES("","EE0887D00FCC7D29375A695F728489A6","C94CEE276DB2187AE6B65D56B3FC2848","");
alert("SET_LICENSES执行了");
二、执行时若无以上提示，说明未调用到这里，此时重点排查是否调用了getlodop过程;
三、不想使用getlodop时可以把SET_LICENSES放到每个具体打印过程中，例如PRINT_INIT前面;
四、更简单的测试办法是把注册语句放在Lodop样例2里试试;
五、注册后有资格加入QQ的VIP群:144894000 或 205332300 入群时说明域名或Email，也可咨询QQ:932131686
最新版本及其技术手册可从如下地址下载：
http://www.c-lodop.com/download.html
http://www.mtsoftware.cn/download.html

谢谢您的注册，感谢对Lodop的支持！