<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[骑着蜗牛的coder]]></title><description><![CDATA[记录一名coder的日常。]]></description><link>https://blog.youkuaiyun.com/kingdaqi</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; kingdaqi]]></copyright><item><title><![CDATA[idea打包install 怎么跳过测试TEST模块]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114333611</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114333611</guid><author>kingdaqi</author><pubDate>Wed, 03 Mar 2021 20:31:20 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[spring集成mybatis后怎么在控制台打印sql语句]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114059764</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114059764</guid><author>kingdaqi</author><pubDate>Thu, 25 Feb 2021 09:21:20 +0800</pubDate><description><![CDATA[spring集成mybatis后怎么在控制台打印sql语句

1、applicationContext.xml中的sqlSessionFactory下增加下述标红部分属性

&lt;bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"&gt;
  &lt;property name="dataSource" ref="testDataSource" /&gt;
  &lt;!-- 自动...]]></description><category></category></item><item><title><![CDATA[各常用数据库驱动]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114059482</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114059482</guid><author>kingdaqi</author><pubDate>Thu, 25 Feb 2021 09:16:24 +0800</pubDate><description><![CDATA[各常用数据库驱动

Oracle数据库:

 驱动程序包名：ojdbc14.jar

 驱动类的名字：oracle.jdbc.driver.OracleDriver

JDBC URL：jdbc:oracle:thin:@dbip:port:databasename

说明：驱动程序包名有可能会变

JDBC URL中各个部分含义如下：

dbip–为数据库服务器的IP地址，如果是本地可写：localhost或127.0.0.1。

port–为数据库的监听端口，需要看安装时的配置，缺省为...]]></description><category></category></item><item><title><![CDATA[数据库连接超时Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes,...]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405229</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405229</guid><author>kingdaqi</author><pubDate>Thu, 14 May 2020 10:01:00 +0800</pubDate><description><![CDATA[错误分析:  数据库连接已经关闭或者失效后仍然在执行操作,导致:mysql服务没返回数据   1.客户端连接池中连接，已经失效；但是：连接池还没有检测到；当操作数据库时，启用该连接，抛出该错误  2.mysql服务器，已关闭该连接，但：客户端连接池中该连接，尚未检测到。当用该连接操作数据库时，抛出该错。处理办法：  1.每次连接操作数据库时，检测：该连接的有效性　　　　&...]]></description><category></category></item><item><title><![CDATA[mysql数据库索引简述]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405228</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405228</guid><author>kingdaqi</author><pubDate>Thu, 30 Apr 2020 14:16:00 +0800</pubDate><description><![CDATA[索引分类：

普通索引：即一个索引只包含单个列，一个表可以有多个单列索引
唯一索引：索引列的值必须唯一，但允许有空值
复合索引：即一个索引包含多个列
聚簇索引(聚集索引)：并不是一种单独的索引类型，而是一种数据存储方式。具体细节取决于不同的实现，InnoDB的聚簇索引其实就是在同一个结构中保存了B-tree索引(技术上来说是B+tree)和数据行。
非聚簇索引：不是聚簇索引，就是非聚簇索引

主...]]></description><category></category></item><item><title><![CDATA[mysql查询慢，如何优化mysql]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405227</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405227</guid><author>kingdaqi</author><pubDate>Thu, 30 Apr 2020 13:55:00 +0800</pubDate><description><![CDATA[思路：
1、服务器硬件优化，比如机械硬盘换成固态硬盘，更换CPU，增加运行内存2、mysql服务器优化，window服务器换成linux服务器，不过一般企业级标配都是linux3、sql本身优化，利用关联查询，连接等，避免子查询嵌套4、反范式设计优化5、索引优化
其中4、反范式设计优化，允许存在适当冗余，通俗说使用表空间换取查询时间
数据库设计三大范式：
一、第一大范式
1、数据库表中的所有字段...]]></description><category></category></item><item><title><![CDATA[用Navicat运行一个比较大的.sql文件时报错：[Err] 2006 - MySQL server has gone away]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405226</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405226</guid><author>kingdaqi</author><pubDate>Wed, 11 Dec 2019 17:44:00 +0800</pubDate><description><![CDATA[https://blog.youkuaiyun.com/qq_34528297/article/details/88384452
]]></description><category></category></item><item><title><![CDATA[macOS 利用SecureCRT 的rz命令上传文件到linux或者下载]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405225</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405225</guid><author>kingdaqi</author><pubDate>Wed, 11 Dec 2019 16:03:00 +0800</pubDate><description><![CDATA[中文版目录设置：   点开 secureCRT 的菜单项中的【选项】 --&gt; 会话选项 --&gt; 打开会话选项对话框 --&gt;点击分类中的的终端 --&gt; X/Y/Zmodem 英文版目录设置：  Options --&gt; session options --&gt; terminal --&gt; X/Y/Zmodem

 点开之后即可找到上传下载的目录位...]]></description><category></category></item><item><title><![CDATA[javax.naming.NamingException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver']]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405223</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405223</guid><author>kingdaqi</author><pubDate>Tue, 28 May 2019 10:58:00 +0800</pubDate><description><![CDATA[解决办法：
　　Tomcat服务器的根目录下也有一个lib目录,也要把mysql的驱动包放进去
]]></description><category></category></item><item><title><![CDATA[mysql无法启动，Can't create/write to file '/usr/local/mysql/data/izj6c27p7s8o9f4pp58o3fz.pid']]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405222</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405222</guid><author>kingdaqi</author><pubDate>Wed, 22 May 2019 18:04:00 +0800</pubDate><description><![CDATA[2019-05-22 17:52:24 4014 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/izj6c27p7s8o9f4pp58o3fz.pid' (Errcode: 13 - Permission denied)2019-05-22 17:52:24 4014 ...]]></description><category></category></item><item><title><![CDATA[IDEA创建SpringBoot无法连接https://start.spring.io]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405245</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405245</guid><author>kingdaqi</author><pubDate>Thu, 16 May 2019 13:56:00 +0800</pubDate><description><![CDATA[IDEA创建SpringBoot无法连接的错误，解决办法：进入到IDEA的setting 搜索HTTP Proxy 选择Auto-detect proxy settings点击最下面的Check connection弹出如下的输入框，输入地址https://start.spring.io点击ok，如果successful证明连接成功，重新生成一次，完美生成springboot项目
...]]></description><category></category></item><item><title><![CDATA[windows.onload]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405244</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405244</guid><author>kingdaqi</author><pubDate>Wed, 15 May 2019 10:20:00 +0800</pubDate><description><![CDATA[1.页面加载后完成
windows.onload = function(){
alert("执行")；
}
2.页面加载前完成
$(document).ready(function() {
alert("执行")；
}
**：需要注意的是，如果在函数中有ajax方法，
问题一：今天一直想不通的问题，我的ajax明明在页面前面为什么直到我的页面代码都执行完了我的后台数据才获取，然而，此时的数据已经...]]></description><category></category></item><item><title><![CDATA[display属性值及含义]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405242</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405242</guid><author>kingdaqi</author><pubDate>Wed, 15 May 2019 10:19:00 +0800</pubDate><description><![CDATA[一般都是用display:none和display:block来控制层的显示。
document.getElementById('div1').style.display='none';//隐藏。
document.getElementById('div1').style.display='inline';//内联模式显示，会和周围的元素在一行(不会换行)。
document.getEleme...]]></description><category></category></item><item><title><![CDATA[centos系统中不能执行rz命令导入数据时]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405241</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405241</guid><author>kingdaqi</author><pubDate>Wed, 15 May 2019 10:17:00 +0800</pubDate><description><![CDATA[执行yum install lrzsz
]]></description><category></category></item><item><title><![CDATA[linux系统中安装jdk后，使用java -version查看版本，报错]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405240</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405240</guid><author>kingdaqi</author><pubDate>Wed, 15 May 2019 10:16:00 +0800</pubDate><description><![CDATA[问题：linux系统中安装jdk后，使用java -version查看版本，报错
-bash: /usr/local/jdk/jdk1.8.0_181/bin/java: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory
解决方法：
执行命令：sudo yum install glibc.i686
执行后，再使用...]]></description><category></category></item><item><title><![CDATA[Linux防火墙iptables管理端口]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405238</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405238</guid><author>kingdaqi</author><pubDate>Wed, 15 May 2019 10:15:00 +0800</pubDate><description><![CDATA[1、iptables -nvL 查看防火墙端口放开情况
2、vim /etc/sysconfig/iptables 编辑防火墙配置文件
内容如下
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [1067:161140]
-A INPUT -p tcp -m tcp --dport 80 -j ACCEPT
-A ...]]></description><category></category></item><item><title><![CDATA[<context:annotation-config>和 <context:component-scan>区别]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405236</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405236</guid><author>kingdaqi</author><pubDate>Thu, 14 Jun 2018 10:07:00 +0800</pubDate><description><![CDATA[&lt;context:annotation-config&gt;:注解扫描是针对已经在Spring容器里注册过的Bean
&lt;context:component-scan&gt;:不仅具备&lt;context:annotation-config&gt;的所有功能，还可以在指定的package下面扫描对应的bean
&lt;context:annotation-config /&gt;和...]]></description><category></category></item><item><title><![CDATA[数据库驱动]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405235</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405235</guid><author>kingdaqi</author><pubDate>Wed, 16 May 2018 17:36:00 +0800</pubDate><description><![CDATA[数据库驱动
最常用的就是"org.gjt.mm.mysql.Driver"和"com.mysql.jdbc.Driver"，它们可以正常实现连接，但有一些区别。 另外还有几个驱动名：com.mysql.jdbc.NonRegisteringDriver，com.mysql.jdbc.NonRegisteringReplicationDriver，com.mysql.jdbc.Replicatio...]]></description><category></category></item><item><title><![CDATA[spring quartz定时 注入失败]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405234</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405234</guid><author>kingdaqi</author><pubDate>Mon, 30 Apr 2018 21:41:00 +0800</pubDate><description><![CDATA[&lt;?xml version="1.0" encoding="UTF-8" ?&gt;
&lt;beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.o...]]></description><category></category></item><item><title><![CDATA[json对象的遍历]]></title><link>https://blog.youkuaiyun.com/kingdaqi/article/details/114405250</link><guid>https://blog.youkuaiyun.com/kingdaqi/article/details/114405250</guid><author>kingdaqi</author><pubDate>Mon, 30 Apr 2018 21:40:00 +0800</pubDate><description><![CDATA[JSONArray jsonArraySeriesSubs = jsonObject.getJSONArray("seriesSub");
for(int i=0;i&lt;jsonArraySeriesSubs.size();i++){
JSONObject jsonObjectSeriesSub = jsonArraySeriesSubs.getJSONObject(i);
}
]]></description><category></category></item></channel></rss>