基于Servlet、JSP、JDBC、MySQL的登录模块(含过滤器的使用和配置)

现在的位置: 首页 > 综合 > 正文

基于Servlet、JSP、JDBC、MySQL的登录模块(含过滤器的使用和配置)

2018年01月10日 ⁄ 综合 ⁄ 共 6565字 ⁄ 字号小中大 ⁄ 评论关闭

接前文的注册模块，本篇是登录模块。主要包括登录主界面，和登录相关编写的LoginAction、LoginDao和LoginService。以及配置的Filter。下面按逻辑顺序记录详细过程和代码:

一、在前文的index目录点击登录按钮后，通过javascript跳转至LoginAction。

<script type="text/javascript">
 function login(){
   var th = document.form1;
   if(th.username.value==""){
      alert("用户名不能为空！！");
      th.username.focus();
      return ;
   }
   if(th.pswd.value==""){
      alert("密码不能为空！！");
      th.pswd.focus();
      return ;
   }
   th.action="<%=path%>/servlet/LoginAction";
		th.submit();
	}
</script>

二、就是关于登录这个事件，需要创建三个文件分别是LogingAction，是个Servlet。LoginService是个接口，LoginDao实现上面的接口，查询数据库。跟前文的注册模块一样的哈。

LogingAction.java

package com.product.login.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;

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

import com.product.login.dao.LoginDao;
import com.product.login.service.LoginService;

public class LoginAction extends HttpServlet {

	private LoginService service;
	/**
	 * Constructor of the object.
	 */
	public LoginAction() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doPost(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html; charset=utf-8");
		String path = request.getContextPath();
		PrintWriter out = response.getWriter();
        String username = request.getParameter("username");
        String pswd = request.getParameter("pswd");
        List<Object> params = new ArrayList<Object>();
        params.add(username);
        params.add(pswd);
        boolean flag = service.login(params);
        out.println("username = " + username);
        out.println("pswd = " + pswd);
        
        if(flag){
        request.getSession().setAttribute("username", username);
        response.sendRedirect(path + "/main.jsp");
        }else{
        	out.println("登录失败 ");
        }
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
		service = new LoginDao();
	}

}

要点:创建一个Session，将username存进去传递给main.jsp。也即在main.jsp的时候我要知道当前是谁在登录。

if(flag){
request.getSession().setAttribute("username", username);
response.sendRedirect(path + "/main.jsp");
}

LoginService.java

package com.product.login.service;

import java.util.List;

public interface LoginService {
	public boolean login(List<Object> params);
}

LoginDao.java

package com.product.login.dao;

import java.util.List;
import java.util.Map;

import com.product.jdbc.dbutil.JdbcUtils;
import com.product.login.service.LoginService;

public class LoginDao implements LoginService {
	private JdbcUtils jdbcUtils;
	public LoginDao(){
		jdbcUtils = new JdbcUtils();
	}
	@Override
	public boolean login(List<Object> params) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "select * from userinfo where username = ? and pswd = ?";
		try{
			jdbcUtils.getConnection();
			Map<String, Object> map = jdbcUtils.findSimpleResult(sql, params);
			flag = (!map.isEmpty()) ? true : false;
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			jdbcUtils.releaseConn();
		}
		return flag;
	}

}

三、这样如果登录成功的话就跳转到了main.jsp界面：

main.jsp代码如下:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
	String path = request.getContextPath();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/frameset.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<TITLE>后台管理系统</TITLE>
<META http-equiv=content-type content="text/html; charset=utf-8">
</HEAD>
<FRAMESET rows=105,* cols="*" bordercolor="04376E">
	<FRAME name=ads marginWidth=0 marginHeight=0 src="<%=path%>/top.jsp"
		frameBorder=0 noResize scrolling=no longDesc="">
	<FRAMESET rows=675 cols=198,* frameborder="yes">
		<FRAME name=list marginWidth=0 marginHeight=0 src="<%=path%>/left.jsp"
			frameBorder=0 noResize scrolling=yes longDesc="">
		<FRAME name=main marginWidth=0 marginHeight=0
			src="<%=path%>/postdata.jsp" frameBorder=0 scrolling=yes longDesc="">
	</FRAMESET>
	<NOFRAMES>
	</NOFRAMES>
</FRAMESET>
<body>
</body>
</HTML>

可以看到main.jsp在书写上利用了<frameset>标签，在里面嵌套<frame>,分别是top.jsp left.jsp postdata.jsp.使用说明参见:链接1 链接2

在index.jsp里增加了底部的jsp，使用的是iframe：

<IFRAME name="top" align="default" src="<%=path %>/bottom.jsp"
frameBorder=0 width=100% scrolling=no height=88>
<h1> </h1>
</IFRAME>

正好可以对比其区别，详见链接1 链接2 链接3 iframe使用时常常要和target配合使用，参见链接1 链接2

top.jsp left.jsp postdata.jsp这三个的代码就不贴了，在源码里。

四：filter的使用

起因是浏览器直接输入http://localhost:8080/xianfengYan/main.jsp 这时还没有登录，没有验证，我们不希望游客访问这个界面，因此需要加个过滤器进行过滤，直接将页面跳转至index.jsp.

新建包package com.product.filter;

MyFilter.java

package com.product.filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class MyFilter implements Filter {

	@Override
	public void destroy() {
		// TODO Auto-generated method stub
		
	}

	@Override
	public void doFilter(ServletRequest request, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {
		// TODO Auto-generated method stub
		//过滤用户的请求，判断是否登录
		
		HttpServletRequest httpServletRequest = (HttpServletRequest)request;
		HttpServletResponse httpServletResponse = (HttpServletResponse)response;
		httpServletRequest.setCharacterEncoding("utf-8");
		httpServletResponse.setCharacterEncoding("utf-8");
		String path = httpServletRequest.getContextPath();
		String username = (String)httpServletRequest.getSession().getAttribute("username");
		if(username == null){
			httpServletResponse.sendRedirect(path + "/index.jsp");
		}
		chain.doFilter(httpServletRequest, httpServletResponse);
	}

	@Override
	public void init(FilterConfig arg0) throws ServletException {
		// TODO Auto-generated method stub
		
	}

}

然后再web.xml里进行配置:

	<filter>
		<filter-name>MyFilter</filter-name>
		<filter-class>com.product.filter.MyFilter</filter-class>
	</filter>
	<filter-mapping>
		<filter-name>MyFilter</filter-name>
		<url-pattern>/main.jsp</url-pattern>
	</filter-mapping>

url-pattern里表示过滤的页面，我们指定过滤/main.jsp这个界面。

代码下载链接:http://download.csdn.net/detail/yanzi1225627/7448175

【上篇】考查嵌入式C开发人员最好的十道题
【下篇】“command line option syntax error，Type command/？for help

作者: nagging

该日志由 nagging 于6年前发表在综合分类下，最后更新于 2018年01月10日.
转载请注明: 基于Servlet、JSP、JDBC、MySQL的登录模块(含过滤器的使用和配置) | 学步园 +复制链接

抱歉!评论已关闭.

学步园

基于Servlet、JSP、JDBC、MySQL的登录模块(含过滤器的使用和配置)

作者: nagging

书签

最新文章New

本站推荐

返回首页