Servlet实现登陆

1.新建动态web项目 

 2.在webcontent下面新建login.html

login.html

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

 3 在项目目录下的Java Resources下面的src目录下新建Servet

4.输入包名和类名,点next

5.双击URL mappings下面的/LoginServlet

6将pattern改为/login,点OK,再点Finish

7.删掉新建的Servet的所有内容,重新输入Servlet使用模板来生成LoginServet 

 

package com.dxm.servlet;

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

public class LoginServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.getWriter().write("hello haohao...");
	}

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

8.在src里面新建User类,放到com.dxm.domain包中

package com.dxm.domain;

public class User {
	private int id;
	private String username;
	private String password;
	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;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", password=" + password + "]";
	}
	
}

10.将C3p0,dbutils,mysql driver放在WEB-INF下的lib下面,配置tomcat时候已经将tomcat的runtime加入了build path,同时将

c3p0-config.xml文件拷贝到src目录下,如下图:

11 修改LoginServlet

package com.dxm.login;

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

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
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.dxm.domain.User;
import com.dxm.utils.DataSourceUtils;



public class LoginServlet extends HttpServlet {
	
	@Override
	public void init() throws ServletException {
		//在Seveltcontext域中存一个数据count
		int count = 0;
		this.getServletContext().setAttribute("count", count);
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		
		
		//username=zhangsan&password=123
		
		//1、获得用户名和密码
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		
		//2、从数据库中验证该用户名和密码是否正确
		QueryRunner runner = new QueryRunner(DataSourceUtils.getDataSource());
		String sql = "select * from tbl_user where username=? and password=?";
		User user = null;
		try {
			user = runner.query(sql, new BeanHandler<User>(User.class), username,password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		//3、根据返回的结果给用户不同显示信息
		if(user!=null){
			//从servletcontext中取出count进行++运算
			ServletContext context = this.getServletContext();
			Integer count = (Integer) context.getAttribute("count");
			count++;
			//用户登录成功
			response.getWriter().write(user.toString()+"---you are success login person :"+count);
			context.setAttribute("count", count);
		}else{
			//用户登录失败
			response.getWriter().write("sorry your username or password is wrong");
		}
		
	}

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

12,发布运行tomcat

13 访问http://localhost:8080/WEB0913/login

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值