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 教务系统账号被盗号如何追溯设备
- ¥20 delta降尺度方法,未来数据怎么降尺度
- ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
- ¥15 再不同版本的系统上,TCP传输速度不一致
- ¥15 高德地图点聚合中Marker的位置无法实时更新
- ¥15 DIFY API Endpoint 问题。
- ¥20 sub地址DHCP问题
- ¥15 delta降尺度计算的一些细节,有偿
- ¥15 Arduino红外遥控代码有问题
- ¥15 数值计算离散正交多项式