Thursday, May 21, 2009

备忘录

UTSTARCOM D60模式切换: *20030811#
联通宽带:m156b00100163@gz.unicom/055000

Thursday, April 23, 2009

ORACLE INSTANT CLIENT for LINUX

1. download instantclient from oracle website;
2. extract downloaded files to a directory. ex. /opt/oracle/
3. open .bash_profile add the following codes to the end

# ORACLE ENVIRONMENT SETTINGS.
ORACLE_HOME=/media/software/java/instantclient_11_1
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
TNS_ADMIN=$ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME

export ORACLE_HOME TNS_ADMIN NLS_LANG LD_LIBRARY_PATH

4. re-login.

Tuesday, March 31, 2009

import data from ACCESS/EXCEL to SQLSERVER

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
ACCESS:
select * from openrowset('Microsoft.Jet.OLEDB.4.0',
'd:\orgmst.mdb';'ADMIN';'','SELECT * FROM org_mst')

EXCEL:
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
'Excel 8.0;hdr=yes;database=D:\orgmst.xls',ORG_MST$)

Friday, March 13, 2009

java swing (eg: ORACLE SQL Developer)中汉字显示方块的解决办法

1, 在jre的 lib/fonts 目录创建一个 fallback目录
2, 将windows的字体文件复制到这个新建的目录下

Tuesday, March 10, 2009

解决 在 xfce 中有些软件无法使用 ibus输入问题

在 .bash_profile 中加入
GTK_IM_MODULE=ibus
export GTK_IM_MODULE

Friday, March 6, 2009

wine 下中文字体的关键设置

在E文LINUX, 加 WINE 环境下,运行需要使用中文的软件时,
需要将 LANG设置成zh_CN.UTF-8
例如运行 powerdesigner.
将:
env WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"
改成:
env LANG=zh_CN.UTF-8 WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"

中文问题就解决了

更改字体大小:

[System\\CurrentControlSet\\Hardware Profiles\\Current\\Software\\Fonts]
"LogPixels"=dword:00000070

Thursday, March 5, 2009

download full size Intenet Explorer 6

ie6setup.exe /c:"ie6wzd.exe /d /s:""#E"

Monday, March 2, 2009

vmware 6.5 for linux keyboard error

echo 'xkeymap.nokeycodeMap = true' > ~/.vmware/config

Wednesday, February 25, 2009

Regular Expressions of OpenOffice

匹配中文字符的正则表达式: [\u4e00-\u9fa5]

匹配双字节字符(包括汉字在内):[^\x00-\xff]


匹配空行的正则表达式:\n[\s| ]*\r

匹配HTML标记的正则表达式:/<(.*)>.*<\/\1>|<(.*) \/>/

匹配首尾空格的正则表达式:(^\s*)|(\s*$)

匹配IP地址的正则表达式:/(\d+)\.(\d+)\.(\d+)\.(\d+)/g //


匹配Email地址的正则表达式:\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*

匹配网址URL的正则表达式:http://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?


sql语句:^(select|drop|delete|create|update|insert).*$



1、非负整数:^\d+$

2、正整数:^[0-9]*[1-9][0-9]*$

3、非正整数:^((-\d+)|(0+))$

4、负整数:^-[0-9]*[1-9][0-9]*$

5、整数:^-?\d+$

6、非负浮点数:^\d+(\.\d+)?$

7、正浮点数:^((0-9)+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*))$

8、非正浮点数:^((-\d+\.\d+)?)|(0+(\.0+)?))$

9、负浮点数:^(-((正浮点数正则式)))$

10、英文字符串:^[A-Za-z]+$

11、英文大写串:^[A-Z]+$

12、英文小写串:^[a-z]+$

13、英文字符数字串:^[A-Za-z0-9]+$

14、英数字加下划线串:^\w+$

15、E-mail地址:^[\w-]+(\.[\w-]+)*@[\w-]+(\.[\w-]+)+$

