【servlet】基于MVC的登录验证&查询信息模板

基于三层架构的登录验证&查询信息jsp页面模板

三层架构的思想实在是太完美了，这里我做了一个简单的小笔记，仅供大家参考学习。
希望可以帮到正在努力的你。

基于三层架构的思想，我的文件目录有了新的模板：

web.servlet包下的UserServlet

import dao.UserDao;
import dao.impl.UserDaoImpl;
import domain.User;
import service.UserService;
import service.impl.UserServiceImpl;
import javax.jws.soap.SOAPBinding;
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.util.List;
//servlet层，主要是操作service层。并获取其返回的信息
@WebServlet("/UserServlet")
public class UserServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        UserService userService=new UserServiceImpl();
//        1.获取页面账号密码信息
        User user=new User();
        String username = request.getParameter("username");
        String password = request.getParameter("password");
//        2.将获取到的信息赋值给user对象
        user.setUsername(username);
        user.setPassword(password);
//        3.执行登录验证逻辑
        UserDao userDao=new UserDaoImpl();
        User user1 = userDao.loginUser(user);
//        4.如果不为空，说明登陆成功
        if (user1!=null){
//            4.1.成功的情形
//            4.1.1.获取查询信息
            List<User> all = userService.findAll();
//            4.1.2.将获取到的信息进行发送
            request.setAttribute("user",all);
//            4.1.3.进行信息转发
        request.getRequestDispatcher("/show.jsp").forward(request,response);
        }else {
//            4.2登陆失败情形
//            4.2.1.控制台输入sorry，页面打印err the pin
            System.out.println("sorry");
            response.getWriter().write("error the pin");
        }
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
}

service层接口：

import domain.User;
import java.util.List;
//service层接口
public interface UserService {
    public List<User> findAll();
}

service层接口实现类：

import dao.UserDao;
import dao.impl.UserDaoImpl;
import domain.User;
import service.UserService;
import java.util.List;
//service层接口的实现类，用来操作dao层
public class UserServiceImpl implements UserService {
    //    设置私有dao层实现类
    private UserDao userDao = new UserDaoImpl();
    @Override
    public List<User> findAll() {
//        调用dao层的方法，并将结果返回给servlet
        return userDao.findAll();
    }
}

dao层接口：

import domain.User;
import java.util.List;
//dao层接口
public interface UserDao {
//    方法一：查找所有的信息
    public List<User> findAll();
//    方法二：登陆验证
    public User loginUser(User user);
}

dao层接口实现类：

import dao.UserDao;
import domain.User;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import util.JdbcUtils;
import java.util.List;
//dao层的实现类
public class UserDaoImpl implements UserDao {
//    基操
    private JdbcTemplate jdbcTemplate=new JdbcTemplate(JdbcUtils.getDataSource());
//    查找所有信息
    @Override
    public List<User> findAll() {
        String sql="select *from user";
        List<User> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class));
        return query;
    }
//    登陆验证
    @Override
    public User loginUser(User user) {
        try {
            String sql="select * from user where username=? and password=?";
            User user1 = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), user.getUsername(), user.getPassword());
            return user1;
        } catch (DataAccessException e) {
            e.printStackTrace();
        }
        return null;
    }
}

domain包下User实体类：

public class User {
    //    数据库实体类
    private int id;
    private String username;
    private String password;
    private String gender;
    private int age;
    private String address;
    private String qq;
    private String email;
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", gender='" + gender + '\'' +
                ", age=" + age +
                ", address='" + address + '\'' +
                ", qq='" + qq + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
    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 getGender() {
        return gender;
    }
    public void setGender(String gender) {
        this.gender = gender;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public String getQq() {
        return qq;
    }
    public void setQq(String qq) {
        this.qq = qq;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public User() {
    }
    public User(int id, String username, String password, String gender, int age, String address, String qq, String email) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.gender = gender;
        this.age = age;
        this.address = address;
        this.qq = qq;
        this.email = email;
    }
}

SQL结构机器数据

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `gender` varchar(5) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `address` varchar(32) DEFAULT NULL,
  `qq` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'wei', '123', '男', '20', 'xunx', '17335255620', '177@11.con');

index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$Title$</title>
  </head>
  <body>
  <form action="UserServlet" method="post">
    username<input type="text" name="username">
    password<input type="password" name="password">
    <input type="submit" name="submit">
  </form>
  </body>
</html>

show.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<table align="center" border="1">
    <tr bgcolor="yellow">
        <th>
            编号
        </th>
        <th>
            账号
        </th>
        <th>
            密码
        </th>
        <th>
            性别
        </th>
        <th>
            年龄
        </th>
        <th>
            地址
        </th>
        <th>
            qq
        </th>
        <th>
            email
        </th>
    </tr>
    <c:forEach items="${user}" var="s" varStatus="and">
        <tr>
            <th>
                    ${s.id}
            </th>
            <th>
                    ${s.username}
            </th>
            <th>
                    ${s.password}
            </th>
            <th>
                    ${s.gender}
            </th>
            <th>
                    ${s.age}
            </th>
            <th>
                    ${s.address}
            </th>
            <th>
                    ${s.qq}
            </th>
            <th>
                    ${s.email}
            </th>
        </tr>
    </c:forEach>
</table>
</body>
</html>