【jsp】调用数据库实现用户登录功能（登录界面使用模板）

最新推荐文章于 2021-09-04 09:39:52 发布

原创最新推荐文章于 2021-09-04 09:39:52 发布 · 3.9k 阅读

14 ·

CC 4.0 BY-SA版权

Java 同时被 3 个专栏收录

66 篇文章

订阅专栏

HTML

12 篇文章

订阅专栏

数据库

12 篇文章

订阅专栏

本文解析了rendshop管理系统登录页面的实现细节，包括使用JSP、JSTL、jQuery等技术进行页面布局和交互设计，以及通过Servlet进行登录验证的后端逻辑。

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<c:set var = "path" value = "${pageContext.request.contextPath }"></c:set>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>欢迎登录rendshop管理系统</title>
<link href="${path}/static/css/style.css" rel="stylesheet" type="text/css" />
<script language="JavaScript" src="${path}/static/js/jquery.js"></script>
<script src="${path}/static/js/cloud.js" type="text/javascript"></script>

<script language="javascript">
	$(function(){
    $('.loginbox').css({'position':'absolute','left':($(window).width()-692)/2});
	$(window).resize(function(){  
    $('.loginbox').css({'position':'absolute','left':($(window).width()-692)/2});
    })  
});  
</script> 

</head>

<body style="background-color:#df7611; background-image:url(images/light.png); background-repeat:no-repeat; background-position:center top; overflow:hidden;">



    <div id="mainBody">
      <div id="cloud1" class="cloud"></div>
      <div id="cloud2" class="cloud"></div>
    </div>  


<div class="logintop">    
    <span>欢迎登录后台管理界面平台</span>    
    <ul>
    <li><a href="#">回首页</a></li>
    <li><a href="#">帮助</a></li>
    <li><a href="#">关于</a></li>
    </ul>    
    </div>
    
    <div class="loginbody">
    
    <span class="systemlogo"></span> 
       
    <div class="loginbox loginbox3">
    <form action="dologin.action" method="post">
    <ul>
    <li><input name="userName" type="text" class="loginuser" value="admin" onclick="JavaScript:this.value=''"/></li>
    <li><input name="passwd" type="text" class="loginpwd" value="密码" onclick="JavaScript:this.value=''"/></li>
    
    <li><input  type="submit" class="loginbtn" value="登录"   /><label><input name="" type="checkbox" value="" checked="checked" />记住密码</label><label><a href="#">忘记密码？</a></label></li>
    </ul>
    
    
    </div>
    
    </div>
</body>

</html>

loginservlet.java

package com.zzxtit.shop.sys.controller;

import java.io.IOException;
import java.sql.SQLException;

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

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import com.zzxtit.common.user.UserInfor;
import com.zzxtit.common.util.DBUtil;

@WebServlet("/dologin.action")
public class LoginServlet extends HttpServlet{

	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request,response);
	}

	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String userName = request.getParameter("userName");
		System.out.println(userName);
		String passwd = request.getParameter("passwd");
		System.out.println(passwd);
		QueryRunner qr = new QueryRunner(DBUtil.getDS());
		String sql = "select * from user_infor where user_name = ? and password = ?";
		try {
			if(qr.query(sql, new BeanHandler<UserInfor>(UserInfor.class),userName,passwd) != null) {
				
				response.sendRedirect("success.jsp");
			}else {
				
				response.sendRedirect("Failure.jsp");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
}

characterencodingfilter.java

package com.zzxtit.common.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;

public class CharacterEncodingFilter implements Filter{
	
	private static String encoding = "utf-8";
	
	@Override
	public void destroy() {
		
		
	}

	@Override
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain filterChain)
			throws IOException, ServletException {
		request.setCharacterEncoding(encoding);
		System.out.println("asdfasgdawer");
		filterChain.doFilter(request, response);
	}

	@Override
	public void init(FilterConfig config) throws ServletException {
		if(config.getInitParameter("encoding") != null) {
			encoding = config.getInitParameter("encoding");
		}
		
	}

}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
	id="WebApp_ID" version="3.0">
	<!-- 
		tomcat 是一個Servlet容器，jsp\自定义的Servlet
	
	
	
		配置Filter
	 -->
	
	<session-config>
		<session-timeout>5</session-timeout>
	</session-config>
	
	<!-- 
	工程首页设置项：如果第一项不存储，依次访问后面的设置项
	 -->
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
		<welcome-file>login.jsp</welcome-file>
	</welcome-file-list>
	
</web-app>