servlet做用户管理之三

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class Welcome extends HttpServlet{
 //客户端用get方式访问页面时就是调用了doGet方法（直接在地址栏里面敲url地址）！
 //客户提交表单，并且表单用post方式提交时，调用了doPost方式！
 protected void doGet(HttpServletRequest req, HttpServletResponse resp)
   throws ServletException, IOException {
  doPost(req,resp);
  
 }

 @Override
 protected void doPost(HttpServletRequest req, HttpServletResponse resp)
   throws ServletException, IOException {
  resp.setCharacterEncoding("gbk");
  req.setCharacterEncoding("gbk");
  PrintWriter pw = resp.getWriter();
  boolean flag1=false;
  boolean flag2=false;
  HttpSession hs = req.getSession(true);
  Cookie c []=req.getCookies();
  for(int i=0;i<c.length;i++){
   if(c[i].getName().equals("userName")){
    flag1=true;
   }if(c[i].getName().equals("pwd")){
     flag2=true;
    }
  }
  String userName=null;
  String pwd =null;
  if(req.getParameter("hi")==null){
   userName=(String)hs.getAttribute("userName");
   pwd=(String)hs.getAttribute("pwd");
  }
  pw.print(flag1);
  pw.print(flag2);
  if((userName!=null&&pwd!=null)||(flag1&&flag2)){
   ServletContext sc = this.getServletContext();
   String value=(String)sc.getAttribute("doublejun");
   System.out.println("welcome测试用的："+value+"");
   pw.print("<h1>welcome:您是第:"+value+"个访问次页面的用户,IP:"+req.getRemoteAddr()+"主机名:"+req.getRemoteHost()+"</h1><br/><img src='images/1.jpg' width='146' height='92'><br/><input type=hidden id='hi' name='hi' value='helldsfd'><table border=1><tr><th>ID</th><th>姓名</th><th>密码</th><th>Email</th><th>性别</th><th>其他</th></tr>");
   String dbURL = "jdbc:sqlserver://localhost:1434; DatabaseName=INFO";
   String user="sa";
   String password ="123";
   int pageCount =0;
   int pageSize=5;
   int pageNow=1;
   int rowCount=0;
   String cpageNow =req.getParameter("cpageNow");
   if(cpageNow!=null){
    pageNow=Integer.parseInt(cpageNow);
   }else {
    pageNow=1;
   }
   
   Connection con=null;
   Statement stmt=null;
   ResultSet rs=null;
   PreparedStatement pstmt= null;
   try {
    try {
     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
    } catch (InstantiationException e) {
     e.printStackTrace();
     pw.print("InstantiationException");
    } catch (IllegalAccessException e) {
     e.printStackTrace();
     pw.print("IllegalAccessException");
    }
   } catch (ClassNotFoundException e) {
    e.printStackTrace();
    System.out.println(e.toString());
    pw.print("class not found");
   }finally{
    
    
   }
   try {
    
    con = DriverManager.getConnection(dbURL,user,password);
    stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE );
    rs= stmt.executeQuery("select * from users");
    rs.last();
    rowCount=rs.getRow();
    pw.print(rowCount);
    if(rowCount%pageSize==0){
     pageCount=rowCount/pageSize;
    }
    else {
     pageCount=rowCount/pageSize+1;
    }
    String qurey = "select top "+pageSize+" * from users where id not in(select top "+((pageNow-1)*pageSize) +" id from users )";
    pstmt = con.prepareStatement(qurey);
    rs = pstmt.executeQuery();
    while(rs.next()){
     pw.print("<tr>");
     pw.print("<td>");
     pw.print(rs.getInt(1));
     pw.print("</td>");
     pw.print("<td>");
     pw.print(rs.getString(2));
     pw.print("</td>");
     pw.print("<td>");
     pw.print(rs.getString(3));
     pw.print("</td>");
     pw.print("<td>");
     pw.print(rs.getString(4));
     pw.print("</td>");
     pw.print("<td>");
     pw.print(rs.getString(5));
     pw.print("</td>");
     pw.print("<td>");
     pw.print(rs.getString(6));
     pw.print("</td>");
     pw.print("</tr>");
    
    }
    
    
   } catch (SQLException e) {
    e.printStackTrace();
    pw.write(e.toString());
   } finally {
    
    pw.print("</table><br/>");
    //pw.print("pageCount:"+pageCount+"rowCount:"+rowCount+"pageNOw:"+pageNow+"pageSize"+pageSize);
    pw.print("当前是第"+pageNow+"页");
    if(pageNow!=1){
     pw.print("<a href=welcome?cpageNow="+(pageNow-1)+">上一页</a>");
    }
    for(int i=1;i<=pageCount;i++){
     pw.print("<a href=welcome?cpageNow="+i+">"+i+"</a>&nbsp;&nbsp;");
    }
    if(pageNow<pageCount){
     pw.print("<a href=welcome?cpageNow="+(pageNow+1)+">下一页</a>");
    }
    pw.print("共"+pageCount+"页");
    if(rs!=null){
     try {
      rs.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
    if(stmt!=null){
     try {
      stmt.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }if(con!=null){
     try {
      con.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
   }
  }else{
   pw.print("禁止非法登录!");
  }
 }
 
}