记事本

-------------------------------------------------------------------------------------
excel脚本：
="insert into plf_pur_warehouse_contact(id,factory_code,whouse_code,emp_no,emp_name,emp_tel,emp_email) values(REPLACE(UUID(),'-',''),'"&B2&"','"&D2&"','"&H2&"','"&I2&"','"&J2&"','"&K2&"');"
然后下拉。
-------------------------------------------------------------------------------------
sql:
SET @int = (SELECT MAX(id) FROM um_user)
SELECT @int FROM um_user LIMIT 0,1
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
session里的值，可以在js里直接取值。
${key.value}
------------------------------------------------------
ie下，url含有中文：
var contactPerson=encodeURI(contactPerson);
---------------------------------------------------------
url含有&转义：
contactPerson = contactPerson.replace(/&/g,"%26");
--------------------------------------------------------------
内部类的方法调用外面的变量时，必须是final的。
--------------------------------------------------------------
接口里的方法默认都是public,所以不用写修饰符

---------------------------------------------------------
elipse使用：
//TODO 标记还需要完成的部分。（showview—task）
js代码行号前右键，add task。
---------------------------------------------------------
String idU = UUID.randomUUID().toString();
String id = idU.replaceAll("\\-", "");
-------------------------------------------------------------
奇葩问题：
url中有id字段时，有些框架会字段把值转换成int类型，
如果id字段值长度超过int范围，导致无法跳转
-------------------------------------------------------------
validator.js
-------------------------------------------------------------
sql语句：
SELECT
  t.ACTION_URL,
  t.HELP_URL,
  t.MODULE_CODE
FROM
  ts_module t
  JOIN ts_role b
    ON t.APP_TYPE = b.CREATE_TM
  JOIN ts_user c
    ON t.ACTION_UR = c.CREATE_TM
WHERE b.CREATE_TM = '2015-03' ;

UPDATE
  ts_log t
  JOIN ts_role c
    ON t.CHANNEL = c.CREATE_TM SET t.AFTER_CHANGE = ''
WHERE t.AFTER_CHANGE = '' ;

DELETE t FROM um_role t JOIN um_user c ON t.CREATE_TIME = c.CREATE_TIME WHERE t.ID = '';

三表联查：
SELECT
  *
FROM
  (
    plf_pur_delivery_notice_detail d
    JOIN plf_pur_delivery_plan p
      ON d.pur_order_no = p.pur_order_no
      AND d.line_item = p.line_item
  )
  JOIN plf_pur_delivery_notice_main m
    ON m.asn_no = d.asn_no
WHERE d.asn_no = 'ASN002'
--------------------------------------------------------------
单表查询：
SELECT
  mm.orderNo,
  mm.lineItem,
  SUM(mm.reAmount)
FROM
  (SELECT
    b.pur_order_no orderNo,
    b.line_item lineItem,
    b.reserve_amount reAmount
  FROM
    plf_pur_delivery_notice_detail b
  WHERE CONCAT(b.`pur_order_no`, b.`line_item`) IN
    (SELECT
      CONCAT(a.`pur_order_no`, a.`line_item`)
    FROM
      plf_pur_delivery_notice_detail a
    WHERE asn_no = 'ASN001'
    GROUP BY a.`pur_order_no`,
      a.`line_item`)
    AND b.suppler_confimr_status = 1) mm
GROUP BY mm.orderNo,
  mm.lineItem ;
-----------------------------------------------------------------------------------------------
复杂查询：
SELECT
  a.pur_order_no,
  a.line_item,
  a.material_code,
  a.unit,
  a.delivery_warehouse_code,
  a.promise_delivery_time,
  b.material_name,a.promise_delivery_amount,
  IFNULL(d.reserve_amount,0)
