实现简单的登录功能(1.0)

实现简单的登录功能(1.0)

项目图

在这里插入图片描述

Dao层

package com.example.dao;

import com.example.domain.User;

public interface Dao {
	User findUserandPassword(String name,String password);

}

DaoImpl层

package com.example.dao.impl;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.example.dao.Dao;
import com.example.domain.User;

public class DaoImpl implements Dao {

	@Override
	public User findUserandPassword(String name, String password) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			//1.注册驱动
			Class.forName("com.mysql.jdbc.Driver");
			//2.通过驱动管理器获取连接
			conn = DriverManager.getConnection("jdbc:mysql:///test","root","123456");
			//3.通过连接获取语句对象
			ps = conn.prepareStatement("select * from user where username=? and password=?");
			//4.传递参数
			ps.setString(1,name);
			ps.setString(2,password);
			//5.获取结果集
			rs = ps.executeQuery();
			//6.迭代结果集
			while(rs.next()) {
				User u = new User();
				u.setUid(rs.getInt("uid"));
				u.setUname(rs.getString("username"));
				u.setPassword(rs.getString("password"));
				return u;
			}
		}catch(Exception e) {
			e.printStackTrace();
			return null;
		}finally {
			//7.释放资源
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
			return null;
		}
	}

User层

package com.example.domain;

public class User {
	private Integer uid;
	private String username;
	private String password;
	public Integer getUid() {
		return uid;
	}
	public void setUid(Integer uid) {
		this.uid = uid;
	}
	public String getUname() {
		return username;
	}
	public void setUname(String uname) {
		this.username = uname;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	
}

Service层

package com.example.service;

import com.example.domain.User;

public interface Service {
	User login(String name,String password);

}

ServiceImpl层

package com.example.service.impl;

import com.example.dao.Dao;
import com.example.dao.impl.DaoImpl;
import com.example.domain.User;
import com.example.service.Service;

public class ServiceImpl implements Service {
	private Dao dao = new DaoImpl();
	@Override
	public User login(String name, String password) {
		
		User u = dao.findUserandPassword(name, password);
		if(u == null) 
			
			throw new RuntimeException("bucunzai");
		
			
		return u;
	}

}

LoginService层

package com.example.web;

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

import com.example.service.Service;
import com.example.service.impl.ServiceImpl;


public class LoginServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
   
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.getWriter().append("Served at: ").append(request.getContextPath());
	}

	
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.请求获取参数中的用户名和密码信息
		String username = request.getParameter("username");
		String password= request.getParameter("password");
		//2.调用服务层完成用户登录的业务,面向接口编程
		Service service = new ServiceImpl();
		try {
			
			service.login(username, password);
			System.out.println("登录成功");
		}catch (Exception e) {
			System.out.println("用户名或密码错误,登录失败");
		}
	}
}

Login.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action="dologin" method = "post">
	用户名:	<input type = "text" name = "username">
	密    码:	<input type="password" name = "password">
	<input type = "submit" value = "登录">
	</form>
</body>
</html>

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" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>web02</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <servlet>
    <description></description>
    <display-name>LoginServlet</display-name>
    <servlet-name>LoginServlet</servlet-name>
    <servlet-class>com.example.web.LoginServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>LoginServlet</servlet-name>
    <url-pattern>/dologin</url-pattern>
  </servlet-mapping>
</web-app>

数据库

在这里插入图片描述

谢谢大家的欣赏和关注!!!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值