基础------重点摘要----登录（servlect版本）

Dao实现

package cn.wjs.dao;

import cn.wjs.domain.LoginUser;
import cn.wjs.utils.DaoUtil;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

public class LoginDao {
    private JdbcTemplate jt;
    public LoginUser loginDao(LoginUser loginUser){
        LoginUser user=null;
        try {
            jt=new JdbcTemplate(DaoUtil.getDataSource());
            String sql="select * from user where username=? and password =?";
            user=jt.queryForObject(sql,new BeanPropertyRowMapper<LoginUser>(LoginUser.class),loginUser.getUsername(),loginUser.getPassword());
        }catch (Exception e){
            e.printStackTrace();
            return null;
        }
       return user;
    }
}

domai 实现

package cn.wjs.domain;

public class LoginUser {
    private int id;
    private String username;
    private String password;
    private String checkcode;

    public LoginUser() {
    }

    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 getCheckcode() {
        return checkcode;
    }

    public void setCheckcode(String checkcode) {
        this.checkcode = checkcode;
    }

    @Override
    public String toString() {
        return "LoginUser{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", checkcode='" + checkcode + '\'' +
                '}';
    }
}

验证码是实现

package cn.wjs.servlet;

import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.awt.*;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.util.Random;

/**
 * 验证码类实现
 */

@WebServlet("/checkCode")
public class CheckCode extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int width=100;
        int height=50;
        //验证码图片对象
        BufferedImage bufferedImage=new BufferedImage(width,height,BufferedImage.TYPE_INT_RGB);
        //填充图片背景色
        Graphics graphics=bufferedImage.getGraphics();
        graphics.setColor(Color.pink);
        graphics.fillRect(0,0,width,height);
        //设置图片边框
        graphics.setColor(Color.blue);
        graphics.drawRect(0,0,width-1,height-1);
        //写验证码4d
        String code= "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghigklmnopqrstuvwxyz0123456789";
        Random rdm=new Random();
        graphics.setFont(new Font("TimesRoman",Font.BOLD,20));
        graphics.setColor(Color.BLACK);
        StringBuffer sb=new StringBuffer();
        for (int i =1; i <=4 ; i++) {
            int i1 = rdm.nextInt(code.length());
            char c = code.charAt(i1);
            //将验证码写到字符串缓冲区
            sb.append(c);
            graphics.drawString(c+"",width/5*i,height/2);
        }
        //将生成的验证码放入session中
        request.getSession().setAttribute("cCode",sb.toString());
        //写干扰写
        graphics.setColor(Color.MAGENTA);
        for (int i = 0; i <10 ; i++) {
            int x1=rdm.nextInt(width);
            int y1=rdm.nextInt(height);
            int x2=rdm.nextInt(width);
            int y2=rdm.nextInt(height);
            graphics.drawLine(x1,y1,x2,y2);
        }


        //将图片输出到浏览器
        ImageIO.write(bufferedImage,"jpg",response.getOutputStream());
    }
}

登录的servlet

package cn.wjs.servlet;



import cn.wjs.dao.LoginDao;
import cn.wjs.domain.LoginUser;
import org.apache.commons.beanutils.BeanUtils;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;

@WebServlet("/LoginServlet")
public class LoginServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        Map<String, String[]> userMao = request.getParameterMap();
        LoginUser loginUser=new LoginUser();
        String sessionCode=(String) request.getSession().getAttribute("cCode");
        //避免验证码重复使用
        request.getSession().removeAttribute("cCode");
        LoginDao ld=new LoginDao();
        try {
            BeanUtils.populate(loginUser,userMao);
            if(loginUser.getCheckcode()==null&&sessionCode.equalsIgnoreCase(loginUser.getCheckcode())){
                request.setAttribute("code_Exc","验证码错误");
                request.getRequestDispatcher("login.jsp").forward(request,response);
                return;
            }else {
                LoginUser user = ld.loginDao(loginUser);
                if(user==null){
                    request.setAttribute("user_Exc","用户名密码错误");
                    request.getRequestDispatcher("login.jsp").forward(request,response);
                }else{
                    request.getSession().setAttribute("user",user);
                    response.sendRedirect(request.getServletContext().getContextPath()+"/Success.jsp");
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

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

工具包实现（获取数据源）

package cn.wjs.utils;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

public class DaoUtil {

    public static DataSource dataSource;

    static {
        try {
            Properties properties=new Properties();
            properties.load(DaoUtil.class.getClassLoader().getResourceAsStream("druid.properties"));
            dataSource=DruidDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            e.printStackTrace();
        }

    }


    public  static DataSource getDataSource(){
        return dataSource;
    }

    public static Connection getConnec() throws SQLException {
        return dataSource.getConnection();
    }

}

配置文件

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///。。。。
username=root
password=。。。。
initialSize=5
maxActive=10
maxWait=3000

登陆页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>login</title>
    <script>
        window.onload=function () {
            document.getElementById("checkId").onclick=function () {
                this.src="/tomcat_day02/checkCode?time="+new Date().getTime();
            }
        }

    </script>
    <style>
        div{
            color: red;
        }
    </style>
</head>
<body>
    <form action="/tomcat_day02/LoginServlet" method="post">
        用户名：<input type="text" name="username"/><br>
        密码：<input type="password" name="password"/><br>
        验证码：<input type="text" name="checkcode"/><img id="checkId" src="/tomcat_day02/checkCode"><br>
        <input type="submit" value="提交"/><br>
        <%--验证码出错--%>
        <div><%=request.getAttribute("code_Exc")==null ? "":request.getAttribute("code_Exc")%></div>
        <%--密码用户名错误--%>
        <div><%=request.getAttribute("user_Exc")==null ? "":request.getAttribute("user_Exc")%></div>
    </form>
</body>
</html>

登录成功

<%@ page import="cn.wjs.domain.LoginUser" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <%LoginUser user= (LoginUser) request.getSession().getAttribute("user");%>
    <h1>欢迎<%=user.getUsername()%>,到来</h1>
</body>
</html>