建人所聞-增廣見聞

這問題困擾了一段時間，主要是公司的電腦在特定的時間會自動運行 scan32.exe.
CPU loading 是不高，不過佔用Disk I/O 非常嚴重～連要回個mail 都不行...

Google 一下後，發現用ntsd 可以Force Kill process.

指令如下：
@ntsd -c q -pn scan32.exe

弄完之後，終於可以回mail 了...

最近使用Play! + Siena + GAE 時發現，作類似SQL Like 的Search 時，會傳回所有的資料...
在Stackoverflow 中的討論發現，Siena 由於GAE的限制，在這方面的實做有限...

http://stackoverflow.com/questions/6307841/how-does-siena-query-search-work

也就是支援文字完全相同的和結尾字串相同的比對...真的很雞肋...
就算使用JDBC也必須先手動建立Full text index...

所以看來還是JPA比較有彈性...

備忘一下～線上程式碼語法高亮產生器 - Online syntax highlighting
http://jsgears.com/thread-120-1-1.html

還有另一個網站也有
http://tohtml.com/java/

專案在本地端測試完成之後，接下來就把專案部署到GAE裡面去吧～

1. 先修改 N:\PlayFramework\play-1.1\members\war\WEB-INF\appengine-web.xml
將GAE設定的Application ID 和版本號填入

<appengine-web-app xmlns="http://appengine.google.com/ns/1.0">
	<application>arthur201104</application>
	<version>1</version>
</appengine-web-app>

再將專案匯出成WAR目錄架構

N:\PlayFramework\play-1.1>play war members -o members.war

~        _            _
~  _ __ | | __ _ _  _| |
~ | '_ \| |/ _' | || |_|
~ |  __/|_|\____|\__ (_)
~ |_|            |__/
~
~ play! 1.1, http://www.playframework.org
~
00:44:41,359 INFO  ~ Starting N:\PlayFramework\play-1.1\members
00:44:41,390 INFO  ~ Module siena is available (N:\PlayFramework\play-1.1\module
s\siena-1.5)
00:44:41,390 INFO  ~ Module gae is available (N:\PlayFramework\play-1.1\modules\
gae-1.4)
00:44:42,187 WARN  ~
00:44:42,187 WARN  ~ Google App Engine module
00:44:42,187 WARN  ~ ~~~~~~~~~~~~~~~~~~~~~~~
00:44:42,203 WARN  ~ No Google App Engine environment found. Setting up a develo
pment environement
00:44:42,218 WARN  ~ Don't forget to define your GAE application id in the 'war/
WEB-INF/appengine-web.xml' file
00:44:42,218 WARN  ~
00:44:42,218 INFO  ~ Precompiling ...
00:44:48,218 INFO  ~ Done.

~ Packaging current version of the framework and the application to N:\PlayFrame
work\play-1.1\members.war ...
~ Done !
~
~ You can now load N:\PlayFramework\play-1.1\members.war as a standard WAR into
your servlet container
~ You can't use play standard commands to run/stop/debug the WAR application...
~ ... just use your servlet container commands instead
~
~ Have fun!
~

最後上傳至GAE,第一次上傳過程中需要輸入Google的帳號和密碼...

M:\appengine-java-sdk-1.4.3\bin>appcfg update N:\PlayFramework\play-1.1\members.
war
Reading application configuration data...
2011/7/6 上午 12:59:14 com.google.apphosting.utils.config.AppEngineWebXmlReader
readAppEngineWebXml
資訊: Successfully processed N:/PlayFramework/play-1.1/members.war\WEB-INF/appen
gine-web.xml
2011/7/6 上午 12:59:14 com.google.apphosting.utils.config.AbstractConfigXmlReade
r readConfigXml
資訊: Successfully processed N:/PlayFramework/play-1.1/members.war\WEB-INF/web.x
ml
2011/7/6 上午 12:59:14 com.google.apphosting.utils.config.IndexesXmlReader readC
onfigXml
資訊: Successfully processed N:\PlayFramework\play-1.1\members.war\WEB-INF\appen
gine-generated\datastore-indexes-auto.xml
Beginning server interaction for arthur201104...
0% Creating staging directory
5% Scanning for jsp files.
20% Scanning files on local disk.
25% Scanned 250 files.
28% Initiating update.
31% Cloning 252 application files.
33% Cloned 100 files.
34% Cloned 200 files.
40% Uploading 70 files.
52% Uploaded 17 files.
61% Uploaded 34 files.
68% Uploaded 51 files.
73% Uploaded 68 files.
77% Initializing precompilation...
90% Deploying new version.
95% Will check again in 1 seconds.
98% Will check again in 2 seconds.
99% Will check again in 4 seconds.
99% Closing update: new version is ready to start serving.
99% Uploading index definitions.

