需求:用户在页面上选择本地json文件后,进行解析和展示。
解决方案;1、利用js直接对json文件进行解析。2、ajax把文件传送到服务器,利用java解析json文件,然后返回数据。
hospital.json文件示例
{
"hospital":[
{
"lon":120,
"lat":30,
"name":"西安医院"
},
{
"lon":130,
"lat":40,
"name":"北京医院"
}
]
}
html代码
<input type="file" id="poiFile"/>
<button id = "importFile" >导入</button>
1、js解析json文件
<script type="text/javascript" src="./jquery3.3.1.js"></script>
<script type="text/javascript">
$(function(){
$("#importFile").click(function(){
//获取文件列表
var files = $('#poiFile').prop('files');
console.log(files);
if(files.length == 0){
alert("请先选择json文件");
return;
}
//获取文件名称
var fileName = files[0].name.substring(0,files[0].name.lastIndexOf("."));
if(files.length == 0){
alert('请选择文件');
return;
}else{
//新建一个FileReader
var reader = new FileReader();
//读取文件
reader.readAsText(files[0], "UTF-8");
//读取完文件之后的回调函数
reader.onload = function(evt){
var fileString = evt.target.result;
var fileJson = JSON.parse(fileString);
$.each(fileJson["键"], function(i, item) {
alert(item.lon+","+item.lat);
})
}
}
})
})
</script>
2、ajax上传文件,java解析
2.1 ajax代码
<script type="text/javascript" src="./jquery3.3.1.js"></script>
<script type="text/javascript">
$(function(){
$("#importFile").click(function(){
if($("#poiFile")[0].files.length == 0){
alert("请先选择json文件");
return;
}
var formData = new FormData();
formData.append("myfile", $("#poiFile")[0].files[0]);
$.ajax({
url: "http://127.0.0.1:8080/filetemp/file/upload",
type: "post",
data: formData,
//必须false才会自动加上正确的Content-Type
contentType: false,
//必须false才会避开jQuery对 formdata 的默认处理
//XMLHttpRequest会对 formdata 进行正确的处理
processData: false,
success: function (datas) {
console.log(datas);
var data = JSON.parse(datas);
$.each(data["键"], function(i, item) {
alert(item.lon+","+item.lat);
},
error: function () {
alert("上传失败!");
}
});
})
})
</script>
2.2 springMVC框架搭建
image.pngpom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<packaging>war</packaging>
<name>filetemp</name>
<groupId>FileTemp</groupId>
<artifactId>filetemp</artifactId>
<version>1.0-SNAPSHOT</version>
<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
</plugin>
</plugins>
</build>
<dependencies>
<!--Spring依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.0.0.RELEASE</version>
</dependency>
<!--fileupload文件下载-->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.json</groupId>
<artifactId>json</artifactId>
<version>20180130</version>
</dependency>
</dependencies>
</project>
spring-mvc.xml代码
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- mvc的注解驱动 -->
<mvc:annotation-driven/>
<!-- 自动扫描该包,使SpringMVC认为包下用了@controller注解的类是控制器 -->
<context:component-scan base-package="controller" />
<!-- 配置文件上传,如果没有使用文件上传可以不用配置,当然如果不配,那么配置文件中也不必引入上传组件包 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!-- 默认编码 -->
<property name="defaultEncoding" value="utf-8" />
<!-- 文件最大值 -->
<property name="maxUploadSize" value="10485760000" />
<!-- 内存中的最大值 -->
<property name="maxInMemorySize" value="40960" />
</bean>
</beans>
web.xml代码
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<!-- 编码过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:config/spring-mvc.xml</param-value>
</context-param>
<!-- Spring MVC servlet -->
<servlet>
<servlet-name>SpringMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:config/spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>SpringMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- Spring监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 防止Spring内存溢出监听器 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<welcome-file-list>
<welcome-file>/WEB-INF/jsp/index.jsp</welcome-file>
</welcome-file-list>
</web-app>
2.3 java解析文件代码
FileUploadController.java代码
package controller;
import org.json.JSONObject;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import java.io.*;
@Controller
@RequestMapping("/file")
public class FileUploadController{
@ResponseBody
@RequestMapping(value="/upload", method= RequestMethod.POST,produces="text/html;charset=UTF-8")
public String fileUpload(@RequestParam("myfile") MultipartFile file){
String fileName = file.getOriginalFilename().substring(0,file.getOriginalFilename().length()-5);
String str = "";
try {
InputStreamReader inputStreamReader = new InputStreamReader(file.getInputStream(),"UTF-8");
BufferedReader br = new BufferedReader(inputStreamReader);
String s= "";
while ((s = br.readLine()) != null) {
str +=s;
}
br.close();
} catch (FileNotFoundException e1) {
e1.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
JSONObject jo = new JSONObject(str);
jo.put("fileName",fileName);
System.out.println(jo.toString());
return jo.toString();
}
}
网友评论