跳到主要內容

發表文章

目前顯示的是 十一月, 2011的文章

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 = webServerAnswer.getEntity();
Log.d(TAG, ">>>" + webServerAnswer);
if (httpEntity != null) {
InputStream instream = httpEntity.getConten…

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()