16、URL:^[a-zA-Z]+://(\w+(-\w+)*)(\.(\w+(-\w+)*))*(\?\s*)?$
或:^http:\/\/[A-Za-z0-9]+\.[A-Za-z0-9]+[\/=\?%\-&_~`@[\]\':+!]*([^<>\"\"])*$

17、邮政编码:^[1-9]\d{5}$

18、中文:^[\u0391-\uFFE5]+$

19、电话号码:^((\(\d{2,3}\))|(\d{3}\-))?(\(0\d{2,3}\)|0\d{2,3}-)?[1-9]\d{6,7}(\-\d{1,4})?$

20、手机号码:^((\(\d{2,3}\))|(\d{3}\-))?13\d{9}$

21、双字节字符(包括汉字在内):^\x00-\xff

22、匹配首尾空格:(^\s*)|(\s*$)(像vbscript那样的trim函数)

23、匹配HTML标记:<(.*)>.*<\/\1>|<(.*) \/>

24、匹配空行:\n[\s| ]*\r

25、提取信息中的网络链接:(h|H)(r|R)(e|E)(f|F) *= *('|")?(\w|\\|\/|\.)+('|"| *|>)?

26、提取信息中的邮件地址:\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*

27、提取信息中的图片链接:(s|S)(r|R)(c|C) *= *('|")?(\w|\\|\/|\.)+('|"| *|>)?

28、提取信息中的IP地址:(\d+)\.(\d+)\.(\d+)\.(\d+)

29、提取信息中的中国手机号码:(86)*0*13\d{9}

30、提取信息中的中国固定电话号码:(\(\d{3,4}\)|\d{3,4}-|\s)?\d{8}

31、提取信息中的中国电话号码(包括移动和固定电话):(\(\d{3,4}\)|\d{3,4}-|\s)?\d{7,14}

32、提取信息中的中国邮政编码:[1-9]{1}(\d+){5}

33、提取信息中的浮点数(即小数):(-?\d*)\.?\d+

34、提取信息中的任何数字 :(-?\d*)(\.\d+)?

35、IP:(\d+)\.(\d+)\.(\d+)\.(\d+)

36、电话区号:/^0\d{2,3}$/

37、腾讯QQ号:^[1-9]*[1-9][0-9]*$

38、帐号(字母开头,允许5-16字节,允许字母数字下划线):^[a-zA-Z][a-zA-Z0-9_]{4,15}$

39、中文、英文、数字及下划线:^[\u4e00-\u9fa5_a-zA-Z0-9]+$

Tuesday, February 24, 2009

union sync files/dir to USB Flash Disk

Within gconf-editor, I used the "Find" tool to search for "vfat" (searching also in all key names and key values).

This returned the key "/system/storage/default_options/vfat"

I deleted the umask key, then added the 2 keys you suggested as follows:
dmask=022
fmask=133

Now all directories/folders on my vfat USB flash drives and USB external hard drives are presented with the permissions:

drwxr-xr-x

...and all files on my vfat USB flash drives and USB external hard drives are presented with the permissions:

-rw-r--r--

Monday, February 16, 2009

KEYS, serials 序列号

----Confirmed
Windows 2000 Server

H6TWQ-TQQM8-HXJYG-D69F7-R84VM


windows xp

MRX3F-47B9T-2487J-KWKMF-RPWBY

DreamWeaver 8:WPD800-58834-65732-23622
UltraEdit 14.20
user:888888
code:FEKMA-KEOHD-NKEMQ-RPFNQ-LGHGO-QFIIA-SRJLX-OODVZ

VMware Workstation 6.* for Linux 序列号:
1TMYT-T0L2X-J24FU-4MDZK
M15YR-429DA-YAH6F-4WRX7
N1HPX-6U248-D206Y-4Y8Z6
YHE88-5KCDW-C84DF-4YDQ6

office 2007
VD92M-CPR74-YJ3F6-QDWMP-D4THW

XR349-WTW37-CXQ7R-96M2Y-BB6HW

RTDPB-YVFHK-K6TDQ-4D4PK-DCJ7W
MDWJF-G6PTW-MHFPH-DC82T-JRX38
QRGGR-GF3TP-3GPHP-6CHTW-K4MYJ
FP86W-BGW9W-QFVVC-CD3BT-6KHD8
J7G28-HXWKD-PG63D-6HW9X-86PVW
K63QK-8JJYK-CDQHX-XW96F-HCQQ8
R4MM2-HJ9BF-3MXRP-XV2RW-CJK38
JVHCQ-HCT8W-CBDD8-8HXM3-KF4MJ
FTFGF-KFVHG-29BW9-9CTGV-D8GHW
KKPDP-BXRMR-PXTQD-6YRX7-JCFMJ
MKVRH-RGD9J-FXXHK-Q9P87-4JRMJ
XGTKQ-9VP2G-MCM6G-QH9H3-666HW
BMMPP-GJR76-PRTF7-HKHWH-QD3Q8
H8KJP-2WGPP-6C3CW-7QPRW-GQ8BJ
HDYGF-WC2T2-CMRQT-BDQQX-RV2VW
PH4WK-JD66P-FC4CM-QD9H4-WK87W
W44TP-K43KX-TQB69-WH8RD-PTVD8

----------un-comfirmed

windows2003序列号:cky24-q8qrh-x3kmr-c6bcy-t847y
win2003 Enterprise Server:QW32K-48T2T-3D2PJ-DXBWY-C6WRJ
win2003 Standard Server:M6RJ9-TBJH3-9DDXM-4VX9Q-K8M8M
win2003 Web Server:D42X8-7MWXD-M4B76-MKYP7-CW9FD
Windows2003服务器版的序列号:JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY



Windows 2000专业版安装序列号:PQHKR-G4JFW-VTY3P-G4WQ2-88CTW
Windows 2000服务器版安装序列号:H6TWQ-TQQM8-HXJYG-D69F7-R84VM
Windows 2000 Server 安装版序列号:H6TWQ-TQQM8-HXJYG-D69F7-R84VM

Office XP 中文正式版序列号:P2KDC-9HMXH-9QFVK-PMQCB-V2XMM
Office XP 中文正式版序列号:BMV8D-G272X-MHMXW-4DY9G-M8YTQ
Macromedia Flash v5.0正式版 SN: FLW500-03143-77238-80660
Macromedia Flash v5.0正式版 SN: FLW500-13547-37838-54321
Macromedia Dreamweaver4.03 简体中文正式版SN::DWW400-03771-57289-73501
Macromedia Dreamweaver V4.0-sn:DWW400-03771-57289-73501
Macromedia Dreamweaver UltraDev 4.0-sn:UDW400-06066-07241-71420
Microsoft Office XP 简体中文正式版:SN:FM9FY-TMF7Q-KCKCT-V9T29-TBBBG
Microsoft Office XP 中文正式版序列号:BMV8D-G272X-MHMXW-4DY9G-M8YTQ
Microsoft Office XP 中文正式版序列号:P2KDC-9HMXH-9QFVK-PMQCB-V2XMM
Microsoft Office 2000 简体中文正式版序列号:J2MV9-JYYQ6-JM44K-QMYTH-8RB2W

Windows操作系统序列号大全
EWIN95 S/N:111-1111111
CWIN97 S/N:26495-OEM-0004782-75026
EWIN97 S/N:00100-OEM-0123456-00100
PWIN97 S/N:00100-OEM-0123456-00100
CWIN98 S/N:DC688-DET96-5SCN7-E5RLK-XL413
EWIN98 S/N:K4HVD-Q9TJ9-6CRX9-C9G68-RQ2D3
PWIN98 S/N:VR9TR-74M8W-YPT9C-4VDF4-R7PD8
PWIN98 OEM(第二版) S/N:BBH2G-D2VK9-QD4M9-F63XB-43C33
PWIN98 2A 2222版S/N:QY7TT-VJ7VG-7QPHY-QXHD3-B838Q
PWIN98 2A 2222版S/N:MB9HY-M4JGJ-B3RV2-FPH8D-FP8KY
PWIN98 2A 2222版S/N:WHWGP-XDR8Y-GR9X3-863RP-67J2T
Windows98(第三版)th OEM 升级程序密码:1
Windows98(第三版)th OEM 密码:QY7TT-VJ7VG-7QPHY-QXHD3-B838Q
WINDOWS ME 简体中文正式零售版S/N:HJPFQ-KXW9C-D7BRJ-JCGB7-Q2DRJ
WINDOWS ME 正式英文零售版S/N:RBDC9-VTRC8-D7972-J97JY-PRVMG
PwindowsXP:简体中文正式零售版S/N:FCKGW-RHQQ2-YXRKT-8TG6W-2B7Q8
Windows XP 专业版:CCC64-69Q48-Y3KWW-8V9GV-TVKRM
Windows XP 家庭版:BQJG2-2MJT7-H7F6K-XW98B-4HQRQ
Windows 2000 Professional:PQHKR-G4JFW-VTY3P-G4WQ2-88CTW
Windows 2000 Server:H6TWQ-TQQM8-HXJYG-D69F7-R84VM
Windows 2000 Advanced Server:RBDC9-VTRC8-D7972-J97JY-PRVMG
windows NT Server 4.0 sn:727-1111111
windows NT WorkStation 4.0 sn:727-1111111
Windows 98 Second Edition sn:QY7TT-VJ7VG-7QPHY-QXHD3-B838Q
windows2003序列号:cky24-q8qrh-x3kmr-c6bcy-t847y
win2003 Enterprise Server:QW32K-48T2T-3D2PJ-DXBWY-C6WRJ
win2003 Standard Server:M6RJ9-TBJH3-9DDXM-4VX9Q-K8M8M
win2003 Web Server:D42X8-7MWXD-M4B76-MKYP7-CW9FD
Windows2003服务器版的序列号:JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY

1.操作系统:
Windows XP V5 完美版 SN: BX6HT-MDJKW-H2J4X-BX67W-TVVFG
WinXPPRO 简体中文完美版 sn:BX6HT-MDJKW-H2J4X-BX67W-TVVFGWinXPPRO简体中文版(原版)
Windows Xp 简体中文家庭破解版 SN: JQ4T4-8VM63-6WFBK-KTT29-V8966
Windows 2000 Pro 简体中文版SN:QHKR-G4JFW-VTY3P-G4WQ2-88CTW
Windows 2000 三合一 简体中文版专业版安装序列号:PQHKR-G4JFW-VTY3P-G4WQ2-88CTW 服务器版安装序列号:H6TWQ-TQQM8-HXJYG-D69F7-R84VM
Windows Me简体中文最终正式版序列号:K9KDJ-3XPXY-92WFW-9Q26K-MVRK8 或 hjpfq-kxw9c-d7brj-jcgb7-q2drj Windows98SE第二版 sn:WHWGP-XDR8Y-GR9X3-863RP-67J2T
Microsoft Office XP 中文正式版 序列号:P2KDC-9HMXH-9QFVK-PMQCB-V2XMM
Microsoft Office XP 中文正式版 序列号:BMV8D-G272X-MHMXW-4DY9G-M8YTQ
Microsoft Office 2000 中文正式版 序列号:J2MV9-JYYQ6-JM44K-QMYTH-8RB2W

WINDOWS 2003 安装序列号:
cky24-q8qrh-x3kmr-c6bcy-t847y
JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY
QW32K-48T2T-3D2PJ-DXBWY-C6WRJ
JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY
QW32K-48T2T-3D2PJ-DXBWY-C6WRJ
CKY24-Q8QRH-X3KMR-C6BCY-T847Y
krmxq-bjduw-j89mb-7767f-pvr8m
------CDKEY------------
企业版: QW32K-48T2T-3D2PJ-DXBWY-C6WRJ
标准版: C4C24-QDY9P-GQJ4F-2DB6G-PFQ9W
企业VLK: JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY
标准VLK: JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY

序列号:JCGMJ-TC669-KCBG7-HB8X2-FXG7M
安装序列号:
cky24-q8qrh-x3kmr-c6bcy-t847y
JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY
QW32K-48T2T-3D2PJ-DXBWY-C6WRJ
JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY
QW32K-48T2T-3D2PJ-DXBWY-C6WRJ
CKY24-Q8QRH-X3KMR-C6BCY-T847Y

UltraISO PE注册码
Name:UW-Madison Executive Education
Serial:1519-E287-A828-A24A

Saturday, January 3, 2009

使用My Book做简单的WEB服务器

使用My Book做简单的WEB服务器
1) 首先建立连接
例如:
ln -s /shares/internal/MYWEB /usr/www/lib/

2) 如果需要可以列出目录结构,则打开文件/etc/lighttpd/lighttpd.conf添加:dir-listing.activate = "enable"

3) 重启My Book

4) 在浏览器中http:///MYWEB就可以了~