FROM
  plf_pur_delivery_plan a
  LEFT JOIN plf_pur_material_data b
    ON a.material_code = b.material_code
  LEFT JOIN
    (SELECT
      a.pur_order_no,
      a.line_item,
      SUM(c.reserve_amount)  reserve_amount
    FROM
      plf_pur_delivery_plan a
      INNER JOIN plf_pur_delivery_notice_detail c
        ON a.pur_order_no = c.pur_order_no
        AND a.line_item = c.line_item
    WHERE c.suppler_confimr_status = 1
    GROUP BY a.pur_order_no, a.line_item ) d
    ON a.pur_order_no = d.pur_order_no
    AND a.line_item = d.line_item  WHERE
      a.promise_delivery_amount > IFNULL(d.reserve_amount,0)
      AND a.promise_delivery_time = '2015-10-22'
      AND a.pur_order_no = 'order002' AND a.line_item='line3'

------------------------------------------------------------------------------------------
使用right join强制生成一条记录。
SELECT
IFNULL(SUM(k.received_amount), 0) sumAmount 
FROM
    (SELECT
      *
    FROM
      (SELECT
        i.pur_order_no,
        i.line_item,
        i.received_amount
      FROM
        plf_pur_delivery_notice_detail i
      WHERE i.pur_order_no = 'order002'
        AND i.line_item = 'line3') d
    GROUP BY d.pur_order_no,
      d.line_item) k   RIGHT JOIN (SELECT 1 AS c FROM DUAL ) t ON t.c = k.line_item;

--------------------------------------------------------------------------------------
关联查
SELECT
  *
FROM
  (SELECT
    p.id,
    p.pur_order_no,
    p.line_item,
    p.delivery_warehouse_code,
    p.supplier_code,
    s.name1
  FROM
    plf_pur_delivery_plan p
    LEFT JOIN plf_pur_supplierinfo s
      ON p.supplier_code = s.supp_code) pp
  LEFT JOIN plf_warehouse_master_data w
    ON pp.delivery_warehouse_code = w.whouse_code
WHERE pp.id = '7b091f958d0611e5b82e333018d85ce0'
-------------------------------------------------------------------------------------
mybatis判断字符串相等，必须这样：
妈蛋，
<if test='auditStatus == "1"'>
m.audit_status = '1', m.warehouse_remark = #{warehouseRemark}
</if>

---------------------------------------------------------------12USD
java日历：
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
Date date=sdf.parse(map.get("quantityTime"));
Calendar cal = Calendar.getInstance();
cal.setTime(date);
cal.set(cal.DATE, 1);
Date dateStart = cal.getTime();
cal.set(cal.DATE, cal.getActualMaximum(cal.DATE));
Date dateEnd = cal.getTime();

-------------------------
jpgrid:
sortname:'id',
sortorder:"desc",
---------------------------------------
mysql：
获取年和月： DATE_FORMAT(quantity_time,'%Y-%m')；

-----------------------
修改工程名：修改下面的两个build文件。
1.D:\zkwork\workspace\novatar-tax
2.D:\zkwork\workspace\novatar-tax\project\novatar-webapp
3.D:\zkwork\workspace\novatar-syn\settings
生成war包路径：gradle-build：D:\zkwork\workspace\novatar-tax\build\dist
-------------------------------------------------------------------------------
artdialog/jpgrid两个插件
--------------------------------------------------------------------------------
MySQL主机IP：10.202.4.48（mysql: jeffrey/init1234    jeffrey@10.118.12.23）
Jetty主机IP：10.202.10.31
sfapp/sf123456登录 再切换到  root/sf123456789

su - root;
cd /dba;
cd mysqlhome/;
cd 5.6.21/;
cd bin;
./mysql --socket=/tmp/mysqld_mysqldev.sock --port=3306 -uroot -pmysqldev;
-------------------------------------------------------------------------------------------------------------------
create database `mysqldb`character set utf8 collate utf8_general_ci;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON mysqldb.* TO tiger@10.202.4.48 IDENTIFIED BY 'sf987654321';
SET PASSWORD FOR tiger@10.202.4.48 = OLD_PASSWORD('sf987654321');
desc mysql.user
show grants for jeffrey@'%';
SELECT USER();
SELECT DATABASE();
---------------------------------------------
Linus 命令：su - root
/根目录；
./当前目录；
../上一级目录；
cd .. 返回上一级；
cd directory;
nano filename.txt;(Ctrl+x 退出)
-----------------------------------------------