Update completed successfully.
Success.
Cleaning up temporary files...

M:\appengine-java-sdk-1.4.3\bin>

完成之後連到你在GAE設定的Application網址，就可以看見成果了～
http://arthur201104.appspot.com/basicmemberoperation/index


http://arthur201104.appspot.com/enhancememberoperation/index

之前發生過Windows 作業系統異常，重裝之後發現有些軟體的設定不見了(ex. PUTTY)
主要的原因是因為那些設定存於系統註冊檔裡面。所以找了一些方法將資訊挖出來...

我用的是 MiTeC Windows Registry File Viewer 可以將註冊表資訊由檔案中擷取出來。

Putty 的資訊是放在 HKEY_CURRENT_USER\Software\SimonTatham 下面，所以只要開啟 C:\Documents and Settings\UserName\NTUSER.DAT 就可以讀取設定。

至於註冊表資訊放在哪個實體檔案中，可以參閱下面連結：

資訊來源：介绍两款读注册表文件的软件

這一部分是將前端表格顯示的部份作改善。
使用的元件是jqGrid。這是jqGrid的Demo，裡面有許多使用範例，有興趣的可以去看一下，這邊只會用到以下這些簡單的功能。

1. 使用AJAX 的方式，向Server取得 JSON 格式的資料
2. 支援常見的分頁方式
3. 編輯時使用 inline editor 的方式

檔案位置：

檔案要放對位置
*.css 放在 N:\PlayFramework\play-1.1\members\public\stylesheets
css中用到的圖檔放在 N:\PlayFramework\play-1.1\members\public\stylesheets\images

*.js 放在 N:\PlayFramework\play-1.1\members\public\javascripts

View
View 的部份要將相關的js 檔include進來。我決定直接加在main.html
N:\PlayFramework\play-1.1\members\app\views\main.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

    <head>
        <title>#{get 'title' /}</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <link rel="stylesheet" type="text/css" media="screen" href="@{'/public/stylesheets/main.css'}">
  <link rel="stylesheet" type="text/css" media="screen" href="@{'/public/stylesheets/jquery-ui-1.8.12.custom.css'}">
  <link rel="stylesheet" type="text/css" media="screen" href="@{'/public/stylesheets/ui.jqgrid.css'}">
  
        #{get 'moreStyles' /}
        <link rel="shortcut icon" type="image/png" href="@{'/public/images/favicon.png'}">
        <script src="@{'/public/javascripts/jquery-1.4.2.min.js'}" type="text/javascript" charset="utf-8"></script>
        <script src="@{'/public/javascripts/jquery-ui-1.7.2.custom.min.js'}" type="text/javascript"></script>
  <script src="@{'/public/javascripts/grid.locale-cn.js'}" type="text/javascript"></script>
  <script src="@{'/public/javascripts/jquery.jqGrid.min.js'}" type="text/javascript"></script>

  #{get 'moreScripts' /}
    </head>
    <body>
           #{if flash.error}
            <p class="error">${flash.error}</p>
        #{/if}
        #{if flash.success}
            <p class="success">${flash.success}</p>
        #{/if}
        
        <div id="main">
            #{doLayout /} 
        </div>
    </body>
</html>

和controller對應的View要加入jqGrid元件

N:\PlayFramework\play-1.1\members\app\views\EnhanceMemberOperation\index.html

#{extends 'main.html' /}
#{set title:'Home' /}

Member Data
<table id="scroll37"></table>
<div id="pscroll37" ></div>

<script type="text/javascript">
 
jQuery.fn.log = function(msg) {
    if (typeof console != "undefined")
        console.log("%s: %o", msg, this);
    return this;
};
 
 var lastsel2

