Servlet.service() for servlet [****.****] in context with path [/practice_system] threw exception

最新推荐文章于 2024-10-04 07:08:17 发布
最新推荐文章于 2024-10-04 07:08:17 发布
阅读量2.6w 收藏 2
点赞数
分类专栏： 后端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mm1030533738/article/details/81191080
版权

我的出错的源代码：

ImporMsg.html:

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://cdn.bootcss.com/jquery/1.10.2/jquery.min.js">
	
</script>
<script>
	$(document).ready(function() {
		$("#submitfile").click(function() {
			$.post("/practice_system/Test1", {
				type : "1"
			}, function(data, status) {
				alert("数据: \n" + data + "\n状态: " + status);
			});
		});
	});
</script>
</head>
<body>
	<form action="ImportMsg" enctype="multipart/form-data" method="post">
		选择文件： <input type="file" name="excelfilename"><br> <input
			type="submit" id="submitfile" value="数据入库" />
	</form>
</body>
</html>

ImportMsg.java:

package interfaceServlet;

import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileItemFactory;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

import databaseOrm.DBConnection;
import databaseOrm.DatabaseOperation;

/**
 * Servlet implementation class ImportMsg
 */
@WebServlet("/ImportMsg")
public class ImportMsg extends HttpServlet {
	private static final long serialVersionUID = 1L;

	// 使用工具类连接数据库
	DatabaseOperation db = DBConnection.db;

	// 设置环境:创建一个DiskFileItemFactory工厂
	FileItemFactory factory = new DiskFileItemFactory();
	// 核心操作类:创建一个文件上传解析器
	ServletFileUpload upload = new ServletFileUpload(factory);

	static DatabaseOperation conn = DBConnection.db;
	DatabaseOperation stmt = DBConnection.db;