---------------------------------------------
grant all on *.* to jeffrey@%;(任意地址)
flush privileges;
----------------------------------------------------------------
Last login: Mon Sep 14 20:24:15 2015 from 10.118.12.4
WARNING: If you are not authorized to access this private computer system, disconnect now. All activities on this system will be monitored and recorded without prior notification or permission!
[sfapp@cnsz22vl0273:/home/sfapp]$su - root
Password:
su: incorrect password
[sfapp@cnsz22vl0273:/home/sfapp]$su - root
Password:
**************************************************************************
*                                                                        *
*Attention: Auditing process will report your every action!              *
*Warning: Don't delete any files in directory /root/slogs!!              *
*                                                                        *
*                                   --SF-Express COMPANY OF CHINA,LTD.*
**************************************************************************
Script started, file is /root/slogs/2015-09-15_09:25:46pts-0sfapp.log
[root@cnsz22vl0273:/root]#cd /dba
[root@cnsz22vl0273:/dba]#ll
total 293172
-rwxr-xr-x 1 root  root       7019 Mar  3  2015 install.sh
drwxr-xr-x 3 root  root       4096 Mar  3  2015 mariadb
-rw-r--r-- 1 root  root  300183709 Mar  3  2015 mariadb-10.0.14-linux-x86_64.tar.gz
drwxr-xr-x 3 mysql mysql      4096 Mar  3  2015 mysqlhome
-rw-r--r-- 1 root  root         53 Mar  3  2015 mysql.info
[root@cnsz22vl0273:/dba]#cd mysqlhome/
[root@cnsz22vl0273:/dba/mysqlhome]#ll
total 32240
drwxr-xr-x 40 mysql mysql     4096 Mar  3  2015 5.6.21
-rw-r--r--  1 mysql mysql 33009070 Mar  3  2015 mysql-5.6.21.tar.gz
[root@cnsz22vl0273:/dba/mysqlhome]#cd 5.6.21/
[root@cnsz22vl0273:/dba/mysqlhome/5.6.21]#ll
total 1008
drwxr-xr-x  2 root  root    4096 Mar  3  2015 bin
drwxr-xr-x  2 mysql mysql   4096 Sep 11  2014 BUILD
-rw-r--r--  1 mysql mysql    142 Sep 11  2014 BUILD-CMAKE

drwxr-xr-x  2 mysql mysql   4096 Sep 11  2014 win
drwxr-xr-x  3 mysql mysql   4096 Mar  3  2015 zlib
[root@cnsz22vl0273:/dba/mysqlhome/5.6.21]#cd bin
[root@cnsz22vl0273:/dba/mysqlhome/5.6.21/bin]#ll
total 496524
-rwxr-xr-x 1 root root  4888439 Mar  3  2015 innochecksum
-rwxr-xr-x 1 root root     1556 Mar  3  2015 msql2mysql
-rwxr-xr-x 1 root root  7672650 Mar  3  2015 myisamchk
-rwxr-xr-x 1 root root  7202611 Mar  3  2015 myisam_ftdump
-rwxr-xr-x 1 root root  7026254 Mar  3  2015 myisamlog
-rwxr-xr-x 1 root root  7305814 Mar  3  2015 myisampack
-rwxr-xr-x 1 root root  4813441 Mar  3  2015 my_print_defaults
-rwxr-xr-x 1 root root  9780974 Mar  3  2015 mysql
-rwxr-xr-x 1 root root   111828 Mar  3  2015 mysqlaccess
[root@cnsz22vl0273:/dba/mysqlhome/5.6.21/bin]#./mysql --socket=/tmp/mysqld_mysqldev.sock --port=3306 -uroot -pmysqldev
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.6.21-log Source distribution

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> grant all on *.* to jeffrey@10.202.4.48;
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for current_user;
+--------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@%                                                                                                              |
+--------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*3A2AAB75C0786A84487A6CAA437A392294B05FAD' WITH GRANT OPTION |
+--------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>
-------------------------------------------------------------------------------------------------------------------------------------


