【javaee】前端_后端_数据库_mysql_JDBC_连接池_案例

项目结构：

user：

package cn.itcast.domin;


/**
 * 用户的实体类，类似与c语言的结构体
 */
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 + '\'' +
                '}';
    }
}

failServlet：

package cn.itcast.servlet;

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;


/**
 * 用户名和密码输入错后的动作
 */
@WebServlet("/failServlet")
public class failServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 设置编码
        resp.setContentType("text/html;; charset=utf-8");

        // 调用response的方法给页面写一句话
        resp.getWriter().write("登陆失败，用户名或密码错误");
        System.out.println("fail...");
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

Servlwt_login：

package cn.itcast.servlet;

import cn.itcast.userdao.userdao;
import cn.itcast.domin.user;
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;

/**
 * 在前端页面登录后的动作
 */
@WebServlet("/login_servlet")
public class Servlet_login extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        System.out.println("login...");
        // 设置编码，为了防止中文乱码
        resp.setCharacterEncoding("utf-8");
        // 获取请求参数，在前端页面的输入框中获取传递的值
        String username = req.getParameter("username");
        String password = req.getParameter("password");

//        // 用于测试结果，相当于debug了
//        System.out.println(username);
//        System.out.println(password);

        // 封装user对象，类似于c语言中结构体操作
        user login_user = new user();
        login_user.setUsername(username);
        login_user.setPassword(password);

        // 调用userdao的login方法
        userdao dao = new userdao();    // 初始化结构体
        user find_user = dao.login(login_user);
        System.out.println(find_user);

        // 判断find_user
        if (find_user == null) {
            // 登陆失败操作
            req.getRequestDispatcher("failServlet").forward(req, resp);
        } else {
            // 登录成功操作
            // 存储数据
            req.setAttribute("user", find_user);
            // 转发后端的动作
            req.getRequestDispatcher("successServlet").forward(req, resp);
        }
    }


    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

successServlet：

package cn.itcast.servlet;

import cn.itcast.domin.user;

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;


/**
 * 在前端页面输入的用户名和密码输入对之后的动作
 */
@WebServlet("/successServlet")
public class successServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 获取request域中共享的user对象
        user user = (cn.itcast.domin.user) req.getAttribute("user");

        if (user!=null){
            // 设置编码
            resp.setContentType("text/html;; charset=utf-8");

            // 给页面写一句话
            resp.getWriter().write("登录成功!" + user.getUsername() +  "欢迎您");
        }
        System.out.println("success...");
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

user_dao_test：

package cn.itcast.test;

import cn.itcast.domin.user;
import cn.itcast.userdao.userdao;
import org.junit.Test;


/**
 * 测试类，用于测试userdao是否能够成功获取正确的数据
 */
public class user_dao_test {

    @Test
    public void test_login(){
        user login_use = new user();    // 初始化类
        // 设置用户名和密码
        login_use.setUsername("zhangsan");
        login_use.setPassword("123456");

        userdao dao = new userdao();
        user l_u = dao.login(login_use);    // l_u是在数据库中返回的集合
        System.out.println(l_u);
    }
}

userdao：

package cn.itcast.userdao;

import cn.itcast.domin.user;
import cn.itcast.util.JDBCTiles;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 * 操作数据库中User表的类
 */
public class userdao {
    // 声明JDBCTemplate对象共用
    private JdbcTemplate template = new JdbcTemplate(JDBCTiles.getDataSource());


    /**
     * @param login_user 只有用户名和密码
     * @return 包含用户所有数据
     */
    public user login(user login_user) {
        try {
            // 编写sql语句
            String sql = "select * from user where username = ? and password = ?";
            // 调用方法，封装对象
            user user = template.queryForObject(sql, new BeanPropertyRowMapper<user>(user.class),
                    login_user.getUsername(),       // login_user是获取连接sql并且获取返回值的类
                    login_user.getPassword());

            return user;
        } catch (DataAccessException e) {
            e.printStackTrace();
            return null;    // 查询失败，返回null值
        }
    }
}

JDBCTiles：

package cn.itcast.util;

import com.alibaba.druid.pool.DruidDataSourceFactory;

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

/**
 * JDBC的工具类，使用druid连接池
 */
public class JDBCTiles {
    // 定义连接对象
    private static DataSource ds;

    // 静态代码块
    static {
        // 加载配置文件
        Properties pro = new Properties();
        // 使用ClassLoader加载配置文件获取字节输入流
        InputStream is = JDBCTiles.class.getClassLoader().getResourceAsStream("druid.properties");
        try {
            pro.load(is);
        } catch (IOException e) {
            e.printStackTrace();
        }


        // 初始化连接池对象
        try {
            ds = DruidDataSourceFactory.createDataSource(pro);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }


    /**
     * 获取连接池
     */
    public static DataSource getDataSource(){
        return ds;
    }

    /**
     * 获取Connection对象
     */
    public static Connection getConnection() throws SQLException {
        return ds.getConnection();
    }
}

项目源文件：
点我

加上了验证码验证的案例：
点我

效果：