1条回答
- qq_34791921 2016-04-29 07:32关注
全部的代码:
package com.ads;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;public class Success extends HttpServlet{
ResultSet rs = null;
PreparedStatement pstmt = null;
Connection conn = null;
public void doGet(HttpServletRequest req,HttpServletResponse res){
try{
String u = req.getParameter("uname");
String p = req.getParameter("pass");
HttpSession hs = req.getSession(true);
String val =(String)hs.getAttribute("pas");PrintWriter pw = res.getWriter(); if(val==null){ res.sendRedirect("login"); } int pageSize = 3; int pageNow = 1; int rowCount = 0; int pageCount = 0; String sPageNow = req.getParameter("pageNow"); if(sPageNow!=null){ pageNow = Integer.parseInt(sPageNow); } pw.println("<body>"); pw.println("<img src=Images/Penguins.jpg width=200px><br/>"); pw.println("hello,u:"+ u + "p:" + p); pw.println("<a href=# >return login</a>"); Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","zhushaowei12"); pstmt = conn.prepareStatement("select count(*) from users"); rs = pstmt.executeQuery(); if(rs.next()){ rowCount = rs.getInt(1); } if(rowCount%pageSize==0){ pageCount = rowCount/pageSize; } else{ pageCount = rowCount/pageSize + 1; } pstmt = conn.prepareStatement("select * from (select a1.*,rownum rn from (select * from users) a1 where rownum<=?)where rn>=?"); pstmt.setInt(1,pageSize*pageNow); pstmt.setInt(2,pageSize*(pageNow-1)+1); rs = pstmt.executeQuery(); pw.println("<table border=1>"); pw.println("<tr><td>id</td><td>username</td><td>password</td><td>email</td><td>grade</td>"); while(rs.next()){ pw.println("<tr>"); pw.println("<td>"+rs.getInt(1)+"</td>"); pw.println("<td>"+rs.getString(2)+"</td>"); pw.println("<td>"+rs.getString(3)+"</td>"); pw.println("<td>"+rs.getString(4)+"</td>"); pw.println("<td>"+rs.getInt(5)+"</td>"); pw.println("</tr>"); } pw.println("</table"); for(int i=1;i<=pageCount;i++){ if(i==pageNow){ pw.print("<a href=success?pageNow="+ i +">"+ i + "</a>"); } else{ pw.print("<a href=success?pageNow="+ i +">"+ i + "</a>"); } } pw.println("</body>"); } catch(Exception e){ e.printStackTrace(); } } public void doPost(HttpServletRequest req,HttpServletResponse res){ this.doGet(req,res); }
}
解决 无用评论 打赏 举报
悬赏问题
- ¥15 求差集那个函数有问题,有无佬可以解决
- ¥15 【提问】基于Invest的水源涵养
- ¥20 微信网友居然可以通过vx号找到我绑的手机号
- ¥15 寻一个支付宝扫码远程授权登录的软件助手app
- ¥15 解riccati方程组
- ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
- ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
- ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
- ¥50 树莓派安卓APK系统签名
- ¥65 汇编语言除法溢出问题