<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cookie151的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cookie151</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cookie151]]></copyright><item><title><![CDATA[MyBatis拦截器对update,insert拦截.]]></title><link>https://blog.youkuaiyun.com/cookie151/article/details/100020354</link><guid>https://blog.youkuaiyun.com/cookie151/article/details/100020354</guid><author>cookie151</author><pubDate>Thu, 22 Aug 2019 17:42:10 +0800</pubDate><description><![CDATA[1.自定义拦截器类实现org.apache.ibatis.plugin.Interceptor接口.


import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.SqlCommandType;
imp...]]></description><category></category></item><item><title><![CDATA[Hibernate使用中文排序.]]></title><link>https://blog.youkuaiyun.com/cookie151/article/details/77649526</link><guid>https://blog.youkuaiyun.com/cookie151/article/details/77649526</guid><author>cookie151</author><pubDate>Mon, 28 Aug 2017 15:44:58 +0800</pubDate><description><![CDATA[Mysql在使用utf-8字符集的时候,不能正确的以中文进行排序.
所以得强制mysql进行中文排序

select * from table ORDER BY CONVERT(column USING gbk);
但是hql并不支持 CONVERT这个语法.所以得改变hibernate的方言(hibernate.dialect)将它设置为我们自定义的dialect.
package c]]></description><category></category></item><item><title><![CDATA[CsvWriter导出CSV文件.]]></title><link>https://blog.youkuaiyun.com/cookie151/article/details/77643704</link><guid>https://blog.youkuaiyun.com/cookie151/article/details/77643704</guid><author>cookie151</author><pubDate>Mon, 28 Aug 2017 10:38:50 +0800</pubDate><description><![CDATA[第一次使用CsvWriter做导出功能.记录一下方便日后查看.

1.因业务需求需要导出当前页面展示的内容.所以不能直接导出数据库的全部内容.需要根据当前的查询条件进行查询再导出.所以需要在前端页面先封装好查询条件带到后台去.

2.在后台使用CsvWriter来进行CSV文件的写出. 
CsvWriter有四个构造器,在这用的是

public CsvWriter（String  ]]></description><category></category></item><item><title><![CDATA[或许你不知道的10条SQL技巧]]></title><link>https://blog.youkuaiyun.com/cookie151/article/details/75258601</link><guid>https://blog.youkuaiyun.com/cookie151/article/details/75258601</guid><author>cookie151</author><pubDate>Mon, 17 Jul 2017 18:10:56 +0800</pubDate><description><![CDATA[一、一些常见的SQL实践

（1）负向条件查询不能使用索引



select * from order where status!=0
 and stauts!=1


not in/not exists都不是好习惯




可以优化为in查询：



select * from order where status in(2,3)


 

（2]]></description><category></category></item><item><title><![CDATA[Javadoc注释的用法]]></title><link>https://blog.youkuaiyun.com/cookie151/article/details/74531328</link><guid>https://blog.youkuaiyun.com/cookie151/article/details/74531328</guid><author>cookie151</author><pubDate>Thu, 06 Jul 2017 11:44:06 +0800</pubDate><description><![CDATA[Javadoc注释的用法

 

相关阅读：http://blog.163.com/hui_san/blog/static/5710286720104191100389/ 


Java 文档

// 注释一行
/* ...... */ 注释若干行
/** ...... */ 注释若干行，并写入 javadoc 文档

通常这种注释的多行写法如下：

/**
* .]]></description><category></category></item></channel></rss>