jQuery("#scroll37").jqGrid({
    url:'@{memberList()}',
 datatype: "json",
 height: 400,
 width: 800,
 editable: true,
    colNames:['ID','firstName', 'lastName','gender', 'email'],

 colModel:[
     {
        name:'memberid',
        index:'memberid',
        align : "right",
        width : 50, 
        required : true,
  hidden: true, 
  editable: false, 
  editrules: { edithidden: false }, hidedlg: true
      },{
        name:'firstName',
        index:'firstName',
        width:100,
        editable : true,
        required : true,
  editrules:{required:true}
      },{
        name:'lastName',
        index:'lastName',
        width:100,
        editable : true,
        required : true
      },{
        name:'gender',
        index:'gender',
        width:50, 
        editable : true,
        edittype : 'select',
        editoptions:{value:"1:男;2:女"},
  formatter:function(cellvalue, options, row){
       if(cellvalue==1 || cellvalue=="男" ){
    return "男";
      }else{
          return "女";
     }
  },

        required : true
      },{
        name:'email',
        index:'email',
        width:150, 
        editable : true,
        required : true
      }
    ],
    rowNum:20,
 rowTotal: 100,
 rowList : [20,30,50],
 //scroll:2,
 headertitles: false,
 loadonce:false,
    mtype: "GET",
 editurl: '@{memberEdit()}', 
 rownumbers: true,
 rownumWidth: 40,
 gridview: true,
    pager: '#pscroll37',
    sortname: 'id',
    viewrecords: true,
    sortorder: "asc",
 caption: "Member Data",


 onSelectRow: function(id){
 
      if(id && id!==lastsel2){
 
        jQuery('#scroll37').saveRow(lastsel2);
  $("#scroll37").jqGrid('setGridParam', {editurl:'@{memberEdit()}?memberId='+$('#scroll37').jqGrid('getCell',id, 1)})
  jQuery('#scroll37').editRow(id,true);
        lastsel2=id;
      }
   
    }

});

jQuery("#scroll37").jqGrid('navGrid','#pscroll37',{del:true,add:true,edit:true});

</script>

Controller
由於新增了ajax的功能，所以controller 的部份要使用 renderJSON() 作輸出
N:\PlayFramework\play-1.1\members\app\controllers\EnhanceMemberOperation.java

package controllers;

import java.util.ArrayList;
import java.util.Hashtable;
import java.util.List;

import models.Member;
import models.MemberCard;
import play.data.validation.Required;
import play.mvc.Controller;

public class EnhanceMemberOperation extends Controller {
    public static void index() { 
        render();
   }

    public static void memberEdit(@Required String oper, long memberId,String firstName,String lastName ,Integer gender, String email) {
     if(validation.hasErrors()) {
            params.flash(); // add http parameters to the flash scope
            validation.keep(); // keep the errors for the next request
            System.out.println("ERROR: "+ validation.errors());
            index();
        }
        if (oper.equalsIgnoreCase("add")){
         new Member(firstName,lastName,gender,email).insert();
        }else if (oper.equalsIgnoreCase("del")){
         Member member = Member.findById(memberId);
         member.delete();
        }else if (oper.equalsIgnoreCase("edit")){
         Member member = Member.findById(memberId);
         member.firstName = firstName;
         member.lastName = lastName;
         member.gender = gender;
         member.email = email;
         member.update();
        }
        index();
    }
    
    public static void memberList(int page, int rows ,int sidx ,int  sord ) {

      System.out.println("進入memberList表單" +  params.get("page")+":" + params.get("rows"));
      int totalRecords= Member.all().count();
     int totalPage = (int) java.lang.Math.ceil(new Double(totalRecords) / new Double(rows));
     System.out.println("totalPage=" +  totalPage +" totalRecords=" + totalRecords);
     Hashtable ht = new Hashtable();
  ArrayList al = new ArrayList();
  
  int start = (page - 1) * rows;
  List<Member> members = Member.all().fetch(rows,start);
  for (int i=0;i<members.size();i++){
   Hashtable rowdata = new Hashtable();
   ArrayList columns = new ArrayList();
   columns.add(members.get(i).id);
   columns.add(members.get(i).firstName);
   columns.add(members.get(i).lastName);
   columns.add(members.get(i).gender);
   columns.add(members.get(i).email);
   rowdata.put("id",i);
   rowdata.put("cell",columns);
   al.add(rowdata);
  }

  ht.put("page",page);
  ht.put("total",totalPage);
  ht.put("records",totalRecords);
  ht.put("rows",al);
        renderJSON(ht);
      
    }

    
    public static void memberDelete(Long id) {
     Member member = Member.findById(id);
        notFoundIfNull(member); 
        member.delete();
        flash.success("The member %s has been deleted", member.firstName  );
        index();
    }
}

執行結果如下圖:

這篇文章將實做第一個資料庫互動的範例。
主要是針對Member 作所謂的 Add, Delete, Inquiry, Update. 並將所有動作整合到同一個頁面。

1. Controller

新增BasicMemberOperation.java 在對應的目錄下，這個是要當Controller用的，網頁的每一個動作都對應到Controller裡面的某個method。 最後透過Index呼叫PlayFramework作render。

N:\PlayFramework\play-1.1\members\app\controllers\BasicMemberOperation.java

package controllers;

import java.util.List;

