自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(263)
  • 收藏
  • 关注

原创 javascript函数内的this关键字

在javascript函数内的this指的是谁?一句话: The word "this" within a function refers to the object calling that function.举例子,如下javascript代码 function Ball(p) { // alert(this) // alert(this.construct

2017-03-25 19:08:02 553

原创 step-by-step构造Maven Jersey Web Application

使用maven创建Jersey Web应用1. 使用maven创建jersey web应用框架   $ mvn archetype:generate \   -DarchetypeArtifactId=jersey-quickstart-webapp \   -DarchetypeGroupId=org.glassfish.jersey.archetypes \

2017-03-25 18:57:43 694

原创 step-by-step构造Jersey Web Application

这是一个Hello World例子如何使用Jersey构造一个Web Application使用工具1. Apache Tomcat 7.x1. Eclipse Java EE IDE for Web Developers; Version: Neon.2 Release2. Jersey库(比较方便的构造Jersey应用是使用maven生产框架,但是由于国内访问maven库的

2017-03-19 16:42:22 1134

原创 python嵌套函数

也叫内部函数嵌套函数里面两个重要的概念:变量作用域和函数闭包1. 变量作用域   内部函数可以直接读取访问外部函数变量,但是不能修改;访问规则是从内到外函数逐级寻找变量#!/usr/bin/env pythondef outer(a): i = a + 1 def inner(): j = i + 1

2017-03-11 15:27:32 1604

原创 python函数局部变量

python简单变量(不考虑类变量)分为两类: 函数内定义的局部变量,和函数外定义的全局变量基本访问规则1. 在函数内部,可以直接读取访问全局变量(注意只读) #!/usr/bin/env python i = 10 def f(): j = i + 1 # 读取全局变量i f() print "i=%d" %

2017-03-11 15:23:43 1834

原创 sed 提取匹配的字符串内容

# STR="MAIL FROM(CCC) TO(DDD)"#echo $STR | sed -n 's/.*FROM(\([^)]\{1,\}\)).*TO(\(.*\))/\1-\2/g'p提取括号里面的内如STR="MAIL FROM(ABCD) BODY"echo $STR | sed 's/^.*FROM(\(.*\)).*$/\1/g'      # A

2017-03-05 14:38:30 29252 3

原创 C++ char和unsigned char

signed char 和 unsigned char 的区别1. 如果它们只是作为字符处理,那么是没有区别2. 只有当它们被作为数字值处理的时候,考虑到符号位扩展的时候是有区别的    char ch1 = -8;    unsigned char ch2 = -8;    printf("signed=%d, unsigned=%d\n", ch1, ch2

2017-03-05 14:34:27 5048

原创 C++ std::string能否存储二进制字符

1. std::string 是否可以包含二进制字符,答案是能    std::string ss = std::string("XXX") + '\2' + "YYY" + '\11' + "ZZZ";    std::cout // len=[11],data=[XXXYYY  ZZZ]2. std::string 是否可以包含字符0,答案是

2017-03-05 14:06:55 7170

原创 C++ ostream 常用格式

注意一点: std::setw只对下一个输出值有效,其他选项所有随后的输出都有效,比如:case: std::cout 可见"AAAA"被扩展成了6个字符宽度,而BBBB没有被扩展;因为std::setw只对紧跟着的输出有效, 即只对输出"AAAA"有效,而对"BBBB"输出无效。虽然std::setfill对输出"BBBB"还是有效的, 但是因为长度限定, "BBBB"的输出

2017-03-05 13:58:25 6593

原创 COBOL Decimal Numbers

There are two type of formats for decimal numbers:1. Zoned Decimal2. Packed Decimal1. Zoned Decimal Numbers-- each byte present 1 numeric value.-- the sign mark is plac

2017-02-26 15:13:37 754

原创 Java重载成员变量

如果子类中变量的名字和父类的变量的名字一样,不管他们的类型是否一致,那么在子类中,父类的同名变量无法直接通过变量名访问。(个人认为这是一个很差的设计,对于代码的可读性可维护性非常不友好,编译器应该直接报错,禁止这种同名变量的重载)定义父类:package com.xxx.test.inherit;public class TestParent { public in

2017-02-19 16:29:31 2150 1

原创 Java函数作用域的原理

从代码导入问题class testParentpackage cm.xxx.test.inherit;public class TestParent { private void doTest() { System.out.println("in TestParent::doTest()"); } public static void main(String[] args

2017-02-19 15:49:24 1550

原创 Java编译错误:Cannot reduce the visibility of the inherited method from <class>

原因:java类的继承关系中,只能扩大一个函数的作用域范围,不能缩小。解决方法:在子类中保持父类的作用域范围,或者扩大范围。 1.      父类中private的成员函数,可以在子类中重新声明为private, (default), protected, public2.      父类中(default)的成员函数,可以在子类中重新声明为(default), protected

2017-02-19 15:03:35 4500

原创 Java类成员的作用域概述

所有java程序员都知道java类有三个成员作用域关键字,即public, protected, 和private; 实际上还有一个作用域, 叫做缺省作用域, 也就是当类成员被声明时没有上述三个中的任何一个。 四个作用域按高低排序:1.      public :公有,任何类都可以访问2.      protected :保护,类自己,子类和同一个包的类可以访问3.    

2017-02-19 14:48:26 875

原创 Constant Pool

JavaString s1 = "Hello";String s2 = s1;String s3 = "Hello";String s4 = new String("Hello");String s5 = s4;String s6 = new String("Hello");System.out.println(s1 == s2); // trueSystem.o

2017-02-03 13:19:10 502

原创 UNICODE和UCS

编码类型UNICODE是统一码联盟组织定义的编码。UCS是国际标准化组织iso开展的ISO/IEC 10646项目定义的编码。(注, 到UNICODE2.0上述两种编码都基本一致了)实现类型UTF-8/UTF-16 是UNICODE编码的实现。UCS-2/UCS-4 是UCS编码的实现。例子举例来说,汉字"汉"的编码是6C49如果用UTF

2017-02-02 15:28:23 1897

原创 Oracle varchar2 Chinese characters

This doc describe how to insert a Chinese character into Oracle varchar2 datatype column1. Check character set is correct in database$ sqlplus scott/tiger@orclSQL*Plus: Release 11.2.0.1.

2017-02-02 14:49:32 620

原创 如何打开荣耀5A的调试模式

今天在调试荣耀5A的时候踩了一个坑, 所以记下这个过程。背景: 之前用的MAC开发环境都是好好的, 能够正常调试荣耀3C真机; 这不刚换了一个新的荣耀5A就不能调试了, Android Studio/Android Device Monitor怎么发现不了这个新设备。各种试验手机设置,重启,包括MAC重启都木有用;其实什么也没有变呢, 一样的电脑, 一样的开发环境, 就是换了一台新手机, 还都

2016-11-26 20:00:28 2156

原创 DB2 how to drop overloaded functions

When you try to drop an overloaded function/procedure, DB2 will report a SQL0476N error code.For example: if function MY_TOCHAR is overloaded withCREATE FUNCTION MY_TOCHAR(P DATE) RETURNS VARCHA

2016-11-26 08:36:48 999

原创 DB2 C language external scalar user-defined function

Sample step of define a C language external scalar user-defined function.1. Define function implementation using C language$ cat mymd5.c#include #include #include #include #include #i

2016-11-26 08:32:00 465

原创 DB2 define external scalar java user-defined function

A sample of DB2 define java external scalar user-defined function.Take md5() function for example:The function will accept a string as input, and return md5 string.Step 0 : verify DB2 java envir

2016-11-19 14:49:14 832

原创 JDBC query CLOB column

Sample of JDBC query a CLOB column and write into file.This code snippet is verified on both DB2 and Oracle.public void getCLOBColumn(Connection conn, String outfile) { try {

2016-11-19 14:33:59 410

原创 JDBC query table definition

JDBC retrieve table columns information public void describeTable(String tableName) { try { PreparedStatement pstmt = conn .prepareStatement("select * from

2016-11-19 14:31:22 434

原创 DB2 SQL function overloading with DECIMAL datatype

DB2 SQL function overloading does not care about datatype length, and precision, for exampleMYFUN(P DECIMAL) and MYFUN(P DECIMAL(6, 2) are conflicted definition; DB2 will not regard them as overload

2016-11-19 14:28:42 379

原创 Oracle SQL function overloading

Sample of implement Oracle SQL function overloading, and default parameter.To define your own to_char(...) function support different kinds of input data type.Please notice they must be defi

2016-11-19 14:22:16 412

原创 JDBC insert BLOB column

Insert a BLOB column from a file.Suppose table is defined as: CREATE TABLE TESTTAB(A INT, B BLOB);Oracle JDBC insert BLOB dataimport java.io.File;import java.io.FileInputStream;import java

2016-11-19 14:18:18 1096

原创 How to display CLOB column

This article will give samples how database client display CLOB column for DB2 and OracleDB2 clientDB2 client only show first 8K length, the rest are truncated with following WARNING message

2016-11-19 14:12:03 845

原创 DB2 client connect to server

0. Prerequisite   TCP connection must be configured on DB2 server.1. Catalog the TCP/IP node on the DB2 client side:  Command:db2 catalog tcpip node remote server  Sample: db2 catalog

2016-11-19 14:02:53 3069

原创 DB2 trigger on a view

This article will discuss the trigger on a view, other than a table.Firstly, let's define updatable view, then continue define trigger on view.1. Updatable View   Most of, but the simplest,

2016-11-18 23:06:28 480

原创 SQL Function for DB2 and ORA

SQL Function in DB2 9(UDF=user defined function)DB2 9 and earlier, your could only has RETURN statement in your UDF logic. (This is a too limited design)• RETURN can’t contain a SELECT sta

2016-11-12 09:15:07 375

原创 DB2 DECIMAL data type

Describe DB2 z/OS DECIMAL data typeUsage FormatDECIMAL(PRECISION, SCALE)PRECISION refers to the maximum number of digits that are present in the number, andSCALE refers to the ma

2016-11-11 23:35:59 1180

原创 Generate DB2 table definition COPYBOOK

When accessing DB2 table in a COBOL program, usually we need know the table definition COPYBOOK.Utility DCLGEN could be used to generate this COPYBOOK file.For example: when table was defined

2016-11-11 22:55:54 637

原创 JDBC access DB2

Sample program using JDBC access DB2 database.Prerequisite: installing DB2 JDBC driver and license JARsThe DB2 Universal JDBC Driver.1. db2jcc.jar : includes functions in the JDBC 3.0 and ea

2016-11-11 22:45:39 760

原创 Oracle BLOB data type

Define BLOBSQL> CREATE TABLE TESTTAB(A BLOB)INSERT BLOBSQL> INSERT INTO TESTTAB VALUES(HEXTORAW('61626364'));SQL> INSERT INTO TESTTAB VALUES(UTL_RAW.CAST_TO_RAW('ABCD'));SQL> SELECT A FROM

2016-11-11 22:35:43 498

原创 DB2 system table resource

-- CHECK USER TABLESSELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATEDBY = CURRENT_SCHEMASELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATEDBY = ''-- CHECK TABLE COLUMNS INFORMATIONSELECT NAME,

2016-11-11 22:28:51 508

原创 DB2 BLOB data type

SQL samples of INSERT/SELECT DB2 BLOB data type.db2 => drop table db2 => create table (a varchar(4), b varchar(4) for bit data, c blob(4))db2 => describe select * from Column Inform

2016-11-06 20:06:30 2375

原创 DB2 Passing transition tables from trigger to stored procedure

欢迎使用Markdown编辑器写博客本Markdown编辑器使用StackEdit修改而来,用它写博客,将会带来全新的体验哦:Markdown和扩展Markdown简洁的语法代码块高亮图片链接和图片上传LaTex数学公式UML序列图和流程图离线写博客导入导出Markdown文件丰富的快捷键快捷键加粗 Ctrl + B 斜体 Ctrl + I 引用 Ctrl

2016-11-04 22:38:33 473

原创 Usage of mainframe DB2 trigger

General Trigger Creation Syntax$ cat create_trigger.sql--#SET TERMINATOR #DROP TRIGGER #CREATE TRIGGER AFTER [UPDATE|INSERT|DELETE] ON REFERENCING [NEW|NEW_TABLE] AS N [OL

2016-11-04 22:17:17 812

原创 DB2 mainframe table operation DML

Sample JCL to operate a DB2 table.//OPERTBL JOB (DSNTEP4),'OPERTBL',REGION=0M,CLASS=2,MSGCLASS=X,// NOTIFY=&SYSUID//*============================================================//STE

2016-10-29 09:32:08 569

原创 DB2 mainframe create table DDL

Sample JCL to create DB2 table on mainframe//CREATBL JOB (DSNTEP4),'CREATBL',REGION=0M,CLASS=2,MSGCLASS=X,// NOTIFY=&SYSUID//*=========================================================

2016-10-29 09:26:55 818

空空如也

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除