MYSQL_HOME 解壓路徑 C:\DevelopTool\MySQL\mysql-5.7.25-winx64
Path %MYSQL_HOME%\bin
先啟動服務:
net start MySQL【或者是MySQL57】
use mysql; GRANT ALL ON *.* TO root@'%' IDENTIFIED BY '密碼' WITH GRANT OPTION; flush privileges;
在了解REST API URI設計的規則之前,讓我們快速瀏覽一些我們將要討論的術語。
REST API使用統一資源標識符(URI)來尋址資源。在當今互聯網上,充斥著各種各樣的URI設計規則,既有像//api.example.com/louvre/leonardo-da-vinci/mona-lisa這樣能夠清楚的傳達API資源模型的文章,也有很難理解的文章,例如://api.example.com/68dd0-a9d3-11e0-9f1c-0800200c9a66 ;Tim Berners-Lee在他的“Axioms of Web Architecture”一文中將URI的不透明度總結成一句話:
唯一可以使用標識符的是引用對象。在不取消引用時,就不應該查看URI字符串的內容以獲取其他信息。
——蒂姆·伯納斯 - 李
客戶端必須遵循Web的鏈接范例,將URI視為不透明標識符。
REST API設計人員應該在考慮將REST API資源模型傳達給潛在的客戶端開發者的前提下,創造URI。在這篇文章中,我將嘗試為REST API URI 引入一套設計規則。
先跳過規則,URI的通用語法也適用與本文中的URI。RFC 3986定義了通用URI語法,如下所示:
URI = scheme “://” authority “/” path [ “?” query ][ “#” fragment ]
這是作為URI路徑中處理中最重要的規則之一,正斜杠(/)不會增加語義值,且可能導致混淆。REST API不允許一個尾部的斜杠,不應該將它們包含在提供給客戶端的鏈接的結尾處。
許多Web組件和框架將平等對待以下兩個URI:
http://api.canvas.com/shapes/
http://api.canvas.com/shapes
但是,實際上URI中的每個字符都會計入資源的唯一身份的識別中。
兩個不同的URI映射到兩個不同的資源。如果URI不同,那么資源也是如此,反之亦然。因此,REST API必須生成和傳遞精確的URI,不能容忍任何的客戶端嘗試不精確的資源定位。
有些API碰到這種情況,可能設計為讓客戶端重定向到相應沒有尾斜杠的URI(也有可能會返回301 - 用來資源重定向)。
URI的路徑中的正斜杠(/)字符用于指示資源之間的層次關系。
例如:
(http://api.canvas.com/shapes/polygons/quadrilaterals/squares ;
為了使您的URI容易讓人們理解,請使用連字符( - )字符來提高長路徑中名稱的可讀性。在路徑中,應該使用連字符代空格連接兩個單詞 。
例如:
http://api.example.com/blogs/guy-levin/posts/this-is-my-first-post
一些文本查看器為了區分強調URI,常常會在URI下加上下劃線。這樣下劃線(_)字符可能被文本查看器中默認的下劃線部分地遮蔽或完全隱藏。
為避免這種混淆,請使用連字符( - )而不是下劃線
方便時,URI路徑中首選小寫字母,因為大寫字母有時會導致一些問題。RFC 3986將URI定義為區分大小寫,但scheme 和 host components除外。
例如:
http://api.example.com/my-folder/my-doc
HTTP://API.EXAMPLE.COM/my-folder/my-doc
這個URI很好。URI格式規范(RFC 3986)認為該URI與URI#1相同。
http://api.example.com/My-Folder/my-doc
而這個URI與URI 1和2不同,這可能會導致不必要的混淆。
在Web上,(.)字符通常用于分隔URI的文件名和擴展名。
REST API不應在URI中包含人造文件擴展名,來指示郵件實體的格式。相反,他們應該依賴通過Content-Type中的header傳遞media type,來確定如何處理正文的內容。
http://api.college.com/students/3248234/courses/2005/fall.json
http://api.college.com/students/3248234/courses/2005/fall
如上所示:不應使用文件擴展名來表示格式。
應鼓勵REST API客戶端使用HTTP提供的格式選擇機制Accept request header。
為了是鏈接和調試更簡單,REST API應該支持通過查詢參數來支持媒體類型的選擇。
keep-it-simple的原則在這里同樣適用。雖然一些”語法學家”會告訴你使用復數來描述資源的單個實例是錯誤的,但實際上為了保持URI格式的一致性建議使用復數形式。
本著API提供商更容易實施和API使用者更容易操作的原則,可以不必糾結一些奇怪的復數(person/people,goose/geese)。
但是應該怎么處理層級關系呢?如果一個關系只能存在于另一個資源中,RESTful原則就會提供有用的指導。我們來看一下這個例子。學生有一些課程。這些課程在邏輯上映射到學生終端,如下所示:
http://api.college.com/students/3248234/courses - 檢索id為3248234的學生學習的所有課程的清單。
http://api.college.com/students/3248234/courses/physics -檢索該學生的物理課程
當你在設計REST API服務時,您必須注意這些由URI定義的資源。
正在構建的服務中的每個資源將至少有一個URI標識它。這個URI最好是有意義的,且能充分描述資源。URI應遵循可預測的層次結構,用來提高其可理解性,可用性:可預測的意義在于它們是一致的,它的層次結構在數據關系上是有意義的。
RESTful API是為使用者編寫的。URI的名稱和結構應該能夠向使用者傳達更清晰的含義。通過遵循上述規則,您將創建一個更清晰的的REST API與更友好的客戶端。這些并不是REST的規則或約束,僅僅是API的增強和補充。
我也建議你來看看http://blog.restcase.com/5-basic-rest-api-design-guidelines/這篇文章。
最后,望大家牢記:你在為你的客戶端設計API URI,而不僅僅是為你的數據。
* this.getClass().getClassLoader().getResourceAsStream("testVariables.bpmn")
從classpath根目錄下加載指定名稱的文件
* this.getClass().getResourceAsStream("testVariables.bpmn")
從當前包下加載指定名稱的文件
* this.getClass().getResourceAsStream("/testVariables.bpmn")
從classpath根目錄下加載指定名稱的文件
package org.gdharley.activiti.integration.rest;
import com.fasterxml.jackson.annotation.JsonProperty;
import com.fasterxml.jackson.databind.JsonNode;
import com.fasterxml.jackson.databind.ObjectMapper;
import org.activiti.engine.ActivitiException;
import org.activiti.engine.delegate.DelegateExecution;
import org.activiti.engine.delegate.Expression;
import org.activiti.engine.delegate.JavaDelegate;
import org.apache.commons.lang3.StringUtils;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.methods.*;
import org.apache.http.client.utils.URIBuilder;
import org.apache.http.client.utils.URLEncodedUtils;
import org.apache.http.conn.ssl.SSLConnectionSocketFactory;
import org.apache.http.conn.ssl.SSLContextBuilder;
import org.apache.http.conn.ssl.TrustSelfSignedStrategy;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClientBuilder;
import org.apache.http.message.BasicNameValuePair;
import org.apache.http.protocol.HTTP;
import org.apache.http.util.EntityUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.http.HttpMethod;
import java.io.IOException;
import java.net.URI;
import java.net.URISyntaxException;
import java.util.List;
/**
* Created by gharley on 5/2/17.
*/
public class SimpleRestDelegate implements JavaDelegate {
private static final Logger logger = LoggerFactory.getLogger(SimpleRestDelegate.class);
protected Expression endpointUrl;
protected Expression httpMethod;
protected Expression isSecure;
protected Expression payload;
// 一個Content-Type是application/json的請求,具體看起來是這樣的:
// POST /some-path HTTP/1.1
// Content-Type: application/json
//
// { "foo" : "bar", "name" : "John" }
//
//
// { "foo" : "bar", "name" : "John" } 就是這個請求的payload
protected Expression headers;
protected Expression responseMapping;
protected ObjectMapper objectMapper = new ObjectMapper();
// Create a mixin to force the BasicNameValuePair constructor
protected static abstract class BasicNameValuePairMixIn {
private BasicNameValuePairMixIn(@JsonProperty("name") String name, @JsonProperty("value") String value) {
}
}
public void execute(DelegateExecution execution) throws Exception {
logger.info("Started Generic REST call delegate");
if (endpointUrl == null || httpMethod == null) {
throw new IllegalArgumentException("An endpoint URL and http method are required");
}
String restUrl = getExpressionAsString(endpointUrl, execution);
String payloadStr = getExpressionAsString(payload, execution);
String headersJSON = getExpressionAsString(headers, execution); // [{"name":"headerName", "value":"headerValue"}]
String method = getExpressionAsString(httpMethod, execution);
String rMapping = getExpressionAsString(responseMapping, execution);
String secure = getExpressionAsString(isSecure, execution);
String scheme = secure == "true" ? "https" : "http";
// validate URI and create create request
URI restEndpointURI = composeURI(restUrl, execution);
logger.info("Using Generic REST URI " + restEndpointURI.toString());
HttpRequestBase httpRequest = createHttpRequest(restEndpointURI, scheme, method, headersJSON, payloadStr, rMapping);
// create http client
CloseableHttpClient httpClient = createHttpClient(httpRequest, scheme, execution);
// execute request
HttpResponse response = executeHttpRequest(httpClient, httpRequest);
// map response to process instance variables
if (responseMapping != null) {
mapResponse(response, rMapping, execution);
}
logger.info("Ended Generic REST call delegate");
}
protected URI composeURI(String restUrl, DelegateExecution execution)
throws URISyntaxException {
URIBuilder uriBuilder = null;
uriBuilder = encodePath(restUrl, uriBuilder);
return uriBuilder.build();
}
protected URIBuilder encodePath(String restUrl, URIBuilder uriBuilder) throws URISyntaxException {
if (StringUtils.isNotEmpty(restUrl)) {
// check if there are URL params
if (restUrl.indexOf('?') > -1) {
List<NameValuePair> params = URLEncodedUtils.parse(new URI(restUrl), "UTF-8");
if (params != null && !params.isEmpty()) {
restUrl = restUrl.substring(0, restUrl.indexOf('?'));
uriBuilder = new URIBuilder(restUrl);
uriBuilder.addParameters(params);
}
} else {
uriBuilder = new URIBuilder(restUrl);
}
}
return uriBuilder;
}
protected HttpRequestBase createHttpRequest(URI restEndpointURI, String scheme, String httpMethod, String headers, String payload, String responseMapping) {
if (StringUtils.isEmpty(httpMethod)) {
throw new ActivitiException("no HTTP method provided");
}
if (restEndpointURI == null) {
throw new ActivitiException("no REST endpoint URI provided");
}
HttpRequestBase httpRequest = null;
HttpMethod parsedMethod = HttpMethod.valueOf(httpMethod.toUpperCase());
StringEntity input;
URIBuilder builder = new URIBuilder(restEndpointURI);
switch (parsedMethod) {
case GET:
try {
httpRequest = new HttpGet(builder.build());
httpRequest = addHeadersToRequest(httpRequest, headers);
} catch (URISyntaxException use) {
throw new ActivitiException("Error while building GET request", use);
}
break;
case POST:
try {
httpRequest = new HttpPost(builder.build());
input = new StringEntity(payload);
// input.setContentType(new BasicHeader(HTTP.CONTENT_TYPE, "application/json"));
((HttpPost) httpRequest).setEntity(input);
httpRequest = addHeadersToRequest(httpRequest, headers);
break;
} catch (Exception e) {
throw new ActivitiException("Error while building POST request", e);
}
case PUT:
try {
httpRequest = new HttpPut(builder.build());
input = new StringEntity(payload);
// input.setContentType(new BasicHeader(HTTP.CONTENT_TYPE, "application/json"));
((HttpPut) httpRequest).setEntity(input);
httpRequest = addHeadersToRequest(httpRequest, headers);
break;
} catch (Exception e) {
throw new ActivitiException("Error while building PUT request", e);
}
case DELETE:
try {
httpRequest = new HttpDelete(builder.build());
httpRequest = addHeadersToRequest(httpRequest, headers);
} catch (URISyntaxException use) {
throw new ActivitiException("Error while building DELETE request", use);
}
break;
default:
throw new ActivitiException("unknown HTTP method provided");
}
return httpRequest;
}
protected CloseableHttpClient createHttpClient(HttpRequestBase request, String scheme, DelegateExecution execution) {
SSLConnectionSocketFactory sslsf = null;
// Allow self signed certificates and hostname mismatches.
if (StringUtils.equalsIgnoreCase(scheme, "https")) {
try {
SSLContextBuilder builder = new SSLContextBuilder();
builder.loadTrustMaterial(null, new TrustSelfSignedStrategy());
sslsf = new SSLConnectionSocketFactory(builder.build(), SSLConnectionSocketFactory.ALLOW_ALL_HOSTNAME_VERIFIER);
} catch (Exception e) {
logger.warn("Could not configure HTTP client to use SSL", e);
}
}
HttpClientBuilder httpClientBuilder = HttpClientBuilder.create();
if (sslsf != null) {
httpClientBuilder.setSSLSocketFactory(sslsf);
}
return httpClientBuilder.build();
}
protected HttpResponse executeHttpRequest(CloseableHttpClient httpClient, HttpRequestBase httpRequest) {
CloseableHttpResponse response = null;
try {
response = httpClient.execute(httpRequest);
} catch (IOException e) {
throw new ActivitiException("error while executing http request: " + httpRequest.getURI(), e);
}
if (response.getStatusLine().getStatusCode() >= 400) {
throw new ActivitiException("error while executing http request " + httpRequest.getURI() + " with status code: "
+ response.getStatusLine().getStatusCode());
}
return response;
}
protected void mapResponse(HttpResponse response, String responseMapping, DelegateExecution execution) {
if (responseMapping == null || responseMapping.trim().length() == 0) {
return;
}
JsonNode jsonNode = null;
try {
String jsonString = EntityUtils.toString(response.getEntity());
jsonNode = objectMapper.readTree(jsonString);
} catch (Exception e) {
throw new ActivitiException("error while parsing response", e);
}
if (jsonNode == null) {
throw new ActivitiException("didn't expect an empty response body");
}
execution.setVariable(responseMapping, jsonNode.toString());
}
protected HttpRequestBase addHeadersToRequest(HttpRequestBase httpRequest, String headerJSON) {
Boolean contentTypeDetected = false;
if (headerJSON != null) {
// Convert JSON to array
try {
// configuration for Jackson/fasterxml
objectMapper.addMixInAnnotations(BasicNameValuePair.class, BasicNameValuePairMixIn.class);
NameValuePair[] headers = objectMapper.readValue(headerJSON, BasicNameValuePair[].class);
for (NameValuePair header : headers) {
httpRequest.addHeader(header.getName(), header.getValue());
if (header.getName().equals(HTTP.CONTENT_TYPE)) {
contentTypeDetected = true;
}
}
} catch (Exception e) {
throw new ActivitiException("Unable to parse JSON header array", e);
}
}
// Now add content type if necessary
if (!contentTypeDetected) {
httpRequest.addHeader(HTTP.CONTENT_TYPE, "application/json");
}
return httpRequest;
}
/**
* @return string value of expression.
* @throws {@link IllegalArgumentException} when the expression resolves to a value which is not a string
* or if the value is null.
*/
protected String getExpressionAsString(Expression expression, DelegateExecution execution) {
if (expression == null) {
return null;
} else {
Object value = expression.getValue(execution);
if (value instanceof String) {
return (String) value;
} else {
throw new IllegalArgumentException("Expression does not resolve to a string or is null: " + expression.getExpressionText());
}
}
}
}
activiti系統一共有23個表,包括流程定義表、一般數據信息表、流程運行實例表、流程歷史記錄表、用戶用戶組表。
流程定義表,流程定義表也可以叫做是靜態資源庫,靜態資源包括圖片、定義規則等。它有部署信息表、流程模型表、流程定義表
1、ACT_RE_DEPLOYMENT(部署信息表)
包括:部署流程名稱、類型、部署時間
2、ACT_RE_MODEL(模型表)
名稱,key、類型、創建時間、最后修改時間、版本、數據源信息、部署ID、編輯源值ID、編輯源額外值ID(外鍵ACT_GE_BYTEARRAY )
3、ACT_RE_PROCDEF(流程定義表)
包括流程定義、類型、流程名稱、流程key、版本號、部署ID、資源名稱、圖片資源名稱、描述信息、是否從key啟動、暫停狀態。
運行實例表記錄流程流轉過程中產生的數據,一般數據分為兩個部分流程數據、業務數據。流程數據是指activiti流程引擎流轉過程中的數據,包括流程執行實例數據接、任務數據、執行任務人員信息、變量信息。業務數據則是流程過程中保存的表單數據,例如:如請假的請假單數據、報銷單數據、審批意見信息等,此部分數據一般需要自己建數據表進行保存,在之前的jbpm4中沒有保存業務數據。
1、ACT_RU_EVENT_SUBSCR(事件子腳本)作用未知
事件名稱(EVENT_NAME_)、事件類型(EVENT_TYPE_)、流程執行ID(EXECUTION_ID_)、流程實例ID(PROC_INST_ID_)、活動ID(ACTIVITY_ID_)、配置信息(CONFIGURATION_)、創建時間(CREATED_)
2、ACT_RU_EXECUTION(執行中流程執行)核心我的代辦任務查詢表
流程實例ID(PROC_INST_ID_),業務key(BUSINESS_KEY_)、父執行流程(PARENT_ID_)、流程定義Id(外鍵PROC_DEF_ID_)、實例id(ACT_ID_)、激活狀態(IS_ACTIVE_)、并發狀態(is_concurrent)、is_scope、is_evnet_scope、暫停狀態(suspension_state)、緩存結束狀態(cached_end_state)
3、ACT_RU_IDENTITYLINK(身份聯系)
用戶組ID(GROUP_ID_)、用戶組類型(TYPE_)、用戶ID(USER_ID_)、任務Id(外鍵:TASK_ID_)、流程實例ID(外鍵:PROC_INST_ID_)、流程定義Id(外鍵:PROC_DEF_ID_)
4、ACT_RU_JOB(運行中的任務)
5、ACT_RU_TASK(執行中實時任務)代辦任務查詢表
實例id(外鍵EXECUTION_ID_)、流程實例ID(外鍵PROC_INST_ID_)、流程定義ID(PROC_DEF_ID_)、任務名稱(NAME_)、父節任務ID(PARENT_TASK_ID_)
、任務描述(DESCRIPTION_)、任務定義key(TASK_DEF_KEY_)、所屬人(OWNER_)、代理人員 (ASSIGNEE_)、代理團(DELEGATION_)、優先權(PRIORITY_)、創建時間(CREATE_TIME_)、執行時間(DUE_DATE_)、暫停狀態(SUSPENSION_STATE_)
6、ACT_RU_VARIABLE(實時變量)
變量名稱(NAME_)、編碼類型(TYPE_)、執行實例ID(EXECUTION_ID_)、流程實例Id(PROC_INST_ID_)、任務id(TASK_ID_)、字節組ID(BYTEARRAY_ID_)、DOUBLE_、LONG_、TEXT_、TEXT2_
流程歷史信息表,activiti歷史記錄表包括節點信息表、附件信息表、歷史審批記錄表、理想詳細信息表、歷史身份信息表、流程實例歷史表、任務歷史表、歷史變量表。(節點信息表、附件信息表、歷史審批記錄表、理想詳細信息表、歷史身份信息表)這些表目前還未知是如何用的。(流程實例歷史表、任務歷史表、歷史變量)三個表可以查詢我已完成任務、任務追蹤等。
1、ACT_HI_ACTINST(活動實例信息)
流程定義ID(PROC_DEF_ID_)、流程實例ID(PROC_INST_ID_)、流程執行ID(EXECUTION_ID_)、活動ID(ACT_ID_)、活動名稱(TASK_ID_)、活動類型(ACT_TYPE_)、任務ID、(TASK_ID_)、請求流程實例ID(CALL_PROC_INST_ID_)、代理人員(ASSIGNEE_)、開始時間(START_TIME_)、結束時間(END_TIME_)、時長(DURATION_)
2、ACT_HI_ATTACHMENT(附件信息)
用戶id(USER_ID_)、名稱(NAME_)、描述(DESCRIPTION_)、類型(TYPE_)、任務Id(TASK_ID_)、流程實例ID(PROC_INST_ID_)、連接(URL_)、內容Id(CONTENT_ID_)
3、ACT_HI_COMMENT(歷史審批信息)
類型(TYPE_)、時間(TIME_)、用戶Id(USER_ID_)、任務Id(TASK_ID_)、流程實例Id(PROC_INST_ID_)、活動(ACTION_)、消息(MESSAGE_)、全部消息(FULL_MSG_)
4、ACT_HI_DETAIL(歷史詳細信息)
數據類型(TYPE_)、創建時間(TIME_)、名稱(NAME_)、流程實例ID(PROC_INST_ID_)、執行實例Id(EXECUTION_ID_)、任務Id(TASK_ID_)、活動實例Id(ACT_INST_ID_)、變量類型(VAR_TYPE_)、字節數組Id、DOUBLE_、LONG_、值(TEXT_)、值2(TEXT2_)
5、ACT_HI_IDENTITYLINK(歷史身份信息)
任務Id(TASK_ID_)、流程實例Id(PROC_INST_ID_)、userId(USER_ID_)、用戶組類型Type(TYPE_)、用戶組ID(GROUP_ID_)
6、ACT_HI_PROCINST(歷史流程實例信息)核心表
流程實例ID(PROC_INST_ID_)、業務Key(BUSINESS_KEY_)、流程定義Id(PROC_DEF_ID_)、開始時間(START_TIME_)、結束時間(END_TIME_)、時長(DURATION_)、發起人員Id(START_USER_ID_)、開始節點(START_ACT_ID_)、結束節點(END_ACT_ID_)、超級流程實例Id(SUPER_PROCESS_INSTANCE_ID_)、刪除理由(DELETE_REASON_)
7、ACT_HI_TASKINST(歷史任務流程實例信息)核心表
流程實例ID(PROC_INST_ID_)、任務定義Key(BUSINESS_KEY_)、流程定義Id(PROC_DEF_ID_)、執行ID(EXECUTION_ID_)、名稱(NAME_)、父任務iD(PARENT_TASK_ID_)、描述(DESCRIPTION_)、所屬人(OWNER_)、代理人(ASSIGNEE_)、開始時間(START_TIME_)、結束時間(END_TIME_)、時長(DURATION_)、刪除理由(DELETE_REASON__)、優先級(PRIORITY_)、應完成時間(DUE_DATE_)、表單key(FORM_KEY_)
8、ACT_HI_VARINST(歷史變量信息)
流程實例ID(PROC_INST_ID_)、執行ID(EXECUTION_ID_)、任務Id、名稱(NAME_)、變量(TASK_ID_)、類型(VAR_TYPE_)、字節數組ID(BYTEARRAY_ID_)、DOUBLE_、LONG_、TEXT_、TEXT2_
1、ACT_GE_BYTEARRAY(字節數據表)
名稱(NAME_)、部署Id(DEPLOYMENT_ID_)、字節數據(BYTES_)、發生的(GENERATED_)
2、ACT_GE_PROPERTY(一般屬性表)
名稱(NAMe_)、值(VALUe_)
Activit 的用戶用戶組表,包括用戶信息、用戶組信息、用戶與用戶組間的關系、用戶信息與用戶之間的關系。在實際開發中未采用,用的實際系統中用戶。
1、ACT_ID_GROUP(用戶組表)
名稱(NAME_)、類型(TYPE_)
2、ACT_ID_USER(用戶表)
姓(FIRST_)、名稱(LAST_)、郵件(EMAIL_)、密碼(PWD_)、頭像Id (PICTURE_ID_)
3、ACT_ID_INFO(用戶信息表)
用戶Id(USER_ID_)、類型(TYPE_)、formINPut名稱(KEY_)、值(VALUE_)、密碼(PASSWORD_)、父節點(PARENT_ID_)
4、ACT_ID_MEMBERSHIP(用戶用戶組關聯表)
用戶Id(user_ID_)、用戶組Id(group_Id)
Activiti表結構分析完成,花了5個小時,還有很多問題不明白。后續慢慢開發過程中再理一次表之間關系吧,初步想法在系統中需要擴建表,把業務數據和流程數據分開。
Druid是什么?
Druid是一個JDBC組件,它包括四個部分:
DruidDriver,是一個ProxyJdbcDriver,它提供了Filter-Chain模式的擴展機制,使得在Jdbc擴展編程特別方便。
Druid提供了一些內置的擴展機制,包括Stat、Log、Trace、HA等擴展。
DruidDataSource是一個數據庫連接池的實現,它的設計目標是提供一個當前最好的數據庫連接池,在性能、擴展性等方面取得最合適的平衡,取代DBCP、C3P0等連接池。
這是DruidDataSource的設計圖示:
http://code.alibabatech.com/svn/druid/trunk/doc/druid-pool.txt
如果發現有亂碼,請選擇utf-8的編碼方式查看。
Druid提供一個手工編寫的高性能的方便擴展的SQL Parser。將會支持MySQL、Oracle等流行關系數據庫的SQL Parser。
Parser組件包括如下幾個部分:
Druid提供了強大的監控功能,能夠監控連接池行為和SQL執行情況,讓你能夠詳細了解應用的數據庫訪問行為。
為了使神經網絡有效,我們必須對數據進行正態化。這是激活函數的正確計算所需要的。正態化是一種數學處理,將數據轉換為 0..1 或 -1..1 的范圍。正態化后的數據可以進行去正態化,即轉換回原來的范圍。
The cron4j main entity is the scheduler. With a it.sauronsoftware.cron4j.Scheduler instance you can execute tasks at fixed moments, during all the year. A scheduler can execute a task once a minute, once every five minutes, Friday at 10:00, on February the 16th at 12:30 but only if it is Saturday, and so on.
The use of the cron4j scheduler is a four steps operation:
Consider this simple example:
import it.sauronsoftware.cron4j.Scheduler; public class Quickstart { public static void main(String[] args) { // Creates a Scheduler instance. Scheduler s = new Scheduler(); // Schedule a once-a-minute task. s.schedule("* * * * *", new Runnable() { public void run() { System.out.println("Another minute ticked away..."); } }); // Starts the scheduler. s.start(); // Will run for ten minutes. try { Thread.sleep(1000L * 60L * 10L); } catch (InterruptedException e) { ; } // Stops the scheduler. s.stop(); } }
This example runs for ten minutes. At every minute change it will print the sad (but true) message "Another minute ticked away...".
Some other key concepts:
A UNIX crontab-like pattern is a string split in five space separated parts. Each part is intended as:
The star wildcard character is also admitted, indicating "every minute of the hour", "every hour of the day", "every day of the month", "every month of the year" and "every day of the week", according to the sub-pattern in which it is used.
Once the scheduler is started, a task will be launched when the five parts in its scheduling pattern will be true at the same time.
Scheduling patterns can be represented with it.sauronsoftware.cron4j.SchedulingPattern instances. Invalid scheduling patterns are cause of it.sauronsoftware.cron4j.InvalidPatternExceptions. The SchedulingPattern class offers also a static validate(String) method, that can be used to validate a string before using it as a scheduling pattern.
Some examples:
5 * * * *
This pattern causes a task to be launched once every hour, at the begin of the fifth minute (00:05, 01:05, 02:05 etc.).
* * * * *
This pattern causes a task to be launched every minute.
* 12 * * Mon
This pattern causes a task to be launched every minute during the 12th hour of Monday.
* 12 16 * Mon
This pattern causes a task to be launched every minute during the 12th hour of Monday, 16th, but only if the day is the 16th of the month.
Every sub-pattern can contain two or more comma separated values.
59 11 * * 1,2,3,4,5
This pattern causes a task to be launched at 11:59AM on Monday, Tuesday, Wednesday, Thursday and Friday.
Values intervals are admitted and defined using the minus character.
59 11 * * 1-5
This pattern is equivalent to the previous one.
The slash character can be used to identify step values within a range. It can be used both in the form */c and a-b/c. The subpattern is matched every c values of the range 0,maxvalue or a-b.
*/5 * * * *
This pattern causes a task to be launched every 5 minutes (0:00, 0:05, 0:10, 0:15 and so on).
3-18/5 * * * *
This pattern causes a task to be launched every 5 minutes starting from the third minute of the hour, up to the 18th (0:03, 0:08, 0:13, 0:18, 1:03, 1:08 and so on).
*/15 9-17 * * *
This pattern causes a task to be launched every 15 minutes between the 9th and 17th hour of the day (9:00, 9:15, 9:30, 9:45 and so on... note that the last execution will be at 17:45).
All the fresh described syntax rules can be used together.
* 12 10-16/2 * *
This pattern causes a task to be launched every minute during the 12th hour of the day, but only if the day is the 10th, the 12th, the 14th or the 16th of the month.
* 12 1-15,17,20-25 * *
This pattern causes a task to be launched every minute during the 12th hour of the day, but the day of the month must be between the 1st and the 15th, the 20th and the 25, or at least it must be the 17th.
Finally cron4j lets you combine more scheduling patterns into one, with the pipe character:
0 5 * * *|8 10 * * *|22 17 * * *
This pattern causes a task to be launched every day at 05:00, 10:08 and 17:22.
The simplest manner to build a task is to implement the well-known java.lang.Runnable interface. Once the task is ready, it can be scheduled with the it.sauronsoftware.cron4j.Scheduler.schedule(String, Runnable) method. This method throws an it.sauronsoftware.cron4j.InvalidPatternException when the supplied string does not represent a valid scheduling pattern.
Another way to build a task is to extend the it.sauronsoftware.cron4j.Task abstract class, which is more powerful and let the developer access some other cron4j features. This is better discussed in the "Building your own task" paragraph. Task instances can be scheduled with the schedule(String, Task) and the schedule(SchedulingPattern, Task) methods.
Scheduling methods available in the scheduler always return an ID used to recognize and retrieve the scheduled operation. This ID can be used later to reschedule the task (changing its scheduling pattern) with the reschedule(String, String) or the reschedule(String, SchedulingPattern) methods, and to deschedule the task (remove the task from the scheduler) with the deschedule(String) method.
The same ID can also be used to retrieve the scheduling pattern associated with a scheduled task, with the getSchedulingPattern(String) method, or to retrieve the task itself, with the getTask(String) method.
System processes can be easily scheduled using the ProcessTask class:
ProcessTask task = new ProcessTask("C:\\Windows\\System32\\notepad.exe"); Scheduler scheduler = new Scheduler(); scheduler.schedule("* * * * *", task); scheduler.start(); // ...
Arguments for the process can be supplied by using a string array instead of a single command string:
String[] command = { "C:\\Windows\\System32\\notepad.exe", "C:\\File.txt" }; ProcessTask task = new ProcessTask(command); // ...
Environment variables for the process can be supplied using a second string array, whose elements have to be in the NAME=VALUE form:
String[] command = { "C:\\tomcat\\bin\\catalina.bat", "start" }; String[] envs = { "CATALINA_HOME=C:\\tomcat", "JAVA_HOME=C:\\jdks\\jdk5" }; ProcessTask task = new ProcessTask(command, envs); // ...
The default working directory for the process can be changed using a third parameter in the constructor:
String[] command = { "C:\\tomcat\\bin\\catalina.bat", "start" }; String[] envs = { "CATALINA_HOME=C:\\tomcat", "JAVA_HOME=C:\\jdks\\jdk5" }; File directory = "C:\\MyDirectory"; ProcessTask task = new ProcessTask(command, envs, directory); // ...
If you want to change the default working directory but you have not any environment variable, the envs parameter of the constructor can be set to null:
ProcessTask task = new ProcessTask(command, null, directory);
When envs is null the process inherits every environment variable of the current JVM:
Environment variables and the working directory can also be set by calling the setEnvs(String[]) and setDirectory(java.io.File) methods.
The process standard output and standard error channels can be redirected to files by using the setStdoutFile(java.io.File) and setStderrFile(java.io.File) methods:
ProcessTask task = new ProcessTask(command, envs, directory); task.setStdoutFile(new File("out.txt")); task.setStderrFile(new File("err.txt"));
In a siminal manner, the standard input channel can be read from an existing file, calling the setStdinFile(java.io.File) method:
ProcessTask task = new ProcessTask(command, envs, directory); task.setStdinFile(new File("in.txt"));
The cron4j scheduler can also schedule a set of processes from a file.
You have to prepare a file, very similar to the ones used by the UNIX crontab, and register it in the scheduler calling the scheduleFile(File) method. The file can be descheduled by calling the descheduleFile(File) method. Scheduled files can be retrieved by calling the getScheduledFiles() method.
Scheduled files are parsed every minute. The scheduler will launch every process declared in the file whose scheduling pattern matches the current system time.
Syntax rules for cron4j scheduling files are reported in the "Cron parser" paragraph.
A java.lang.Runnable object is the simplest task ever possible, but to gain control you need to extend the it.sauronsoftware.cron4j.Task class. In the plainest form, implementing Runnable or extending Task are very similar operations: while the first requires a run() method, the latter requires the implementation of execute(TaskExecutionContext). The execute(TaskExecutionContext) method provides a it.sauronsoftware.cron4j.TaskExecutionContext instance, which the Runnable.run() method does not provide. The context can be used in the following ways:
A task can communicate with its executor, by notifying its internal state with a textual description. This is called status tracking. If you are interested in supporting status tracking in your task, you have to override the supportsStatusTracking() method, which should return true. Once this has been done, within the execute(TaskExecutionContext) method you are enabled to call the context setStatusMessage(String) method. This will propagate your task status message to its executor. The status message, through the executor, can be retrieved by an external user (see the "
A task can communicate with its executor, by notifying its completeness level with a numeric value. This is called completeness tracking. If you are interested in supporting completeness tracking in your task, you have to override the supportsCompletenessTracking() method, which should return true. Once this has been done, within the execute(TaskExecutionContext) method you are enabled to call the context setCompleteness(double) method, with a value between 0 and 1. This will propagate your task completeness level to its executor. The completeness level, through the executor, can be retrieved by an external user (see the "
A task can be optionally paused. If you are interested in supporting pausing and resuming in your task, you have to override the canBePaused() method, which should return true. Once this has been done, within the execute(TaskExecutionContext) method you have to periodically call the context pauseIfRequested() method. This will pause the task execution until it will be resumed (or stopped) by an external user (see the "
A task can be optionally stopped. If you are interested in supporting stopping in your task, you have to override the canBeStopped() method, which should return true. Once this has been done, within the execute(TaskExecutionContext) method you have to periodically call the context isStopped() method. This will return true when the execution has be demanded to be stopped by an external user (see the "
Through the context, the task can retrieve the scheduler, calling getScheduler().
Through the context, the task can retrieve its executor, calling getTaskExecutor().
A custom task can be scheduled, launched immediately or returned by a task collector.
You can build and plug within the scheduler your own task source, via the task collector API.
The cron4j scheduler supports the registration of one or more it.sauronsoftware.cron4j.TaskCollector instances, with the addTaskCollector(TaskCollector) method. Registered collectors can be retrieved with the scheduler getTaskCollectors() method. A previously registered collector can be removed from the scheduler with the removeTaskCollector(TaskCollector) method. Collectors can be added, queried or removed at every moment, also when the scheduler is started and it is running.
Each registered task collector is queried by the scheduler once a minute. The scheduler calls the collector getTasks() method. The implementation must return a it.sauronsoftware.cron4j.TaskTable instance. A TaskTable is a table that associates tasks and scheduling patterns. The scheduler, once the table has been retrieved, will examine the reported entries, and it will execute every task whose scheduling pattern matches the current system time.
A custom collector can be used to tie the scheduler with an external task source, i.e. a database or a XML file, which can be managed and changed in its contents also at run time.
The it.sauronsoftware.cron4j.SchedulerListener API can be used to listen to scheduler events.
The SchedulerListener interface requires the implementation of the following methods:
taskLaunching(TaskExecutor)
This one is called every time a task is launched by the scheduler.
taskSucceeded(TaskExecutor)
This one is called every time a task execution has been successfully completed.
taskFailed(TaskExecutor, Throwable)
This one is called every time a task execution fails due to an uncaught exception.
See the " Once your SchedulerListener instance is ready, you can register it on a Scheduler object by calling its addSchedulerListener(SchedulerListener) method. Already registered listeners can be removed by calling the removeSchedulerListener(SchedulerListener) method. The scheduler can also give back any registered listener, with the getSchedulerListeners() method. SchedulerListeners can be added and removed at every moment, also while the scheduler is running.
The scheduler, once it has been started and it is running, can be queried to give back its executors. An executor is similar to a thread. Executors is used by the scheduler to execute tasks.
By calling the Scheduler.getExecutingTasks() method you can obtain the currently ongoing executors.
You can also obtain an executor through a SchedulerListener instance (see the "Building your own scheduler listener" paragraph).
Each executor, represented by a it.sauronsoftware.cron4j.TaskExecutor instance, performs a different task execution.
The task can be retrieved with the getTask() method.
The executor status can be checked with the isAlive() method: it returns true if the executor is currently running.
If the executor is running, the current thread can be paused until the execution will be completed, calling the join() method.
The supportsStatusTracking() method returns true if the currently executing task supports status tracking. It means that the task communicates to the executor its status, represented by a string. The current status message can be retrieved by calling the executor getStatusMessage() method.
The supportsCompletenessTracking() method returns true if the currently executing task supports completeness tracking. It means that the task communicates to the executor its own completeness level. The current completeness level can be retrieved by calling the executor getCompleteness() method. Returned values are between 0 (task just started and still nothing done) and 1 (task completed).
The canBePaused() method returns true if the currently executing task supports execution pausing. It means that the task execution can be paused by calling the executor pause() method. The pause status of the executor can be checked with the isPaused() method. A paused executor can be resumed by calling its resume() method.
The canBeStopped() method returns true if the currently executing task supports execution interruption. It means that the task execution can be stopped by calling the executor stop() method. The interruption status of the executor can be checked with the isStopped() method. Stopped executors cannot be resumed.
The getStartTime() method returns a time stamp reporting the start time of the executor, or a value less than 0 if the executor has not been yet started.
The getScheduler() method returns the scheduler which is the owner of the executor.
The getGuid() method returns a textual GUID for the executor.
Executors offer also an event-driven API, through the it.sauronsoftware.cron4j.TaskExecutorListener class. A TaskExecutorListener can be added to a TaskExecutor with its addTaskExecutorListener(TaskExecutorListener) method. Listeners can be removed with the removeTaskExecutorListener(TaskExecutorListener) method, and they can also be retrieved with the getTaskExecutorListeners() method. A TaskExecutorListener must implement the following methods:
executionPausing(TaskExecutor)
Called when the executor is requested to pause the ongoing task. The given parameter represents the source TaskExecutor instance.
executionResuming(TaskExecutor)
Called when the executor is requested to resume the execution of the previously paused task. The given parameter represents the source TaskExecutor instance.
executionStopping(TaskExecutor)
Called when the executor is requested to stop the task execution. The given parameter represents the source TaskExecutor instance.
executionTerminated(TaskExecutor, Throwable)
Called when the executor has completed the task execution. The first parameter represents the source TaskExecutor instance, while the second is the optional exception that has caused the task to be terminated. If the task has been completed successfully, the given value is null.
statusMessageChanged(TaskExecutor, String)
Called every time the execution status message changes. The first parameter represents the source TaskExecutor instance, while the second is the new message issued by the task.
completenessValueChanged(TaskExecutor, double)
Called every time the execution completeness value changes. The first parameter represents the source TaskExecutor instance, while the second is the new completeness value (between 0 and 1) issued by the task.
If the scheduler is started and running, it is possible to manually launch a task, without scheduling it with a pattern. The method is Scheduler.launch(Task). The task will be immediately launched, and a TaskExecutor instace is returned to the caller. The returned object can be used to control the task execution (see the "
Scheduler instances, by default, work with the system default Time Zone. I.e. a scheduling pattern whose value is 0 2 * * * will activate its task at 02:00 AM according to the default system Time Zone. The scheduler can be requested to work with a different Time Zone, which is not the system default one. Call Scheduler.setTimeZone(TimeZone) and Scheduler.getTimeZone() to control this feature.
Once the default Time Zone has been changed, system current time is adapted to the supplied zone before comparing it with registered scheduling patterns. The result is that any supplied scheduling pattern is treated according to the specified Time Zone. Suppose this situation:
The scheduler, before comparing system time with patterns, translates 10:00 from GMT+1 to GMT+3. It means that 10:00 becomes 12:00. The resulted time is then used by the scheduler to activate tasks. So, in the given configuration at the given moment, any task scheduled as 0 12 * * * will be executed, while any 0 10 * * * will not.
The Java Virtual Machine exits when the only threads running are all daemon threads. The cron4j scheduler can be configured to spawn only daemon threads. To control this feature call the Scheduler.setDaemon(boolean) method. This method must be called before the scheduler is started. Default value is false. To check the scheduler current daemon status call the Scheduler.isDaemon() method.
The it.sauronsoftware.cron4j.Predictor class is able to predict when a scheduling pattern will be matched.
Suppose you want to know when the scheduler will execute a task scheduled with the pattern 0 3 * jan-jun,sep-dec mon-fri. You can predict the next n execution of the task using a Predictor instance:
String pattern = "0 3 * jan-jun,sep-dec mon-fri"; Predictor p = new Predictor(pattern); for (int i = 0; i < n; i++) { System.out.println(p.nextMatchingDate()); }
The it.sauronsoftware.cron4j.CronParser class can be used to parse crontab-like formatted file and character streams.
If you want to schedule a list of tasks declared in a crontab-like file you don't need the CronParser, since you can do it by adding the file to the scheduler, with the Scheduler.scheduleFile(File) method.
Consider to use the CronParser if the Scheduler.scheduleFile(File) method is not enough for you. In example, you may need to fetch the task list from a remote source which is not representable as a java.io.File object (a document on a remote server, a DBMS result set and so on). To solve the problem you can implement your own it.sauronsoftware.cron4j.TaskCollector, getting the advantage of the CronParser to easily parse any crontab-like content.
You can parse a whole file/stream, but you can also parse a single line.
A line can be empty, can contain a comment or it can be a scheduling line.
A line containing no characters or a line with only space characters is considered an empty line.
A line whose first non-space character is a number sign (#) is considered a comment.
Empty lines and comment lines are ignored by the parser.
Any other kind of line is parsed as a scheduling line.
A valid scheduling line respects the following structure:
scheduling-pattern [options] command [args]
After the scheduling pattern item, other tokens in each line are space separated or delimited with double quotation marks (").
Double quotation marks delimited items can take advantage of the following escape sequences:
The options token collection can include one or more of the following elements:
It is also possible to schedule the invocation of a method of a Java class in the scope of the parser ClassLoader. The method has to be static and it must accept an array of strings as its sole argument. To invoke a method of this kind the syntax is:
scheduling-pattern java:className#methodName [args]
The #methodName part can be omitted: in this case the main(String[]) method will be assumed.
Please note that static methods are invoked within the scheduler same JVM, without spawning any external process. Thus IN, OUT, ERR, ENV and DIR options can't be applied.
Invalid scheduling lines are discarded without blocking the parsing procedure, but an error message is sent to the application standard error channel.
Valid examples:
0 5 * * * sol.exe 0,30 * * * * OUT:C:\ping.txt ping 10.9.43.55 0,30 4 * * * "OUT:C:\Documents and Settings\Carlo\ping.txt" ping 10.9.43.55 0 3 * * * ENV:JAVA_HOME=C:\jdks\1.4.2_15 DIR:C:\myproject OUT:C:\myproject\build.log C:\myproject\build.bat "Nightly Build" 0 4 * * * java:mypackage.MyClass#startApplication myOption1 myOption2
阿里云Linux安裝軟件鏡像源
阿里云是最近新出的一個鏡像源。得益與阿里云的高速發展,這么大的需求,肯定會推出自己的鏡像源。
阿里云Linux安裝鏡像源地址:http://mirrors.aliyun.com/
CentOS系統更換軟件安裝源
第一步:備份你的原鏡像文件,以免出錯后可以恢復。
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
第二步:下載新的CentOS-Base.repo 到/etc/yum.repos.d/
CentOS 5
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-5.repo
CentOS 6
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo
第三步:運行yum makecache生成緩存
yum clean all
yum makecache
CentOS/RHEL 7.x:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm |
CentOS/RHEL 6.x:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm |
CentOS/RHEL 5.x:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-5.noarch.rpm rpm -Uvh http://mirror.webtatic.com/yum/el5/latest.rpm |
Now you can install PHP 5.5’s mod_php SAPI (along with an opcode cache) by doing:
yum install php55w php55w-opcache |
You can alternatively install PHP 5.5’s php-fpm SAPI (along with an opcode cache by doing: