How to implement syntax highlighter in javadoc

Javadoc don't support syntax highlighter, and this feature is important when make example of how to use the class.

We can and this feature by add a block of JavaScript.

1. Download syntaxhighlighter_3.0.83 to document root.
2. Add the javadoc comment as

/**
 * Class Description
 * {@docRoot}
   
   
   
   
   
      You java code here
   
 */
public class YouClass{}

3. It works now.

在Google Calendar中创建联系人的农历生日

谷歌的日历中有“联系人的生日和活动”(添加->浏览有趣的日历->联系人的生日和活动)，这个功能貌似很好，可惜不支持农历生日。

我做了一个联系人的生日，里面可以有农历生日，也是从Google Contacts中提取联系人的生日（包括农历生日）并把它添加到日历中。(http://contactsbirthday.appspot.com)

屏幕截图:

同步到Android手机后效果图

使用说明：
1. 在谷歌联系人中添加联系人的生日。

    如果只要阳历生日，则不用添加第二行。
    如果只要阴历生日，则保持第二行和第一行一致。
2. 访问我的google appenging网站http://contactsbirthday.appspot.com
    要求：(1)用户有googl帐号，并且登录。
                (2)用户授权访问自己的联系人信息。（你也可以建立自己站点，这样最安全，后面有源代码）

3. 授权成功后系统会自动redirect到http://contactsbirthday.appspot.com/ical/?email=xxx@xxx.xxx

    xxx@xxx.xxx是你的google帐号

4. 在谷歌日历中添加这个日历

5. 下载源代码这里，提取码：bx7n86tj   lunar.py是抄自这里（作者提供的源代码中描述数据结构的注释不正确，我已经改正确了）

Singleton implementation in Python

def Singleton(cls):
    
    def delegate(*args, **keyargs):
        if hasattr(cls, 'instance') == False:
            cls.instance = cls(*args, **keyargs)
        return cls.instance    
    
    return delegate
    
@Singleton
class test:
    def __init__(self):
        self.attr = 'aaa'
        print('init test')

if __name__ == '__main__':
    a = test()
    b = test()
    print(a,b,a==b)
    print(a.attr, b.attr)
    a.attr = 'bbb'
    print(a.attr, b.attr)    
    b.attr = 'ccc'
    print(a.attr, b.attr)

Extract metadata from xbox360 GOD directory

I have many xbox306 game and I want to share some to my friends (Note: I  use XBR system).
But I can't get game name from the directory.

Fortunately there a file in game folder whose name is GUID, we can extract game name and game icon from that file.

The game name is at position 1041, there are 2 pictures at the metadata file, 5914 and 22298.

I cann't get other metadata from this file, anyone who knowes please send me an email.

Here is the program I wrote in python to extract metadata from GOD directory.

How to use:
1. Extract the zip file.
2. Modify main.py (4th and 5th line)

sourceFolder = r'............\xbox360'
outpath = r'.........\out'

3. run metaExtractor.exe
4. Open gamelist.html in the output folder to see the game list.

Oralce Sum function in livelink

Found a big bug in livelink.

When excute oracle aggregate function SUM, livelink always truncate the value.

See this SQL

select sum(v)
from 
(
  select 1.01 v from dual
  union
  select 1.05 v from dual
)

pl/sql give 2.06 but livelink give 2.

The solution is (for livelink) convert decimal to string

select to_char(sum(v))
from 
(
select 1.01 v from dual
union
select 1.05 v from dual
)

It is very strange, isn't it?

The dropdownl list default value issu in IE of jqGrid cell eding

The dropdownlist in jqGrid cell edit has an issue in IE.

Let's see what happens

In jqGrid js file

var oSv = options.value;
} else if (typeof options.value === 'object') {
    var oSv = options.value;
    for ( var key in oSv) {
        if (oSv.hasOwnProperty(key ) ){
            ov = document.createElement("option");
            ov.setAttribute("role","option");
            ov.value = key; ov.innerHTML = oSv[key];
            
            
            // this line set option to be selected and the selectedIndex is correct
            if (!msl &&  ( $.trim(key) == $.trim(vl) || $.trim(oSv[key]) == $.trim(vl)) ) { ov.selected ="selected"; }
                        
            
            if (msl && ($.inArray($.trim(oSv[key]),ovm)>-1 || $.inArray($.trim(key),ovm)>-1)) { ov.selected ="selected"; }
            elem.appendChild(ov);
        }
    }
}

// before this line the selectedIndex is correct
setAttributes(elem, options);
// but after this line the selectedIndex is incorrect

The problem must be setAttributes(elem, options);

function setAttributes(elm, atr) {
    var exclude = ['dataInit','dataEvents','dataUrl', 'buildSelect','sopt', 'searchhidden', 'defaultValue', 'attr'];
    $.each(atr, function(key, value){
        if($.inArray(key, exclude) === -1) {
            $(elm).attr(key,value);
        }
    });
    if(!atr.hasOwnProperty('id')) {
        $(elm).attr('id', $.jgrid.randId());
}

Notice this line

$(elm).attr(key,value);

The key is "value" and the value is "{RMB:'RMB', USD:'USD', EUR:'EUR', AUD: 'AUD', GBP:'GBP', SGD: 'SGD'}"

Here is the problem. We can add key "value" to exclude array.

Now the functions reads

function setAttributes(elm, atr) {
    var exclude = ['dataInit','dataEvents','dataUrl', 'buildSelect','sopt', 'searchhidden', 'defaultValue', 'attr'];
    $.each(atr, function(key, value){
        if($.inArray(key, exclude) === -1) {
            $(elm).attr(key,value);
        }
    });
    if(!atr.hasOwnProperty('id')) {
        $(elm).attr('id', $.jgrid.randId());
}

It works well now.