星期四, 2月 24, 2011

[Mysql] SP where in

DROP PROCEDURE IF EXISTS `simpleproc08`$$

CREATE PROCEDURE `simpleproc08`(IN param0 TEXT, OUT param1 INT)
BEGIN
SET @qry = CONCAT('SELECT COUNT(*) INTO @param1 FROM regions WHERE regions_id IN (', param0, ')');
PREPARE stmt FROM @qry;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET param1 = @param1;
END$$

DELIMITER ;

CALL simpleproc08('1, 2, 3', @a);
SELECT @a;
Result:
@a
------
3

星期三, 2月 23, 2011

[Alfresco] Authority

AuthorityDAOImpl.java
Language: Java
License: GPL
Copyright: (C) 2005-2007 Alfresco Software Limited.
LOC: 471

AuthorityServiceImpl.java
Language: Java
License: GPL
Copyright: (C) 2005-2007 Alfresco Software Limited.
LOC: 215

Reference:
Repository Cache Configuration
Repository Configuration

星期二, 2月 22, 2011

星期二, 2月 15, 2011

[Alfresco] Alfresco APIs Reference

if you want to use alfresco APIs to build costomized web application,those are some links as the following
Tips:Navigate to Web Script List:http://localhost:8080/alfresco/service/index
  1. RESTful API (source code path:remote-api/config/alfresco/templates/webscripts/org/alfresco/*)
    1. 3.1 REST API
    2. Deployment REST API
    3. 3.0 REST API
    4. Repository RESTful API Reference
    5. 2.1 REST API
    6. 2.0 RESTful API
    7. OpenSearch
    8. REST Design Guidelines
    9. CMIS RESTful API Reference
  2. 3.4 JavaScript Services API 
  3. JavaScript API Cookbook
  4. Java Foundation API