servlet+mysql模拟登录

代码仓库+文档：https://gitee.com/DerekAndroid/ServletLogin.git

效果：(刷新看登录成功次数效果)

mysql

###数据库准备
CREATE DATABASE day09;
###创建账户表 
CREATE TABLE USER( uid INT PRIMARY KEY AUTO_INCREMENT , username VARCHAR(100), PASSWORD VARCHAR(100) );
 
INSERT INTO USER (username,PASSWORD) VALUES('agen','999'); 
INSERT INTO USER (username,PASSWORD) VALUES('nice','666'); 
INSERT INTO USER (username,PASSWORD) VALUES('good','888');

servlet

package com.itheima.servlet;

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

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

import com.itheima.bean.User;
import com.itheima.service.LoginService;

public class LoginServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    @Override
    public void init() throws ServletException {
    	//初始化
        int countInit = 0;
        this.getServletContext().setAttribute("count", countInit);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setHeader("content-type", "text/html;charset=utf-8");
        //获取请求的用户名和密码
        String username = request.getParameter("username");
        String password = request.getParameter("password");

        //创建LoginService
        LoginService ls = new LoginService();
        try {
            //调用service中的方法
            User user = ls.getUserByUsernameAndPwd(username, password);
            //根据返回的对象，判断提示信息的内容
            if (user == null) {
                response.getWriter().println("登录失败");
            } else {
                response.getWriter().println(user.getUsername() + ":欢迎回来");
                //记录次数

                int count = (int) this.getServletContext().getAttribute("count");
                System.out.println(count);
				count++;
                this.getServletContext().setAttribute("count",count);
				 count= (int) this.getServletContext().getAttribute("count");
				response.getWriter().println("登录成功次数:"+count);

            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}