import models.Member;
import models.MemberCard;
import play.data.validation.Required;
import play.mvc.Controller;

public class BasicMemberOperation extends Controller {
    public static void index() { 
        List members = Member.getall(); // get all member data
        render(members);
   }
    
 
    //將選取的資料傳回表單
    public static void getDataForEdit(Long id) {
     Member member = Member.findById(id);
        notFoundIfNull(member);
        flash.put("id", member.id);
        flash.put("firstName", member.firstName);
        flash.put("lastName", member.lastName);
        flash.put("email", member.email);
        index();
    }
    
    //delete member 
    public static void delete(Long id) {
     Member member = Member.findById(id);
        notFoundIfNull(member); 
        member.delete();
        flash.success("The member %s has been deleted", member.firstName  );
        index();
    }
   
    //add or edit member 
   public static void addOrEdit(long id,@Required String firstName,@Required String lastName , @Required String email) {
       if(validation.hasErrors()) {
           params.flash();       // add http parameters to the flash scope
           validation.keep(); // keep the errors for the next request
           index();
       }
       
       if (id == 0){ //no id, add member
        new Member(firstName,lastName,0,email).insert();
       }else{ // have id, edit member
        Member member = Member.findById(id);
         member.firstName = firstName;
         member.lastName = lastName;
         member.email = email;
         member.update();
       }
       index();
   }
   
   //產生測試資料
   public static void genData() {
    int count = 10;
       for (int i=1;i<=count;i++){
        Member theMember = new Member("FirstName"+i,"lastName"+i,0,"email"+i);
        theMember.insert();
        for (int j=1;j<=20;j++){
         MemberCard theCard = new MemberCard("NO:"+i+j,theMember);
         theCard.startDate = new java.util.Date();
         theCard.insert();
         System.out.println("NO:"+i+j);
        }
       }
       flash.success("The member has been deleted, row=%s", count);
       index();
   }
   
   //清空測試資料
   public static void removeAllData() {
    int count = Member.all().delete();
    for (Member m: Member.all().fetch()) m.delete();
       flash.success("The member has been deleted, row=%s", count);
       index();
   }
   
}

2.View 

N:\PlayFramework\play-1.1\members\app\views\BasicMemberOperation\index.html

#{extends 'main.html' /}
#{set title:'Home' /}
<h2>
#{a @BasicMemberOperation.genData()}<b>Create Test Data</b>#{/a}
<BR>
#{a @BasicMemberOperation.removeAllData()}<b>Remove all Data</b>#{/a}
</h2>
<hr>

#{form @BasicMemberOperation.addOrEdit()}
    <p>
     <input type="hidden" name="id" id="id" size="60" value="${flash.id}"/>
  
        Member First Name <input type="text" name="firstName" id="firstName" size="20" value="${flash.firstName}"/>
  <span class="error">#{error 'firstName' /}</span>
  <BR>
  
  Member Last Name <input type="text" name="lastName" id="lastName" size="20" value="${flash.lastName}"/>
  <span class="error">#{error 'lastName' /}</span>
  <BR>
  
  Member Email <input type="text" name="email" id="email" size="40" value="${flash.email}"/>
  <span class="error">#{error 'email' /}</span>
    </p>  
    <p>
     #{if flash.id == null}
        <input type="submit" value="ADD Data"> 
  #{/if}
  #{else}
  <input type="submit" value="SAVE"> 
  #{/else}
    </p>

#{/form}
<hr>
<h2>All Member List</h2>
#{if members.size() > 0}

<table BORDER=1>
<tr >
 <td><b>Member First Name</b></td>
 <td><b>Member Last Name</b></td>
 <td><b>Member Email</b></td>
 <td><b>Action</b></td>
 </tr> 
#{list items:members, as:'members'}
 <tr>
 <td>${members.firstName} </td>
 <td>${members.lastName}</td>
 <td>${members.email}</td>
 <td>
  #{a @BasicMemberOperation.getDataForEdit(members.id)}Edit#{/a}
  #{a @BasicMemberOperation.delete(members.id)}Delete#{/a}
 </td>
 </tr>
#{/list} 
</table>
#{/if}
 
 
#{else}
    <div class="empty">
        There is currently nothing to show here.
    </div>
#{/else}

3. Model
Model 的部份請參照第一篇，將資料物件相關的檔案放到N:\PlayFramework\play-1.1\members\app\models下 

4. 執行專案 
執行以下命令 N:\PlayFramework\play-1.1>play run members 之後直接用瀏覽器開啟 http://127.0.0.1:9000/basicmemberoperation/index 便可以進行操作