<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[一见如故的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sinat_23900151</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sinat_23900151]]></copyright><item><title><![CDATA[JAVA代码优化]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/126579647</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/126579647</guid><author>sinat_23900151</author><pubDate>Mon, 29 Aug 2022 13:26:38 +0800</pubDate><description><![CDATA[JAVA代码优化，list的流操作]]></description><category></category></item><item><title><![CDATA[Linux常用命令]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/126537642</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/126537642</guid><author>sinat_23900151</author><pubDate>Fri, 26 Aug 2022 10:06:33 +0800</pubDate><description><![CDATA[Linux常用命令]]></description><category></category></item><item><title><![CDATA[Swagger常用注解]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/124997569</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/124997569</guid><author>sinat_23900151</author><pubDate>Sat, 28 May 2022 09:43:47 +0800</pubDate><description><![CDATA[SwaggerAPI常用注解Swagger简介类注解@Api@ApiModel方法注解@ApiImplicitParam@ApiImplicitParams@ApiModelProperty@ApiOperation@ApiResponse@ApiResponses@ApiParam@Authorization@AuthorizationScope@ResponseHeader
Swagger简介
Swagger 是一个规范和完整的框架，用于生成、描述、调用和可视化 RESTful 风格的 Web 服务。总]]></description><category></category></item><item><title><![CDATA[SQLSERVER开启CDC]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/116653516</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/116653516</guid><author>sinat_23900151</author><pubDate>Tue, 11 May 2021 14:22:31 +0800</pubDate><description><![CDATA[SQLSERVER开启CDC：
IF EXISTS(SELECT 1 FROM sys.tables WHERE name='t_member_rec_official' AND is_tracked_by_cdc = 0)
BEGIN
	EXEC sys.sp_cdc_enable_table
	@source_schema = 'dbo', 
	@source_name = 't_member_rec_official',
	@capture_instance = NULL, 
	@supports_n]]></description><category></category></item><item><title><![CDATA[查看是否有阻塞 如果当前SQLSERVER里面没有任何等待资源，那么下面的SQL语句不会显示任何结果]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/116653160</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/116653160</guid><author>sinat_23900151</author><pubDate>Tue, 11 May 2021 14:16:11 +0800</pubDate><description><![CDATA[查看是否有阻塞
如果当前SQLSERVER里面没有任何等待资源，那么下面的SQL语句不会显示任何结果
SELECT TOP 10
 [session_id],
 [request_id],
 [start_time] AS '开始时间',
 [status] AS '状态',
 [command] AS '命令',
 dest.[text] AS 'sql语句',
 DB_NAME([database_id]) AS '数据库名',
 [blocking_session_id] AS '正在阻塞其他会话的会]]></description><category></category></item><item><title><![CDATA[查找目前SQL Server所执行的SQL语法，并展示资源情况：]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/114319269</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/114319269</guid><author>sinat_23900151</author><pubDate>Wed, 03 Mar 2021 15:47:45 +0800</pubDate><description><![CDATA[查找目前SQLServer所执行的SQL语法，并展示资源情况：
SELECT
s2.dbid,
DB_NAME(s2.dbid)AS[数据库名],
--s1.sql_handle,
(
SELECT
TOP1SUBSTRING(
s2.text,
statement_start_offset/2+1,
(
(
CASE

WHE...]]></description><category></category></item><item><title><![CDATA[ApplicationEventMulticaster not initialized - call ‘refresh‘ before multicasting events via the cont]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/102309005</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/102309005</guid><author>sinat_23900151</author><pubDate>Mon, 07 Oct 2019 15:18:37 +0800</pubDate><description><![CDATA[SSH框架 报如下错误：

java.lang.IllegalStateException: ApplicationEventMulticaster not initialized - call 'refresh' before multicasting events via the context: Root WebApplicationContext: startup date [Mon Oc...]]></description><category></category></item><item><title><![CDATA[IDEA快捷键]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017893</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017893</guid><author>sinat_23900151</author><pubDate>Thu, 28 Feb 2019 10:55:28 +0800</pubDate><description><![CDATA[动作
			快捷键
			说明
		Move Caret to Code Block End
			Ctrl+]
			诸如{}围起来的代码块，使用该快捷键可以快速跳转至代码块的结尾处
		Move Caret to Code Block Start
			Ctrl+[
			同上，快速跳至代码块的开始出
		Complete Current Statement
			Ctrl+Shift+Ent...]]></description><category></category></item><item><title><![CDATA[JAVA时间类型处理]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017772</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017772</guid><author>sinat_23900151</author><pubDate>Thu, 28 Feb 2019 10:51:08 +0800</pubDate><description><![CDATA[new java.sql.Date(new java.util.Date().getTime()  获得当前时间 返回java.sql.date类型 存库只有年月日



Calendar calendar = Calendar.getInstance();

new java.sql.Timestamp(calendar.getTime().getTime())获得当前时间 返回...]]></description><category></category></item><item><title><![CDATA[数据库里面值重复怎么办？]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017729</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017729</guid><author>sinat_23900151</author><pubDate>Thu, 28 Feb 2019 10:50:06 +0800</pubDate><description><![CDATA[当数据库里面的值重复怎么办？单独删一条删不掉

新建一个结构一样的空表，然后用旧表数据像新表里面插入ID字段，注意要group by 一下重复的数据 例如：

insert into A_copy(id) ( select id fromA group by id)

添加完新表的ID后 然后根据ID更新成旧表的数据 即可



注意：

新表设置主键...]]></description><category></category></item><item><title><![CDATA[Oracle 11g报ORA-01034和ORA-27101的错误]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017621</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/88017621</guid><author>sinat_23900151</author><pubDate>Thu, 28 Feb 2019 10:48:11 +0800</pubDate><description><![CDATA[通常这种错误是因为服务器为非正常关闭导致的，解决方法如下：

使用sqlplus连接oracle，提示ORA-01034和ORA-27101，具体内容如下：


ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial...]]></description><category></category></item><item><title><![CDATA[IDEA导入SSH项目用Tomcat运行]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/86086668</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/86086668</guid><author>sinat_23900151</author><pubDate>Tue, 08 Jan 2019 17:43:52 +0800</pubDate><description><![CDATA[这里用SVN检出的SSH项目：



导入完成后，选中项目点击按钮配置，按钮在右上角：





Modules配置：



一个项目中可以有多个子项目，每个子项目相当于一个模块。一般我们项目只是单独的一个，IDEA 默认也是单子项目的形式，所以只需要配置一个模块。

下面是配置依赖包：



配置web.xml:



注意web.xml的路径，修改成你项目的路径如下：



项目部署：



...]]></description><category></category></item><item><title><![CDATA[SqlServer数据库分离和附加]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/80661573</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/80661573</guid><author>sinat_23900151</author><pubDate>Tue, 12 Jun 2018 10:12:39 +0800</pubDate><description><![CDATA[在导入数据库乱码不知道怎么处理，或者导入数据量比较大的情况下推荐使用此方法进行数据库导入导出。1、数据库分离，分离路径一般为：C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA2、数据库附加（还原），注意需要mdf文件和ldf文件同时都有3、如果数据库比较大，则对数据库log进行简化，对数据进行收缩可减小体...]]></description><category></category></item><item><title><![CDATA[SQLserver新安装其他电脑连接不了]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/80661529</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/80661529</guid><author>sinat_23900151</author><pubDate>Tue, 12 Jun 2018 10:11:13 +0800</pubDate><description><![CDATA[对于新安装的SQLserver数据库，一定要注意以下地方：     设置对外IP启用，不然默认四个小时候之后其他电脑访问不了数据库下面是设置方法：打开SQL Server 配置管理器选择网络配置  TCP/IP查看属性其中IP1,IP2,IP3,IP4在启用一栏中选择启用 注：启用之后需要重启下SQLSERVER服务！...]]></description><category></category></item><item><title><![CDATA[jxl warning: Maximum number of format records exceeded 格式记录数超出最大数限制]]></title><link>https://blog.youkuaiyun.com/sinat_23900151/article/details/80495854</link><guid>https://blog.youkuaiyun.com/sinat_23900151/article/details/80495854</guid><author>sinat_23900151</author><pubDate>Tue, 29 May 2018 14:27:14 +0800</pubDate><description><![CDATA[采用jxl处理 excel文件生成时，产生如下报错：查看生产Excel部分代码，在添加单元格时，需要提供相关格式信息。因此，在for循环内部，new了很多WritableCellFormat对象出来，以至于超过jxl内部约束的format records最大数限制。原因：jxl允许的每个workbook（一个excel文件）中的WritableCellFormat对象个数不超过441个,超过部分的...]]></description><category></category></item></channel></rss>