`
aerchi
  • 浏览: 422308 次
  • 性别: Icon_minigender_1
  • 来自: 昆明
文章分类
社区版块
存档分类
最新评论

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

 
阅读更多

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

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

  1. <%@pagelanguage="java"contentType="text/html;charset=UTF-8"
  2. pageEncoding="UTF-8"%>
  3. <%@pageimport="java.util.*"%>
  4. <%@pageimport="com.waleking.property.db.*"%>
  5. <!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
  6. <html>
  7. <head>
  8. <metahttp-equiv="Content-Type"content="text/html;charset=UTF-8">
  9. <title>Inserttitlehere</title>
  10. </head>
  11. <body>
  12. <mce:scripttype="text/javascript"><!--
  13. //同一个表单,多个submit的js分发
  14. functiondeleteSubmit(form){
  15. form.submitType.value="delete";
  16. }
  17. //同一个表单,多个submit的js分发
  18. functionupdateSubmit(form){
  19. form.submitType.value="update";
  20. }
  21. //同一个表单,多个submit的js分发
  22. functionaddSubmit(form){
  23. form.submitType.value="add";
  24. }
  25. //--></mce:script>
  26. <tableborder="1">
  27. <tr>
  28. <td>SearcherIP</td>
  29. <td>TopNum</td>
  30. <td>IndexerPort</td>
  31. <td>Operation</td>
  32. </tr>
  33. <%
  34. List<Searcher_PropertyVO>lSearcher=Searcher_PropertyDAO.queryAll();
  35. for(inti=0;i<lSearcher.size();i++){
  36. Searcher_PropertyVOproperty=lSearcher.get(i);
  37. %>
  38. <tr>
  39. <formaction="SearcherSheetServlet"method="post">
  40. <td>
  41. <%=property.getSearcherIP()%>
  42. </td>
  43. <td>
  44. <inputtype="text"name="topNum"value="<%=property.getTopNum()%>"/>
  45. </td>
  46. <td>
  47. <inputtype="text"name="indexerPort"value="<%=property.getIndexerPort()%>"/>
  48. </td>
  49. <td>
  50. <table>
  51. <tr>
  52. <td>
  53. <inputtype="hidden"name="submitType"/>
  54. <inputtype="hidden"name="searcherIP"value="<%=property.getSearcherIP()%>"></input>
  55. </td>
  56. <td><inputtype="submit"value="delete"onclick="deleteSubmit(form)"></input></td>
  57. <td><inputtype="submit"value="update"onclick="updateSubmit(form)"></input></td>
  58. </tr>
  59. </table>
  60. </td>
  61. </form>
  62. </tr>
  63. <%
  64. }
  65. %>
  66. <tr>
  67. <formaction="SearcherSheetServlet"method="post">
  68. <td>
  69. <inputtype="text"name="searcherIP"/>
  70. </td>
  71. <td>
  72. <inputtype="text"name="topNum"/>
  73. </td>
  74. <td>
  75. <inputtype="text"name="indexerPort"/>
  76. </td>
  77. <td>
  78. <table>
  79. <tr>
  80. <td>
  81. <inputtype="hidden"name="submitType"/>
  82. </td>
  83. <td><inputtype="submit"value="add"onclick="addSubmit(form)"></input></td>
  84. </tr>
  85. </table>
  86. </td>
  87. </form>
  88. </tr>
  89. </table>
  90. </body>
  91. </html>

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

  1. packagecom.waleking.servlet;
  2. importjava.io.IOException;
  3. importjavax.servlet.ServletException;
  4. importjavax.servlet.http.HttpServlet;
  5. importjavax.servlet.http.HttpServletRequest;
  6. importjavax.servlet.http.HttpServletResponse;
  7. importcom.waleking.property.db.Searcher_PropertyDAO;
  8. importcom.waleking.property.db.Searcher_PropertyVO;
  9. /**
  10. *ServletimplementationclassSearcherSheet
  11. */
  12. publicclassSearcherSheetServletextendsHttpServlet{
  13. privatestaticfinallongserialVersionUID=1L;
  14. privateSearcher_PropertyDAOsearcherDAO=newSearcher_PropertyDAO();
  15. privateSearcher_PropertyVOsearcherProperty=newSearcher_PropertyVO();
  16. /**
  17. *Defaultconstructor.
  18. */
  19. publicSearcherSheetServlet(){
  20. //TODOAuto-generatedconstructorstub
  21. }
  22. /**
  23. *@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponse
  24. *response)
  25. */
  26. protectedvoiddoGet(HttpServletRequestrequest,
  27. HttpServletResponseresponse)throwsServletException,IOException{
  28. System.out.println("ok");
  29. StringsearcherIP=request.getParameter("searcherIP");
  30. StringtopNum=request.getParameter("topNum");
  31. System.out.println(topNum);
  32. StringindexerPort=request.getParameter("indexerPort");
  33. System.out.println(indexerPort);
  34. searcherProperty.setSearcherIP(searcherIP);
  35. searcherProperty.setTopNum(Integer.parseInt(topNum));
  36. searcherProperty.setIndexerPort(Integer.parseInt(indexerPort));
  37. System.out.println(searcherProperty);
  38. searcherDAO.insert(searcherProperty);
  39. }
  40. /**
  41. *@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponse
  42. *response)
  43. */
  44. protectedvoiddoPost(HttpServletRequestrequest,
  45. HttpServletResponseresponse)throwsServletException,IOException{
  46. //TODOAuto-generatedmethodstub
  47. //Strings=request.getParameter("ip");
  48. StringsubmitType=request.getParameter("submitType");
  49. System.out.println(submitType);
  50. if(submitType.equals("add")){//添加
  51. StringsearcherIP=request.getParameter("searcherIP");
  52. StringtopNum=request.getParameter("topNum");
  53. StringindexerPort=request.getParameter("indexerPort");
  54. searcherProperty.setSearcherIP(searcherIP);
  55. searcherProperty.setTopNum(Integer.parseInt(topNum));
  56. searcherProperty.setIndexerPort(Integer.parseInt(indexerPort));
  57. System.out.println(searcherProperty);
  58. searcherDAO.insert(searcherProperty);
  59. response.sendRedirect("index.jsp");
  60. }elseif(submitType.equals("update")){//修改
  61. StringsearcherIP=request.getParameter("searcherIP");
  62. StringtopNum=request.getParameter("topNum");
  63. StringindexerPort=request.getParameter("indexerPort");
  64. searcherProperty.setSearcherIP(searcherIP);
  65. searcherProperty.setTopNum(Integer.parseInt(topNum));
  66. searcherProperty.setIndexerPort(Integer.parseInt(indexerPort));
  67. searcherDAO.update(searcherProperty);
  68. response.sendRedirect("index.jsp");
  69. }elseif(submitType.equals("delete")){//删除
  70. StringsearcherIP=request.getParameter("searcherIP");
  71. searcherDAO.deleteByKey(searcherIP);
  72. response.sendRedirect("index.jsp");
  73. }
  74. }
  75. }

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

可以看到最终的效果:

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics