龍卷風驛站

開發環境：eclipse3.1.2? myeclipse4.1.1?? Tomcat5.0.28?? Mysql5.0
dwr類包版本是1.1
步驟一：配置web.xml
?<?xml version="1.0" encoding="UTF-8"?>
<web-app>
??? <servlet>
??????? <servlet-name>action</servlet-name>
??????? <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
??????? <init-param>
??????????? <param-name>config</param-name>
??????????? <param-value>/WEB-INF/struts-config.xml</param-value>
??????? </init-param>
??????? <init-param>
??????????? <param-name>debug</param-name>
??????????? <param-value>3</param-value>
??????? </init-param>
??????? <init-param>
??????????? <param-name>detail</param-name>
??????????? <param-value>3</param-value>
??????? </init-param>
??????? <load-on-startup>0</load-on-startup>
??? </servlet>

??? <servlet-mapping>
??????? <servlet-name>action</servlet-name>
??????? <url-pattern>*.do</url-pattern>
??? </servlet-mapping>
??? <servlet>
??????? <servlet-name>dwr-invoker</servlet-name>
??????? <servlet-class>uk.ltd.getahead.dwr.DWRServlet</servlet-class>
??????? <init-param>
??????????? <param-name>debug</param-name>
??????????? <param-value>true</param-value>
??????? </init-param>
??? </servlet>

