<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[天籁]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/GoodLuckToThePole</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; GoodLuckToThePole]]></copyright><item><title><![CDATA[mysqldump导入、导出DB数据]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/106211255</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/106211255</guid><author>GoodLuckToThePole</author><pubDate>Tue, 19 May 2020 11:46:27 +0800</pubDate><description><![CDATA[查mysqldump路径：

whereis mysql

一、mysql dump导出db data

/opt/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqldump -u root -pAaaa1111 metro_scm &gt; /usr/local/metro_scm_20200519.sql

说明：

/opt/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqldump ：mysqldump路径

metro]]></description><category></category></item><item><title><![CDATA[ORACLE-over()函数用法]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/77770750</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/77770750</guid><author>GoodLuckToThePole</author><pubDate>Fri, 01 Sep 2017 11:13:07 +0800</pubDate><description><![CDATA[ORACLE-over()函数用法
  select annual_rate, invest_amount, self_amt from busi_order_bak;
SQL> select annual_rate, invest_amount, self_amt from busi_order_bak;ANNUAL_RATE     INVEST_AMOUNT          SELF_AMT]]></description><category></category></item><item><title><![CDATA[Apache Ant的基本用法]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75544780</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75544780</guid><author>GoodLuckToThePole</author><pubDate>Thu, 20 Jul 2017 16:31:16 +0800</pubDate><description><![CDATA[打印&变量    <?xml version="1.0"?>  
    <project name="HelloWorld" default="test" basedir="">  
        <target name="test">  
            <echo message="test echo messsage, basedir=${basedir}" />]]></description><category></category></item><item><title><![CDATA[springmvc项目创建]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75351824</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75351824</guid><author>GoodLuckToThePole</author><pubDate>Wed, 19 Jul 2017 11:22:05 +0800</pubDate><description><![CDATA[一、项目创建 
二、设置字节码文件class生成路径三、设置编码四、导包五、配置web.xml<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web=]]></description><category></category></item><item><title><![CDATA[ORACLE：阻塞]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75246497</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75246497</guid><author>GoodLuckToThePole</author><pubDate>Mon, 17 Jul 2017 15:50:28 +0800</pubDate><description><![CDATA[ORACLE：阻塞update、delete、for update都具有阻塞。 
阻塞使用场景案例： 
主线程执行逻辑，更新表trade_type_test，开辟新线程导出数据后，查询数据，查询的数据是主线程更新状态后的数据，而不是更新状态前的数据。 
一、如果子线程查询数据，不使用阻塞，则可能会出现主线程更新数据，还没有提交，而子线程执行速度很快，已经执行到了查询这一步的情况下，导致查询出来的数据]]></description><category></category></item><item><title><![CDATA[SRPING:定时器并发问题]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75222645</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75222645</guid><author>GoodLuckToThePole</author><pubDate>Mon, 17 Jul 2017 12:02:29 +0800</pubDate><description><![CDATA[SRPING:定时器并发问题PUSH_BIRTH_MSG_TEST表status=’1’的数据共19条SQL>       select ID, USER_ID, STATUS
  2        from PUSH_BIRTH_MSG_TEST
  3        where STATUS = '1'
  4        order by ID
  5      fetch next 50]]></description><category></category></item><item><title><![CDATA[Oracle：触发器]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75113958</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75113958</guid><author>GoodLuckToThePole</author><pubDate>Fri, 14 Jul 2017 15:09:20 +0800</pubDate><description><![CDATA[Oracle：触发器说明：oracle触发器，对指定表进行增删改操作，触发逻辑操作。SQL> create or replace trigger agreement_trigger
  2    after update or insert or delete on base_agreement_template_test
  3    for each row
  4  begin
  5]]></description><category></category></item><item><title><![CDATA[SPRING：定时器]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75066717</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75066717</guid><author>GoodLuckToThePole</author><pubDate>Thu, 13 Jul 2017 15:15:39 +0800</pubDate><description><![CDATA[SPRING：定时器项目结构 
applicationContext.xml<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xml]]></description><category></category></item><item><title><![CDATA[org.springframework.beans.factory.parsing.BeanDefinitionParsingException&更换jdk]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75058295</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/75058295</guid><author>GoodLuckToThePole</author><pubDate>Thu, 13 Jul 2017 14:45:02 +0800</pubDate><description><![CDATA[org.springframework.beans.factory.parsing.BeanDefinitionParsingException&更换jdklog4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
log4j:WARN Please ini]]></description><category></category></item><item><title><![CDATA[ORACLE：加字段、加字段描述、验证字段JSON格式]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74990376</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74990376</guid><author>GoodLuckToThePole</author><pubDate>Tue, 11 Jul 2017 17:53:49 +0800</pubDate><description><![CDATA[ORACLE：加字段、加字段说明、验证字段JSON格式SQL> SELECT * FROM T_POINT_GRADE_KG_TEST;GRADE      IS_SEND    SMS_CONTENT
---------- ---------- -----------------------------------------------------------------------------]]></description><category></category></item><item><title><![CDATA[ORACLE：复制表]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74989788</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74989788</guid><author>GoodLuckToThePole</author><pubDate>Tue, 11 Jul 2017 17:14:42 +0800</pubDate><description><![CDATA[ORACLE：复制表表：T_POINT_GRADE_KG_TESTSQL> SELECT * FROM T_POINT_GRADE_KG_TEST;GRADE      IS_SEND    SMS_CONTENT
---------- ---------- -----------------------------------------------------------------------]]></description><category></category></item><item><title><![CDATA[ORACLE：prompt、set feedback、set define]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74986675</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74986675</guid><author>GoodLuckToThePole</author><pubDate>Tue, 11 Jul 2017 16:47:05 +0800</pubDate><description><![CDATA[ORACLE：prompt、set feedback、set defineprompt PL/SQL Developer import file
prompt Created on 2017年7月7日 by admin
set feedback off
set define off
prompt Deleting BLSC.CONFIG_SMS...
delete from BLSC.CONFIG_]]></description><category></category></item><item><title><![CDATA[ORACLE PLSQL解析JSON]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74929818</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74929818</guid><author>GoodLuckToThePole</author><pubDate>Mon, 10 Jul 2017 16:32:38 +0800</pubDate><description><![CDATA[ORACLE PLSQL解析JSON下载pljson 
地址：https://github.com/pljson/pljson 
 
打开command window 
执行：SQL> @C:\pljson-master\install.sql;select grade, content from shop.t_point_grade_kg where grade = 1;
  grade
  co]]></description><category></category></item><item><title><![CDATA[springmvc拦截器配置]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74526706</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74526706</guid><author>GoodLuckToThePole</author><pubDate>Thu, 06 Jul 2017 10:30:31 +0800</pubDate><description><![CDATA[<mvc:interceptors>
        <mvc:interceptor>
            <mvc:mapping path="/**" />
            <bean class="com.springmvc.intercepter.FirstInterceptor" />
        </mvc:interceptor>
        <mvc:inter]]></description><category></category></item><item><title><![CDATA[springmvc拦截器和拦截器执行顺序]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74518921</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74518921</guid><author>GoodLuckToThePole</author><pubDate>Thu, 06 Jul 2017 09:57:46 +0800</pubDate><description><![CDATA[springmvc拦截器和拦截器执行顺序HandlerInterceptor和HandlerInterceptorAdapter 
HandlerInterceptor接口，子类实现后要实现接口中所有方法。 
HandlerInterceptorAdapter抽象类，子类继承后重写需要使用到的方法即可。
  自定义拦截器执行顺序
自定义拦截器FirstInterceptor：public class]]></description><category></category></item><item><title><![CDATA[隐私窗口]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74517606</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74517606</guid><author>GoodLuckToThePole</author><pubDate>Thu, 06 Jul 2017 09:31:03 +0800</pubDate><description><![CDATA[隐私窗口隐私窗口进行测试，清浏览器缓存，避免反复测试查不出BUG是因为浏览器缓存导致。 
FireFox：]]></description><category></category></item><item><title><![CDATA[RESTClient插件]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74517023</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74517023</guid><author>GoodLuckToThePole</author><pubDate>Thu, 06 Jul 2017 09:19:13 +0800</pubDate><description><![CDATA[RESTClient插件客户端POST&GET提交，调用接口和测试接口使用。]]></description><category></category></item><item><title><![CDATA[Chrome和FireFox调试js代码]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74454741</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74454741</guid><author>GoodLuckToThePole</author><pubDate>Wed, 05 Jul 2017 16:37:30 +0800</pubDate><description><![CDATA[Chrome调试js代码FireFox]]></description><category></category></item><item><title><![CDATA[springmvc文件上传]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74452893</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74452893</guid><author>GoodLuckToThePole</author><pubDate>Wed, 05 Jul 2017 16:05:43 +0800</pubDate><description><![CDATA[<div>
    <input type="file" id="file" name="file" multiple="true" />
    <button type="button" onclick="upload();">upload</button>
</div>        function upload(){
            var file=$("#file").val(]]></description><category></category></item><item><title><![CDATA[springmvc Restful风格]]></title><link>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74294478</link><guid>https://blog.youkuaiyun.com/GoodLuckToThePole/article/details/74294478</guid><author>GoodLuckToThePole</author><pubDate>Tue, 04 Jul 2017 10:23:59 +0800</pubDate><description><![CDATA[springmvc Restful风格@Controller
@RequestMapping(value = "/agreement")
public class AgreementTemplateController {
    @RequestMapping(value="/agreementTemplate", method=RequestMethod.GET)
    public Stri]]></description><category></category></item></channel></rss>