-----------------------------------------------------------------------------------------------------------------------------
ie安全警告、阻止：
if (file.exists()) {
// 可以为application/x-msdownload或者application/octet-stream
response.setContentType("application/octet-stream; charset=gb2312");
// 设置Content-Disposition头的值为"attachment;filename=文件名"
response.setHeader("Content-Disposition", "attachment;filename="
+ new String(annex.getBytes("gb2312"), "iso-8859-1"));

ServletOutputStream outS = response.getOutputStream();
BufferedInputStream inS = new BufferedInputStream(
new FileInputStream(file));
byte[] buff = new byte[1024];
int len = inS.read(buff, 0, 1024);
while (len != -1) {
  outS.write(buff, 0, len);
  len = inS.read(buff, 0, 1024);
}
inS.close();
outS.flush();
outS.close();
}
但愿这段代码对你有帮助。。我是用Servlet做的上传下载。。但下载写文件应该是一样的。。

-------------------------------------------------------
teambition:123QAZzxc
-----------------------
测试密码：qwe123456
如果没查到，$.each()会报错。
var accessType = "${access_key.accessType}"; 
var userName = "${curumuser.username}";  页面获取当前用户的方法
---------------------------------------------------------
[e-mail]
active.123
--------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
大型网站技术架构：核心原理与案例分析；redis设计与实现；企业应用架构模式；mangodb；
JAVASCRIPT语言精髓与编程实践;算法导论；java tcp/ip 网络编程；深入理解nginx；HighCharts表格学习
------------------------------------------------------------------------------------------------------------------------

SELECT
  *
FROM
  reportrules
WHERE CODE IN (
    '增值税主表',
    '附表一 (本期销售情况明细)',
    '附表二 (本期进项税额明细)',
    '附表三 (扣除项目明细)',
    '附表四 (税额抵减情况表)',
    '附表五 (不动产分期抵扣计算表)',
    '本期抵扣进项税额结构明细表',
    '分配表',
    '增值税 (小规模纳税人主表)',
    '附列资料'
  ) ;

-----------------------------------------------------------------------------------------------------
HighCharts：
-----------
spring 声明式事物：
     1、ServiceA类为Web层的Action服务
     2、Action调用了ServiceA的方法A，而方法A没有声明事务（原因是方法A本身比较耗时而又不需要事务）
     3、ServiceA的方法A调用了自己的方法B，而方法B声明了事务，但是方法B的事务声明在这种情况失效了。
     4、如果在方法A上也声明事务，则在Action调用方法A时，事务生效，而方法B则自动参与了这个事务。
之所以出现这个问题，是因为：我们使用aop进行代理，当执行proxy类的a方法时，会进行拦截(开启事物),
紧接着逻辑走到target类上a方法，而后调用target类的b方法。此时需要明白，它调用的是target类上的b方法，
而不是proxy类的b方法。要知道，针对方法b的横切逻辑，只植入到了proxy类上的方法b中。所以target类的a方
法中所调用的b方法没有开启事物.
-----------------------------------------------------------------------------------------------------
SELECT
  *
FROM
  b_ztfi_tax_surtax s
WHERE (
    s.TAX_ENT_COL_L,
    s.TAX_PAY_SUB,
    s.GJAHR,
    s.MONAT,
    s.TAX_CATE
  ) IN
  (SELECT
    TAX_ENT_COL_L,
    TAX_PAY_SUB,
    GJAHR,
    MONAT,
    TAX_CATE
  FROM
    b_ztfi_tax_surtax
  GROUP BY TAX_ENT_COL_L,
    TAX_PAY_SUB,
    GJAHR,
    MONAT,
    TAX_CATE
  HAVING COUNT(1) > 1);
---------------------------------------
[user]
name = 80001092
email = [e-mail]
signingkey = pujie@sf44
spring,jvm,多线程，
CALL proc_queryTaxAnalysisReport(
'',
'',
'',
'',
'',
'',
'2016-03-01',
'',
'000021',
'1',
0,
1000
);
lac

----------------
ALTER TABLE p2_desperse_bill
CHANGE CREATE_TIME CREATE_TIME TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
CHANGE UPDATE_TIME UPDATE_TIME TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
-------------------------------------------------------------------------------------------------------
ALTER TABLE table_name COMMENT='这是表的注释'; 
--------------------------------------------------
1、各框架原理，底层；
2、String s=new String("abc)；
3、hashMap 底层hash值是怎么存储；
4、4h