simple的login

最新推荐文章于 2026-04-01 20:10:48 发布

原创最新推荐文章于 2026-04-01 20:10:48 发布 · 424 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

JavaWeb类基础专栏收录该内容

18 篇文章

订阅专栏

1.mysql驱动jar
2.beanutils.jar
3.组织包结构
——-web层, 业务层,dao层
com.sky.login.web
com.sky.login.service
com.sky.login.dao
com.sky.login.domain
com.sky.login.utils
4.用户登录
5.db.properties

com.sky.login.web.LoginServlet.java

package com.sky.login.web;

import java.io.IOException;
import java.lang.reflect.InvocationTargetException;

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

import org.apache.commons.beanutils.BeanUtils;

import com.itheima.login.domain.User;
import com.itheima.login.service.UserSerivce;

public class LoginServlet extends HttpServlet {

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {


        User user = new User();

        //使用beanUtils封装
        try {
            BeanUtils.populate(user, request.getParameterMap());
        } catch (Exception e) {
            e.printStackTrace();
        }

        UserSerivce us =new UserSerivce();
        User loginUser = us.login(user);

        if(loginUser==null){

            request.setAttribute("message", "对不起,用户名或密码错误,不要瞎搞...");
            request.getRequestDispatcher("/login.jsp").forward(request, response);

        }else{

            request.getSession().setAttribute("loginUser", loginUser);
            response.sendRedirect(request.getContextPath()+"/index.jsp");
        }

    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        doGet(request, response);
    }

}

com.sky.login.service.UserSerivce.java

package com.sky.login.service;

import com.itheima.login.dao.UserDao;
import com.itheima.login.domain.User;

public class UserSerivce {

    public User login(User user) {

        UserDao udao = new UserDao();

        return udao.selectOne(user);

    }

}

com.sky.login.dao.UserDao.java

package com.sky.login.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

import com.itheima.login.domain.User;
import com.itheima.login.utils.JdbcUtils;

public class UserDao {
//2、prepareStatement
    public User selectOne(User user) {

        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;
        try {

            conn = JdbcUtils.getConnection();

            String sql ="select * from users where username=? and password=?";

            stmt = conn.prepareStatement(sql);

            stmt.setString(1, user.getUsername());
            stmt.setString(2, user.getPassword());

            rs = stmt.executeQuery();
            User loginUser = null;

            if(rs.next()){

                loginUser = new User();
                int id = rs.getInt("id");
                String username = rs.getString("username");
                String password = rs.getString("password");
                String nickname = rs.getString("nickname");

                loginUser.setId(id);
                loginUser.setUsername(username);
                loginUser.setPassword(password);
                loginUser.setNickname(nickname);

            }

            return loginUser;

        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }finally{
            JdbcUtils.release(rs, stmt, conn);
        }

    }

//1、Statement 
    public User selectOne1(User user) {


        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            conn = JdbcUtils.getConnection();

            stmt = conn.createStatement();

            String sql = "select * from users where username='"+user.getUsername()+"' and password='"+user.getPassword()+"'";

            rs = stmt.executeQuery(sql);

            User loginUser = null;

            if(rs.next()){

                loginUser = new User();
                int id = rs.getInt("id");
                String username = rs.getString("username");
                String password = rs.getString("password");
                String nickname = rs.getString("nickname");


                loginUser.setId(id);
                loginUser.setUsername(username);
                loginUser.setPassword(password);
                loginUser.setNickname(nickname);

            }

            return loginUser;

        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }finally{
            JdbcUtils.release(rs, stmt, conn);
        }

    }

}

com.sky.login.domain.User.java

package com.sky.login.domain;

public class User {

    private int id;
    private String username;
    private String password;
    private String nickname;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getNickname() {
        return nickname;
    }
    public void setNickname(String nickname) {
        this.nickname = nickname;
    }
}

com.sky.login.utils.JdbcUtils.java

package com.sky.login.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;



public class JdbcUtils {

    private static String driverClass =null;
    private static String url =null;
    private static String username =null;
    private static String password =null;

    static{

        ResourceBundle bundle = ResourceBundle.getBundle("db");

        url = bundle.getString("url");
        username = bundle.getString("username");
        password = bundle.getString("password");
        driverClass = bundle.getString("driverClass");

    }


    public static Connection getConnection(){

        try {
            loadDriver();

            return DriverManager.getConnection(url, username, password);
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    }

    private static void loadDriver() {

        try {
            Class.forName(driverClass);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }


    public static void release(ResultSet rs, Statement stmt ,  Connection conn){

        if(rs!=null){
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            rs =null;
        }
        if(stmt!=null){
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            stmt=null;
        }
        if(conn!=null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            conn=null;
        }

    }

}

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <title>My JSP 'index.jsp' starting page</title>
  </head>

  <body>

    <c:if test="${empty loginUser }"> 
        对不起, 你还没登录,
        <a href="${pageContext.request.contextPath }/login.jsp">去登录</a>
    </c:if>
    <c:if test="${not empty loginUser }"> 
        欢迎您, ${loginUser.nickname }
    </c:if>
  </body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
    <h3>登录表单</h3>
    <font color="red">${message }</font>
    <form action="${pageContext.request.contextPath }/login" method="post">
        用户名: <input type="text" name="username"><br/>
        密码: <input type="password" name="password"><br/>
        <input type="submit" value="登录">
    </form>
</body>
</html>