jsp实现连接数据库分页浏览增删改查等功能

ID：39551796

大小：258.00 KB

页数：9页

时间：2019-07-06

资源描述：

《jsp实现连接数据库分页浏览增删改查等功能》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、一利用jsp实现Oracle数据库中表格的分页浏览：二在Oracle数据库中建立表格，包含员工的工号、姓名、性别、工龄、工资等字段，并实现增删改查操作。（1）所建的worker表格如下：（2）Input.jsp运行结果如下：（3）Inputcheck.jsp运行结果如下：Pagebreak.jsp代码如下：<%@pagecontentType="text/html"pageEncoding="UTF-8"import="java.sql.*"%>

2、pe"content="text/html;charset=UTF-8">JSPpage

分页显示记录内容

工号姓名性别工龄工资<%Stringoracledriver="oracle.jdbc.driver.OracleDriver";String

3、oracleUrl="jdbc:oracle:thin:@localhost:1521:ORACLE";Stringusername="scott";Stringpassword="tiger";Connectioncon;Class.forName(oracledriver);con=DriverManager.getConnection(oracleUrl,username,password);intintPageSize;intintRowCount;intintPageCount;intintPage;String

4、strPage;inti;intPageSize=10;strPage=request.getParameter("page");if(strPage==null){intPage=1;}else{intPage=java.lang.Integer.parseInt(strPage);if(intPage<1)intPage=1;}Statementstmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);S

5、tringsql="select*fromworker";ResultSetrs=stmt.executeQuery(sql);rs.last();intRowCount=rs.getRow();intPageCount=(intRowCount+intPageSize-1)/intPageSize;if(intPage>intPageCount)intPage=intPageCount;if(intPageCount>0){rs.absolute((intPage-1)*intPageSize+1);i=0;while(

6、i<%=rs.getString("id")%><%=rs.getString("name")%><%=rs.getString("sex")%><%=rs.getString("workyear")%><%=rs.getString("sal")%><%rs.next();i++;}}%>

