kettle调用免费天气接口API入库

1.采用中华万年历天气API

//URL:
http://wthrcdn.etouch.cn/weather_mini?city=太原
//获取到的json数据
{
	"data": {
		"yesterday": {
			"date": "26日星期四",
			"high": "高温 28℃",
			"fx": "西风",
			"low": "低温 14℃",
			"fl": "<![CDATA[2级]]>",
			"type": "阴"
		},
		"city": "太原",
		"forecast": [{
			"date": "27日星期五",
			"high": "高温 30℃",
			"fengli": "<![CDATA[2级]]>",
			"low": "低温 16℃",
			"fengxiang": "南风",
			"type": "多云"
		}, {
			"date": "28日星期六",
			"high": "高温 28℃",
			"fengli": "<![CDATA[2级]]>",
			"low": "低温 16℃",
			"fengxiang": "东北风",
			"type": "阴"
		}, {
			"date": "29日星期天",
			"high": "高温 28℃",
			"fengli": "<![CDATA[2级]]>",
			"low": "低温 15℃",
			"fengxiang": "东风",
			"type": "多云"
		}, {
			"date": "30日星期一",
			"high": "高温 25℃",
			"fengli": "<![CDATA[2级]]>",
			"low": "低温 15℃",
			"fengxiang": "东风",
			"type": "小雨"
		}, {
			"date": "31日星期二",
			"high": "高温 19℃",
			"fengli": "<![CDATA[2级]]>",
			"low": "低温 15℃",
			"fengxiang": "东北风",
			"type": "大雨"
		}],
		"ganmao": "感冒易发期，外出请适当调整衣物，注意补充水分。",
		"wendu": "25"
	},
	"status": 1000,
	"desc": "OK"
}

2.定义请求 参数

 3.发请求

 4.解析结果为json

 5.去掉无用字段

6.截取温度数值

7.入库

CREATE TABLE weather (
	f_day date NOT NULL, -- 日期
	weather varchar(100) NULL, -- 天气
	ltemp int2 NULL, -- 最低温度
	htemp int2 NULL, -- 最高温度
	CONSTRAINT weather_pk PRIMARY KEY (f_day)
);