3.用户欢迎界面 Wel3.java
package com.tsinghua;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class Wel3 extends HttpServlet {
public void doGet(HttpServletRequest req,HttpServletResponse res) {
//数据库
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
//html格式
res.setContentType("text/html;charset=utf8");
//分页
int pageCount=0; //总共页数
int pageSize=3; //每页记录数
int rowCount=0; //总共记录数
int pageNow=1; //希望当前页数
//动态的接收pageNow
String sPageNow = req.getParameter("pageCur");
if(sPageNow!=null) {
pageNow = Integer.parseInt(sPageNow);
}
PrintWriter pw = res.getWriter();
//获取session属性
HttpSession hs = req.getSession(true);
String name = (String)hs.getAttribute("uname");
//session不存在
if(name==null) {
//跳转登陆页面,提醒用户未登录
res.sendRedirect("login3?info1=err1");
}
//session存在
//数据库连接
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_user","root","");
ps = con.prepareStatement("select count(*) from users");
rs = ps.executeQuery();
if(rs.next()) {
rowCount = rs.getInt(1);
}
ps = con.prepareStatement("select * from users limit ?,?");
//给?赋值
ps.setInt(1,(pageNow-1)*pageSize);
ps.setInt(2,pageSize);
rs=ps.executeQuery(); //欢迎用户(用户名)
pw.println("Welcome your coming,"+name+"
");
//图片
pw.println("");
//输出分页后users表中信息
pw.println("
pw.println("
");pw.println("
userid");pw.println("
username");pw.println("
passwd");pw.println("
email");pw.println("
priority");pw.println("
");while(rs.next()) {
pw.println("
");pw.println("
"+rs.getInt(1)+"");pw.println("
"+rs.getString(2)+"");pw.println("
"+rs.getString(3)+"");pw.println("
"+rs.getString(4)+"");pw.println("
"+rs.getInt(5)+"");pw.println("
");}
pw.println("
");//计算pageCount
if(rowCount % pageSize == 0) {
pageCount = rowCount / pageSize;
}else {
pageCount = rowCount / pageSize + 1;
}
//上一页
if(pageNow!=1) {
pw.println("上一页");
}
//页数链接
for(int i=pageNow;i
//想要显示的当前页
pw.println(""+i+"");
}
//下一页
if(pageNow!=pageCount) {
pw.println("下一页");
}
}catch(Exception ex) {
ex.printStackTrace();
}finally {
try {
if(rs!=null) {
rs.close();
}
if(ps!=null) {
ps.close();
}
if(con!=null) {
con.close();
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
}
public void doPost(HttpServletRequest req,HttpServletResponse res) {
this.doGet(req,res);
}
}