7、">第<%=intPage%>页共<%=intPageCount%>页<%if(intPage">下一页<%}if(intPage>1){%>">上一页<%}rs.close();stmt.close();con.close();%>

Input.jsp代码

8、如下:<%@pagecontentType="text/html"pageEncoding="UTF-8"%>JSP中更新数据库</tit</p> </div> <div class="mt-3 bg-white"> <div class="d-lg-block d-none px-3 px-lg-4 py-3 border-bottom text-center font-18"> 当前文档最多预览五页，下载文档查看全文 </div> <div class="detail-fixed-feature d-none d-lg-block" id="detailFixedFeatureBox"> <div class="px-3 px-lg-4 py-3 d-flex align-items-center justify-content-between fixed-feature-box" id="detailFixedFeature"> <div class="d-lg-flex d-none align-items-center"> <div> <a class="btn btn-outline-danger article-state" href="javascript:;" data-id="39551796" data-code="438274" data-title="jsp实现连接数据库分页浏览增删改查等功能"> <span>侵权申诉</span> </a> <button type="button" class="btn btn-outline-secondary with-light ml-2" data-toggle="modal" data-target="#reportModal" data-id="39551796"><span>举报</span></button> </div> <nav class="d-flex align-items-center ml-4" id="anchorPoint"> <a href="javascript:;" class="btn btn-light anchor-pre px-2"><i class="iconfont text-muted"></i></a> <div class="text-muted mb-0 pre-point-list" id="prePointList"> <a class="px-2 active nav-link" href="#anchorImg0">1</a> <a class="px-2 nav-link" href="#anchorImg1">1</a> <a class="px-2 nav-link" href="#anchorImg2">2</a> <a class="px-2 nav-link" href="#anchorImg3">3</a> <a class="px-2 nav-link" href="#anchorImg4">4</a> <a class="px-2 nav-link" href="#anchorImg5">5</a> / <span class="px-2" id="prePageNums">9</span> </div> <a href="javascript:;" class="btn btn-light anchor-next px-2"><i class="iconfont text-muted"></i></a> </nav> </div> <div class="d-flex align-items-center"> <p class="d-lg-block d-none font-14 text-black-50 mb-0 mr-2">此文档下载收益归作者所有</p> <button class="btn btn-danger detail-download-btn px-3 ml-0 font-16" data-btn="downloadfile" style="width:128px;height:40px;" data-id="39551796" data-price="2000" data-size="258.00 KB" data-page="9页" data-type="doc" data-binddown="true" data-isold="new_content" data-vip="0" data-title="jsp实现连接数据库分页浏览增删改查等功能">下载文档</button> </div> </div> </div> </div> <div class="d-block d-lg-none px-3 px-lg-4 py-3 border-bottom text-center font-14" style="color:#999">当前文档最多预览五页，下载文档查看全文</div> <button class="btn d-block w-100 d-lg-none btn-danger detail-download-btn px-3 ml-0 font-16" data-btn="downloadfile" data-id="39551796" data-price="2000" data-size="258.00 KB" data-page="9页" data-type="doc" data-binddown="true" data-isold="new_content" data-vip="0" data-title="jsp实现连接数据库分页浏览增删改查等功能">点击下载本文档 </button> </div> <div class="px-3 px-lg-4 py-3 bg-white mt-3"> <ul class="nav custom-tab border-bottom" id="myTab" role="tablist"> <li class="nav-item" role="presentation"> <a class="nav-link active px-0 mr-4 font-16 font-weight-light pb-3" id="tips-tab" data-toggle="tab" href="#showTips" role="tab" aria-controls="showTips" aria-selected="true">版权提示</a> </li> <li class="nav-item" role="presentation"> <a class="nav-link px-0 pb-3 font-16 font-weight-light text-black-50" href="/d-39551796.html" >下载文档</a> </li> <dl class="flex-grow-1 mb-0 d-lg-none"> <li class="ml-3 float-right d-lg-none"> <button type="button" class="btn btn-light" data-toggle="modal" data-target="#reportModal" data-id="39551796"><span>举报</span></button> </li> </dl> </ul> <div class="tab-content with-content pt-3" id="myTabContent"> <div class="tab-pane fade show active font-14" id="showTips" role="tabpanel" aria-labelledby="showTips-tab"> 温馨提示： <br> 1. 部分包含数学公式或PPT动画的文件，查看预览时可能会显示错乱或异常，文件下载后无此问题，请放心下载。<br> 2. 本文档由用户上传，版权归属用户，天天文库负责整理代发布。如果您对本文档版权有争议请及时联系客服。<br> 3. 下载前请仔细阅读文档内容，确认文档内容符合您的需求后进行下载，若出现内容与标题不符可向本站投诉处理。<br> 4. 下载文档时可能由于网络波动等原因无法下载或下载错误，付费完成后未能成功下载的用户请联系客服处理。 <br> </div> </div> </div> </div> <div class="detail-sidebar d-none d-lg-block"> <div id="columnDetailSiderRight"> <div class="detail-yourlike mt-0 pb-2" id="relativeArticle"> <div class="border-bottom py-2 d-flex align-items-center justify-content-between"> <h5 class="font-16">相关文章</h5> <a class="font-14 hover-letter-spacing" href="/ucenter/search/index.html?text=jsp实现连接数据库分页浏览增删改查等功能" target="_blank" rel="nofollow">更多<i class="iconfont font-12 pl-1"></i></a> </div> <ul class="font-14 like-list"> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-1205044.html" title="jsp进行简单的增删改查" target="_blank"><span class="text-danger">j</span><span class="text-danger">s</span><span class="text-danger">p</span>进行简单的<span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span></a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-3300698.html" title="java连接mysql数据库,并且实现增删改查功能" target="_blank"><span class="text-danger">j</span>ava<span class="text-danger">连</span><span class="text-danger">接</span>my<span class="text-danger">s</span>ql<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>,并且<span class="text-danger">实</span><span class="text-danger">现</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span><span class="text-danger">功</span><span class="text-danger">能</span></a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-8970051.html" title="java连接mysql数据库并且实现增删改查功能" target="_blank"><span class="text-danger">j</span>ava<span class="text-danger">连</span><span class="text-danger">接</span>my<span class="text-danger">s</span>ql<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>并且<span class="text-danger">实</span><span class="text-danger">现</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span><span class="text-danger">功</span><span class="text-danger">能</span></a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-11110234.html" title="java连接mysql数据库,并且实现增删改查功能" target="_blank"><span class="text-danger">j</span>ava<span class="text-danger">连</span><span class="text-danger">接</span>my<span class="text-danger">s</span>ql<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>,并且<span class="text-danger">实</span><span class="text-danger">现</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span><span class="text-danger">功</span><span class="text-danger">能</span></a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-12965031.html" title="使用jsp对数据库进行增删改查" target="_blank">使用<span class="text-danger">j</span><span class="text-danger">s</span><span class="text-danger">p</span>对<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>进行<span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span></a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-docx" href="/p-14407880.html" title="javaweb-连接mysql数据库增删改查" target="_blank"><span class="text-danger">j</span>avaweb-<span class="text-danger">连</span><span class="text-danger">接</span>my<span class="text-danger">s</span>ql<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span></a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-37710625.html" title="jsp增删改查2" target="_blank"><span class="text-danger">j</span><span class="text-danger">s</span><span class="text-danger">p</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span>2</a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-docx" href="/p-38382111.html" title="sql server jsp增删改查" target="_blank"><span class="text-danger">s</span>ql<span class="text-danger">s</span>erver<span class="text-danger">j</span><span class="text-danger">s</span><span class="text-danger">p</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span></a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-39546520.html" title="C#_WinForm_实现增删改查等功能(数据库Access)" target="_blank">C#_WinForm_<span class="text-danger">实</span><span class="text-danger">现</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span><span class="text-danger">等</span><span class="text-danger">功</span><span class="text-danger">能</span>(<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>Acce<span class="text-danger">s</span><span class="text-danger">s</span>)</a> </li> <li class=""> <a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-47430339.html" title="JAVA swing界面实现数据库增删改查" target="_blank">JAVA<span class="text-danger">s</span>wing界面<span class="text-danger">实</span><span class="text-danger">现</span><span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span><span class="text-danger">增</span><span class="text-danger">删</span><span class="text-danger">改</span><span class="text-danger">查</span></a> </li> </ul> </div> <div class="detail-yourlike pb-2"> <div class="border-bottom py-2"> <h5 class="font-16">相关标签</h5> </div> <ul class="font-14 like-list d-flex flex-wrap"> <a class="search-tag" href="/tags/553684/" target="_blank">增删</a> <a class="search-tag" href="/tags/782595/" target="_blank">浏览</a> <a class="search-tag" href="/tags/1560613/" target="_blank">数据库</a> <a class="search-tag" href="/tags/1604275/" target="_blank">分页</a> <a class="search-tag" href="/tags/785075/" target="_blank">连接</a> <a class="search-tag" href="/tags/540259/" target="_blank">功能</a> <a class="search-tag" href="/tags/1456203/" target="_blank">实现</a> </ul> </div> <script src="/d/js/acmsd/thea1.js"></script> </div> </div> </div> <footer> <div class="container d-none d-lg-block mb-4"> <div class="d-flex justify-content-between footer-nav"> <ul class="d-flex foot-nav"> <li> <h5>常见问题</h5> <a class=text-decoration-none href=/help/wenti/upload/ target=_blank> 关于上传 </a><a class=text-decoration-none href=/help/wenti/xiazai/ target=_blank> 关于下载 </a><a class=text-decoration-none href=/help/wenti/qinquan/ target=_blank> 关于侵权 </a><a class=text-decoration-none href=/help/wenti/fenxaing/ target=_blank> 分享文档赚钱教程 </a> </li> <li> <h5>关于我们</h5> <a class=text-decoration-none href=/help/about/wzjs/ target=_blank> 网站介绍 </a><a class=text-decoration-none href=/help/about/gywm/ target=_blank> 关于我们 </a><a class=text-decoration-none href=/help/about/lxwm/ target=_blank> 联系我们 </a> </li> <li> <h5>版权问题</h5> <a class=text-decoration-none href=/help/banquan/bqsm/ target=_blank> 版权声明 </a><a class=text-decoration-none href=/help/banquan/qqcl/ target=_blank> 侵权处理 </a><a class=text-decoration-none href=/help/banquan/mzsm/ target=_blank> 免责声明 </a> </li> <li> <h5>协议条款</h5> <a class=text-decoration-none href=/help/xieyi/yhxy/ target=_blank> 用户协议 </a><a class=text-decoration-none href=/help/xieyi/fwtk/ target=_blank> 用户服务条款 </a><a class=text-decoration-none href=/help/xieyi/ysbh/ target=_blank> 用户隐私保护 </a> </li> <li> <h5>网站导航</h5> <a class="text-decoration-none help-nav-item" href="/sitemaps.xml" data-name="网站地图" target="_blank">网站地图</a> <a class="text-decoration-none help-nav-item" href="/list.html" data-name="全部分类" target="_blank">全部分类</a> <a class="text-decoration-none help-nav-item" href="/sitemaps/index.html" data-name="资源地图" target="_blank">资源地图</a> </li> </ul> <div class="foot-qrcode d-flex"> <div> <div class="subsitute-bg"><img src="https://www.wenku365.com/d/file/2022/07-08/f23df57d987ef7ad9acb33fe5abf9854.jpg"></div> <p>关注公众号<br></p> </div> </div> </div> </div> <div class="footer-copyright"> <p><a href="/" target="_blank">天天文库</a>站为“文档C2C交易模式”，即用户上传的文档直接卖给(下载)用户，本站只是中间服务平台，本站所有文档下载所得的收益归上传人(含作者)所有【成交的100%(原创)】。</p> <p>本站是网络服务平台方，若您的权利被侵害，侵权客服QQ：3074922707 欢迎举报。</p> <p>Copyright 2004-2021 <a href="https://www.wenku365.com/" target="_blank">wenku365.com</a> All Rights Reserved <a href="https://beian.miit.gov.cn/#/Integrated/index" rel="nofollow" target="_blank">闽ICP备15016911号-5 </a></p> <p>闽公网安备 <a href="http://www.beian.gov.cn/portal/registerSystemInfo?recordcode=35052402000320" rel="nofollow" target="_blank">35052402000320</a></p> <p> <a href="https://www.wenku365.com/zt.html" target="_blank">专题文集</a> <a href="https://www.wenku365.com/zt-90007.html" target="_blank">丨职业培训</a> <a href="https://www.wenku365.com/zt-90005.html" target="_blank">丨实用范文</a> <a href="https://www.wenku365.com/zt-90010.html" target="_blank">丨商业材料</a> <a href="https://www.wenku365.com/zt-90013.html" target="_blank">丨合同协议</a> <a href="https://www.wenku365.com/zt-90009.html" target="_blank">丨PPT专题</a></p> </div> </footer> <script src="//static.wenku365.com/wenku365/js/global.min.js?"></script> <script src="//static.wenku365.com/wenku365/js/clipboard.min.js?"></script> <script src="//static.wenku365.com/wenku365/js/jquery.treeview.js?"></script> <script src="//static.wenku365.com/wenku365/js/jquery.share.min.js?"></script> <script src="//static.wenku365.com/wenku365/js/common.min.js?"></script> <script src="//static.wenku365.com/wenku365/js/downloadFile.js?"></script> <script src="//static.wenku365.com/wenku365/js/loginWindow.js?"></script> <script src="//static.wenku365.com/wenku365/js/windowRecharge.js?"></script> <script src="//static.wenku365.com/wenku365/js/viewer.min.js?"></script> <script src="//static.wenku365.com/wenku365/js/detail.js?"></script>  </body> </html>

jsp实现连接数据库分页浏览 增删改查等功能

jsp实现连接数据库分页浏览 增删改查等功能

jsp实现连接数据库分页浏览增删改查等功能

jsp实现连接数据库分页浏览增删改查等功能