發表文章

目前顯示的是 11月, 2011的文章

Executing exe on Mac

Enjoy a bottle of Wine... http://winebottler.kronenberg.org/

Android doPost request encoding problem

日前在開發一個Android上的doPost需求時候 發現在呼叫伺服端主機時候,均會有中文亂碼問題 後來文獻中找到應該是輸入參數時候需要在轉碼一次(或者說指定用UTF-8) 下面是各通用的doPost方法 供有需要的人參考:   public String getDataFromUrl(String url, Map<String, String> params) { HttpClient httpclient = new DefaultHttpClient(); HttpPost httppost = new HttpPost(url); String result = null; Log.d(TAG, "Params: " + params); try { List<NameValuePair> pairs = null; if(params != null){ pairs = new ArrayList<NameValuePair>(params.size()); for(String k : params.keySet()){ String v = params.get(k); pairs.add(new BasicNameValuePair(k,v)); } } httppost.setEntity(new UrlEncodedFormEntity(pairs, HTTP.UTF_8 )); // Finally, execute the request HttpResponse webServerAnswer = httpclient.execute(httppost); Log.d(TAG, ">>>" + httppost.getURI()); Log.d(TAG, ">>>" + httppost.getParams()); HttpEntity httpEntity = webServ

Python + MySQL 效能增進

下面是一篇Python使用SSCursor做MySQL資料查詢的文章 其中使用SSCursor做大量資料查詢時,可以更有效能 有興趣的人,可以參考一下: http://fcamel-life.blogspot.com/2010/08/python-mysql.html 下面是可用的Code,可以參考: import MySQLdb from MySQLdb.cursors import SSCursor db = MySQLdb.connect(host="db_ip_address", user="db_user", passwd="db_password", db="db_name") sql = "SELECT * FROM some_table" cursor = db.cursor(cursorclass=SSCursor) #cursor = db.cursor() cursor.execute(sql) result = cursor.fetchall() try:   for record in result:     print record[0] finally:   cursor.close()   db.close()