	static List items;
	static InputStream is = null;
	static Workbook workbook;
	static Sheet sheet;
	static int rows;
	static int columns;

	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}

	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {

		String type = request.getParameter("type");

		try {
			// 使用ServletFileUpload解析器解析上传数据，解析结果返回的是一个List集合
			items = upload.parseRequest(request);
			// Iterator定义一个迭代器，是一种设计模式，它是一个对象，它可以遍历并选择序列中的对象
			Iterator iter = items.iterator();
			while (iter.hasNext()) {
				FileItem item = (FileItem) iter.next();
				if (!item.isFormField()) {// 判断一个参数域是普通的表单输入域，还是文件上传域，是后者的情况下，就要对相应的域做相应的文件上传处理
					is = item.getInputStream();
				}
			}
		} catch (FileUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			workbook = Workbook.getWorkbook(is);
			sheet = workbook.getSheet(0);
			// 行数
			rows = sheet.getRows();
			System.out.println("行数：" + rows);
			// 列数
			columns = sheet.getColumns();
			System.out.println("列数：" + columns);
		} catch (BiffException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		// // 以列数判断读取的角色类型
		//
		// /**
		// * type: 1：学生 2：项目辅导老师 3：项目管理员
		// */
		// if (columns == 10) {
		// type = "1";
		// } else if (columns == 6) {
		// type = "2";
		// } else if (columns == 5) {
		// type = "3";
		// }

		System.out.println("type=" + type);

		switch (type) {
		case "1":
			// 插入学生信息
			insert_student(rows, sheet);
			System.out.println("插入学生信息");
			break;
		case "2":
			// 插入项目老师信息
			insert_teacher(rows, sheet);
			System.out.println("插入项目老师信息");
			break;
		case "3":
			// 插入项目管理员信息
			insert_manager(rows, sheet);
			System.out.println("插入项目管理员信息");
			break;
		default:
			System.out.println("错误type类型");
		}
	}

	/**
	 * 插入学生信息
	 * 
	 * @param rows
	 * @param sheet
	 */
	public static void insert_student(int rows, Sheet sheet) {
		try {
			for (int i = 0; i < rows; i++) {
				String sql = new String(
						"insert into student(sid,ssex,sname,spwd,sschool,smajor,sphone,sproject,spid,stid) values");
				if (i == 0) {// 第一行是属性，不读取
					continue;
				}
				Cell ce0 = ((jxl.Sheet) sheet).getCell(0, i);
				Cell ce1 = ((jxl.Sheet) sheet).getCell(1, i);
				Cell ce2 = ((jxl.Sheet) sheet).getCell(2, i);
				Cell ce3 = ((jxl.Sheet) sheet).getCell(3, i);
				Cell ce4 = ((jxl.Sheet) sheet).getCell(4, i);
				Cell ce5 = ((jxl.Sheet) sheet).getCell(5, i);
				Cell ce6 = ((jxl.Sheet) sheet).getCell(6, i);
				Cell ce7 = ((jxl.Sheet) sheet).getCell(7, i);
				Cell ce8 = ((jxl.Sheet) sheet).getCell(8, i);
				Cell ce9 = ((jxl.Sheet) sheet).getCell(9, i);

				String c0 = "'" + ce0.getContents() + "'";
				String c1 = "'" + ce1.getContents() + "'";
				String c2 = "'" + ce2.getContents() + "'";
				String c3 = "'" + ce3.getContents() + "'";
				String c4 = "'" + ce4.getContents() + "'";
				String c5 = "'" + ce5.getContents() + "'";
				String c6 = "'" + ce6.getContents() + "'";
				String c7 = "'" + ce7.getContents() + "'";
				String c8 = "'" + ce8.getContents() + "'";
				String c9 = "'" + ce9.getContents() + "'";

				sql = sql + "(" + c0 + "," + c1 + "," + c2 + "," + c3 + ","
						+ c4 + "," + c5 + "," + c6 + "," + c7 + "," + c8 + ","
						+ c9 + ")";
				System.out.println(sql);
				conn.update_op(sql);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 插入项目老师信息
	 * 
	 * @param rows
	 * @param sheet
	 */
	public static void insert_teacher(int rows, Sheet sheet) {
		try {
			for (int i = 0; i < rows; i++) {
				String sql = new String(
						"insert into teacher(tid,tpwd,tsex,tname,tphone,tpid) values");
				if (i == 0) {// 第一行是属性，不读取
					continue;
				}
				Cell ce0 = ((jxl.Sheet) sheet).getCell(0, i);
				Cell ce1 = ((jxl.Sheet) sheet).getCell(1, i);
				Cell ce2 = ((jxl.Sheet) sheet).getCell(2, i);
				Cell ce3 = ((jxl.Sheet) sheet).getCell(3, i);
				Cell ce4 = ((jxl.Sheet) sheet).getCell(4, i);
				Cell ce5 = ((jxl.Sheet) sheet).getCell(5, i);

				String c0 = "'" + ce0.getContents() + "'";
				String c1 = "'" + ce1.getContents() + "'";
				String c2 = "'" + ce2.getContents() + "'";
				String c3 = "'" + ce3.getContents() + "'";
				String c4 = "'" + ce4.getContents() + "'";
				String c5 = "'" + ce5.getContents() + "'";

				sql = sql + "(" + c0 + "," + c1 + "," + c2 + "," + c3 + ","
						+ c4 + "," + c5 + ")";
				System.out.println(sql);
				conn.update_op(sql);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 插入项目管理员信息
	 * 
	 * @param rows
	 * @param sheet
	 */
	public static void insert_manager(int rows, Sheet sheet) {
		try {
			for (int i = 0; i < rows; i++) {
				String sql = new String(
						"insert into projector(pid,ppwd,psex,pphone,pname) values");
				if (i == 0) {// 第一行是属性，不读取
					continue;
				}
				Cell ce0 = ((jxl.Sheet) sheet).getCell(0, i);
				Cell ce1 = ((jxl.Sheet) sheet).getCell(1, i);
				Cell ce2 = ((jxl.Sheet) sheet).getCell(2, i);
				Cell ce3 = ((jxl.Sheet) sheet).getCell(3, i);
				Cell ce4 = ((jxl.Sheet) sheet).getCell(4, i);

				String c0 = "'" + ce0.getContents() + "'";
				String c1 = "'" + ce1.getContents() + "'";
				String c2 = "'" + ce2.getContents() + "'";
				String c3 = "'" + ce3.getContents() + "'";
				String c4 = "'" + ce4.getContents() + "'";

				sql = sql + "(" + c0 + "," + c1 + "," + c2 + "," + c3 + ","
						+ c4 + ")";
				System.out.println(sql);
				conn.update_op(sql);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}

运行出现错误：

自己写的一个简易的文件上传的前后端，点击上传时出现了这个错误，当时一直不知道原因。

 

 

后来才知道我在一个表单中提交本地文件时，表单form的enctype="multipart/form-data"，是以二进制数据流提交数据的。
所以没法用request.getParameter("name")来获取提交到后台的普通表单域值

 

 

阿懵
关注
专栏目录
异常：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception 已解决
Java Punk
11-21 36万+
既然和 DispatcherServlet 有关，那无非就是MVC的映射出了问题
1.Servlet.service() for servlet [springmvc] in context with path [] threw exception [Request process
qq_24790827的博客
04-01 3398
1.Servlet.service() for servlet [springmvc] in context with path [] threw exception [Request processing failed; nested exception is com.alibaba.fastjson.JSONException] with root cause java.lang.Number...
异常报错：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
热门推荐
Alian_auerua的博客
03-18 5万+
servlet service（）下报错
已解决：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
最新发布
官方推荐
10-04 1万+
已解决：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
Servlet.service() for servlet [springDispatcherServlet]的解决办法
YiYang_sky的博客
09-23 7627
Servlet.service() for servlet [springDispatcherServlet] in context with path [] threw exception [Request processing failed org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet [springDispatcherServlet] in context with path
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler d
寿春
12-01 1123
检查您的Java版本：确保您正在使用包含 “javax/xml/bind/DatatypeConverter” 类的JDK版本。错误信息提示缺少 “javax/xml/bind/DatatypeConverter” 类，这是在Java类路径中缺失的一个类。添加JAXB库：如果您使用的JDK版本不包含 “javax/xml/bind/DatatypeConverter” 类，您可以手动将JAXB库添加到项目的依赖项中。清理并重新构建项目：在添加依赖项后，清理并重新构建项目，以确保JAXB库正确包含。
Error resolving template，template might not exist or might not be accessible by any of the configure...
maxchenBug的博客
10-11 1997
template might not exist or might not be accessible by any of the configured Template Resolvers at org.thymeleaf.engine.TemplateManager.resolveTemplate(TemplateManager.java:869) ~[thymelea...
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request p
HRX98的博客
01-12 2031
浪费了我的午休以及一整个下午、、、、、、、、、、、、、 在使用springboot+mybatisplus+thymeleaf完成一个CRUD的过程中，我在查询列表的时候，不采用三层架构的时候，可以将列表查询，但是分层后，一直报错500，报错信息如下 2022-01-12 17:38:29.764 ERROR 13896 --- [nio-8002-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet
严重: Servlet.service() for servlet [servlet.WxServlet] in context with path [/weixin] threw exception
pyan77的博客
07-16 3518
7月 16, 2020 3:06:20 下午 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet [servlet.WxServlet] in context with path [/weixin] threw exception [Servlet execution threw an exception] with root cause java.lang.ClassNotFoundE
Servlet实现文件上传
cainiaoyilong的博客
01-21 237
需要commons-fileupload    commons-io-1.4两个jar包 1 upload.jsp 上传表单设置  注意三个方面  1.enctype="multipart/form-data"     2.method="post"  3       文件上传         function addOne(){     documen
成功解决 Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Requ
一名Java语言狂热分子。
04-06 2836
看访问路径是不是多了一个“/” 然后要做到的是排除是不是springboot使用的注释有误，可以参考一下这位大佬的博客：https://blog.csdn.net/sinat_35566306/article/details/90312461 如果任然解决不了，那你就如果看看是不是自己的html文件出问题了，我就是排除以上两种可能后发现自己的html文件额外要的东西没有传递，而引发的解析失败，你可以写一个空白html看能不能访问成功，如果能就证明我刚刚说的没有错，那你可以进一步缩小范围去找bug了 每.
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception （已解决）
weixin_58171704的博客
10-22 2万+
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception （已解决）
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Could not
weixin_65265028的博客
02-15 3586
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Could not resolve view with name 'employee/login' in servlet with name 'dispatcherServlet'] with root cause 原因：手快将@RestController注解打成了@Configuration @Configurati..
Servlet.service() for servlet [] in context with path [/onlearn]threw exception [Servlet execution t
qq_42958729的博客
03-29 2246
Servlet.service() for servlet [com.neuede.onlearn.web.WebDispatcher] in context with path [/onlearn] threw exception [Servlet execution threw an exception] with root cause 三月 29, 2020 11:02:19 上午 org....
Servlet.service() for servlet [jsp] in context with path [/Eshop] threw exception [Unable to compile
uu_uuu的博客
07-28 4651
Tomcat和JDK版本问题 起初我用的是，Tomcat7和JDK8，但是运行报错 我查了一下原因，大概是版本不兼容，于是把JDK8换成了JDK7 做JavaWeb开发，更换JDK版本的时候，注意要替换以下几个地方，不然会继续报错： 1.项目路径/项目名/.settings文件夹下的org.eclipse.wst.common.project.facet.core.xml文件，Jav...
Servlet.service() for servlet [dispatcherServlet] in context with path [] th 问题解决
xTand的博客
03-05 2万+
解决办法: 在pom.xml加入thymeleaf依赖 <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> 问题描述 debug运行程序，发现程序能找到controller中的此方法，但就是
Servlet.service() for servlet [springmvc] in context with path [/xxxxxx] threw exception报错解决办法
Walker_m的博客
04-13 4万+
第二次报这个错。严重: Servlet.service() for servlet [springmvc] in context with path [/xxxxxx] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root causejava...
Servlet.service() for servlet [dispatcherServlet] in context with path [/blood_system] threw exception
09-27
在处理请求时，如果出现任何异常，就会抛出 Servlet.service() 异常。 要解决这个问题，你可以采取以下步骤： 1. 检查错误日志：查看完整的错误信息和堆栈跟踪，以便更好地了解问题的根本原因。 2. 检查配置文件：...
评论 4
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值