public void doGet(HttpServletRequest req, HttpServletResponse res){
PreparedStatement ps = null;
ResultSet rs = null;
try{
res.setContentType("text/html;charset=gbk");
PrintWriter pw = res.getWriter();
HttpSession hs = req.getSession(true);
String name = (String)hs.getAttribute("name");
if(name == null){
res.sendRedirect("login");
}
pw.println("登陆成功"+name);
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
//分页
int pagerow = 3;
int nowpage = 1;
int pagelist = 0;
int pagecount = 0;
ps = conn.prepareStatement("select count(*) from data");
rs = ps.executeQuery();
if(rs.next()){
pagelist = rs.getInt(1);
if(pagelist%pagerow == 0){
pagecount = pagelist/pagerow;
}else{
pagecount = pagelist/pagerow+1;
}
}
if(req.getParameter("spagecount") != null){
nowpage = Integer.parseInt(req.getParameter("spagecount"));
//System.out.println(req.getParameter("spagecount"));
}
//显示列表
Statement st = conn.createStatement();
rs = st.executeQuery("select * from data limit "+(nowpage-1)*pagerow+","+pagerow);
pw.println("<table border=1 style='margin:0 auto 0 auto;width:350px'>");
while(rs.next()){
pw.println("<tr>");
pw.println("<td>"+rs.getInt(1)+"</td>");
pw.println("<td>"+rs.getString(2)+"</td>");
pw.println("<td>"+rs.getInt(4)+"</td>");
pw.println("</tr>");
}
pw.println("</table>");
//分页开始
pw.println("<div style='text-align:center'>");
//显示上一页
if(nowpage>1)
pw.println("<a href='?spagecount="+(nowpage-1)+"'>上一页</a>");
if(nowpage>6){
pw.println("<a href='?spagecount="+1+"'>...1...</a>");
}
//页码显示
int j = 0;
if(nowpage>5 ){
j = nowpage-5;
}
if(pagecount-nowpage<5){
j = pagecount-10;
}
for(int i = 1+j; i<=10+j; i++){
pw.println("<a href='?spagecount="+i+"'>"+i+"</a>");
}
if(pagecount-nowpage > 5){
pw.println("<a href='?spagecount="+pagecount+"'>..."+pagecount+"...</a>");
}
//显示下一页
if(nowpage<pagecount)
pw.println("<a href='?spagecount="+(nowpage+1)+"'>下一页</a>");
pw.println("</div>");
}catch(Exception e){
e.printStackTrace();
}
}