`
DavyJones2010
  • 浏览: 148278 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
社区版块
存档分类
最新评论
文章列表
1. Eg.    # Fetch the difference between shop_price and market_price, and list the goods whose difference is bigger than 200 # The first part select *, (market_price - shop_price) as difference from goods; # The whole part # The below approach will calculate twice, poor performance. selec ...

MySQL: Group By

 
1. Group By     1) GroupBy Is usually used with aggragation function(statistic function). If not, group by is pointless.     2) Five aggragation function:         1) max         2) min         3) sum         4) avg         5) count     Eg. # fetch the most expensive goods price # knowing ...
Flex Data Binding Pitfalls and Common Misuse Mistakes   1. Using [Bindable] When Binding Is Not Necessary <?xml version="1.0" encoding="utf-8"?> <s:Application xmlns:fx="http://ns.adobe.com/mxml/2009" xmlns:s="library://ns.adobe.com/flex/spark& ...
1. Normal Data Binding for VO   package vo { [Bindable] public class Student { public var id:int; public var name:String; public var gender:String; public function Student(id:int, name:String, gender:String) { this.id = id; this.name = name; this.gender = gender; ...
1. Implicit Data Binding & Explicit Data Binding      //The main difference between implicit and explicit is that implicit data binding is //done at run time while explicit data binding is done at compile time     1). Implicit Data Binding:  Eg1.     <?xml version="1.0" enco ...
1. One-way binding & Two-way binding     1) One-way binding: Source  ->Destination, once source changed, destination will change accordingly.     2) Two-way binding: Source<->Destination, once source changed, destination will change and vice versa. Eg.     1)One-way binding <?x ...
1.  The previous article about data grid sort function that still have problems about code refractor. http://davyjones2010.iteye.com/blog/1840335   2. Below are solutions for a cleaner code with code refractor.       1. Vo (Compare functions are now moved from main application to value object. ...
  Requirements:     1. Set the first column of the data grid to be checkbox, indicating we can select one or more specific rows.     2. Once we clicked the header, then the data grid can be sorted by the clicked column, if there are same item in this column indicating that returns 0, we use the i ...
1. Declare a custom Event that extends Event and have some properties for data transfer purpose. 2. Declare the custom Event in component/application's metadata block 3. In the declared component/application, dispatch the custom event under specific circumstance. 4. Use the component in outter co ...
1. Create a subclass that extends the flash.events.Event base class 2. Add properties to the subclass to hold the data you want to dispatch 3. Create the event class's constructor:         3.1 Invoke the super() method of the Event class within the constructor, passing the event type to it     ...
曾经用Android开发过学校教务系统的登录功能(jsp/tomcat),能够成功模拟出Http请求. 但是WordPress的登录功能实现起来要绕一个弯子. 不能直接用HttpClient来得到cookie. 这位兄弟遇到的问题跟我是一样的 http://hi.baidu.com/xtitman/item/eeaef4c7d4a0e2bc0c0a7b69最后也是成功用socket方法把功能实现了. 其中为如何用socket模拟http的post/get请求消息头以及消息体纠结了几个小时。 My codes are as follows. Please ignore the anima ...
Global site tag (gtag.js) - Google Analytics