91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

該文件為2019年美團最新商圈數據sql數據，可以直接使用

資源截圖

代碼片段和文件信息 

import?java.io.File;
import?java.io.FileWriter;
import?java.util.ArrayList;
import?java.util.List;
import?java.util.Map;

import?org.springframework.jdbc.core.JdbcTemplate;

import?com.fasterxml.jackson.databind.objectMapper;

public?class?BusinessUtil?{
	
	???public?static?void?main（String[]?args）?{
	????	
	????????String?cn?=?“你“;
	????????System.out.println（cnToUnicode（cn））;
	????????//?字符串?:?\u5f00\u59cb\u4efb\u52a1?，由于?\?在java里是轉義字符，要寫出下面這種形式
	????????String?unicode?=?“\\u4f60“;
	????????System.out.println（unicodeToCn（unicode））;
	????????JsonToSql（）;
	????}
	?????
	????private?static?String?unicodeToCn（String?unicode）?{
	????????/**?以?\?u?分割，因為java注釋也能識別unicode，因此中間加了一個空格*/
	????????String[]?strs?=?unicode.split（“\\\\u“）;
	????????String?returnStr?=?““;
	????????//?由于unicode字符串以?\?u?開頭，因此分割出的第一個字符是““。
	????????for?（int?i?=?1;?i?	??????????returnStr?+=?（char）?Integer.valueOf（strs[i]?16）.intValue（）;
	????????}
	????????return?returnStr;
	????}
	?????
	????private?static?String?cnToUnicode（String?cn）?{
	????????char[]?chars?=?cn.toCharArray（）;
	????????String?returnStr?=?““;
	????????for?（int?i?=?0;?i?	??????????returnStr?+=?“\\u“?+?Integer.toString（chars[i]?16）;
	????????}
	????????return?returnStr;
	????}
	????
	????public?static?void?JsonToSql（）?{
//	????	JdbcTemplate?jdbcTemplate?=??SpringContextHolder.getApplicationContext（）.getBean（JdbcTemplate.class）;
	????	String?filePath?=?“H:\\aaaaaaaaaaaaaaa.json“;
	????	objectMapper?mapper?=?new?objectMapper（）;
	????	try?{
		????	List?readValue?=?mapper.readValue（new?File（filePath）?List.class）;
		????	StringBuilder?insert_sql?=?new?StringBuilder（）;
		????	List?insert_list?=?new?ArrayList（）;
		????	int?i=?1;
		????	for?（Map?map?:?readValue）?{
		????		Map?object?=?（Map）map.get（“data“）;
		????		
		????		object?districtId?=?object.get（“districtId“）;
		????????	object?pinyin?=?object.get（“pinyin“）;
		????????	object?SubAreaId?=?object.get（“SubAreaId“）;
		????????	object?cityname?=?object.get（“cityname“）;
		????????	object?longitude?=?object.get（“longitude“）;
		????????	object?cityid?=?object.get（“cityid“）;
		????????	object?lat?=?object.get（“lat“）;
		????????	object?locationId?=?object.get（“locationId“）;
		????????	object?secondArea?=?object.get（“secondArea“）;
		????????	object?districtName?=?object.get（“districtName“）;
		????????	object?latitude?=?object.get（“latitude“）;
		????????	object?lng?=?object.get（“lng“）;
		????????	String?province_sql?=
						“INSERT?INTO?sys_bussiness?（iddistrictIdpinyinSubAreaIdcitynamelongitudecityidlatlocationIdsecondAreadistrictNamelatitudelng）\n“?+
						“VALUES?（‘“+i+“‘‘“+districtId+“‘‘“+pinyin+“‘‘“+SubAreaId+“‘‘“+cityname+“‘‘“+longitude+“‘‘“+cityid+“‘‘“+lat+“‘“
							+?“‘“+locationId+“‘‘“+secondArea+“‘‘“+districtName+“‘‘“+latitude+“‘‘“+lng+“‘）“;
					insert_list.add（province_sql）;
					insert_sql.append（prov

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????6969017??2019-01-18?19:53??美團最新全國商圈json-sql數據\2019?美團最新商圈數據.json

?????文件???????3620??2019-01-22?14:56??美團最新全國商圈json-sql數據\BusinessUtil.java

?????文件????5844436??2019-01-22?14:55??美團最新全國商圈json-sql數據\sys_business_district.sql

?????目錄??????????0??2019-01-22?14:56??美團最新全國商圈json-sql數據

-----------?---------??----------?-----??----

?????????????12817073????????????????????4


評論

共有 條評論