MVC实现简单登录功能代码

最新推荐文章于 2022-06-25 15:52:36 发布

qq_43573743

最新推荐文章于 2022-06-25 15:52:36 发布

阅读量1.6k

点赞数

分类专栏： JAVAWEB

本文链接：https://blog.csdn.net/qq_43573743/article/details/104464336

版权

JAVAWEB 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

View

前端登录页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action="Controller"  method="post">
		用户名&nbsp;<input type="text" name="name"><p>
		密码&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="pswd"><p>
		<input type="submit">		
	</form>
</body>
</html>

前端登录失败页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%out.print("欢迎") ;%>
</body>
</html>

C

servlet控制器，负责与v和m交互

package LoginServelet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import javaBean.LoginDao;
import javaBean.User;

/**
 * Servlet implementation class Controller
 */
public class Controller extends HttpServlet {

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String env="UTF-8";
		request.setCharacterEncoding(env);
		String name=request.getParameter("name");
		String pswd=request.getParameter("pswd");
		LoginDao ld=new LoginDao();
		int r=ld.login(new User(name,pswd));
		if(r==1)
			
			response.sendRedirect("welcome.jsp");
		else if(r==0)
			request.getRequestDispatcher("login.jsp").forward(request,response);
		else
			response.sendRedirect("a.jsp");
	}

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

}

Model

实现登录功能

package javaBean;

import java.sql.*;

public class LoginDao {

	
	public int login(User user) 
	{
		Connection conn=null;
		PreparedStatement ps=null;
		ResultSet rs =null;
		try {
			conn=JDBCUtils.msngetConnection();
			String sql="select name ,password  from `login` where name=? && password=? ";
			ps = conn.prepareStatement(sql);
			ps.setObject(1, user.getName());
			ps.setObject(2, user.getPassword());
			rs = ps.executeQuery();
			if(rs.next())
			{
				return 1;
			}
			else
				return 0;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return -1;
		}finally {
			
			JDBCUtils.closeResourse(conn, ps, rs);
			
		}
			
		
		
		
		
	}
	

}

##JDBC 工具类

package javaBean;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JDBCUtils {
	public static Connection msngetConnection() throws Exception {

		String user="root";
		String url="jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=utf-8&useSSL=false";
		String password="root";
		String driverClass="com.mysql.jdbc.Driver";
		Class.forName(driverClass);
		
		Connection conn = DriverManager.getConnection(url, user, password);
	
		return conn;

	}

	public static void closeResourse(Connection conn, PreparedStatement ps, ResultSet rs) {
		try {
			if(conn!=null)
			conn.close();
			if(ps!=null)
			ps.close();
			if(rs!=null)
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}
	

}

封装表中的数据的javabean

package javaBean;

public class User {
	private int id;
	private String name;
	private String password;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public User() {
		super();
		// TODO Auto-generated constructor stub
	}
	public User( String name, String password) {
		super();

		this.name = name;
		this.password = password;
	}
}

qq_43573743

关注

0
点赞
踩
13

收藏

觉得还不错? 一键收藏
0
评论
MVC实现简单登录功能代码

View前端登录页面<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html><html><head><meta charset="UTF-8"><title>I...
复制链接

扫一扫