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 outlook无法配置成功
- ¥30 这是哪个作者做的宝宝起名网站
- ¥60 版本过低apk如何修改可以兼容新的安卓系统
- ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
- ¥50 有数据,怎么建立模型求影响全要素生产率的因素
- ¥50 有数据,怎么用matlab求全要素生产率
- ¥15 TI的insta-spin例程
- ¥15 完成下列问题完成下列问题
- ¥15 C#算法问题, 不知道怎么处理这个数据的转换
- ¥15 YoloV5 第三方库的版本对照问题