用jsp+servlet写一个类似于excel表格的网页表单

最新推荐文章于 2023-05-27 20:40:56 发布

Waleking

最新推荐文章于 2023-05-27 20:40:56 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： java开发文章标签： servlet jsp excel string delete function

本文链接：https://blog.youkuaiyun.com/Waleking/article/details/5993403

java开发专栏收录该内容

23 篇文章

订阅专栏

本文展示了如何在Dreamweaver CS5中使用jsp和servlet创建一个具有增删改功能的表格。通过同一表单、多个submit按钮的JavaScript分发，实现了对表格数据的操作。Servlet在后台处理POST请求，根据提交类型执行添加、更新或删除操作，并通过redirect返回到主页面。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

再DreamweaverCS5下要看到这样的效果：

需要编写jsp网页如下，这里使用了同一个表单，多个submit的分发的方法，具体可以看里面的js函数：

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.util.*"%> <%@ page import="com.waleking.property.db.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <mce:script type="text/javascript"></mce:script> <table border="1"> <tr> <td>SearcherIP</td> <td>TopNum</td> <td>IndexerPort</td> <td>Operation</td> </tr> <% List<Searcher_PropertyVO> lSearcher=Searcher_PropertyDAO.queryAll(); for(int i=0;i<lSearcher.size();i++){ Searcher_PropertyVO property=lSearcher.get(i); %> <tr> <form action="SearcherSheetServlet" method="post"> <td> <%=property.getSearcherIP() %> </td> <td> <input type="text" name="topNum" value="<%=property.getTopNum() %>"/> </td> <td> <input type="text" name="indexerPort" value="<%=property.getIndexerPort() %>"/> </td> <td> <table> <tr> <td> <input type="hidden" name="submitType"/> <input type="hidden" name="searcherIP" value="<%=property.getSearcherIP()%>"></input> </td> <td><input type="submit" value="delete" onclick="deleteSubmit(form)"></input></td> <td><input type="submit" value="update" onclick="updateSubmit(form)"></input></td> </tr> </table> </td> </form> </tr> <% } %> <tr> <form action="SearcherSheetServlet" method="post"> <td> <input type="text" name="searcherIP"/> </td> <td> <input type="text" name="topNum"/> </td> <td> <input type="text" name="indexerPort"/> </td> <td> <table> <tr> <td> <input type="hidden" name="submitType"/> </td> <td><input type="submit" value="add" onclick="addSubmit(form)"></input></td> </tr> </table> </td> </form> </tr> </table> </body> </html>

用servlet来处理请求，因为是用post方法发送的参数，所以在doPost里面修改：

package com.waleking.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.waleking.property.db.Searcher_PropertyDAO; import com.waleking.property.db.Searcher_PropertyVO; /** * Servlet implementation class SearcherSheet */ public class SearcherSheetServlet extends HttpServlet { private static final long serialVersionUID = 1L; private Searcher_PropertyDAO searcherDAO = new Searcher_PropertyDAO(); private Searcher_PropertyVO searcherProperty = new Searcher_PropertyVO(); /** * Default constructor. */ public SearcherSheetServlet() { // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse * response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("ok"); String searcherIP = request.getParameter("searcherIP"); String topNum = request.getParameter("topNum"); System.out.println(topNum); String indexerPort = request.getParameter("indexerPort"); System.out.println(indexerPort); searcherProperty.setSearcherIP(searcherIP); searcherProperty.setTopNum(Integer.parseInt(topNum)); searcherProperty.setIndexerPort(Integer.parseInt(indexerPort)); System.out.println(searcherProperty); searcherDAO.insert(searcherProperty); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse * response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub //String s=request.getParameter("ip"); String submitType=request.getParameter("submitType"); System.out.println(submitType); if(submitType.equals("add")){//添加 String searcherIP = request.getParameter("searcherIP"); String topNum = request.getParameter("topNum"); String indexerPort = request.getParameter("indexerPort"); searcherProperty.setSearcherIP(searcherIP); searcherProperty.setTopNum(Integer.parseInt(topNum)); searcherProperty.setIndexerPort(Integer.parseInt(indexerPort)); System.out.println(searcherProperty); searcherDAO.insert(searcherProperty); response.sendRedirect("index.jsp"); }else if(submitType.equals("update")){//修改 String searcherIP = request.getParameter("searcherIP"); String topNum = request.getParameter("topNum"); String indexerPort = request.getParameter("indexerPort"); searcherProperty.setSearcherIP(searcherIP); searcherProperty.setTopNum(Integer.parseInt(topNum)); searcherProperty.setIndexerPort(Integer.parseInt(indexerPort)); searcherDAO.update(searcherProperty); response.sendRedirect("index.jsp"); }else if(submitType.equals("delete")){//删除 String searcherIP = request.getParameter("searcherIP"); searcherDAO.deleteByKey(searcherIP); response.sendRedirect("index.jsp"); } } }

关于web.xml的编写可以参看上一篇servlet的编写。

可以看到最终的效果：