图书管理系统（javaWeb)

不是小阳

已于 2024-01-11 16:02:52 修改

阅读量789

点赞数 10

文章标签： java

于 2024-01-11 16:00:57 首次发布

本文链接：https://blog.csdn.net/qq_52318243/article/details/135532086

版权

本文介绍了使用Lombok、Thymeleaf、MyBatis等技术构建的一个JavaWeb项目，包括系统设计、数据库结构、依赖管理、登录模块的实现（包括DAO、Service和Servlet）以及部分功能展示，如登录界面、主页面和用户管理等。

摘要由CSDN通过智能技术生成

1 设计思路

系统结构图

2 数据库的建立

2.1 触发器的学习

2.2 索引的学习

2.3 主键和外键

3 项目的实现

3.1 导入依赖

lombok 小辣椒依赖

  <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.26</version>
        </dependency>

thymeleaf技术与前端交互，非常简单

<dependency>
            <groupId>org.thymeleaf</groupId>
            <artifactId>thymeleaf</artifactId>
            <version>3.1.1.RELEASE</version>
        </dependency>

数据库依赖

    <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.27</version>
        </dependency>

mybatis依赖

 <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>

3.2 两个工具类

mybatis封装的工具类


package com.book.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;

public class MybatisUtil {
    private static SqlSessionFactory factory;
    static {
        try {
            factory=new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("mybatis-config.xml"));
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static SqlSession getSession(){
       return factory.openSession(true);
    }
}

thymeleaf封装的工具类


package com.book.utils;

import org.thymeleaf.TemplateEngine;
import org.thymeleaf.context.IContext;
import org.thymeleaf.templateresolver.ClassLoaderTemplateResolver;

import java.io.Writer;
import java.nio.charset.StandardCharsets;

public class ThymeleafUtil {

    private static final TemplateEngine engine;
    static  {
        engine = new TemplateEngine();
        ClassLoaderTemplateResolver r = new ClassLoaderTemplateResolver();
        engine.setTemplateResolver(r);
    }

    public static void process(String template, IContext context, Writer writer) {
         engine.process(template,context,writer);
    }
}

3.3 过滤器


package com.book.utils;

import org.thymeleaf.TemplateEngine;
import org.thymeleaf.context.IContext;
import org.thymeleaf.templateresolver.ClassLoaderTemplateResolver;

import java.io.Writer;
import java.nio.charset.StandardCharsets;

public class ThymeleafUtil {

    private static final TemplateEngine engine;
    static  {
        engine = new TemplateEngine();
        ClassLoaderTemplateResolver r = new ClassLoaderTemplateResolver();
        engine.setTemplateResolver(r);
    }

    public static void process(String template, IContext context, Writer writer) {
         engine.process(template,context,writer);
    }
}

3.4 登录模块功能实现

实体层Entity

Entity层，顾名思义就是实体层，放置一个个实体，及其相应的set、get方法。如果想要对数据库进行一些操作（比如说读取）的话，就要先写entity层。


package com.book.entity;

import lombok.Data;

@Data
public class User {
    int id;
    String username;
    String nichenname;
    String password;
}

数据访问层dao

DAO（Data Access Object）模型就是写一个类，把访问数据库的代码封装起来，DAO在数据库与业务逻辑（Service）之间。

Dao是数据访问层，Dao的作用是封装对数据库的访问：增删改查，不涉及业务逻辑，只是达到按某个条件获得指定数据的要求。



import com.book.entity.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserMapper {
    @Select("select *from admin where username=#{username} and password=#{password}")
    User getUser(@Param("username")String username,@Param("password")String password);



    @Results({
            @Result(column = "username", property = "username"),
            @Result(column = "nichenname", property = "nichenname"),
            @Result(column = "password", property = "password"),
    })
    @Select("select * from admin")
    List<User> getUserList();
}

业务逻辑层Service

顾名思义，它处理逻辑上的业务，而不去考虑具体的实现。


package com.book.service;

import com.book.entity.User;

import javax.servlet.http.HttpSession;
import java.util.List;

public interface UserService {
    boolean auth(String username, String password, HttpSession session);

    List<User> getUserList();
}

Service的实现


import javax.servlet.http.HttpSession;
import java.util.List;

public class UserServiceImpl implements UserService {
    @Override
    public boolean auth(String username, String password, HttpSession session) {
        try(SqlSession sqlSession= MybatisUtil.getSession()) {
            UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
            User user=userMapper.getUser(username,password);
            if(user==null)
                return false;
            session.setAttribute("user",user);
            return true;
        }
    }

    @Override
    public List<User> getUserList() {
        try(SqlSession sqlSession= MybatisUtil.getSession()) {
            UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
            return userMapper.getUserList();

        }
    }
}

控制层Servlet


import org.thymeleaf.context.Context;

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")
public class LoginServlet extends HttpServlet {
    UserService userService;

    @Override
    public void init() throws ServletException {
        userService=new UserServiceImpl();
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        Context context=new Context();

       if (req.getSession().getAttribute("user")!=null){
           resp.sendRedirect("index");
           return;
       }
        if(req.getSession().getAttribute("login-failure")!=null){
            context.setVariable("failure",true);
            req.getSession().removeAttribute("login-failure");
        }
         resp.setContentType("text/html;charset=utf-8");
        ThymeleafUtil.process("login.html",context,resp.getWriter());
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String username=req.getParameter("username");
        String password=req.getParameter("password");
        String remember=req.getParameter("remember-me");
        if (userService.auth(username,password, req.getSession())){
            resp.sendRedirect("index");
        }
        else {
           req.getSession().setAttribute("login-failure",true);
            this.doGet(req,resp);

        }
    }
}