上个周末，为了测试一下体力，跑了一个迷你马拉松，大概10多公里的路程，连跑带走，中间还看了一会模型飞机表演。

这个周末，代表公司参加了，2010软件工程技术、产业与人才培养论坛，论坛的名子起的很响亮，大概也就百十来人的规模

上图是来自CMU的John T Grasso(现已离开CMU，他在SEPG的推广上作出了很大的贡献)，在做开篇演讲《Methodology in Software Engineering Education》期间还有一些来自IT界著名和非著名人士做了些专题报告。整个论坛类似于TED，但是比TED更有倾向性，就是软件工程、产业、教育等。

中午吃饭的时候，遇到个老先生，据他说是从美国回来，之前在Bell Labs，刚回国4个月，开了家公司，马上就搞定了3个单子，主要做的是视觉识别类的软件以及产业化，大概是用在Test Handler上的一些技术，据他说前途一片光明，佩服。

傍晚去欧尚买盆栽植物，偶然在体育用品货架上发现个怪怪的盒子，里面装了很多小棍子，似乎听别人说过有种棍子游戏，我没有玩过，遂买回来玩玩。

详见说明：

http://de.wikipedia.org/wiki/Mikado_(Spiel)

http://baike.baidu.com/view/718078.htm

打算考个驾照，实际上已经开始了，5月30号开始正式学习，6月28号就全部结束了，速度算是比较快的，每天6点就得起床了，早上得练习1个小时，睡眠严重不足。

淘宝上买的，Sheldon的T-shirt之一

Several weeks ago, I upgraded my Outlook to Outlook 2010 Beta, and previously I wrote a macro to move all emails with my name in the recipient list to a local PST folder(folder: OnlyToMe) automatically. So there’s no backup in enterprise vault.

This morning, when I try to check email in my Outlook, there’s no email in this folder(OnlyToMe), but there’s a number indicating 4 new emails:

OnlyToMe(4)

This is the most important folder for me, the folder size is around 500M(for Y2010 only),  below is how I recover it:

Sub Recover()
	Set OutApp = CreateObject("Outlook.Application")
	Set NmSpace = OutApp.GetNamespace("MAPI")
	Set F = NmSpace.Folders("Default").Folders("OnlyToMe")
	Set T = NmSpace.Folders("HR").Folders("Temp")

	For intX = F.Items.Count To 1 Step -1
		Set objMessage = F.Items.Item(intX)
		objMessage.Move T
	Next

	Set OutApp = Nothing
	Set NmSpace = Nothing
	Set F = Nothing
	Set T = Nothing
End Sub

Above VBA will move all mail items from the weird folder to a newly created folder. I believe I’m not the only one  who got this problem, if you’re the lucky guy, try this method. Don’t forget to re-create a new PST, it’s likely something wrong with the PST.

Outlook 2010 is still a beta release, using it in a production environment is not a good practice. if you like the new features of 2010, you’d better backup your PST regularly.

1. download instant client package  http://download.oracle.com/otn/nt/instantclient/112010/instantclient-basic-win32-11.2.0.1.0.zip
2. extract it to C:\Oracle\instantclient_11_2
3. add C:\Oracle\instantclient_11_2 to %PATH%
4. set %LD_LIBRARY_PATH%, %SQLPATH% and %TNS_ADMIN% as C:\Oracle\instantclient_11_2
5. set OCI Library as “C:\Oracle\instantclient_11_2\oci.dll” in PL/SQL Developer (Tools->Preferences->Connection)
6. done

I verified it on Windows 7, it works.

最近新改了宽带，从有线通换到电信，初始密码是就是电话号码，这个是电信的客服人员推荐的，他说这样的密码比较好记，不容易忘记（安全意识差，对用户信息安全不负责任）。不知道是否有人扫描过电信用户的账号，用户名和密码相同的情况应该不少见（电信用的验证码就是最简单的图片，没有加任何噪音，很容易被破解，这个也是对客户信息安全的不负责任）。

电信一直比较霸道，比如宽带业务，强行绑定电话，买它的宽带一定要装固话，否则免谈，最近更离谱，不仅要装固话，还要强送139号码，对于很多人来说，已经有一个移动或者联通的号码，为什么还要装一个固话和一个139手机。看来只顾着抢钱了，很多细节的用户体验根本都顾忌不上了。

为了节省开发时间，今天打算做一个数据集合类，可以直接将java中的ResultSet，或者其他Collection派生类的内容copy到该集合中，然后加入自定义的一些方法，比如支持直接导出Excel、CSV、KDF、Image、HTML等。这里借助Apache Commons BeanUtils的和反射(Reflection)，将数据库中的一行记录保存为一个对象，然后插入数据集中，结果老是报错如下：

USING CONVERTER org.apache.commons.beanutils.converters.IntegerConverter@1befab0
java.lang.reflect.InvocationTargetException: Cannot set id
at org.apache.commons.beanutils.BeanUtilsBean.copyProperty(BeanUtilsBean.java:449)
at org.apache.commons.beanutils.BeanUtils.copyProperty(BeanUtils.java:129)

… …
Caused by: java.lang.NoSuchMethodException: Property ‘id’ has no setter method
at org.apache.commons.beanutils.PropertyUtilsBean.setSimpleProperty(PropertyUtilsBean.java:1746)
at org.apache.commons.beanutils.BeanUtilsBean.copyProperty(BeanUtilsBean.java:447)

代码段如下：

