问题记录表
问题
虚拟机
虚拟机与主机Ping不通
虚拟机环境布置成功，但是虚拟机与主机Ping不通，需要在做判断
问题解决：
网段问题：在实体机与虚拟机下需要同一个网段，否则无法ping通，并且网关也需要设置为同一网段下的相关设置。
Oracle数据库学习
Oracle数据库密码忘记
相关内容可以参考一下这篇文章。
https://blog.csdn.net/qq_37171506/article/details/81556780
navicat 登录Oracle数据库 sys登录显示没有sysdba权限
这里我们需要在高级处进行设置，因为我们默认的账户是普通角色，并没有加上sysDBA的角色权限
Oracle通过 表名、列名、字段名、注释 找到所在库 或者所在表
通过表名找到所在库或者所在表
例子：有一张 STUDENT_BASE_INFO 表，但是库太多了，不知道在哪个库。
执行sql：
select * from all_tables where table_name = 'STUDENT_BASE_INFO';
结果如下：
通过列名
例如：知道一个列名age，但是不知道在哪张表里面，执行下面的sql：
select * from all_tab_columns where column_name = 'AGE';
通过注释找到所在表
**
select * from all_tab_comments where comments like '%学生%';
Oracle设置自增id
create sequence s_user_seq
increment by 1
START WITH 1
NOMAXVALUE
NOCYCLE
NOCACHE
create or replace trigger s_user_tr
before insert on SUBSIDIES_INFORMATION
for each row
begin
select s_user_seq.nextval into :new.id from dual;
end s_user_tr;
Oracle复杂条件判断-CASE WHEN
<select id="batchDataQuery" resultMap="batchDataQueryMap">
select
SUBSIDY_INSTITUTION,
SUBSIDY_PROJECT,
BATCH_NO,
COUNT(AMOUNT) as subsidiesTotalNumber,
SUM(AMOUNT) as totalSubsidyAmount,
COUNT(id) as headCount,
COUNT(CASE WHEN s.IS_NORMAL='1' THEN s.ID END) as normalNumber,
SUM(case WHEN s.IS_NORMAL='1' THEN amount else 0 END) as normalAmount,
COUNT(CASE WHEN s.IS_NORMAL='0' THEN s.ID END) as AbnormalNumber,
SUM(case WHEN s.IS_NORMAL='0' THEN AMOUNT else 0 END) as abnormalAmount
FROM
SUBSIDIES_INFORMATION s
<where>
<if test="subsidyInstitution != null and subsidyInstitution != ''">
SUBSIDY_INSTITUTION = #{subsidyInstitution},
</if>
<if test="subsidyProject != null and subsidyProject != ''">
SUBSIDY_PROJECT = #{subsidyProject},
</if>
<if test="batchNo != null and batchNo != ''">
BATCH_NO = #{batchNo},
</if>
</where>
GROUP BY s.SUBSIDY_INSTITUTION,s.SUBSIDY_PROJECT,s.BATCH_NO
</set
Oracle 递归查询
SELECT T.CODE, T.NAME
FROM T_DISTINCT T
START WITH T.DISTINCT_ID = '3604320505'
CONNECT BY T.DISTINCT_ID = PRIOR T.Parent_Id
ORDER BY LEVEL DESC
Oracle批量插入
<insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
insert into T_EXTERNAL_BATCH(ID,IMPORT_FILE_NAME, IMPORT_TIME, BATCH_NUMBER, AMOUNT, BANK, LEADER_IN_CHARGE, INFORMANT, FILLING_DATE, DEL_FLAG, CREATED_BY, CREATED_TIME, UPDATED_BY, UPDATED_TIME)
select T_EXTERNAL_BATCH_SEQ.nextval,cd.* from
(
<foreach collection="list" item="entity" index="index" close=")" open="(" separator="union">
select
#{entity.importFileName}, #{entity.importTime}, #{entity.batchNumber}, #{entity.amount}, #{entity.bank}, #{entity.leaderInCharge}, #{entity.informant}, #{entity.fillingDate}, #{entity.delFlag}, #{entity.createdBy}, #{entity.createdTime}, #{entity.updatedBy}, #{entity.updatedTime}
from dual
</foreach>
) cd
</insert>
Oracle数据迁移
PDManner导出相关PPL
Navicat导出相关数据 SQL语句
DBaver导出相关序列语句
mysql数据库
mybatis-generator 无法链接至数据库
解决方法：
pom引入的mysql-connector-java的版本过低
需要引入新的
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
时间time zone 异常
java.sql.SQLException: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
解决方法：
在连接字符串后面加上?serverTimezone=UTC
Cannot instantiate object of type tk.mybatis.mapper.generator.MapperPlugin
自己的插件错误，后面发现是写入方法出错
Mybatis：逆向工程配合生成报Cannot instantiate object of type tk.mybatis.mapper.generator.
完整的引入代码如下
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>TestGenerator</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<!--mapper-->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>1.2.4</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.5</version>
<configuration>
<verbose>true</verbose>
<overwrite>true</overwrite>
<configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
</configuration>
<dependencies>
<!--MyBatis Generator及工具-->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</build>
</project>
generatorConfig.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<context id="MysqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/>
<!-- 通用mapper所在目录 -->
<plugin type="tk.mybatis.mapper.generator.MapperPlugin">
<property name="mappers" value="com.test.my.mapper.MyMapper"/>
</plugin>
<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/tecsun?serverTimezone=UTC"
userId="root"
password="123456">
</jdbcConnection>
<!-- 对应生成的pojo所在包 -->
<javaModelGenerator targetPackage="com.imooc.pojo" targetProject="src/main/java"/>
<!-- 对应生成的mapper所在目录 -->
<sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>
<!-- 配置mapper对应的java映射 -->
<javaClientGenerator targetPackage="com.imooc.mapper" targetProject="src/main/java" type="XMLMAPPER"/>
<!-- 数据库表 -->
<table tableName="usr"></table>
</context>
</generatorConfiguration>
Swagger2具体问题
在Swagger2的文档中，requestparam与requestbody无法一起使用，需要今晚进行接口查看。
swagger2中并不支持@RequestPrams 和@RequestBody一起使用，然后测试接口。
它会只发送一次json数据,但是我们平时使用的话,如果在url上拼接上requestparam是可以使用的。这是swagger2的局促。
保存评论列表的接口
以及修改用户信息接口
Vue
Post请求和get请求写法
axios({
method: 'POST',
async: false, //false表示同步，true表示异步，默认为异步
url: 'http://localhost:8088/insertUsr',
data: {
"age":"123",
"description":"123",
"name":"123"
}
})
Maven
连接公司私库不成功
改正措施-将公司仓库id剔除mirrorOf
<mirror>
<id>huaweicloud</id>
<mirrorOf>*,!(此处为公司仓库id),!nexus</mirrorOf>
<url>https://mirrors.huaweicloud.com/repository/maven/</url>
</mirror>
多个jar包导入本地
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.7</source>
<target>1.7</target>
<compilerArguments>
<!-- <extdirs>${basedir}/WebRoot/WEB-INF/lib</extdirs> -->
<extdirs>${basedir}/src/main/webapp/WEB-INF/lib</extdirs>
</compilerArguments>
</configuration>
</plugin>
</plugins>
</build>
Elasticsearch-访问8080端口，却无法正常启动
安装了elasticSearch之后，经过一段时间之后，tomcat的服务就无法正常启动，进入到log日志中查看，发现说是地址被占用，然后心想杀死占用这个端口的进程就可以了。
01-Jun-2022 16:45:17.926 SEVERE [main] org.apache.catalina.util.LifecycleBase.handleSubClassException Failed to initialize component [Connector[HTTP/1.1-8088]]
org.apache.catalina.LifecycleException: Protocol handler initialization failed
at org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:533)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:1059)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.startup.Catalina.load(Catalina.java:584)
at org.apache.catalina.startup.Catalina.load(Catalina.java:607)
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 org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:304)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:474)
Caused by: java.net.BindException: Address already in use
at sun.nio.ch.Net.bind0(Native Method)
at sun.nio.ch.Net.bind(Net.java:433)
at sun.nio.ch.Net.bind(Net.java:425)
at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:230)
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:213)
at org.apache.tomcat.util.net.AbstractEndpoint.bindWithCleanup(AbstractEndpoint.java:1124)
at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1137)
at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:574)
at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:74)
at org.apache.catalina.connector.Connector.initInternal(Connector.java:980)
... 13 more
lsof -i tcp:xxxx（进程号），重启tomcat还是不行。现在开始寻坑之旅
通过百度还有google查询
ps -ef|grep java
root 2659 28686 0 17:18 pts/0 00:00:00 grep --color=auto java
root *********** 明显不是tomcat ******
ps -ef|grep tomcat
root 2821 28686 0 17:18 pts/0 00:00:00 grep --color=auto tomcat
正常启动
ps -ef|grep java
root 2355 1 31 17:18 pts/0 00:00:03 /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.282.b08-1.el7_9.x86_64/bin/java -Djava.util.logging.config.file=/root/apache-tomcat-8.5.65/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Dignore.endorsed.dirs= -classpath /root/apache-tomcat-8.5.65/bin/bootstrap.jar:/root/apache-tomcat-8.5.65/bin/tomcat-juli.jar -Dcatalina.base=/root/apache-tomcat-8.5.65 -Dcatalina.home=/root/apache-tomcat-8.5.65 -Djava.io.tmpdir=/root/apache-tomcat-8.5.65/temp org.apache.catalina.startup.Bootstrap start
root 2659 28686 0 17:18 pts/0 00:00:00 grep --color=auto java
ps -ef|grep tomcat
root 2355 1 19 17:18 pts/0 00:00:03 /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.282.b08-1.el7_9.x86_64/bin/java -Djava.util.logging.config.file=/root/apache-tomcat-8.5.65/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Dignore.endorsed.dirs= -classpath /root/apache-tomcat-8.5.65/bin/bootstrap.jar:/root/apache-tomcat-8.5.65/bin/tomcat-juli.jar -Dcatalina.base=/root/apache-tomcat-8.5.65 -Dcatalina.home=/root/apache-tomcat-8.5.65 -Djava.io.tmpdir=/root/apache-tomcat-8.5.65/temp org.apache.catalina.startup.Bootstrap start
root 2821 28686 0 17:18 pts/0 00:00:00 grep --color=auto tomcat
这就发现异常情况了。
然后尝试关闭tomcat
./shutdown.sh
Using CATALINA_BASE: /root/apache-tomcat-8.5.65
Using CATALINA_HOME: /root/apache-tomcat-8.5.65
Using CATALINA_TMPDIR: /root/apache-tomcat-8.5.65/temp
Using JRE_HOME: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.282.b08-1.el7_9.x86_64
Using CLASSPATH: /root/apache-tomcat-8.5.65/bin/bootstrap.jar:/root/apache-tomcat-8.5.65/bin/tomcat-juli.jar
Using CATALINA_OPTS: /root/soft/tomcat/apache-tomcat-7.0.57/bin/catalina.sh: line 385: soft/jdk/jdk1.7.0_71/jre/bin/java: 文件或目录不存在
修改环境配置文件
vim /etc/profile
export JAVA_HOME=/usr/java/jdk1.8.0_191
export CLASSPATH=.:%JAVA_HOME/lib/dt.jar:%JAVA_HOME%/lib/tools.jar
export PATH=$PATH:$JAVA_HOME/bin
source /etc/profile
export JAVA_HOME=/usr/java/jdk1.8.0_121
export JRE_HOME=$JAVA_HOME/jreexport CLASSPATH=.:$JAVA_HOME/lib:$JRE_HOME/lib
export PATH=$JAVA_HOME/bin:$PATH
source /etc/profile
重新启动tomcat就可以了
本地从SVN中导入的文件如何在IDEA中加入版本控制
IDEA->File->Version Control->
打开alt+9 查看是否已经加入版本控制
IDEA/@value 没有映射相关数据
yml文件不参与映射文件数据