??? <servlet-mapping>
??????? <servlet-name>dwr-invoker</servlet-name>
??????? <url-pattern>/dwr/*</url-pattern>
??? </servlet-mapping>
????
??? <context-param>
??????? <param-name>contextConfigLocation</param-name>
??????? <param-value>/WEB-INF/applicationContext.xml
??????? </param-value>
??? </context-param>
??? <listener>
??????? <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
??? </listener>?
?????
??? <filter>
??????? <filter-name>EncodingFilter</filter-name>
??????? <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
??????? <init-param>
??????????? <param-name>encoding</param-name>
??????????? `
??????????? <param-value>UTF-8</param-value>
??????? </init-param>

??? </filter>
??? <filter-mapping>
??????? <filter-name>EncodingFilter</filter-name>
??????? <url-pattern>/*</url-pattern>
??? </filter-mapping>

????? <error-page>
??????? <error-code>404</error-code>
??????? <location>/404.jsp</location>
??? </error-page>

??? <error-page>
??????? <error-code>500</error-code>
??????? <location>/500.jsp</location>
??? </error-page>

??? <taglib>
??????? <taglib-uri>/WEB-INF/struts-bean</taglib-uri>
??????? <taglib-location>/WEB-INF/tld/struts-bean.tld</taglib-location>
??? </taglib>
??? <taglib>
??????? <taglib-uri>/WEB-INF/struts-logic</taglib-uri>
??????? <taglib-location>/WEB-INF/tld/struts-logic.tld</taglib-location>
??? </taglib>
??? <taglib>
??????? <taglib-uri>/WEB-INF/struts-html</taglib-uri>
??????? <taglib-location>/WEB-INF/tld/struts-html.tld</taglib-location>
??? </taglib>
??? <taglib>
??????? <taglib-uri>/WEB-INF/struts-tiles</taglib-uri>
??????? <taglib-location>/WEB-INF/tld/struts-tiles.tld</taglib-location>
??? </taglib>
??? <taglib>
??????? <taglib-uri>/WEB-INF/ntu</taglib-uri>
??????? <taglib-location>/WEB-INF/tld/ntu.tld</taglib-location>
??? </taglib>

</web-app>

二：spring中注入相關service
<bean id="ajaxTestService" class="com.lion.cms.domain.service.AjaxTestServiceImp">
??????? <property name="commonDAO">
??????????? <ref bean="commonDAO" />
??????? </property>
??? </bean>

三:AjaxTestServiceImp代碼
public class AjaxTestServiceImp implements IAjaxTestService {
??
??? private ICommonDAO commonDAO;

?????
??? public void setCommonDAO(ICommonDAO commonDAO) {
??????? this.commonDAO = commonDAO;
??? }

??? public List getEmployeeById(String deptid) {
??????? DetachedCriteria detachedCriteria=DetachedCriteria.forClass(Employee.class);
??????? detachedCriteria.setFetchMode(Employee.PROP_DEPTID,FetchMode.JOIN);
??????? detachedCriteria.add(Restrictions.eq(Employee.PROP_DEPTID+".id",deptid));
??????? List result=commonDAO.findByCriteria(detachedCriteria);
??????? return result;
???????
??? }
}

四：dwr.xml配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dwr PUBLIC "-//GetAhead Limited//DTD Direct Web Remoting 1.0//EN" "

<dwr>
?<allow>
??<create creator="spring" javascript="ajaxTestService">
???<param name="beanName" value="ajaxTestService" />
???<include method="getEmployeeById" />
??</create>
??????? <convert converter="bean" match="com.lion.cms.domain.pojo.Employee" />
??????? <param name="exclude" value="com.lion.cms.domain.pojo.Dept"/>
?</allow>
</dwr>

五：jsp頁面
<html:select styleId="deptid" property="deptid" onchange="loadEmployList(this.value)">
??????????????? <html:optionsCollection name="deptlist" label="deptname" value="id"/>
??????????? </html:select>
??????????? <html:select property="employee" styleId="employee">
??????????? <html:option value="" >請選擇</html:option>
??????????? </html:select>????

<script type="text/javascript">
<!--
??? // 加載employee下拉列表。
??? function loadEmployList(deptid){
??????? if(deptid==null||deptid==''){
??????? clearEmployeeSel();
??????? return;
??????? }
??????? ajaxTestService.getEmployeeById(loadEmployListCallback,deptid);
??? }
??? var loadEmployListCallback=function(items){
??????? clearEmployeeSel();
??????? DWRUtil.addOptions("employee",items,"id","truename");
??? }
??? function clearEmployeeSel(){
??????? DWRUtil.removeAllOptions("employee");
??????? DWRUtil.addOptions("employee",[{label:'請選擇',value:''}],"value","label");
??? }
//-->
</script>


職工和部門是多對一關系，例子簡單，不詳細敘述了
dwr中spring和hibernate的配置相關幫助文檔：
http://getahead.ltd.uk/dwr/server/spring
http://getahead.ltd.uk/dwr/server/hibernate


dept.hbm.xml代碼如下：
<hibernate-mapping package="com.lion.cms.domain.pojo">
?<class
?? name="Dept"
??table="dept"
?>
?<meta attribute="sync-DAO">false</meta>
???<id
???name="id"
???type="string"
???column="id"
??>
???<generator class="uuid.hex"/>
??</id>

??<property
???name="deptname"
???column="deptname"
???type="string"
???not-null="true"
???length="12"
??/>
??<property
???name="creattime"
???column="creattime"
???type="java.lang.Long"
???not-null="false"
???length="20"
??/>
?

?</class>?
</hibernate-mapping>


employee.hbm.xml代碼如下：

<hibernate-mapping package="com.lion.cms.domain.pojo">
?<class
??name="Employee"
??table="employee"
?>
??<meta attribute="sync-DAO">false</meta>
??<id
???name="id"
???type="string"
???column="Id"
??>
???<generator class="uuid.hex"/>
??</id>

??<property
???name="username"
???column="username"
???type="string"
???not-null="true"
???length="20"
??/>
??<property
???name="password"
???column="password"
???type="string"
???not-null="false"
???length="20"
??/>
??<property
???name="truename"
???column="truename"
???type="string"
???not-null="false"
???length="11"
??/>
??<property
???name="sex"
???column="sex"
???type="string"
???not-null="false"
???length="2"
??/>
??<property
???name="intro"
???column="intro"
???type="string"
???not-null="false"
??/>
??<many-to-one
???name="deptid"
???column="deptid"
???class="Dept"
???not-null="true"
??>
??</many-to-one>

?</class>?
</hibernate-mapping>

用hibernate同步插件可以快速生成po

?

明天下午系統演示，14號論文答辯，希望早點拿好畢業證和學位證走人。

這一個月在公司其他事沒做，天天做畢業設計，前幾天終于完工了。畢業設計做的是計量局的管理系統，采用struts＋spring＋hibernate完成，運行良好，遺憾的是業務層沒有分離，因為時間緊加上系統不是很大，所以都寫在action中了，存在部分代碼重寫，下次改進，呵呵。
???

??? 系統js代碼寫了不少，因為某些功能必須要這樣來實現。

??? 論文寫了1w多字了，早日做好，公司還有事要做。

??? 做項目的過程中得到了公司不少高人的指點，尤其是我師父colky，讓我少走了很多彎路，好多東西也更清晰，謝謝他們。

嘿嘿，好開心哦，好多人，不知道會不會是同學當中最早的，還有一個多月就正式畢業了，開心ing~

路過的就頂一個吧，你也會很幸福的

哈哈，編碼自由寫，在eclipse里面最后用ctrl+shift+f 快捷鍵，代碼乖乖的自動排列好，尤其是xml文件，排得真好看

比較一個屬性可以這樣：
detachedCriteria.add(Restrictions.eq(XXX.PROP_ID,Integer.parseInt(id)));

如果比較的屬性本身類型是對象，那么可以這樣

detachedCriteria.add(Restrictions.eq(XXX.PROP_BM+".id",Integer.parseInt(bmid)));

以上面的語句為例，如果我比較其他屬性
detachedCriteria.add(Restrictions.eq(XXX.PROP_BM+".bmmc",bmmc));

這樣是不行的

解決方法：先定義一個別名
detachedCriteria.createAlias(XXX.PROP_BM, "bm");
然后可以這樣使用了
detachedCriteria.add("bm.bmmc",bmmc));


ps:個人總結：不使用別名，本身是對象的屬性后面只能跟其主鍵屬性，比較其他屬性要用別名。個人觀點，還沒有得到確認

請假請到論文答辯前，接下來的日子不要擔心學校有什么事了，嘿嘿，努力工作，早日完成畢業設計

公司的系統和SQLSERVER的安裝文件都和筆記本的一樣，公司新機安裝什么問題都沒有。
可家里的機器換系統以后再裝SQLSERVER總是有問題，今天上網查了一下，終于找到原因。

因為以前筆記本SQLSERVER安裝的時候數據文件總是指定到E盤，換系統之后還是指定到那邊，但是上個版本安裝留下了幾個系統MDF，所以換系統安裝再次選擇E盤的時候就會出錯了

建議換系統以后裝sql數據目錄指定到一個新目錄，這樣就沒有問題了

項目特殊，js里面有中文參數傳遞


接受方： String? EmployeeName =new? String(httpServletRequest.getParameter("EmployeeName").toString().getBytes("ISO8859-1"));