private void dumpResultSet(ResultSet rs, Class clazz) throws Exception {
	ResultSetMetaData metaData = (ResultSetMetaData) rs.getMetaData();
	int colCnt = metaData.getColumnCount();
	Field[] fields = clazz.getDeclaredFields();

	while (rs.next()) {
		Object newInstance = clazz.newInstance();

		for (int i = 1; i <= colCnt; i++) {
			try {
				Object value = rs.getObject(i);
				for (int j = 0; j < fields.length; j++) {
					Field f = fields[j];
					if (f.getName().equalsIgnoreCase(
							metaData.getColumnName(i).replaceAll("_", ""))) {

						log.info("f.getName:" + f.getName());

						BeanUtils.copyProperty(newInstance, f.getName(),
								value);
					}
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

		list.add(newInstance);
	}
}

The root cause: public is required for class UserInfo, or else you’ll get the ‘NoSuchMethodError‘ exception, DO NOT ignore the access level

public class UserInfo {
	private int id;
	private String user;
	private String password;

	public UserInfo() {
	}

	public String getUser() {
		return user;
	}

	public void setUser(String user) {
		this.user = user;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}
}

Eclipse一直提示：NoSuchMethodError，可是UserInfo里面明明有对应的setter方法，最后，才鬼使神差的发现，只要将UserInfo整个类声明为public就可以了。我一直都把注意力放到是否把setter和getter设置为public，却忽略了Bean的访问级别，希望碰到类似问题的朋友可以注意一下。

如果你安装了PL/SQL Developer的试用版，但在30天内，没有足够的时间来试用它（可能被别的事情耽搁了），可以把下面的Python(V2.6)程序放入你的启动项里，它可以让你无限期的试用PL/SQL Developer (经测试对版本8.0.2.1505有效，未对其他版本测试)，它的原理是每次系统启动的时候，自动检测上次”重置(reset)安装信息”的时间，这些信息保存在一个SQLite数据库中(foobar.db)，请不要删除它，如果时差超过了25天，再次重置(reset)。

import os
import shutil
import win32api
import win32con
import sqlite3
import time
import _winreg
from time import *
from datetime import *

# Reset the trial period of PL/SQL Developer, USE AT YOUR OWN RISK, buy it if you really need it
# by Charry

list = list();

def traverse(root, key, list):
	hKey = _winreg.OpenKey(root, key);

	try:
		i = 0
	    	while 1:
			strFullSubKey = "";
			try:
				strSubKey = _winreg.EnumKey(hKey, i)
				strFullSubKey = key + "\\" + strSubKey;
			except WindowsError:
				hKey.Close();
				return;

			traverse(root, strFullSubKey, list);
			#print strFullSubKey;
			list.append(strFullSubKey);

	        	i+=1
	except	WindowsError:
		print

	hKey.Close();

def reg_delete_key(root, key):
	global list;
	traverse(root, key, list);
	for item in list:
		_winreg.DeleteKey(root, item);
		#print item;

	_winreg.DeleteKey(root, key);

def crack():
	conn = sqlite3.connect('foobar.db')
	conn.execute("""CREATE TABLE IF NOT EXISTS CONFIG(
		ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
		LAST_MODIFIED DATE DEFAULT CURRENT_DATE NULL)""")
	cursor = conn.cursor()
	today = datetime.now().strftime("%Y-%m-%d")

	# get the last_modified date
	sql = "SELECT * FROM {0} ORDER BY LAST_MODIFIED DESC;".format("CONFIG", today)
	cursor.execute(sql)
	str_last_modified = '1970-01-01'
	for row in cursor:
		str_last_modified = row[1]
		break

	print "Last Cracked Time: " + str_last_modified

	# get date delta
	tm_last_modified = datetime.strptime(str_last_modified, "%Y-%m-%d")
	time_diff = datetime.now() - tm_last_modified

	if time_diff.days > 25:
		print "Trial period was reset " + str(time_diff) + " ago"
		print "Save the world, save the cheerleader, let's teleport again"
		sql = "INSERT INTO {0} (LAST_MODIFIED) VALUES('{1}');".format("CONFIG", today)
		cursor.execute(sql)
		conn.commit()

		reg_delete_key(_winreg.HKEY_CURRENT_USER, r"Software\Microsoft\Security");
		reg_delete_key(_winreg.HKEY_CURRENT_USER, r"Software\Allround Automations");

	cursor.close()
	conn.close()

crack();

Keyword: Python, PL/SQL Developer, Crack

The default register function of Python(2.6.x) can’t delete a Windows registry key recursively, an exception(Access is denied) will be thrown if you try to delete a key with sub-keys , below is a wrapper which is easy-to-use, you could use it to delete a key and its sub-keys:

import _winreg 

def traverse(root, key, list):
	hKey = _winreg.OpenKey(root, key);

	try:
		i = 0
	    	while 1:
			strFullSubKey = "";
			try:
				strSubKey = _winreg.EnumKey(hKey, i)
				strFullSubKey = key + "\\" + strSubKey;
			except WindowsError:
				hKey.Close();
				return;

			traverse(root, strFullSubKey, list);
			#print strFullSubKey;
			list.append(strFullSubKey);

	        	i += 1
	except	WindowsError:
		print

	hKey.Close();

def reg_delete_key(root, key):
	global list;
	list = list();
	traverse(root, key, list);
	for item in list:
		_winreg.DeleteKey(root, item);
		#print item;

	_winreg.DeleteKey(root, key);

# Example:
reg_delete_key(_winreg.HKEY_CURRENT_USER, r"Software\charry.org");

Keyword: Python, RegDeleteKey, 注册表, 删除