纯Sevlet登陆页面与数据分页显示

于 2015-01-11 09:57:11 发布
阅读量938 收藏 2
点赞数 1
分类专栏： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/cv_yuippe/article/details/42607857
版权

一、大致流程如下：


分别对应三个sevlet，Login.java LoginCL.java   Wel.java


代码如下：

Login.java

package com.example;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Login extends HttpServlet{

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		resp.setContentType("text/html;charset=utf-8");
		
		PrintWriter pw = resp.getWriter();
		pw.println("<html>");
		pw.println("<body>");
		pw.println("<h1>登陆界面</h1>");
		pw.println("<form action=logincl method=post>");
		pw.println("用户名:<input type=text name=username><br>");
		pw.println("密码:<input type=password name=passwd><br>");
		pw.println("<input type=submit value=login><br>");
		pw.println("</form>");
		pw.println("</body>");
		pw.println("</html>");
		
	}
	
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		this.doGet(req, resp);
	}
}

LoginCL.java 

//用户验证
package com.example;

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

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class LoginCL extends HttpServlet{
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		//接受用户名和密码
		String u = req.getParameter("username");
		String p = req.getParameter("passwd");
		
		//操作数据库
		Connection ct = null;
		Statement stat = null;
		ResultSet rs = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/yuippe", 
					"root", "123456");
			stat = ct.createStatement();
			rs = stat.executeQuery("SELECT passwd FROM users WHERE username='" + u +
					"'" );
			
			if(rs.next()){
				//说明用户存在
				String dbpasswd = rs.getString(1);
				
				if(p.equals(dbpasswd)){
					//用户信息存入session
					HttpSession hs = req.getSession(true);
					hs.setMaxInactiveInterval(60);
					hs.setAttribute("name", u);
					//跳转
					resp.sendRedirect("wel");
				}else{
					resp.sendRedirect("login");
				}
			}else{
				//不合法
				//跳转
				resp.sendRedirect("login");
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try 
			{
				if(rs != null){
					rs.close();
				}
				if(stat != null){
					stat.close();
				}
				if(ct != null){
					ct.close();
				}
			
			} catch (Exception e) {
					e.printStackTrace();
				
			}
		}
	}
	
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		this.doGet(req, resp);
	}
}

Wel.java 

//欢迎界面
package com.example;

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.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class Wel extends HttpServlet{
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		HttpSession hs = req.getSession(true);
		String val = (String)hs.getAttribute("name");
		
		//判断
		if(val == null){
			//非法
			resp.sendRedirect("login");
		}
		
		//分页
		int pageSize = 3;//一页显示几条记录
		int pageNow = 1; //目前显示的页数
		int rowCount = 0;//共有多少条记录（查表）
		int pageCount = 0;//共有多少页(计算)
		
		//动态的接受pageNow
		String spageNow = req.getParameter("pageNow");
		if(spageNow != null)
		pageNow = Integer.parseInt(spageNow);
		
		//操作数据库
		Connection ct = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/yuippe", 
					"root", "123456");
			ps = ct.prepareStatement("SELECT COUNT(*) FROM users");
			rs = ps.executeQuery();
			if(rs.next())
			rowCount = rs.getInt(1);
			
			//共分为多少页
			if(rowCount % pageSize == 0){
				pageCount = rowCount/pageSize;
			}else{
				pageCount = rowCount/pageSize + 1;
			}
			
			ps.close();
			rs.close();
			//每页上需要显示的结果
			ps = ct.prepareStatement("SELECT * FROM users LIMIT " + (pageNow-1)*pageSize + ","
					                 + pageSize +";");
			rs = ps.executeQuery();
			
			resp.setContentType("text/html;charset=utf-8");
			PrintWriter pw = resp.getWriter();
			pw.println("<html>");
			pw.println("<body>");
			pw.println("<table border='1'>");
			//显示结果表格
			pw.println("<tr><th>userId</th><th>username</th><th>passwd</th><th>grade</th></tr>");
			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.getInt(4) + "</td>");
				pw.println("</tr>");
			}
			pw.println("</table>");
			//显示上一页
			if(pageNow != 1)
			pw.println("<a href=wel?pageNow=" + (pageNow-1) + ">"+"上一页"+"</a>");
			//显示5个页面超链接
			for(int i=pageNow; i < pageNow+5; i++){
				pw.println("<a href=wel?pageNow="+i+">" +i+ "</a>");
			}
			//显示下一页
			if(pageNow != pageCount)
			pw.println("<a href=wel?pageNow=" + (pageNow+1) + ">"+"下一页"+"</a>");
			
			pw.println("</body>");
			pw.println("</html>");
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try 
			{
				if(rs != null){
					rs.close();
				}
				if(ps != null){
					ps.close();
				}
				if(ct != null){
					ct.close();
				}
			
			} catch (Exception e) {
					e.printStackTrace();
				
			}
			}
		
	}
	
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		this.doGet(req, resp);
	}
}

web.xml配置文件如下： 

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee/web_2_4.xsd"
         wersion="2.4">

<servlet>
  <servlet-name>login</servlet-name>
  <servlet-class>com.example.Login</servlet-class>
</servlet>

<servlet-mapping>
  <servlet-name>login</servlet-name>
  <url-pattern>/login</url-pattern>
</servlet-mapping>

<servlet>
  <servlet-name>logincl</servlet-name>
  <servlet-class>com.example.LoginCL</servlet-class>
</servlet>

<servlet-mapping>
  <servlet-name>logincl</servlet-name>
  <url-pattern>/logincl</url-pattern>
</servlet-mapping>

<servlet>
  <servlet-name>wel</servlet-name>
  <servlet-class>com.example.Wel</servlet-class>
</servlet>

<servlet-mapping>
  <servlet-name>wel</servlet-name>
  <url-pattern>/wel</url-pattern>
</servlet-mapping>

</web-app>

二、分页显示

分别定义四个变量

                int pageSize = 3;//一页显示几条记录
int pageNow = 1; //目前所在的页面
int rowCount = 0;//共有多少条记录（查表）
int pageCount = 0;//共有多少页(计算)

rowCount通过查表得到：

ps = ct.prepareStatement("SELECT COUNT(*) FROM users");
			rs = ps.executeQuery();
			if(rs.next())
			rowCount = rs.getInt(1);

pageCount通过计算可得： 

if(rowCount % pageSize == 0){
				pageCount = rowCount/pageSize;
			}else{
				pageCount = rowCount/pageSize + 1;
			}

三、结果如下：


cv_yuippe
关注
  • 1
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值